Appendix_7_6_Enrollment_by_Plan_Group.xlsx
XLSX spreadsheet 15 KB Posted
- Attached to
- Employee Assistance Program (EAP) and Behavioral Health Organization (BHO) Services - UPDATED
- Solicitation number
- RFP 31786-00188
- Issued by
- Davidson County, Tennessee
About this file
The file is an Excel spreadsheet titled "Appendix_7_6_Enrollment_by_Plan_Group.xlsx" detailing enrollment data for Local Education, Local Government, and State entities across different demographic categories. The spreadsheet provides a comprehensive breakdown of employee enrollment by gender, age bracket, relationship status, and employment type (Active Full-Time, Active Part-Time, COBRA, and Retiree).
The enrollment data reveals a total of 299,066 individuals across three primary jurisdictions: Local Education (126,115 enrollees), Local Government (26,670 enrollees), and State (146,281 enrollees). The breakdown includes detailed categorizations such as age groups (less than a year, 1-18, 19-39, 40-64, and 65 and older), gender (Female, Male, and Unspecified), and employment status. The largest enrollment segment is Active Full-Time employees, with significant representation across all three jurisdictions, particularly in the State and Local Education sectors. The data appears to be related to a comprehensive benefits or insurance enrollment tracking system, providing a granular view of participant demographics and coverage characteristics.
View the file
Other files
Show 40 more
Latest 50 of 76 listed here. See the rest on GovTribe.
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 | Gender | Age Bracket | Relationship | ||||
| Group | Type | Child | Employee | Spouse | Grand Total | ||
| Local Ed | Active Full-Time | F | Less than a year | 256 | 256 | ||
| 1 to 18 | 13,615 | 13,615 | |||||
| 19 to 39 | 6,880 | 14,040 | 1,539 | 22,459 | |||
| 40 to 64 | 29,702 | 3,139 | 32,841 | ||||
| 65 and older | 2,016 | 179 | 2,195 | ||||
| M | Less than a year | 258 | 258 | ||||
| 1 to 18 | 14,563 | 2 | 2 | 14,567 | |||
| 19 to 39 | 7,253 | 4,233 | 2,931 | 14,417 | |||
| 40 to 64 | 2 | 8,069 | 10,424 | 18,495 | |||
| 65 and older | 845 | 833 | 1,678 | ||||
| U | 1 to 18 | 5 | 5 | ||||
| 19 to 39 | 2 | 2 | |||||
| 40 to 64 | 2 | 2 | |||||
| Active Full-Time Total | 42,834 | 58,907 | 19,049 | 120,790 | |||
| Active Part-Time | F | 19 to 39 | 1 | 1 | |||
| Active Part-Time Total | 1 | 1 | |||||
| Cobra | F | 1 to 18 | 12 | 12 | |||
| 19 to 39 | 15 | 16 | 1 | 32 | |||
| 40 to 64 | 38 | 2 | 40 | ||||
| 65 and older | 5 | 5 | |||||
| M | 1 to 18 | 8 | 8 | ||||
| 19 to 39 | 14 | 3 | 4 | 21 | |||
| 40 to 64 | 21 | 12 | 33 | ||||
| 65 and older | 2 | 2 | 4 | ||||
| Cobra Total | 49 | 85 | 21 | 155 | |||
| Retiree | F | 1 to 18 | 50 | 50 | |||
| 19 to 39 | 260 | 2 | 262 | ||||
| 40 to 64 | 2 | 2,766 | 281 | 3,049 | |||
| 65 and older | 94 | 3 | 97 | ||||
| M | 1 to 18 | 59 | 59 | ||||
| 19 to 39 | 231 | 2 | 233 | ||||
| 40 to 64 | 12 | 600 | 770 | 1,382 | |||
| 65 and older | 18 | 19 | 37 | ||||
| Retiree Total | 614 | 3,482 | 1,073 | 5,169 | |||
| Local Ed Total | 43,497 | 62,475 | 20,143 | 126,115 | |||
| Local Gov | Active Full-Time | F | Less than a year | 40 | 40 | ||
| 1 to 18 | 2,065 | 2,065 | |||||
| 19 to 39 | 987 | 2,437 | 741 | 4,165 | |||
| 40 to 64 | 1 | 4,942 | 1,296 | 6,239 | |||
| 65 and older | 549 | 136 | 685 | ||||
| M | Less than a year | 51 | 51 | ||||
| 1 to 18 | 2,146 | 3 | 2,149 | ||||
| 19 to 39 | 1,003 | 3,362 | 152 | 4,517 | |||
| 40 to 64 | 4,973 | 730 | 5,703 | ||||
| 65 and older | 620 | 108 | 728 | ||||
| Active Full-Time Total | 6,293 | 16,886 | 3,163 | 26,342 | |||
| Cobra | F | 1 to 18 | 2 | 2 | |||
| 19 to 39 | 2 | 2 | 4 | ||||
| 40 to 64 | 14 | 14 | |||||
| 65 and older | 3 | 3 | |||||
| M | 1 to 18 | 5 | 5 | ||||
| 19 to 39 | 1 | 1 | 2 | ||||
| 40 to 64 | 9 | 1 | 10 | ||||
| 65 and older | 1 | 1 | |||||
| Cobra Total | 10 | 28 | 3 | 41 | |||
| Retiree | F | 1 to 18 | 3 | 3 | |||
| 19 to 39 | 18 | 1 | 19 | ||||
| 40 to 64 | 62 | 54 | 116 | ||||
| M | 1 to 18 | 1 | 1 | ||||
| 19 to 39 | 12 | 12 | |||||
| 40 to 64 | 120 | 10 | 130 | ||||
| 65 and older | 6 | 6 | |||||
| Retiree Total | 34 | 189 | 64 | 287 | |||
| Local Gov Total | 6,337 | 17,103 | 3,230 | 26,670 | |||
| State | Active Full-Time | F | Less than a year | 294 | 294 | ||
| 1 to 18 | 14,877 | 14,877 | |||||
| 19 to 39 | 7,650 | 11,505 | 4,145 | 23,300 | |||
| 40 to 64 | 3 | 22,580 | 9,027 | 31,610 | |||
| 65 and older | 2,540 | 1,129 | 3,669 | ||||
| M | Less than a year | 318 | 318 | ||||
| 1 to 18 | 15,688 | 1 | 1 | 15,690 | |||
| 19 to 39 | 7,806 | 8,793 | 2,706 | 19,305 | |||
| 40 to 64 | 3 | 16,410 | 8,870 | 25,283 | |||
| 65 and older | 2,444 | 1,520 | 3,964 | ||||
| U | 1 to 18 | 5 | 5 | ||||
| 19 to 39 | 1 | 1 | |||||
| 40 to 64 | 1 | 1 | |||||
| Active Full-Time Total | 46,645 | 64,273 | 27,399 | 138,317 | |||
| Active Part-Time | F | 1 to 18 | 7 | 7 | |||
| 19 to 39 | 4 | 4 | |||||
| 40 to 64 | 6 | 6 | 12 | ||||
| 65 and older | 2 | 2 | |||||
| M | 1 to 18 | 4 | 4 | ||||
| 19 to 39 | 2 | 7 | 9 | ||||
| 40 to 64 | 7 | 3 | 10 | ||||
| 65 and older | 3 | 1 | 4 | ||||
| Active Part-Time Total | 13 | 27 | 12 | 52 | |||
| Cobra | F | 1 to 18 | 21 | 21 | |||
| 19 to 39 | 9 | 17 | 2 | 28 | |||
| 40 to 64 | 57 | 10 | 67 | ||||
| 65 and older | 2 | 1 | 3 | ||||
| M | 1 to 18 | 17 | 17 | ||||
| 19 to 39 | 17 | 10 | 27 | ||||
| 40 to 64 | 39 | 6 | 45 | ||||
| 65 and older | 8 | 2 | 10 | ||||
| Cobra Total | 64 | 133 | 21 | 218 | |||
| Retiree | F | Less than a year | 1 | 1 | |||
| 1 to 18 | 138 | 138 | |||||
| 19 to 39 | 477 | 5 | 11 | 493 | |||
| 40 to 64 | 21 | 2,274 | 1,469 | 3,764 | |||
| 65 and older | 149 | 91 | 240 | ||||
| M | 1 to 18 | 132 | 132 | ||||
| 19 to 39 | 465 | 1 | 1 | 467 | |||
| 40 to 64 | 26 | 1,539 | 725 | 2,290 | |||
| 65 and older | 135 | 34 | 169 | ||||
| Retiree Total | 1,260 | 4,103 | 2,331 | 7,694 | |||
| State Total | 47,982 | 68,536 | 29,763 | 146,281 | |||
| Grand Total | 97,816 | 148,114 | 53,136 | 299,066 |
File details come from the government source that posted it. Updated .