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

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_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 IDGenderAge BracketRelationship
GroupTypeChildEmployeeSpouseGrand Total
Local EdActive Full-TimeFLess than a year256256
1 to 1813,61513,615
19 to 396,88014,0401,53922,459
40 to 6429,7023,13932,841
65 and older2,0161792,195
MLess than a year258258
1 to 1814,5632214,567
19 to 397,2534,2332,93114,417
40 to 6428,06910,42418,495
65 and older8458331,678
U1 to 1855
19 to 3922
40 to 6422
Active Full-Time Total42,83458,90719,049120,790
Active Part-TimeF19 to 3911
Active Part-Time Total11
CobraF1 to 181212
19 to 391516132
40 to 6438240
65 and older55
M1 to 1888
19 to 39143421
40 to 64211233
65 and older224
Cobra Total498521155
RetireeF1 to 185050
19 to 392602262
40 to 6422,7662813,049
65 and older94397
M1 to 185959
19 to 392312233
40 to 64126007701,382
65 and older181937
Retiree Total6143,4821,0735,169
Local Ed Total43,49762,47520,143126,115
Local GovActive Full-TimeFLess than a year4040
1 to 182,0652,065
19 to 399872,4377414,165
40 to 6414,9421,2966,239
65 and older549136685
MLess than a year5151
1 to 182,14632,149
19 to 391,0033,3621524,517
40 to 644,9737305,703
65 and older620108728
Active Full-Time Total6,29316,8863,16326,342
CobraF1 to 1822
19 to 39224
40 to 641414
65 and older33
M1 to 1855
19 to 39112
40 to 649110
65 and older11
Cobra Total1028341
RetireeF1 to 1833
19 to 3918119
40 to 646254116
M1 to 1811
19 to 391212
40 to 6412010130
65 and older66
Retiree Total3418964287
Local Gov Total6,33717,1033,23026,670
StateActive Full-TimeFLess than a year294294
1 to 1814,87714,877
19 to 397,65011,5054,14523,300
40 to 64322,5809,02731,610
65 and older2,5401,1293,669
MLess than a year318318
1 to 1815,6881115,690
19 to 397,8068,7932,70619,305
40 to 64316,4108,87025,283
65 and older2,4441,5203,964
U1 to 1855
19 to 3911
40 to 6411
Active Full-Time Total46,64564,27327,399138,317
Active Part-TimeF1 to 1877
19 to 3944
40 to 646612
65 and older22
M1 to 1844
19 to 39279
40 to 647310
65 and older314
Active Part-Time Total13271252
CobraF1 to 182121
19 to 39917228
40 to 64571067
65 and older213
M1 to 181717
19 to 39171027
40 to 6439645
65 and older8210
Cobra Total6413321218
RetireeFLess than a year11
1 to 18138138
19 to 39477511493
40 to 64212,2741,4693,764
65 and older14991240
M1 to 18132132
19 to 3946511467
40 to 64261,5397252,290
65 and older13534169
Retiree Total1,2604,1032,3317,694
State Total47,98268,53629,763146,281
Grand Total97,816148,11453,136299,066

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