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

This is an employee benefits enrollment and plan configuration document for Franklin County, Ohio and associated municipalities including the City of Grandview Heights, Prairie Township, and Jefferson Township. The document outlines the disability insurance and legal services plan structure effective April 1, 2015, with subsequent amendments. The spreadsheet maps Long-Term Disability (LTD) and Short-Term Disability (STD) coverage across multiple county departments, elected officials, and municipal entities, organized by bargaining unit status and employee classifications. Additional coverage includes MetLife Legal Plans effective January 1, 2024, and MetLife Pet Insurance effective December 1, 2024. The plan configurations span approximately 50 county departments and offices including judicial departments, executive offices, service agencies, and specialized divisions such as the Sheriff's Office, Children Services, and various township operations.

The document reflects a comprehensive benefits structure with differentiated coverage for bargaining unit employees, non-bargaining employees, and elected officials. Plan effective dates vary by department, with most coverage commencing April 1, 2015, while certain departments such as Guardianship Service Board (August 1, 2015), SWACO (April 1, 2016), and Jefferson Township (January 1, 2018) implemented coverage on later dates. The spreadsheet indicates export number 157775 as the primary reference identifier for most legacy plans, with newer products assigned separate export numbers (255624 for MetLife Legal Plans and 265487 for MetLife Pet Insurance). All plans are managed through standardized sub-codes and branch designations, providing a centralized administrative framework for employee benefits across the multi-jurisdictional county system.