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

File Type Posted
44A3FAEC-97F9-FAD6-B54F90D5CEDD52DA.xlsx XLSX spreadsheet
4ADC244E-B24C-BEC2-4654E43F7ACFB8A4.xlsx XLSX spreadsheet
8B00ECA9-D368-AD09-80DA20EDC1915543.pdf PDF
E99082A3-014B-96AB-48063D8559F32599.pdf PDF
C0135AC1-FF9D-F3AC-BDB7FB4697056E65.pdf PDF
39A8A9E3-F569-C6B6-B9E7BF50CFDC4F51.pdf PDF
44F2A935-093F-1234-3F0F06EFB73CE154.xlsx XLSX spreadsheet
58DCD716-9EAC-9E14-6719EE5FDA607EE3.pdf PDF
1FF81613-C943-E907-903208614AFFB273.pdf PDF
471F2B18-FADB-16E3-6A13A124C82D15B3.pdf PDF
455CA489-AF8F-CF71-6FFA3A68482AEF22.pdf PDF
76154B86-0D35-C013-E46368EB2B8F2266.pdf PDF
36771012-968A-47BA-49FB1CC4DFFFEC63.pdf PDF
B867E43E-FCA2-ABC6-686473D3D551080B.docx DOCX document
8BE169B1-0EA5-67F3-FE8D32CD74B2BC3C.pdf PDF
451D7EC8-9FAF-B01F-15E5F86D68AB3D4B.xlsx XLSX spreadsheet
48C544C3-FCC4-F4ED-99FB5E91E5744B30.pdf PDF
F13E338C-C030-4C55-2FE32EE64813CA9E.docx DOCX document
9188FC82-07E6-2A24-E7927A56369C067A.pdf PDF
471F0983-EB69-959C-3B62A289547CA11E.xlsx XLSX spreadsheet
600AF88E-C800-4399-20BE9FDE4A50714B.docx DOCX document
FAFB33F1-A49E-7354-6799AC07E5D29DA0.pdf PDF
47ADF7AD-983F-9719-2E5C720D20F03E5A.xlsx XLSX spreadsheet
8BD45E27-AD3D-2A81-9DC34421F6415618.pdf PDF
8CFF3838-EA7E-33CD-42D86D9937F5AFDB.pdf PDF
48C71F36-F14E-8501-2A85945F358C6068.xlsx XLSX spreadsheet
441CA1BC-A59E-E520-9F472E421C5515A7.pdf PDF
CCC737E4-C815-7DA9-BAFDD4D8BCA83EAE.pdf PDF
BEA8591A-F056-8D68-013C92A00C2DA843.pdf PDF
1FF79148-03D3-7B1B-77CF64FD687ECA4C.pdf PDF
4764BD72-A4C9-CB3B-C1392F63B1D7AA28.pdf PDF
BCCA0BAC-C5BA-CDB6-49D2EFF559EDAF11.pdf PDF
9AEA49E5-D258-E830-CAAB03DD9BBE7883.pdf PDF
D1C75C4E-ACBE-A700-94A3260C246A50BF.pdf PDF
9CF27992-010C-8CAD-3D1BE0F71396D62B.pdf PDF
600ACEFD-D8A4-EF86-6746123A35214FBD.pdf PDF
D465A6BC-B38E-009F-4BA8EFA38CE55315.pdf PDF
E99102BF-B146-146D-35DFAF9763C1170B.pdf PDF
455CC78D-B78A-EC66-F7D6D71B8AF36042.pdf PDF
6D302278-A5F3-8508-AEC851283D91EF01.pdf PDF
5FEA932D-A443-F834-C369AEC7AD13A552.pdf PDF
8BE999EA-C1F3-6CAA-1ED2B57E621612FB.pdf PDF
4540076D-DA44-888C-413CAB868FEC6141.xlsx XLSX spreadsheet
477EEBB5-9B64-4073-39F4D92B43E61BB0.pdf PDF
47647B12-EF69-CBAE-3877E615229CE346.pdf PDF
379F0AFD-BC67-5833-47CED9B9F8A77644.pdf PDF
8F33C1D9-B606-E1D0-F77CFF24E442EF1B.pdf PDF
4491B391-0B2C-57F1-169E865F334A5FAD.xlsx XLSX spreadsheet
4703BAFF-A637-A4BC-D31224A6D85981B6.pdf PDF
A46910BC-E967-DD22-10B71BADEA153824.docx DOCX document
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 DISABILITYLEGAL PLANPET
STD - DISABILITY EMPLOYEE PAIDSTD - DISABILITY EMPLOYER PAIDLTD - DISABILITY EMPLOYEE PAIDLTD - DISABILITY EMPLOYER PAIDPREMIUM COLLECTION
Semi-monthly = 24 pays Bi-weekly = 26 paysPREMIUM REMITTANCE
Premium and invoice aggregated and remitted by FC (FC) or remitted by Agency directly to vendor (AGENCY)LEGAL PLAN EMPLOYEE PAIDLEGAL PLAN EMPLOYER PAIDPREMIUM COLLECTION
Semi-monthly = 24 pays Bi-weekly = 26 paysPREMIUM 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

