Appendix_7_6_Enrollment_by_Plan_Group.xlsx

This enrollment data file presents a comprehensive breakdown of covered lives across three Tennessee public sector insurance plans—State, Local Education (Local Ed), and Local Government (Local Gov)—by demographic categories including gender, age bracket, and relationship type (employee, spouse, child). The State Plan encompasses 146,281 total covered lives, comprised of 138,317 active full-time employees, 52 active part-time employees, 218 COBRA participants, and 7,694 retirees. The Local Education Plan covers 126,115 lives, consisting of 120,790 active full-time employees, 1 active part-time employee, 155 COBRA participants, and 5,169 retirees. The Local Government Plan includes 26,670 covered lives, with 26,342 active full-time employees, 41 COBRA participants, and 287 retirees. Across all three plans, the combined enrollment totals 299,066 covered lives. The data is stratified by gender (Female, Male, Undesignated), with age brackets ranging from "Less than a year" through "65 and older," enabling the behavioral health organization contractor to understand the demographic composition and service utilization patterns across the enrolled populations.

The enrollment data serves as a critical baseline for determining per-employee-per-month (PEPM) administrative fees and projected claims volumes under the integrated Employee Assistance Program and Behavioral Health Organization services contract. This demographic distribution directly informs staffing requirements for call center operations, utilization management capacity, and network adequacy standards that the selected vendor must maintain across all three financially independent self-funded plans. The substantial enrollment across active employees, retirees, and COBRA participants indicates the contractor's need to deploy comprehensive service capabilities spanning multiple population segments with varying behavioral health needs and utilization patterns, particularly given the significant representation of employees in the 40-to-64 age bracket across all plans.