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

File Type Posted
441CC2FC-B00B-E914-728A3B9F6E284C71.pdf PDF
4ADBF0DE-FA15-F6CB-0B2B1FFF2D166DEF.pdf PDF
56D1C126-97D3-4C35-9D201EE3F38956EA.pdf PDF
56D21EF1-090E-9236-DC87D4ABB226948A.pdf PDF
44F2C847-DCDE-D822-A4337D82DBDE228F.xlsx XLSX spreadsheet
47649CE8-A0E3-2433-AC9846884D7DA4C4.pdf PDF
82C4A68E-CF20-D525-DD84F11D8BE54C23.pdf PDF
365FC443-9C1D-6871-4B183773D28A5AB9.pdf PDF
340E518F-B0A2-92CD-5CE67BE8C5C74ADC.pdf PDF
58D37F6D-B16E-1BC2-6AA94BEC83501089.pdf PDF
477F0E99-DAE2-3C20-3E7D603ABFDF3EFB.pdf PDF
4ADBDA30-A10A-65AC-2585EBF3396EC49F.pdf PDF
1FF7B35A-B067-E38B-5984FBC2B840ECE1.pdf PDF
441C7CE8-FE79-FFAD-86876E5C9E330E9F.pdf PDF
1FF79148-03D3-7B1B-77CF64FD687ECA4C.pdf PDF
441CE78D-F987-C11E-794F97DB70EF1A64.xlsx XLSX spreadsheet
4ADB9154-92D0-FA39-8C51818579A9E699.pdf PDF
E990E137-C5A3-F52C-C390BB811E5E078A.pdf PDF
47A070EA-AA3B-485A-6C240303241C99D2.pdf PDF
D465A6BC-B38E-009F-4BA8EFA38CE55315.pdf PDF
1FF6D412-D5CF-E3DA-42373990EB63A4DE.docx DOCX document
8B0111A9-AB26-EF6C-1377B5BEC77C1480.pdf PDF
47A09361-9A16-2F9F-03970F0DC73EAB8D.pdf PDF
56D1E25C-D6F7-A070-782594700401C348.docx DOCX document
BEA8591A-F056-8D68-013C92A00C2DA843.pdf PDF
4740E487-E21E-8839-C282065471954566.pdf PDF
48C71F36-F14E-8501-2A85945F358C6068.xlsx XLSX spreadsheet
8D7E2732-E2EF-8808-10498B0343D0DB6B.pdf PDF
9705A9CE-B76B-3514-2AB6D46F5013FD96.pdf PDF
455CA489-AF8F-CF71-6FFA3A68482AEF22.pdf PDF
BEA8D216-B719-D18D-2A1EF07B83D22C78.xlsx XLSX spreadsheet
6A9BE711-E1B2-9B67-147E88484CF79F1A.pdf PDF
2D575AB7-B92A-4C61-DE1B68E18F3B1809.pdf PDF
F13E338C-C030-4C55-2FE32EE64813CA9E.docx DOCX document
44B739A8-A554-F8F5-C38D97EF8EFBF991.xlsx XLSX spreadsheet
47039A14-CC1D-3979-F8226F8E1E768343.pdf PDF
8BD45E27-AD3D-2A81-9DC34421F6415618.pdf PDF
A3F924CA-A2E1-A38A-2E6F296BD4EAE5D4.pdf PDF
260F9701-94BA-EFEA-FCAED968AC730EE0.docx DOCX document
CCC737E4-C815-7DA9-BAFDD4D8BCA83EAE.pdf PDF
1FF81613-C943-E907-903208614AFFB273.pdf PDF
BCCA0BAC-C5BA-CDB6-49D2EFF559EDAF11.pdf PDF
8BE169B1-0EA5-67F3-FE8D32CD74B2BC3C.pdf PDF
48C51FFE-B1BA-D9DA-11337A7B04016CA4.pdf PDF
4ADC0CC3-B76B-A18D-C62DDED0F769FB5E.xlsx XLSX spreadsheet
4540076D-DA44-888C-413CAB868FEC6141.xlsx XLSX spreadsheet
4703BAFF-A637-A4BC-D31224A6D85981B6.pdf PDF
600B193E-A6DE-E459-0374B7046DEB49BE.xlsx XLSX spreadsheet
3D557BC1-D80F-2E25-C9390E0BF5A59073.pdf PDF
44A3FAEC-97F9-FAD6-B54F90D5CEDD52DA.xlsx XLSX spreadsheet
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 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 .