Appendix%207.6%20Enrollment%20by%20Plan%20Group.xlsx
XLSX spreadsheet 15 KB Posted
- Solicitation number
- RFP 31786-00190
- Issued by
- Davidson County, Tennessee
About this file
This appendix presents enrollment data by plan group for Tennessee's public sector health plans, covering three primary jurisdictions: Local Education, Local Government, and State employees. The spreadsheet provides a comprehensive breakdown of plan membership across Active Full-Time, Active Part-Time, COBRA, and Retiree categories, segmented by employee relationship (Employee, Spouse, Child, Grand Total), gender (Female, Male, Unspecified), and age bracket (1 to 18, 19 to 39, 40 to 64, 65 and older). The total enrollment across all three jurisdictions is 300,954 members, with State employees representing the largest portion at 147,139 members, followed by Local Education at 124,744 members, and Local Government at 29,071 members.
Active Full-Time employees constitute the dominant enrollment category across all jurisdictions, with 287,414 total members, while retirees account for 12,956 members and COBRA participants represent 561 members. The State jurisdiction shows the highest concentration of active full-time employees at 139,257, with particular density in the 40 to 64 age bracket for both male and female participants. Spouse and dependent coverage represents a substantial portion of total enrollment, indicating comprehensive family plan utilization across all three employer groups. This enrollment data serves as the baseline for Third Party Administrator service requirements and cost projections for the state's public sector health plans.
View the file
Other files
Show all 20
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| Count of HOC ID | Relationship | ||||||
| Group | Overall PT/FT | Gender | Age Bracket | Child | Employee | Spouse | Grand Total |
| Local Ed | Active - Full Time | F | 0 | 503 | 503 | ||
| 1 to 18 | 13,595 | 2 | 13,597 | ||||
| 19 to 39 | 6,437 | 14,022 | 1,556 | 22,015 | |||
| 40 to 64 | 29,271 | 3,100 | 32,371 | ||||
| 65 and older | 1,845 | 168 | 2,013 | ||||
| M | 0 | 515 | 515 | ||||
| 1 to 18 | 14,542 | 1 | 14,543 | ||||
| 19 to 39 | 6,736 | 4,256 | 2,988 | 13,980 | |||
| 40 to 64 | 3 | 8,037 | 10,311 | 18,351 | |||
| 65 and older | 799 | 757 | 1,556 | ||||
| U | 1 to 18 | 5 | 5 | ||||
| 19 to 39 | 2 | 1 | 3 | ||||
| 40 to 64 | 2 | 2 | |||||
| Active - Full Time Total | 42,338 | 58,233 | 18,883 | 119,454 | |||
| COBRA | F | 0 | 3 | 3 | |||
| 1 to 18 | 20 | 20 | |||||
| 19 to 39 | 13 | 14 | 27 | ||||
| 40 to 64 | 70 | 6 | 76 | ||||
| 65 and older | 2 | 2 | |||||
| M | 1 to 18 | 14 | 14 | ||||
| 19 to 39 | 13 | 5 | 2 | 20 | |||
| 40 to 64 | 26 | 22 | 48 | ||||
| 65 and older | 1 | 1 | 2 | ||||
| COBRA Total | 63 | 118 | 31 | 212 | |||
| Retiree | F | 1 to 18 | 47 | 47 | |||
| 19 to 39 | 249 | 2 | 251 | ||||
| 40 to 64 | 2 | 2,824 | 265 | 3,091 | |||
| 65 and older | 2 | 2 | |||||
| M | 1 to 18 | 62 | 62 | ||||
| 19 to 39 | 198 | 3 | 201 | ||||
| 40 to 64 | 13 | 625 | 785 | 1,423 | |||
| 65 and older | 1 | 1 | |||||
| Retiree Total | 571 | 3,457 | 1,050 | 5,078 | |||
| Local Ed Total | 42,972 | 61,808 | 19,964 | 124,744 | |||
| Local Gov | Active - Full Time | F | 0 | 95 | 95 | ||
| 1 to 18 | 2,304 | 6 | 2,310 | ||||
| 19 to 39 | 1,018 | 2,734 | 851 | 4,603 | |||
| 40 to 64 | 1 | 5,326 | 1,408 | 6,735 | |||
| 65 and older | 569 | 122 | 691 | ||||
| M | 0 | 95 | 95 | ||||
| 1 to 18 | 2,341 | 10 | 2,351 | ||||
| 19 to 39 | 1,025 | 3,778 | 187 | 4,990 | |||
| 40 to 64 | 5,371 | 778 | 6,149 | ||||
| 65 and older | 579 | 105 | 684 | ||||
| Active - Full Time Total | 6,879 | 18,373 | 3,451 | 28,703 | |||
| COBRA | F | 1 to 18 | 1 | 1 | |||
| 19 to 39 | 3 | 1 | 4 | ||||
| 40 to 64 | 21 | 3 | 24 | ||||
| M | 1 to 18 | 5 | 5 | ||||
| 19 to 39 | 1 | 1 | 2 | ||||
| 40 to 64 | 19 | 2 | 21 | ||||
| 65 and older | 1 | 1 | |||||
| COBRA Total | 6 | 45 | 7 | 58 | |||
| Retiree | F | 1 to 18 | 4 | 4 | |||
| 19 to 39 | 15 | 1 | 16 | ||||
| 40 to 64 | 67 | 54 | 121 | ||||
| M | 1 to 18 | 4 | 4 | ||||
| 19 to 39 | 12 | 12 | |||||
| 40 to 64 | 140 | 12 | 152 | ||||
| 65 and older | 1 | 1 | |||||
| Retiree Total | 35 | 209 | 66 | 310 | |||
| Local Gov Total | 6,920 | 18,627 | 3,524 | 29,071 | |||
| State | Active - Full Time | F | 0 | 594 | 594 | ||
| 1 to 18 | 15,241 | 1 | 15,242 | ||||
| 19 to 39 | 7,152 | 11,986 | 4,434 | 23,572 | |||
| 40 to 64 | 3 | 22,510 | 9,038 | 31,551 | |||
| 65 and older | 2,191 | 1,005 | 3,196 | ||||
| M | 0 | 609 | 609 | ||||
| 1 to 18 | 16,112 | 1 | 16,113 | ||||
| 19 to 39 | 7,170 | 9,427 | 2,921 | 19,518 | |||
| 40 to 64 | 1 | 16,405 | 8,884 | 25,290 | |||
| 65 and older | 2,180 | 1,384 | 3,564 | ||||
| U | 0 | 1 | 1 | ||||
| 1 to 18 | 6 | 6 | |||||
| 19 to 39 | 1 | 1 | |||||
| Active - Full Time Total | 46,889 | 64,700 | 27,668 | 139,257 | |||
| Active - Part Time | F | 0 | 1 | 1 | |||
| 1 to 18 | 3 | 3 | |||||
| 19 to 39 | 4 | 4 | |||||
| 40 to 64 | 2 | 2 | 4 | ||||
| 65 and older | 2 | 2 | |||||
| M | 19 to 39 | 3 | 1 | 4 | |||
| 40 to 64 | 2 | 2 | |||||
| 65 and older | 2 | 1 | 3 | ||||
| Active - Part Time Total | 4 | 13 | 6 | 23 | |||
| COBRA | F | 0 | 1 | 1 | |||
| 1 to 18 | 20 | 20 | |||||
| 19 to 39 | 8 | 33 | 3 | 44 | |||
| 40 to 64 | 85 | 19 | 104 | ||||
| 65 and older | 4 | 1 | 5 | ||||
| M | 1 to 18 | 17 | 17 | ||||
| 19 to 39 | 11 | 19 | 1 | 31 | |||
| 40 to 64 | 48 | 19 | 67 | ||||
| 65 and older | 2 | 2 | |||||
| COBRA Total | 57 | 191 | 43 | 291 | |||
| Retiree | F | 1 to 18 | 143 | 143 | |||
| 19 to 39 | 489 | 4 | 11 | 504 | |||
| 40 to 64 | 21 | 2,315 | 1,469 | 3,805 | |||
| 65 and older | 55 | 41 | 96 | ||||
| M | 1 to 18 | 141 | 141 | ||||
| 19 to 39 | 470 | 1 | 2 | 473 | |||
| 40 to 64 | 24 | 1,570 | 718 | 2,312 | |||
| 65 and older | 90 | 4 | 94 | ||||
| Retiree Total | 1,288 | 4,035 | 2,245 | 7,568 | |||
| State Total | 48,238 | 68,939 | 29,962 | 147,139 | |||
| Grand Total | 98,130 | 149,374 | 53,450 | 300,954 |
File details come from the government source that posted it. Updated .