451DAC14-D169-2A9F-1266443CD504A357.xlsx
XLSX spreadsheet 17 KB Posted
- Attached to
- Mediation Services
- Solicitation number
- 2026-46-06
- Issued by
- Franklin County, Ohio
About this file
This file is a benefits enrollment and administration matrix for Franklin County detailing the structure and requirements for managing voluntary supplemental employee benefit plans across multiple county agencies. The document outlines the administration of Short-Term Disability (STD), Long-Term Disability (LTD), Legal Plan, and Pet Insurance offerings across 28 identified agency sub-codes. The matrix specifies enrollment counts, premium collection methods, and remittance procedures for each agency, with total enrolled employees across all programs reaching 5,319. Administration requirements vary by agency, with some plans collected and remitted one month in arrears, others in the current month, and certain plans collected in advance. The document identifies two agencies with unique program structures: Agency 7000 provides employer-paid STD coverage after 12 months of employment and employer-paid legal plan coverage, while Agency 8200 provides employer-paid STD and LTD coverage at hire outside of Franklin County's standard programs.
Premium remittance is handled either directly by Franklin County or by individual agencies submitting directly to vendors, with most agencies operating on semi-monthly collection cycles (24 pays annually) and a limited number on bi-weekly cycles (26 pays annually). A 60-day grace period is standard across programs for premium remittance. The document identifies Agency 9996 as offering no Franklin County voluntary coverage and highlights that certain programs are non-Franklin County offerings that may run concurrently with county plans. Pet Insurance enrollment occurs on vendor platforms outside Franklin County's enrollment system with direct member premium remittance. The enrollment breakdown shows 2,862 employees in STD coverage, 1,986 in Legal Plan coverage, 80 in Pet Insurance, and 2,457 in LTD coverage.
View the file
Other files
Show 40 more
Latest 50 of 147 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 .