Exhibit_C__Offset_Key.pdf

PDF 41 KB Posted

Attached to
Group Life & Disability and Supplemental Health Benefits
Solicitation number
RFP-1-26-12
Issued by
Brevard County, Florida

About this file

This file is an Offset Code Key exhibit related to a Florida county's Group Life & Disability and Supplemental Health Benefits contract opportunity. The county seeks to expand its voluntary benefit offerings to include group-sponsored Accident, Hospital Indemnity, and Critical Illness/Cancer coverage through a single carrier/administrator, with an effective date of January 1, 2027. Currently, the county offers fully insured Group Term Life, Accidental Death & Dismemberment, Short-Term Disability, and Long-Term Disability coverage through Standard Insurance Company under a contract awarded via RFP effective January 1, 2019. The supplemental health products are presently offered individually through multiple representatives including Aflac, Allstate, and Colonial Life without group administration.

The Offset Code Key document provides reference codes for various types of benefit offsets and deductions applicable to disability and retirement benefits, including PERS disability retirement, Social Security benefits, workers' compensation, unemployment compensation, and other state and federal withholdings. These codes categorize offset types (such as PD for PERS Disability, SS for Social Security, WP for Workers' Compensation permanent disability) and status codes indicating whether amounts are actual, estimated, or denied, which appear relevant to benefit administration and reserve calculations. Employees currently enrolled in individual Colonial, Aflac, and Allstate plans may continue those coverages on a direct-bill basis, but the county will discontinue on-site enrollment and payroll deductions for individual plans effective January 1, 2027, making only group-sponsored benefits awarded through this solicitation eligible for payroll deduction and group administration.

View the file

Other files

File Type Posted
RFQ_Selection_Committee_Consolidated_Evaluation_Scoresheet.pdf PDF
Public_Meeting_Notice.pdf PDF
RFP_Tabulation__Names_Only.pdf PDF
Addendum_2.pdf PDF
Exhibit_C___Incurred__Paid_Updated_w_BL_Breakout.xlsx XLSX spreadsheet
Exhibit_C__Offset_Report.xlsx XLSX spreadsheet
Exhibit_A__Census.xlsx XLSX spreadsheet
Addendum_1.pdf PDF
Exhibit_C_Claimrun_Updated.xlsx XLSX spreadsheet
Exhibit_C__Incurred__Paid_Updated.pdf PDF
Exhibit_C__Brevard_Life__DI_SelfBill_2.1.26.xlsx XLSX spreadsheet
Exhibit_B__Allstate__Brevard_Fire_department.pdf PDF
Attachment_E__Draft_Contract.pdf PDF
Exhibit_C__641728_BREVARD_COUNTY_BOARD__Claimrun.pdf PDF
Attachment_C__Premium_Worksheet.xlsx XLSX spreadsheet
Exhibit_A__Census.pdf PDF
Exhibit_B__The_Standard_Life_Plan_Cert_Retirees.pdf PDF
Exhibit_B_Life_Age_Reduction_Amendment_1.1.26.pdf PDF
Exhibit_B_Aflac__Brevard_2025.pdf PDF
Exhibit_B__Colonial_Life__Brevard_2025.pdf PDF
Attachment_A__Mandatory_Requirements__Proposal_Worksheet_revised_6.4.26.docx DOCX document
Exhibit_B__The_Standard_LTD_Cert.pdf PDF
Exhibit_B_Spouse_Life_Age_Reduction_Amendment_1.1.26.pdf PDF
Exhibit_C_Incurred_vs._Paid_Exhibit.pdf PDF
Attachment_B__Plan_Design_Worksheet.xlsx XLSX spreadsheet
Exhibit_B__The_Standard_STD_Cert.pdf PDF
Exhibit_B__The_Standard_Life_and_ADD_Cert_Active_EEs.pdf PDF
Attachment_D_Certification_of_Financial_Condition.pdf PDF
INV__SPECIFICATIONS.pdf PDF
Exhibit_C__Claim_Run_Reference_Sheet.pdf PDF
Show all 30

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Offset Code Key Status Code Key

PD, P1, P2 PERS Disability retirement A Actual (The SS amount is known and reserves are reduced based on them)

PL PERS benefits in a lump sum award (either PS or PD) E Estimated (Reserves get reduced based on an estimated amount)

PS PERS service retirement S Estimating and Deducting (Reserves are reduced based on the estimated amount)

RM Work earnings offset D Denied (Reserves kept at full amount)

RO Work earnings offset X Ineligible (Reserves kept at full amount)

SS Social Security DIS/Retirement M (Another permanent benefit is received, we no longer estimate or estimate and deduct)

SC Social Security dependents

SD Social Security disability (primary)

SL Sick leave

SR Social Security retirement

SW Social Security Surviving Spouse (Widow/er's benefits)

WP Workers' Compensation permanent disability benefits

WT Workers' Compensation temporary disability benefits

PV Private Retirement/Pension

RR Railroad Retirement

SO Other South Carolina offsets

SP Benefits not paid for summer

ST Short term disability benefits

TC Teacher's Insurance and Annuity Association/College Retirement Equities Fund

TD Washington State Teachers' Retirement System temporary disability

TE Teachers' retirement benefits

TI Total disability income

TR State Teachers' Retirement System service retirement. California only.

TS Subrogation Settlement

UC Unemployment compensation

VA Veteran's benefits

VC Vacation Pay

XY Plan A offset

SW State Witholding

FW Federal Witholding

CS Child Support

File details come from the government source that posted it. Updated .