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

This is an enrollment and premium collection matrix for Franklin County's voluntary employee benefit programs, covering Short-Term Disability (STD), Long-Term Disability (LTD), Legal Plan, and Pet Insurance offerings across multiple county agencies. The document outlines program structure, enrollment counts, and administration requirements for 38 distinct Franklin County agencies and departments, identified by agency subcodes ranging from 1100 to 9997. Current enrollment totals 2,862 employees in STD coverage (2,730 employee-paid, 132 employer-paid), 1,986 employees in the Legal Plan (1,185 employee-paid, 793 employer-paid, plus 8 part-time), 80 employees in Pet Insurance, and 2,457 employees in LTD coverage (all employee-paid), with a total enrolled workforce of 5,319 employees across participating agencies.

The premium collection and remittance structure varies by agency, with most programs utilizing semi-monthly collection cycles (24 pays annually) while one agency operates bi-weekly (26 pays). Premiums are either collected and remitted by Franklin County directly to vendors or by individual agencies, depending on the specific program and agency requirements, with timing varying between one month in arrears, current month, or one month in advance. Agency 7000 offers unique dual coverage options providing voluntary employee-paid STD at hire and employer-paid STD after 12 months of employment, along with employee-paid LTD and employer-paid Legal Plan coverage. Agency 8200 provides employer-paid STD and LTD coverage not part of Franklin County's standard program, while Agency 9996 does not participate in any Franklin County voluntary coverage. A 60-day grace period applies to most programs, and specific agencies (5000, 5001, 5002, 9995, 9997, and 8200) handle their own premium remittance directly to vendors rather than routing through Franklin County.