Appendix%207.6%20Enrollment%20by%20Plan%20Group.xlsx

XLSX spreadsheet 15 KB Posted

Attached to
Third Party Administrator Services for the State's Public Sector Health Plans
Solicitation number
RFP 31786-00190
Issued by
Davidson County, Tennessee

About this file

This appendix presents enrollment data by plan group for Tennessee's public sector health plans, covering three primary jurisdictions: Local Education, Local Government, and State employees. The spreadsheet provides a comprehensive breakdown of plan membership across Active Full-Time, Active Part-Time, COBRA, and Retiree categories, segmented by employee relationship (Employee, Spouse, Child, Grand Total), gender (Female, Male, Unspecified), and age bracket (1 to 18, 19 to 39, 40 to 64, 65 and older). The total enrollment across all three jurisdictions is 300,954 members, with State employees representing the largest portion at 147,139 members, followed by Local Education at 124,744 members, and Local Government at 29,071 members.

Active Full-Time employees constitute the dominant enrollment category across all jurisdictions, with 287,414 total members, while retirees account for 12,956 members and COBRA participants represent 561 members. The State jurisdiction shows the highest concentration of active full-time employees at 139,257, with particular density in the 40 to 64 age bracket for both male and female participants. Spouse and dependent coverage represents a substantial portion of total enrollment, indicating comprehensive family plan utilization across all three employer groups. This enrollment data serves as the baseline for Third Party Administrator service requirements and cost projections for the state's public sector health plans.

View the file

Other files

File Type Posted
Appendix%207.15%20Simplified%20Wellness%20Activity%20Layout.xlsx XLSX spreadsheet
Appendix%207.13%20Supplier%20Direct%20Deposit%20Authorization.pdf PDF
Appendix%207.3%20Provider%20Disruption%20Analysis%20Instructions%20and%20Template.xlsx XLSX spreadsheet
Appendix%207.9%20Benefits%20Administration%20834%20Guidance%20Manual_v6.pdf PDF
31786-00190%20Digital%20Submission%20Instructions.docx DOCX document
Appendix%207.18%20Written%20Questions%20%20Comments%20Template.xlsx XLSX spreadsheet
Appendix%207.11%20HIPAA%20Business%20Associate%20Assessment.xlsx XLSX spreadsheet
Appendix%207.10%20Decision%20Support%20System%20File%20Format.xlsx XLSX spreadsheet
Appendix%207.4%20Quest%20Analytics%20Sample%20Reports.pdf PDF
Appendix%207.2%20Network%20Access%20Analysis%20Instructions.docx DOCX document
31786-00190%20TPA%20RFP%20for%20posting.docx DOCX document
Appendix%207.7%20Enrollment%20by%20Plan.xlsx XLSX spreadsheet
Appendix%207.17%20ASP%20Reconciliation%20Template.xlsx XLSX spreadsheet
TPA%20Cost%20Proposal%20for%20posting.xlsx XLSX spreadsheet
Appendix%207.12%20Bank%20Draft%20Report%20Template.xlsx XLSX spreadsheet
Appendix%207.1%20Discount%20Data%20Specifications.pdf PDF
Appendix%207.14%20Process%20for%20Subrogation%20and%20Other%20Recoveries.pdf PDF
Appendix%207.16%20Implementation%20and%20Account%20team%20Surveys.xlsx XLSX spreadsheet
Appendix%207.8%20Claims%20and%20Utilization%20History.xlsx XLSX spreadsheet
Appendix%207.5%202026%20TN%20Zip%20Code%20Enrollment%20Counts.xlsx XLSX spreadsheet
Show all 20

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 IDRelationship
GroupOverall PT/FTGenderAge BracketChildEmployeeSpouseGrand Total
Local EdActive - Full TimeF0503503
1 to 1813,595213,597
19 to 396,43714,0221,55622,015
40 to 6429,2713,10032,371
65 and older1,8451682,013
M0515515
1 to 1814,542114,543
19 to 396,7364,2562,98813,980
40 to 6438,03710,31118,351
65 and older7997571,556
U1 to 1855
19 to 39213
40 to 6422
Active - Full Time Total42,33858,23318,883119,454
COBRAF033
1 to 182020
19 to 39131427
40 to 6470676
65 and older22
M1 to 181414
19 to 39135220
40 to 64262248
65 and older112
COBRA Total6311831212
RetireeF1 to 184747
19 to 392492251
40 to 6422,8242653,091
65 and older22
M1 to 186262
19 to 391983201
40 to 64136257851,423
65 and older11
Retiree Total5713,4571,0505,078
Local Ed Total42,97261,80819,964124,744
Local GovActive - Full TimeF09595
1 to 182,30462,310
19 to 391,0182,7348514,603
40 to 6415,3261,4086,735
65 and older569122691
M09595
1 to 182,341102,351
19 to 391,0253,7781874,990
40 to 645,3717786,149
65 and older579105684
Active - Full Time Total6,87918,3733,45128,703
COBRAF1 to 1811
19 to 39314
40 to 6421324
M1 to 1855
19 to 39112
40 to 6419221
65 and older11
COBRA Total645758
RetireeF1 to 1844
19 to 3915116
40 to 646754121
M1 to 1844
19 to 391212
40 to 6414012152
65 and older11
Retiree Total3520966310
Local Gov Total6,92018,6273,52429,071
StateActive - Full TimeF0594594
1 to 1815,241115,242
19 to 397,15211,9864,43423,572
40 to 64322,5109,03831,551
65 and older2,1911,0053,196
M0609609
1 to 1816,112116,113
19 to 397,1709,4272,92119,518
40 to 64116,4058,88425,290
65 and older2,1801,3843,564
U011
1 to 1866
19 to 3911
Active - Full Time Total46,88964,70027,668139,257
Active - Part TimeF011
1 to 1833
19 to 3944
40 to 64224
65 and older22
M19 to 39314
40 to 6422
65 and older213
Active - Part Time Total413623
COBRAF011
1 to 182020
19 to 39833344
40 to 648519104
65 and older415
M1 to 181717
19 to 391119131
40 to 64481967
65 and older22
COBRA Total5719143291
RetireeF1 to 18143143
19 to 39489411504
40 to 64212,3151,4693,805
65 and older554196
M1 to 18141141
19 to 3947012473
40 to 64241,5707182,312
65 and older90494
Retiree Total1,2884,0352,2457,568
State Total48,23868,93929,962147,139
Grand Total98,130149,37453,450300,954

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