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 file is an enrollment spreadsheet prepared by the State of Tennessee for its Employee Assistance Program (EAP) and Behavioral Health Organization (BHO) procurement, detailing covered lives across three distinct self-funded insurance plans: State, Local Education, and Local Government. The spreadsheet presents detailed enrollment breakdowns by plan type, gender, age bracket, and dependent versus employee status across multiple insurance options including Limited PPO, CDHP, Premier PPO, and Standard PPO plans. The State Plan encompasses 146,281 covered lives, the Local Education Plan comprises 126,115 covered lives, and the Local Government Plan contains 26,670 covered lives, for a combined total of 299,066 covered lives requiring administrative and behavioral health services. The RFP was issued on October 8, 2025, with written questions due October 22 and November 19, 2025, and proposals due December 19, 2025. The state anticipates completing technical evaluations by January 29, 2026, with cost proposal scoring on January 30, 2026, and negotiations scheduled for February 9-11, 2026. The contract period spans 86 months, comprising eight months of implementation, 60 months of service delivery from January 1, 2027 through December 31, 2031, and an 18-month claims runout period.
The procurement utilizes a per-employee-per-month (PEPM) administrative fee model with no specific award value stated, though the state self-funds approximately $976 million in annual medical, pharmacy, and behavioral health claims across all three plans. The successful contractor must maintain NCQA accreditation as a Managed Behavioral Healthcare Organization and URAC accreditation for utilization management programs, with performance guarantees tied to liquidated damages ranging from $1,000 to $75,000 per incident. Qualified vendors must demonstrate financial stability, relevant experience managing employer populations exceeding 10,000 members, and claims adjudication experience exceeding $10 million annually for at least two clients. The state encourages responses from minority-owned, women-owned, service-disabled veteran-owned, and small business enterprises. Additional requirements include $5 million in cyber liability insurance and compliance with HIPAA, HITECH, and state security requirements, including annual SOC 2 Type 2 examinations and penetration testing. The incumbent contractor will be responsible for transitioning existing members and services at no additional cost to the state.
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 .