Appendix_7_5_Enrollment_by_Plan.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
This Excel spreadsheet is an enrollment breakdown for health insurance plans across local education and local government sectors, detailing participant demographics for multiple plan types. The document provides a comprehensive count of employees and dependents by plan type (Limited PPO, Local CDHP, Premier PPO, Standard PPO), gender, and age brackets across different organizational segments. The enrollment data spans Local Ed and Local Gov categories, with further segmentation into state-level CDHP/HSA, Premier PPO, and Standard PPO plans.
The spreadsheet reveals a total enrollment of 299,066 participants, with Local Ed accounting for 126,115 enrollees and Local Gov representing 26,670 individuals. The state-level plans contribute an additional 146,281 participants. The data is meticulously organized, showing enrollment distributions across age groups ranging from less than one year to 65 and older, with gender-specific breakdowns. Premier PPO appears to be the most populous plan type, with 77,433 total enrollees in the Local Ed segment and 72,062 in the state segment, indicating significant healthcare coverage for employees and dependents across these governmental sectors.
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 | Dependent or Employee | |||||
| Group | Plan Type | Gender | Age Bracket | Dependent | Employee | Grand Total |
| Local Ed | Limited PPO | F | Less than a year | 19 | 19 | |
| 1 to 18 | 1555 | 1555 | ||||
| 19 to 39 | 993 | 1658 | 2651 | |||
| 40 to 64 | 394 | 3477 | 3871 | |||
| 65 and older | 16 | 199 | 215 | |||
| M | Less than a year | 25 | 25 | |||
| 1 to 18 | 1630 | 1 | 1631 | |||
| 19 to 39 | 1196 | 596 | 1792 | |||
| 40 to 64 | 1257 | 987 | 2244 | |||
| 65 and older | 67 | 88 | 155 | |||
| Limited PPO Total | 7152 | 7006 | 14158 | |||
| Local CDHP | F | Less than a year | 17 | 17 | ||
| 1 to 18 | 1028 | 1028 | ||||
| 19 to 39 | 529 | 778 | 1307 | |||
| 40 to 64 | 238 | 1455 | 1693 | |||
| 65 and older | 9 | 32 | 41 | |||
| M | Less than a year | 10 | 10 | |||
| 1 to 18 | 1066 | 1066 | ||||
| 19 to 39 | 645 | 343 | 988 | |||
| 40 to 64 | 707 | 506 | 1213 | |||
| 65 and older | 29 | 14 | 43 | |||
| U | 1 to 18 | 1 | 1 | |||
| Local CDHP Total | 4279 | 3128 | 7407 | |||
| Premier PPO | F | Less than a year | 166 | 166 | ||
| 1 to 18 | 7983 | 7983 | ||||
| 19 to 39 | 5364 | 8205 | 13569 | |||
| 40 to 64 | 2154 | 20974 | 23128 | |||
| 65 and older | 126 | 1517 | 1643 | |||
| M | Less than a year | 159 | 159 | |||
| 1 to 18 | 8737 | 1 | 8738 | |||
| 19 to 39 | 6291 | 2196 | 8487 | |||
| 40 to 64 | 6955 | 5397 | 12352 | |||
| 65 and older | 605 | 597 | 1202 | |||
| U | 1 to 18 | 2 | 2 | |||
| 19 to 39 | 2 | 2 | ||||
| 40 to 64 | 2 | 2 | ||||
| Premier PPO Total | 38546 | 38887 | 77433 | |||
| Standard PPO | F | Less than a year | 54 | 54 | ||
| 1 to 18 | 3111 | 3111 | ||||
| 19 to 39 | 1809 | 3418 | 5227 | |||
| 40 to 64 | 638 | 6600 | 7238 | |||
| 65 and older | 31 | 367 | 398 | |||
| M | Less than a year | 64 | 64 | |||
| 1 to 18 | 3199 | 3199 | ||||
| 19 to 39 | 2301 | 1103 | 3404 | |||
| 40 to 64 | 2301 | 1800 | 4101 | |||
| 65 and older | 153 | 166 | 319 | |||
| U | 1 to 18 | 2 | 2 | |||
| Standard PPO Total | 13663 | 13454 | 27117 | |||
| Local Ed Total | 63640 | 62475 | 126115 | |||
| Local Gov | Limited PPO | F | Less than a year | 12 | 12 | |
| 1 to 18 | 686 | 686 | ||||
| 19 to 39 | 552 | 893 | 1445 | |||
| 40 to 64 | 363 | 1715 | 2078 | |||
| 65 and older | 26 | 158 | 184 | |||
| M | Less than a year | 15 | 15 | |||
| 1 to 18 | 723 | 3 | 726 | |||
| 19 to 39 | 380 | 1130 | 1510 | |||
| 40 to 64 | 274 | 1547 | 1821 | |||
| 65 and older | 23 | 143 | 166 | |||
| Limited PPO Total | 3054 | 5589 | 8643 | |||
| Local CDHP | F | Less than a year | 4 | 4 | ||
| 1 to 18 | 151 | 151 | ||||
| 19 to 39 | 101 | 164 | 265 | |||
| 40 to 64 | 74 | 236 | 310 | |||
| 65 and older | 3 | 5 | 8 | |||
| M | Less than a year | 2 | 2 | |||
| 1 to 18 | 116 | 116 | ||||
| 19 to 39 | 52 | 225 | 277 | |||
| 40 to 64 | 40 | 258 | 298 | |||
| 65 and older | 6 | 17 | 23 | |||
| Local CDHP Total | 549 | 905 | 1454 | |||
| Premier PPO | F | Less than a year | 15 | 15 | ||
| 1 to 18 | 898 | 898 | ||||
| 19 to 39 | 791 | 989 | 1780 | |||
| 40 to 64 | 672 | 2337 | 3009 | |||
| 65 and older | 84 | 294 | 378 | |||
| M | Less than a year | 22 | 22 | |||
| 1 to 18 | 1001 | 1001 | ||||
| 19 to 39 | 560 | 1312 | 1872 | |||
| 40 to 64 | 334 | 2307 | 2641 | |||
| 65 and older | 61 | 339 | 400 | |||
| Premier PPO Total | 4438 | 7578 | 12016 | |||
| Standard PPO | F | Less than a year | 9 | 9 | ||
| 1 to 18 | 335 | 335 | ||||
| 19 to 39 | 304 | 394 | 698 | |||
| 40 to 64 | 242 | 730 | 972 | |||
| 65 and older | 23 | 95 | 118 | |||
| M | Less than a year | 12 | 12 | |||
| 1 to 18 | 312 | 312 | ||||
| 19 to 39 | 177 | 695 | 872 | |||
| 40 to 64 | 93 | 990 | 1083 | |||
| 65 and older | 19 | 127 | 146 | |||
| Standard PPO Total | 1526 | 3031 | 4557 | |||
| Local Gov Total | 9567 | 17103 | 26670 | |||
| State | CDHP/HSA | F | Less than a year | 37 | 37 | |
| 1 to 18 | 1756 | 1756 | ||||
| 19 to 39 | 1225 | 1447 | 2672 | |||
| 40 to 64 | 994 | 1917 | 2911 | |||
| 65 and older | 67 | 83 | 150 | |||
| M | Less than a year | 33 | 33 | |||
| 1 to 18 | 1854 | 1854 | ||||
| 19 to 39 | 983 | 1395 | 2378 | |||
| 40 to 64 | 879 | 1697 | 2576 | |||
| 65 and older | 64 | 127 | 191 | |||
| U | 1 to 18 | 2 | 2 | |||
| CDHP/HSA Total | 7894 | 6666 | 14560 | |||
| Premier PPO | F | Less than a year | 127 | 127 | ||
| 1 to 18 | 6848 | 6848 | ||||
| 19 to 39 | 5901 | 3908 | 9809 | |||
| 40 to 64 | 5846 | 13863 | 19709 | |||
| 65 and older | 860 | 1871 | 2731 | |||
| M | Less than a year | 137 | 137 | |||
| 1 to 18 | 7148 | 7148 | ||||
| 19 to 39 | 5480 | 2613 | 8093 | |||
| 40 to 64 | 5140 | 9493 | 14633 | |||
| 65 and older | 1092 | 1732 | 2824 | |||
| U | 1 to 18 | 2 | 2 | |||
| 40 to 64 | 1 | 1 | ||||
| Premier PPO Total | 38582 | 33480 | 72062 | |||
| Standard PPO | F | Less than a year | 131 | 131 | ||
| 1 to 18 | 6439 | 6439 | ||||
| 19 to 39 | 5168 | 6176 | 11344 | |||
| 40 to 64 | 3696 | 9137 | 12833 | |||
| 65 and older | 296 | 737 | 1033 | |||
| M | Less than a year | 148 | 148 | |||
| 1 to 18 | 6840 | 1 | 6841 | |||
| 19 to 39 | 4534 | 4803 | 9337 | |||
| 40 to 64 | 3614 | 6805 | 10419 | |||
| 65 and older | 401 | 731 | 1132 | |||
| U | 1 to 18 | 1 | 1 | |||
| 19 to 39 | 1 | 1 | ||||
| Standard PPO Total | 31269 | 28390 | 59659 | |||
| State Total | 77745 | 68536 | 146281 | |||
| Grand Total | 150952 | 148114 | 299066 |
File details come from the government source that posted it. Updated .