4540076D-DA44-888C-413CAB868FEC6141.xlsx

This file is an employee benefits enrollment and plan mapping document for Franklin County, Ohio and associated municipalities, detailing long-term disability (LTD) and short-term disability (STD) insurance coverage across multiple departments and employee classifications. The document outlines plan assignments effective April 1, 2015, with select plan effective dates of August 1, 2015, January 1, 2018, April 1, 2016, and subsequent dates through January 1, 2024. Coverage extends across numerous county departments including Commissioners, Human Resources, Purchasing, Fleet Management, Auditor, Treasurer, Prosecutor, Common Pleas Courts, Probate Court, Clerk of Courts, Coroner, Board of Elections, Recorder, Engineer, Board of Health, Sheriff, and various social services departments, as well as to the municipalities of Prairie Township, Jefferson Township, and City of Grandview Heights. The document segments employee populations into three primary classifications: bargaining unit employees, non-bargaining employees, and elected officials, with separate plan designations for permanent part-time employees in Grandview Heights.

The spreadsheet maps specific sub-codes and branch designations to corresponding LTD and STD plans, with all Franklin County employee plans consolidated under a single plan structure and separate plan designations maintained for Grandview Heights employees. Additional supplemental coverage includes MetLife Legal Plans (Franklin - Non-Platform) effective January 1, 2024, and MetLife Pet Insurance effective December 1, 2024. The file indicates export number 157775 as the primary export reference for most entries, with subsequent export numbers 255624 and 265487 associated with the newer supplemental coverages. The document serves as an administrative reference tool for benefits administration, ensuring proper classification of employees for insurance eligibility and claims processing purposes across the county's decentralized departmental structure.