451DAC14-D169-2A9F-1266443CD504A357.xlsx
XLSX spreadsheet 17 KB Posted
- Attached to
- Voluntary Programs: Short and Long Term Disability, Legal Plan, Identity Theft, and Pet Insurance
- Solicitation number
- RFP #2025-06-09
- Issued by
- Franklin County, Ohio
About this file
This is an employee benefits enrollment and administration document for Franklin County outlining voluntary and employer-paid coverage options across multiple benefit categories including short-term disability (STD), long-term disability (LTD), legal plans, and pet insurance. The document establishes the administrative framework and premium collection procedures for 24 Franklin County agencies and their employees, specifying which benefits each agency offers and how premiums are collected and remitted. Coverage is available on both semi-monthly (24 pays) and bi-weekly (26 pays) schedules depending on agency payroll structures. The document identifies enrollment counts totaling 5,319 employees across the county's benefits programs, with 2,862 enrolled in STD coverage, 2,457 in LTD coverage, 1,986 in legal plans, and 80 in pet insurance.
Premium collection and remittance procedures vary by agency and benefit type, with Franklin County handling aggregated premium collection and remittance for most agencies while some agencies remit premiums directly to vendors. Premium collection timing differs by benefit and agency, occurring either one month in arrears, during the current month of coverage, or one month in advance. All employee-paid benefits are designated as employee self-select options with a 60-day grace period for coverage lapses. Agency 7000 offers a unique structure combining employee-paid STD and LTD coverage at hire with employer-paid coverage beginning after 12 months of employment, while Agencies 8200 and 9996 maintain alternative non-county programs. The document serves as an administrative reference establishing which agencies participate in which programs and the specific operational requirements for premium handling and employee enrollment management across Franklin County's benefits portfolio.
View the file
Other files
Show 40 more
Latest 50 of 148 listed here. See the rest on GovTribe.
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
Sheet1
| Franklin County Agency ID | ||||||||
| (Identified as the Sub Code in the FC Structure STD.LTD.LEGAL.PET file) | SHORT AND LONG TERM DISABILITY | LEGAL PLAN | PET | |||||
| STD - DISABILITY EMPLOYEE PAID | STD - DISABILITY EMPLOYER PAID | LTD - DISABILITY EMPLOYEE PAID | LTD - DISABILITY EMPLOYER PAID | PREMIUM COLLECTION | ||||
| Semi-monthly = 24 pays Bi-weekly = 26 pays | PREMIUM REMITTANCE | |||||||
| Premium and invoice aggregated and remitted by FC (FC) or remitted by Agency directly to vendor (AGENCY) | LEGAL PLAN EMPLOYEE PAID | LEGAL PLAN EMPLOYER PAID | PREMIUM COLLECTION | |||||
| Semi-monthly = 24 pays Bi-weekly = 26 pays | PREMIUM REMITTANCE | |||||||
| Premium and invoice aggregated and remitted by Franklin County (FC) or remitted by Agency directly to vendor (AGENCY) | PET INSURANCE |
Enrollment on vendor site - not FC enrollment system No payroll deduction or invoice by FC - member remits premium to vendor
| 1100 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 1110 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 1130 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 1140 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 1160 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 1180 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 1200 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 1250 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 1300 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 1500 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 1600 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 1900 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 2500 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 2700 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 2800 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 3000 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 3200 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 3500 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 3700 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 4000 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 4400 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 4800 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 6300 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 6500 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 6600 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 6700 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 6800 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 6900 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| **7000 | YES | N/A | ||||||||||
| See below | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | N/A | YES | ||||||
| See below | No payroll deduction - ER paid | |||||||||||
| Remitted current month | AGENCY | EMPLOYEE SELF SELECT/self pay | ||||||||||
| 8000 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 8400 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 8600 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 8700 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 8800 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 9000 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 9300 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 9600 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 9601 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | FC / 60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay | |
| 5000 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | AGENCY /60 day grace period | YES | N/A | Semi-monthly - collected and remitted 1 month in arrears | AGENCY | EMPLOYEE SELF SELECT/self pay | |
| 5001 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in advance | AGENCY /60 day grace period | YES | N/A | Semi-monthly - collected and remitted current month | AGENCY | EMPLOYEE SELF SELECT/self pay | |
| 5002 | YES | N/A | YES | N/A | Semi-monthly - collected and remitted 1 month in advance | AGENCY /60 day grace period | YES | N/A | Semi-monthly - collected and remitted 1 month in advance | AGENCY | EMPLOYEE SELF SELECT/self pay | |
| 9995 | YES | N/A | YES | N/A | Bi-weekly - collected and remitted 1 month in arrears | AGENCY /60 day grace period | YES | N/A | Bi-weekly - collected and remitted 1 month in arrears | AGENCY | EMPLOYEE SELF SELECT/self pay | |
| ** 9996 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | |
| 9997 | N/A | YES | YES | N/A | Semi-monthly - collected and remitted current month | AGENCY /60 day grace period | YES | N/A | Bi-weekly - collected and remitted current month | AGENCY | EMPLOYEE SELF SELECT/self pay | |
| ** 8200 | N/A | |||||||||||
| See below | N/A | |||||||||||
| See below | N/A | |||||||||||
| See below | N/A | |||||||||||
| See below | N/A | N/A | YES | N/A | Semi-monthly - collected and remitted current month | FC | EMPLOYEE SELF SELECT/self pay |
| Enrollment Count STD | STD - DISABILITY EMPLOYEE PAID | STD - DISABILITY EMPLOYER PAID | TOTAL ENROLLED | |||||||
| STD | LEGAL PLAN EMPLOYEE PAID | LEGAL PLAN EMPLOYER PAID | TOTAL ENROLLED EMPLOYEES | PET TOTAL ENROLLED EMPLOYEES | ||||||
| 2730 | 132 | 2862 | 1185 | 793 + 8 part -time | 1986 | 80 |
Enrollment Count LTD LTD - DISABILITY EMPLOYEE PAID LTD - DISABILITY EMPLOYER PAID TOTAL ENROLLED
LTD
2457 N/A 2457
| TOTAL ENROLLED EMPLOYEES | 5319 |
| Hilited fields represent unique program offering or administration requirements. |
| ** Agency 7000: |
| Offers Franklin County's voluntary EE PAID STD DISABILITY coverage to employees at hire. |
| Provides ER PAID STD DISABILITY coverage to employees after 12 months of employment. This is not a Franklin County program. Employees may be covered by both this plan and the Franklin County plan. |
| Offers Franklin County EE PAID LTD DISABILITY coverage to employees at hire. |
| Provides ER PAID LEGAL PLAN coverage. Agency pays a group rate for the Franklin County Legal Plan. 8 part-time employees are included in this offering. Agency remits premium directly to vendor. |
| ** Agency 8200: |
| Provides ER PAID STD DISABILITY coverage to employees at hire. This is not a Franklin County program. |
| Provides ER PAID LTD DISABILITY coverage to employees at hire. This is not a Franklin County program. |
| ** Agency 9996: |
| Does not offer any Franklin County voluntary EE OR ER PAID coverage to employees. |
| Premium Remittance: |
| Any premium remittance identified as AGENCY is submitted directly to the vendor by the agency. All premium remittance identified as FC is submitted directly to the vendor by Franklin County. |
| Premium Collection: |
| Collected and remitted 1 month in arrears = Deducted from employee pay and remitted to vendor 1 month after coverage period, i.e. premium collected and remitted in April pays for coverage in March |
| Collected and remitted current month = Deducted from employee pay and remitted to vendor the current month of coverage period, i.e. premium collected and remitted in April pays for coverage in April |
| Collected and remitted 1 month in advance = Deducted from employee pay and remitted to vendor 1 month in advance of coverage period, i.e. premium collected and remitted in April pays for coverage in May |
| Remitted current month = No deduction b/c employer paid; premium remitted to vendor the current month of coverage period, i.e. premium remitted in April pays for coverage in April |
File details come from the government source that posted it. Updated .