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

File Type Posted
Appendix_7_11_DOHR_Policy_17-002-Contract_Section_A_8_b_5.pdf PDF
Appendix_7_12_Written_Questions_and_Comments_template.pdf PDF
Appendix_7_12_Written_Questions_and_Comments_template.pdf PDF
31786-00188_EAP_BHO_for_posting.pdf PDF
Appendix_7_8_Benefits_Administration_834_Guidance_Manual_v5.pdf PDF
Appendix_7_5_Enrollment_by_Plan.xlsx XLSX spreadsheet
31786-00188_EAP_BHO_Release_2.pdf PDF
RFP_31786-00188_Amendment_One.pdf PDF
31786-00188_Release_3.pdf PDF
Appendix_7_10_HIPAA_Business_Associate_Assessment.xlsx XLSX spreadsheet
Appendix_7_6_Enrollment_by_Plan_Group.xlsx XLSX spreadsheet
Appendix_7_1_Provider_and_Facility_Disruption-1.xlsx XLSX spreadsheet
31786-00188_Digital_Submission_Instructions.pdf PDF
Appendix_7_3_Network_Access_Analysis_Sample_Report.pdf PDF
Appendix_7_7_EAP_WL_MHSA_Utilization_Revised.xlsx XLSX spreadsheet
Appendix_7_13_LE_LG_enrollment_counts_by_dept.xlsx XLSX spreadsheet
Appendix_7_4_TN_Zip_Code_List.xlsx XLSX spreadsheet
Appendix_7_9_Decision_Support_System_File_Layout.xlsx XLSX spreadsheet
Attachment_6_3_Cos_Proposal.xlsx XLSX spreadsheet
Appendix_7_2_Network_Access_Analysis_Instructions.pdf PDF
31786-00188_Digital_Submission_Instructions.pdf PDF
Appendix_7_4_TN_Zip_Code_List.xlsx XLSX spreadsheet
31786-00188_EAP_BHO_Release_2.pdf PDF
Appendix_7_8_Benefits_Administration_834_Guidance_Manual_v5.pdf PDF
Appendix_7_11_DOHR_Policy_17-002-Contract_Section_A_8_b_5.pdf PDF
Appendix_7_1_Provider_and_Facility_Disruption-1.xlsx XLSX spreadsheet
31786-00188_EAP_BHO_for_posting.pdf PDF
Appendix_7_10_HIPAA_Business_Associate_Assessment.xlsx XLSX spreadsheet
Appendix_7_2_Network_Access_Analysis_Instructions.pdf PDF
Attachment_6_3_Cos_Proposal.xlsx XLSX spreadsheet
Appendix_7_9_Decision_Support_System_File_Layout.xlsx XLSX spreadsheet
Appendix_7_6_Enrollment_by_Plan_Group.xlsx XLSX spreadsheet
RFP_31786-00188_Amendment_One.pdf PDF
Appendix_7_3_Network_Access_Analysis_Sample_Report.pdf PDF
Appendix_7_7_EAP_WL_MHSA_Utilization_Revised.xlsx XLSX spreadsheet
Appendix_7_13_LE_LG_enrollment_counts_by_dept.xlsx XLSX spreadsheet
31786-00188_Amendment_Two.pdf PDF
Appendix_7_11_DOHR_Policy_17-002-Contract_Section_A_8_b_5.pdf PDF
Appendix_7_10_HIPAA_Business_Associate_Assessment.xlsx XLSX spreadsheet
Appendix_7_9_Decision_Support_System_File_Layout.xlsx XLSX spreadsheet
31786-00188_EAP_BHO_for_posting.pdf PDF
Appendix_7_6_Enrollment_by_Plan_Group.xlsx XLSX spreadsheet
Appendix_7_3_Network_Access_Analysis_Sample_Report.pdf PDF
Appendix_7_8_Benefits_Administration_834_Guidance_Manual_v5.pdf PDF
Appendix_7_2_Network_Access_Analysis_Instructions.pdf PDF
Appendix_7_12_Written_Questions_and_Comments_template.pdf PDF
Appendix_7_4_TN_Zip_Code_List.xlsx XLSX spreadsheet
Attachment_6_3_Cos_Proposal.xlsx XLSX spreadsheet
Appendix_7_1_Provider_and_Facility_Disruption-1.xlsx XLSX spreadsheet
31786-00188_Digital_Submission_Instructions.pdf PDF
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 IdDependent or Employee
GroupPlan TypeGenderAge BracketDependentEmployeeGrand Total
Local EdLimited PPOFLess than a year1919
1 to 1815551555
19 to 3999316582651
40 to 6439434773871
65 and older16199215
MLess than a year2525
1 to 18163011631
19 to 3911965961792
40 to 6412579872244
65 and older6788155
Limited PPO Total7152700614158
Local CDHPFLess than a year1717
1 to 1810281028
19 to 395297781307
40 to 6423814551693
65 and older93241
MLess than a year1010
1 to 1810661066
19 to 39645343988
40 to 647075061213
65 and older291443
U1 to 1811
Local CDHP Total427931287407
Premier PPOFLess than a year166166
1 to 1879837983
19 to 395364820513569
40 to 6421542097423128
65 and older12615171643
MLess than a year159159
1 to 18873718738
19 to 39629121968487
40 to 646955539712352
65 and older6055971202
U1 to 1822
19 to 3922
40 to 6422
Premier PPO Total385463888777433
Standard PPOFLess than a year5454
1 to 1831113111
19 to 39180934185227
40 to 6463866007238
65 and older31367398
MLess than a year6464
1 to 1831993199
19 to 39230111033404
40 to 64230118004101
65 and older153166319
U1 to 1822
Standard PPO Total136631345427117
Local Ed Total6364062475126115
Local GovLimited PPOFLess than a year1212
1 to 18686686
19 to 395528931445
40 to 6436317152078
65 and older26158184
MLess than a year1515
1 to 187233726
19 to 3938011301510
40 to 6427415471821
65 and older23143166
Limited PPO Total305455898643
Local CDHPFLess than a year44
1 to 18151151
19 to 39101164265
40 to 6474236310
65 and older358
MLess than a year22
1 to 18116116
19 to 3952225277
40 to 6440258298
65 and older61723
Local CDHP Total5499051454
Premier PPOFLess than a year1515
1 to 18898898
19 to 397919891780
40 to 6467223373009
65 and older84294378
MLess than a year2222
1 to 1810011001
19 to 3956013121872
40 to 6433423072641
65 and older61339400
Premier PPO Total4438757812016
Standard PPOFLess than a year99
1 to 18335335
19 to 39304394698
40 to 64242730972
65 and older2395118
MLess than a year1212
1 to 18312312
19 to 39177695872
40 to 64939901083
65 and older19127146
Standard PPO Total152630314557
Local Gov Total95671710326670
StateCDHP/HSAFLess than a year3737
1 to 1817561756
19 to 39122514472672
40 to 6499419172911
65 and older6783150
MLess than a year3333
1 to 1818541854
19 to 3998313952378
40 to 6487916972576
65 and older64127191
U1 to 1822
CDHP/HSA Total7894666614560
Premier PPOFLess than a year127127
1 to 1868486848
19 to 39590139089809
40 to 6458461386319709
65 and older86018712731
MLess than a year137137
1 to 1871487148
19 to 39548026138093
40 to 645140949314633
65 and older109217322824
U1 to 1822
40 to 6411
Premier PPO Total385823348072062
Standard PPOFLess than a year131131
1 to 1864396439
19 to 395168617611344
40 to 643696913712833
65 and older2967371033
MLess than a year148148
1 to 18684016841
19 to 39453448039337
40 to 643614680510419
65 and older4017311132
U1 to 1811
19 to 3911
Standard PPO Total312692839059659
State Total7774568536146281
Grand Total150952148114299066

File details come from the government source that posted it. Updated .