Appendix%207.7%20Enrollment%20by%20Plan.xlsx

This is an enrollment data file documenting health plan participation across Tennessee's public sector health plans, including State, Local Education, and Local Government employee groups. The spreadsheet presents a comprehensive breakdown of 300,954 total enrollees distributed across four primary plan types: Limited PPO, CDHP (Consumer Driven Health Plan), Premier PPO, and Standard PPO. Enrollment data is segmented by employee classification (dependent versus employee), gender (female, male, and unspecified), and age brackets (0, 1-18, 19-39, 40-64, and 65 and older). The State group represents the largest enrollment segment with 147,139 members, followed by Local Education with 124,744 members and Local Government with 29,071 members. The Premier PPO plan is the most popular across all groups, with 76,146 enrollees in Local Education, 69,040 in State, and 12,519 in Local Government.

The enrollment distribution reveals significant demographic patterns relevant to benefits administration and actuarial planning. Premier PPO and Standard PPO plans dominate enrollment across all three jurisdictional groups, collectively accounting for the majority of covered lives. The State group shows relatively balanced enrollment between dependent and employee classifications, while Local Education demonstrates higher dependent enrollment. Age distribution indicates substantial concentration in the 40-to-64 age bracket across most plan types, reflecting an aging workforce demographic. This enrollment data serves as a critical baseline for the Third Party Administrator Services contract, as it quantifies the beneficiary population requiring claims processing, customer service, and administrative support across Tennessee's public sector health insurance programs.