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

File Type Posted
Appendix_7_5_Enrollment_by_Plan.xlsx XLSX spreadsheet
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
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 .