Appendix_7_6_Enrollment_by_Plan_Group.xlsx

This file is an enrollment data spreadsheet detailing health plan coverage across three jurisdictions: Local Education, Local Government, and State. The document presents a comprehensive breakdown of active full-time employees, part-time employees, COBRA participants, and retirees segmented by gender, age bracket, and relationship group type (child, employee, spouse). The Local Education sector encompasses 126,115 total enrollees, including 120,790 active full-time members across various demographics. The Local Government jurisdiction covers 26,670 enrollees with 26,342 active full-time participants. The State sector represents the largest group with 146,281 total enrollees, including 138,317 active full-time members. Overall enrollment across all three jurisdictions totals 299,066 participants. The data reveals significant variation in enrollment patterns, with the highest concentration of active full-time employees occurring in the 40 to 64 age bracket across all jurisdictions.

The spreadsheet provides detailed demographic stratification essential for benefits administration and actuarial analysis. The State jurisdiction demonstrates the largest dependent enrollment, with substantial numbers of employees spanning the 19 to 39 and 40 to 64 age brackets. COBRA continuation coverage remains minimal across all jurisdictions, representing fewer than 500 total participants. Retiree populations range from 5,169 in Local Education to 7,694 in the State sector, indicating significant long-term liability exposure. The data indicates active part-time enrollment is substantially lower than full-time populations, with limited participation primarily in the State and Local Education sectors. Gender distribution across most categories demonstrates relatively balanced male and female participation, with some variation by age group and employment status. This enrollment information appears designed to support health plan cost projections, premium calculations, and benefits allocation decisions across the three participating governmental entities.