1100YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
1110YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
1130YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
1140YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
1160YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
1180YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
1200YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
1250YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
1300YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
1500YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
1600YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
1900YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
2500YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
2700YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
2800YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
3000YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
3200YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
3500YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
3700YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
4000YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
4400YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
4800YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
6300YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
6500YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
6600YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
6700YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
6800YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
6900YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
**7000YESN/A
See belowYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodN/AYES
See belowNo payroll deduction - ER paid
Remitted current monthAGENCYEMPLOYEE SELF SELECT/self pay
8000YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
8400YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
8600YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
8700YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
8800YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
9000YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
9300YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
9600YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
9601YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsFC / 60 day grace periodYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
5000YESN/AYESN/ASemi-monthly - collected and remitted 1 month in arrearsAGENCY /60 day grace periodYESN/ASemi-monthly - collected and remitted 1 month in arrearsAGENCYEMPLOYEE SELF SELECT/self pay
5001YESN/AYESN/ASemi-monthly - collected and remitted 1 month in advanceAGENCY /60 day grace periodYESN/ASemi-monthly - collected and remitted current monthAGENCYEMPLOYEE SELF SELECT/self pay
5002YESN/AYESN/ASemi-monthly - collected and remitted 1 month in advanceAGENCY /60 day grace periodYESN/ASemi-monthly - collected and remitted 1 month in advanceAGENCYEMPLOYEE SELF SELECT/self pay
9995YESN/AYESN/ABi-weekly - collected and remitted 1 month in arrearsAGENCY /60 day grace periodYESN/ABi-weekly - collected and remitted 1 month in arrearsAGENCYEMPLOYEE SELF SELECT/self pay
** 9996N/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A
9997N/AYESYESN/ASemi-monthly - collected and remitted current monthAGENCY /60 day grace periodYESN/ABi-weekly - collected and remitted current monthAGENCYEMPLOYEE SELF SELECT/self pay
** 8200N/A
See belowN/A
See belowN/A
See belowN/A
See belowN/AN/AYESN/ASemi-monthly - collected and remitted current monthFCEMPLOYEE SELF SELECT/self pay
Enrollment Count STDSTD - DISABILITY EMPLOYEE PAIDSTD - DISABILITY EMPLOYER PAIDTOTAL ENROLLED
STDLEGAL PLAN EMPLOYEE PAIDLEGAL PLAN EMPLOYER PAIDTOTAL ENROLLED EMPLOYEESPET TOTAL ENROLLED EMPLOYEES
273013228621185793 + 8 part -time198680

Enrollment Count LTD LTD - DISABILITY EMPLOYEE PAID LTD - DISABILITY EMPLOYER PAID TOTAL ENROLLED

LTD

2457 N/A 2457

TOTAL ENROLLED EMPLOYEES5319
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 .