451DAC14-D169-2A9F-1266443CD504A357.xlsx

This file is an administrative spreadsheet for Franklin County detailing employee benefit program structures and enrollment across multiple voluntary and employer-paid insurance offerings. The document outlines the configuration of Short-Term Disability (STD), Long-Term Disability (LTD), Legal Plan, and Pet Insurance programs across 28 Franklin County agencies and sub-codes, each with distinct premium collection and remittance methodologies. The programs are offered on either a semi-monthly (24 pays) or bi-weekly (26 pays) basis, with premium collection occurring either one month in arrears, current month, or one month in advance depending on the agency and plan type. Current enrollment totals include 2,862 employees in STD coverage, 1,986 employees in Legal Plan coverage, 80 employees in Pet Insurance, and 2,457 employees in LTD coverage, for a total of 5,319 enrolled employees across all programs.

The spreadsheet identifies critical administrative distinctions between Franklin County-administered premiums (FC) and agency-administered premiums (AGENCY), with specific agencies noted for unique program offerings. Agency 7000 provides employee-paid STD at hire and employer-paid STD after 12 months of employment while offering employer-paid legal plan coverage at a group rate. Agency 8200 offers employer-paid STD and LTD coverage at hire, neither of which are Franklin County programs. Agency 9996 offers no voluntary or employer-paid coverage. Premium remittance timelines vary significantly, with most FC-administered premiums remitted one month in arrears with a 60-day grace period, while certain agencies remit premiums on alternative schedules ranging from current month to one month in advance. Pet Insurance is unique in that it requires employee enrollment directly with the vendor and no payroll deduction or Franklin County invoice processing.