Appendix_7_6_Enrollment_by_Plan_Group.xlsx

This enrollment data spreadsheet provides a detailed breakdown of covered lives across three Tennessee insurance plans—State, Local Education, and Local Government—segmented by employment classification, demographic characteristics, and relationship to the employee. The data encompasses 299,066 total covered lives distributed across Active Full-Time employees (235,449 lives), Active Part-Time employees (52 lives), COBRA participants (414 lives), and Retirees (13,151 lives). The State Plan represents the largest cohort with 146,281 covered lives, followed by the Local Education Plan with 126,115 covered lives, and the Local Government Plan with 26,670 covered lives. Enrollment is further stratified by gender (Female, Male, and Undesignated), age bracket (Less than a year through 65 and older), and relationship type (Child, Employee, and Spouse), providing a comprehensive demographic profile essential for behavioral health services planning and resource allocation.

The enrollment distribution reveals significant concentration among working-age populations, with the 40-to-64 age bracket and 19-to-39 age bracket representing the largest segments across all three plans. The data supports the contract procurement's stated scope of approximately 300,000 covered lives requiring integrated Employee Assistance Program and Behavioral Health Organization services. This granular enrollment information establishes the baseline population for claims adjudication, network administration, utilization management, and call center services outlined in the RFP, enabling potential vendors to accurately forecast operational requirements and pricing models based on the per-employee-per-month administrative fee structure specified in the procurement.