5-Claims Enrollment Large Claims.xlsx

XLSX spreadsheet 64 KB Posted

Attached to
Stop Loss Insurance
Solicitation number
SLCC2026-M6005
Issued by
Utah

About this file

This file is a claims enrollment spreadsheet and high claimant analysis document supporting a Stop Loss Insurance RFP issued by a Utah-based organization, likely an educational institution or government entity. The spreadsheet contains detailed monthly claims data spanning from July 2020 through February 2026, broken down by plan type (Traditional PPO, ValueCare PPO, Focal Point, and HDHP), coverage category (Single, 2-Party, Family), and claim amounts separated into medical and pharmacy costs. The data tracks contract and member enrollment numbers across multiple plan variations, including ICOB (In-Coordination-of-Benefits) designations. The document also includes a comprehensive high claimant analysis identifying individuals with claims exceeding $100,000 across five plan years (2020-2025), listing member identifiers, plan categories, diagnoses, and total paid amounts, with the highest single claim reaching $716,836.57 in 2024.

The claims data demonstrates significant utilization patterns with total monthly claims ranging from approximately $50,000 to $900,000 across all plans combined, and total members ranging from approximately 400 to 1,400 across plan categories. The high claimant data reveals that serious medical conditions including sepsis, end-stage renal disease, various malignancies, multiple sclerosis, Crohn's disease, and cardiac conditions are driving substantial claim costs. The RFP seeks a single-year initial contract for Stop Loss Insurance with the option for up to four additional one-year renewals, contingent upon vendor performance and organizational satisfaction. This claims history provides the contractual basis for stop loss coverage evaluation, allowing potential vendors to assess risk exposure, claims trends, and the financial protection needed to cover catastrophic claims exceeding specified attachment points.

View the file

Other files

File Type Posted
8-Cost Proposal Template.xlsx XLSX spreadsheet
9-M6005 Stop Loss Insurance SON-SOW.docx DOCX document
7-2025 PY SPD.pdf PDF
6-Census.xlsx XLSX spreadsheet
1-slccstandardtcs (2).pdf PDF
4-SLCC RFP About SLCC.pdf PDF
3-SLCC RFP General Conditions.pdf PDF
2-SLCC RFP Proposal File Requirements.pdf PDF

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

Traditional Plan Claims_Enroll

Traditional Focal PointTraditional ValueCareTraditional Participating
MonthMedicalTotal RxTotal ClaimsSingle2-PartyFamilyContractsMembersICOB SingleICOB 2-PartyICOB FamilyICOB ContractsICOB MembersTotal ContractsTotal MembersMedicalTotal RxTotal ClaimsSingle2-PartyFamilyContractsMembersICOB SingleICOB 2-PartyICOB FamilyICOB ContractsICOB MembersTotal ContractsTotal MembersMedicalTotal RxTotal ClaimsSingle2-PartyFamilyContractsMembersICOB SingleICOB 2-PartyICOB FamilyICOB ContractsICOB MembersTotal ContractsTotal Members
Jul-20$ 127,911.50$ 11,387.00$ 139,298.50302864122371- 0- 0227124378$ 339,222.27$ 140,131.48$ 479,353.751501502115111,337- 0- 077265181,363$ 265,707.03$ 96,886.61$ 362,593.64787369220501- 01239223510
Aug-20$ 86,595.89$ 14,839.13$ 101,435.02292664119363- 0- 0227121370$ 470,267.14$ 185,406.75$ 655,673.891491452105041,321- 0- 077265111,347$ 206,160.30$ 97,943.20$ 304,103.50777270219503- 01239222512
Sep-20$ 58,960.81$ 10,719.04$ 69,679.85312665122371- 0- 0227124378$ 437,981.06$ 168,534.13$ 606,515.191511442125071,331- 0- 077265141,357$ 550,300.93$ 138,777.35$ 689,078.28747368215499- 01239218508
Oct-20$ 108,443.83$ 17,139.36$ 125,583.19312665122371- 0- 0227124378$ 400,085.62$ 157,512.41$ 557,598.031501482125101,337- 0- 077265171,363$ 205,824.21$ 100,643.62$ 306,467.83727271215504- 01239218513
Nov-20$ 144,960.34$ 9,042.37$ 154,002.71302665121370- 0- 0227123377$ 524,060.51$ 143,090.62$ 667,151.131541472125131,342- 0- 077265201,368$ 230,624.43$ 118,852.12$ 349,476.55727271215505- 01239218514
Dec-20$ 75,955.07$ 12,831.23$ 88,786.30312665122369- 0- 0227124376$ 500,766.28$ 169,694.56$ 670,460.841541482125141,345- 0- 077265211,371$ 214,405.96$ 140,707.85$ 355,113.81717269212500- 01239215509
Jan-21$ 99,168.62$ 18,919.10$ 118,087.72352464123366- 0- 0227125373$ 473,757.04$ 164,202.38$ 637,959.421481472095041,323- 0- 077265111,349$ 226,759.57$ 134,789.19$ 361,548.76707569214504- 01239217513
Feb-21$ 70,402.66$ 8,865.69$ 79,268.35372363123362- 0- 0227125369$ 468,687.76$ 188,987.32$ 657,675.081481472095041,325- 0- 077265111,351$ 200,119.17$ 125,277.63$ 325,396.80697767213497- 01239216506
Mar-21$ 129,260.84$ 16,879.94$ 146,140.78372263122360- 0- 0227124367$ 821,094.85$ 183,218.38$ 1,004,313.231471482034981,305- 0- 077265051,331$ 341,909.62$ 137,215.51$ 479,125.13707767214498- 01239217507
Apr-21$ 47,929.84$ 22,203.96$ 70,133.80362363122361- 0- 0227124368$ 509,600.05$ 199,679.50$ 709,279.551471462014941,294- 0- 077265011,320$ 486,156.98$ 125,221.12$ 611,378.10727866216496- 01239219505
May-21$ 115,055.65$ 11,671.54$ 126,727.19362363122361- 0- 0227124368$ 671,894.91$ 216,899.28$ 888,794.191461472014941,293- 0- 077265011,319$ 365,018.64$ 138,705.81$ 503,724.45737865216494- 01239219503
Jun-21$ 66,240.28$ 12,733.01$ 78,973.29352561121357- 0- 0227123364$ 379,061.92$ 236,011.01$ 615,072.931471462014941,295- 0- 077265011,321$ 423,466.65$ 147,271.37$ 570,738.02737664213482- 01239216491
Jul-21$ 52,004.43$ 12,691.28$ 64,695.71293060119353- 0- 0227121360$ 360,051.31$ 179,203.68$ 539,254.991411441974821,261- 0189334911,294$ 453,877.51$ 126,076.47$ 579,953.98717764212481- 01125214486
Aug-21$ 85,843.35$ 16,549.55$ 102,392.90303160121355- 0- 03312124367$ 623,617.25$ 137,996.21$ 761,613.461411381984771,250- 0189334861,283$ 278,839.23$ 97,412.22$ 376,251.45737464211477- 01125213482
Sep-21$ 47,171.29$ 15,667.15$ 62,838.44333059122351- 0- 03312125363$ 303,037.87$ 192,102.73$ 495,140.601371391954711,235- 0189334801,268$ 319,920.55$ 147,374.59$ 467,295.14747463211472- 01125213477
Oct-21$ 32,186.01$ 17,134.59$ 49,320.60333059122351- 0- 03312125363$ 508,561.98$ 184,580.48$ 693,142.461381381924681,227- 0189324771,259$ 173,634.28$ 114,126.74$ 287,761.02757660211465- 01125213470
Nov-21$ 100,632.59$ 19,262.01$ 119,894.60353059124352- 0- 03312127364$ 702,658.85$ 173,484.79$ 876,143.641341361934631,220- 02810344731,254$ 248,571.02$ 142,575.81$ 391,146.83767559210464- 01125212469
Dec-21$ 60,910.31$ 15,644.27$ 76,554.58333061124361- 0- 03312127373$ 631,081.66$ 177,988.48$ 809,070.141381351934661,221- 03710334761,254$ 399,335.10$ 133,494.14$ 532,829.24757560210465- 01125212470
Jan-22$ 53,091.12$ 12,396.80$ 65,487.92333161125362- 0- 03312128374$ 540,933.48$ 171,460.06$ 712,393.541371351974691,236- 0279314781,267$ 213,390.90$ 156,504.72$ 369,895.62737359205454- 01125207459
Feb-22$ 54,536.57$ 15,862.52$ 70,399.09323058120346- 0- 03312123358$ 540,323.03$ 162,320.31$ 702,643.341381371944691,231- 0178294771,260$ 187,980.99$ 148,873.23$ 336,854.22747259205454- 01125207459
Mar-22$ 72,600.64$ 27,492.05$ 100,092.69313058119345- 0- 03312122357$ 346,429.82$ 192,557.97$ 538,987.791371361944671,226- 0178294751,255$ 157,345.25$ 156,303.46$ 313,648.71767257205452- 01125207457
Apr-22$ 89,266.76$ 10,765.24$ 100,032.00313157119344- 0- 03312122356$ 369,846.05$ 173,860.04$ 543,706.091391391924701,227- 0178294781,256$ 122,099.86$ 139,570.20$ 261,670.06797258209456- 01125211461
May-22$ 87,986.98$ 24,054.43$ 112,041.41313157119349- 0- 03312122361$ 610,720.21$ 185,634.20$ 796,354.411411381924711,227- 0178294791,256$ 344,193.20$ 134,642.15$ 478,835.35767158205452- 01125207457
Jun-22$ 123,411.45$ 31,687.54$ 155,098.99313158120352- 0- 03312123364$ 430,854.66$ 180,242.68$ 611,097.341391391924701,224- 0178294781,253$ 283,440.83$ 125,945.54$ 409,386.37776760204451- 01125206456
Jul-22$ 53,003.12$ 25,717.32$ 78,720.44343358125359- 0- 03312128371$ 265,591.80$ 210,004.50$ 475,596.301311421834561,190- 0156224621,212$ 171,788.86$ 121,472.77$ 293,261.63746460198440- 01125200445
Aug-22$ 91,154.00$ 22,159.45$ 113,313.45343359126362- 0- 03312129374$ 427,502.74$ 195,544.19$ 623,046.931351431834611,195- 0156224671,217$ 236,933.32$ 121,424.53$ 358,357.85756460199441- 01125201446
Sep-22$ 97,796.13$ 25,546.40$ 123,342.53333358124355- 0- 03312127367$ 382,079.61$ 189,044.69$ 571,124.301301411804511,173- 0156224571,195$ 171,497.51$ 123,643.91$ 295,141.42766460200443- 02- 024202447
Oct-22$ 122,013.27$ 12,905.53$ 134,918.80343358125356- 0- 03312128368$ 524,084.49$ 203,196.31$ 727,280.801301441774511,168- 0156224571,190$ 422,043.41$ 143,927.73$ 565,971.14756560200444- 02- 024202448
Nov-22$ 148,090.52$ 22,277.49$ 170,368.01363357126359- 0- 03312129371$ 476,499.68$ 174,677.40$ 651,177.081301461764521,168- 0156224581,190$ 231,400.10$ 74,642.37$ 306,042.47736559197439- 02- 024199443
Dec-22$ 122,975.68$ 35,510.12$ 158,485.80383257127359- 0- 03312130371$ 526,962.17$ 222,889.57$ 749,851.741331451764541,170- 0156224601,192$ 537,272.25$ 124,832.01$ 662,104.26716759197442- 02- 024199446
Jan-23$ 89,326.42$ 15,015.48$ 104,341.90383257127357- 0- 03312130369$ 653,539.44$ 206,984.81$ 860,524.251311431784521,174- 0156224581,196$ 385,749.67$ 114,851.20$ 500,600.87706660196445- 02- 024198449
Feb-23$ 75,419.56$ 22,638.10$ 98,057.66373357127358- 0- 0339130367$ 500,616.00$ 190,396.45$ 691,012.451301441754491,161- 0156254551,186$ 239,749.10$ 105,588.41$ 345,337.51706659195438- 02- 024197442
Mar-23$ 96,530.81$ 38,732.94$ 135,263.75383459131369- 0- 0229133378$ 468,775.80$ 269,107.72$ 737,883.521301431734461,149- 0167254531,174$ 279,788.51$ 137,397.72$ 417,186.23736459196436- 02- 024198440
Apr-23$ 92,575.39$ 20,113.52$ 112,688.91383460132372- 0- 0229134381$ 542,204.08$ 194,105.81$ 736,309.891321421724461,143- 0167254531,168$ 133,497.21$ 114,870.65$ 248,367.86726459195435- 02- 024197439
May-23$ 88,597.90$ 27,784.75$ 116,382.65393359131365- 0- 0229133374$ 793,979.25$ 193,154.56$ 987,133.811301401724421,142- 0167254491,167$ 257,678.28$ 120,318.75$ 377,997.03746459197436- 02- 024199440
Jun-23$ 107,603.87$ 52,097.56$ 159,701.43393459132366- 0- 0229134375$ 391,119.12$ 262,734.69$ 653,853.811291391714391,133- 0167254461,158$ 155,088.68$ 135,559.08$ 290,647.76746658198437- 02- 024200441
Jul-23$ 151,326.58$ 27,878.78$ 179,205.36403057127336- 0- 0228129344$ 593,641.48$ 205,119.74$ 798,761.221281371664311,107- 0167254381,132$ 615,774.01$ 103,275.05$ 719,049.06766360199448- 03- 036202454
Aug-23$ 68,730.01$ 37,123.14$ 105,853.15393059128342- 0- 0228130350$ 437,548.83$ 225,726.47$ 663,275.301251391684321,116- 0167254391,141$ 304,904.13$ 127,179.60$ 432,083.73736461198448- 03- 036201454
Sep-23$ 73,310.80$ 52,765.85$ 126,076.65393160130348- 0- 0228132356$ 407,043.83$ 205,560.46$ 612,604.291221421644281,108- 0178284361,136$ 179,422.55$ 120,972.17$ 300,394.72726360195442- 03- 036198448
Oct-23$ 115,759.98$ 29,526.44$ 145,286.42393160130350- 0- 0228132358$ 629,243.64$ 225,585.41$ 854,829.051231381654261,103- 0178284341,131$ 305,332.13$ 126,920.53$ 432,252.66716160192437- 03- 036195443
Nov-23$ 73,941.70$ 32,282.23$ 106,223.93403061131350- 0- 0228133358$ 407,345.53$ 204,146.17$ 611,491.701261361674291,107- 0178284371,135$ 165,607.68$ 137,612.89$ 303,220.57766261199448- 03- 036202454
Dec-23$ 50,772.02$ 55,693.87$ 106,465.89413059130343- 0- 0228132351$ 474,188.44$ 232,187.64$ 706,376.081241321664221,090- 0178284301,118$ 220,482.96$ 128,693.12$ 349,176.08756061196442- 02- 024198446
Jan-24$ 100,820.96$ 33,249.23$ 134,070.19413159131345- 012310134355$ 576,906.55$ 221,707.56$ 798,614.111161291674121,073- 0178284201,101$ 208,298.08$ 124,617.66$ 332,915.74756260197444- 02- 024199448
Feb-24$ 97,821.43$ 30,080.37$ 127,901.80413258131343- 012310134353$ 401,153.42$ 161,467.43$ 562,620.851181281674131,073- 0178284211,101$ 309,473.14$ 96,253.80$ 405,726.94756358196440- 03- 036199446
Mar-24$ 65,835.67$ 52,629.91$ 118,465.58423256130337- 012310133347$ 346,987.78$ 189,861.01$ 536,848.791171311664141,075- 0178284221,103$ 123,031.25$ 133,172.87$ 256,204.12766358197441- 03- 036200447
Apr-24$ 231,665.78$ 31,035.85$ 262,701.63433156130333- 0- 0228132341$ 425,371.64$ 172,828.58$ 598,200.221211301634141,067- 0178284221,095$ 238,362.04$ 128,759.07$ 367,121.11776558200445- 03- 036203451
May-24$ 220,358.68$ 58,601.63$ 278,960.31433156130333- 0- 0228132341$ 421,852.96$ 214,356.20$ 636,209.161191301624111,061- 0268274191,088$ 238,628.43$ 143,459.56$ 382,087.99776660203454- 03- 036206460
Jun-24$ 94,744.94$ 52,643.22$ 147,388.16423157130336- 0- 0228132344$ 717,738.83$ 183,509.20$ 901,248.031181311614101,058- 0268274181,085$ 265,593.90$ 132,978.06$ 398,571.96776660203454- 03- 036206460
Jul-24$ 200,122.07$ 23,816.48$ 223,938.55383359130357- 0- 0228132365$ 709,442.99$ 128,124.68$ 837,567.671131321513961,016- 0257234031,039$ 376,538.67$ 101,187.12$ 477,725.79716965205471- 03- 036208477
Aug-24$ 76,793.73$ 44,283.07$ 121,076.80403358131355- 0- 0228133363$ 436,397.23$ 188,797.37$ 625,194.601131321503951,012- 0257234021,035$ 247,086.91$ 137,740.77$ 384,827.68726766205470- 03- 036208476
Sep-24$ 131,351.23$ 43,345.12$ 174,696.35403259131355- 0- 0228133363$ 571,451.34$ 182,029.27$ 753,480.611121321503941,012- 0257234011,035$ 215,005.05$ 88,670.36$ 303,675.41726566203467- 03- 036206473
Oct-24$ 137,024.91$ 45,228.40$ 182,253.31403361134364- 0- 0228136372$ 463,198.56$ 217,079.40$ 680,277.961121331503951,017- 0257234021,040$ 140,258.15$ 176,055.34$ 316,313.49706367200463- 03- 036203469
Nov-24$ 154,128.06$ 65,927.07$ 220,055.13443262138368- 0- 0228140376$ 408,143.72$ 150,106.38$ 558,250.101101331503931,015- 0257234001,038$ 280,242.11$ 112,498.61$ 392,740.72706166197455- 03- 036200461
Dec-24$ 172,876.30$ 39,654.74$ 212,531.04443262138370- 0- 0228140378$ 547,042.77$ 223,569.56$ 770,612.331091311513911,016- 0257233981,039$ 222,636.17$ 124,757.12$ 347,393.29696166196454- 03- 036199460
Jan-25$ 150,139.99$ 48,376.74$ 198,516.73443263139374- 0- 0228141382$ 425,400.10$ 160,780.76$ 586,180.861081321523921,021- 0257233991,044$ 167,556.84$ 137,422.37$ 304,979.21685966193450- 03- 036196456
Feb-25$ 93,312.74$ 42,898.26$ 136,211.00443163138372- 0- 0228140380$ 371,016.39$ 171,694.85$ 542,711.241101301513911,011- 0257233981,034$ 226,339.75$ 87,233.41$ 313,573.16685966193449- 03- 036196455
Mar-25$ 168,800.48$ 43,927.53$ 212,728.01453163139374- 0- 0228141382$ 635,202.65$ 161,114.02$ 796,316.671111301503911,008- 0257223981,030$ 449,460.30$ 123,657.75$ 573,118.05685965192445- 03- 036195451
Apr-25$ 106,641.89$ 73,044.49$ 179,686.38473163141375- 0- 0228143383$ 599,529.76$ 152,987.82$ 752,517.581131301493921,006- 0257223991,028$ 220,918.05$ 134,701.12$ 355,619.17666065191444- 03- 036194450
May-25$ 84,891.26$ 64,703.20$ 149,594.46473261140368- 0- 0228142376$ 625,222.32$ 218,404.79$ 843,627.11115130146391995- 0257223981,017$ 278,859.48$ 89,047.90$ 367,907.38626065187441- 03- 036190447
Jun-25$ 206,212.69$ 56,251.88$ 262,464.57473262141371- 0- 0228143379$ 741,278.59$ 170,941.09$ 912,219.68116131146393998- 0257224001,020$ 247,027.26$ 142,272.39$ 389,299.65625865185438- 03- 036188444
Jul-25$ 80,313.48$ 19,685.18$ 99,998.66463465145387- 0- 0228147395$ 509,356.40$ 53,265.78$ 562,622.18109134141384968- 025722391990$ 237,828.62$ 27,608.86$ 265,437.48695163183429- 03- 036186435
Aug-25$ 86,589.54$ 57,794.99$ 144,384.53483564147388- 0- 0228149396$ 344,655.81$ 117,939.54$ 462,595.35110133140383961- 025722390983$ 208,604.13$ 98,834.50$ 307,438.63715164186435- 02- 024188439
Sep-25$ 115,110.90$ 54,596.40$ 169,707.30463567148402- 0- 0228150410$ 625,735.51$ 147,033.12$ 772,768.63110133137380941- 025722387963$ 197,431.62$ 87,464.34$ 284,895.96725164187437- 02- 024189441
Oct-25$ 95,491.77$ 56,722.76$ 152,214.53453567147399- 0- 0228149407$ 822,969.52$ 147,020.09$ 969,989.61110132135377931- 025722384953$ 225,514.01$ 81,437.51$ 306,951.52725164187435- 02- 024189439
Nov-25$ 116,459.68$ 53,600.78$ 170,060.46453567147398- 0- 0228149406$ 530,390.20$ 141,126.08$ 671,516.28109132134375925- 025722382947$ 216,338.89$ 99,851.24$ 316,190.13725164187436- 02- 024189440
Dec-25$ 130,658.13$ 38,631.12$ 169,289.25453566146397- 0- 0228148405$ 590,519.11$ 153,257.32$ 743,776.43110129136375928- 025722382950$ 400,612.21$ 88,125.70$ 488,737.91735064187435- 03- 036190441
Jan-26$ 141,446.88$ 30,538.38$ 171,985.26433667146401- 0- 0228148409$ 727,852.84$ 165,900.51$ 893,753.35110128134372919- 025722379941$ 253,314.70$ 95,929.17$ 349,243.87734964186431- 03- 036189437
Feb-26$ 106,716.38$ 44,411.97$ 151,128.35443566145396- 0- 0228147404$ 318,960.55$ 120,914.92$ 439,875.47110127133370912- 025722377934$ 205,486.85$ 123,736.79$ 329,223.64734964186431- 03- 036189437

HDHP Claims_Enroll

HDHP Focal PointHDHP ValueCareHDHP Participating
MonthMedicalTotal RxTotal ClaimsSingle2-PartyFamilyContractsMembersICOB SingleICOB 2-PartyICOB FamilyICOB ContractsICOB MembersTotal ContractsTotal MembersMedicalTotal RxTotal ClaimsSingle2-PartyFamilyContractsMembersICOB SingleICOB 2-PartyICOB FamilyICOB ContractsICOB MembersTotal ContractsTotal MembersMedicalTotal RxTotal ClaimsSingle2-PartyFamilyContractsMembersICOB SingleICOB 2-PartyICOB FamilyICOB ContractsICOB MembersTotal ContractsTotal Members
Jul-20$ 28,810.03$ 1,749.56$ 30,559.5946133695227- 0- 0- 0- 095227$ 146,462.63$ 14,425.87$ 160,888.50773579191492- 0- 0115192497$ 36,759.65$ 2,934.26$ 39,693.9151153096218- 0- 0- 0- 0- 096218
Aug-20$ 19,641.22$ 29,065.02$ 48,706.2446133594223- 0- 0- 0- 094223$ 38,752.54$ 29,249.56$ 68,002.10783678192492- 0- 0115193497$ 77,493.10$ 10,725.48$ 88,218.5851143095216- 0- 0- 0- 0- 095216
Sep-20$ 18,205.90$ 1,658.24$ 19,864.1447123594222- 0- 0- 0- 094222$ 29,821.51$ 21,825.29$ 51,646.80773777191490- 0- 0115192495$ 60,493.26$ 10,400.10$ 70,893.3651153197223- 0- 0- 0- 0- 097223
Oct-20$ 26,133.23$ 23,984.43$ 50,117.6647123594222- 0- 0- 0- 094222$ 32,596.78$ 25,446.24$ 58,043.02773678191491- 0- 0115192496$ 36,402.49$ 10,356.97$ 46,759.4652143298224- 0- 0- 0- 0- 098224
Nov-20$ 19,201.39$ 3,632.22$ 22,833.6147123695225- 0- 0- 0- 095225$ 59,478.09$ 25,601.50$ 85,079.59773778192493- 0- 0115193498$ 98,369.66$ 10,158.07$ 108,527.7353143299225- 0- 0- 0- 0- 099225
Dec-20$ 27,774.15$ 30,679.35$ 58,453.5047123695225- 0- 0- 0- 095225$ 121,143.08$ 26,835.31$ 147,978.39753778190491- 0- 0115191496$ 59,483.92$ 13,673.76$ 73,157.6854143199221- 0- 0- 0- 0- 099221
Jan-21$ 17,018.47$ 24,379.94$ 41,398.4145133795229- 0- 0- 0- 095229$ 96,654.43$ 28,472.42$ 125,126.85803878196498- 0- 0115197503$ 75,773.28$ 8,420.58$ 84,193.8655143099214- 0- 0- 0- 0- 099214
Feb-21$ 21,244.97$ 1,258.46$ 22,503.4346123896230- 0- 0- 0- 096230$ 83,250.60$ 30,157.02$ 113,407.62784077195497- 0- 0115196502$ 112,065.01$ 20,334.07$ 132,399.0856142999214- 0- 0- 0- 0- 099214
Mar-21$ 23,780.16$ 24,014.84$ 47,795.0046123896230- 0- 0- 0- 096230$ 132,624.99$ 31,267.88$ 163,892.87764077193494- 0- 0115194499$ 125,636.17$ 10,298.73$ 135,934.90561529100216- 0- 0- 0- 0- 0100216
Apr-21$ 17,734.45$ 2,890.98$ 20,625.4346123795227- 0- 0- 0- 095227$ 145,671.73$ 33,933.52$ 179,605.25793878195499- 0- 0115196504$ 77,797.49$ 12,412.05$ 90,209.54571629102218- 0- 0- 0- 0- 0102218
May-21$ 31,277.29$ 3,080.61$ 34,357.9046123795227- 0- 0- 0- 095227$ 210,378.49$ 28,659.91$ 239,038.40833679198501- 0- 0115199506$ 266,453.31$ 17,914.41$ 284,367.72591629104220- 0- 0- 0- 0- 0104220
Jun-21$ 16,562.99$ 25,551.63$ 42,114.6247123796228- 0- 0- 0- 096228$ 167,147.07$ 41,475.67$ 208,622.74843678198499- 0- 0115199504$ 152,139.54$ 21,434.23$ 173,573.77581630104222- 0- 0- 0- 0- 0104222
Jul-21$ 12,287.75$ 2,033.03$ 14,320.78611239112247- 0- 0- 0- 0- 0112247$ 62,988.33$ 13,550.85$ 76,539.18903480204515- 0- 0115205520$ 118,464.43$ 1,681.00$ 120,145.43591431104224- 0- 0- 0- 0- 0104224
Aug-21$ 12,828.59$ 2,233.83$ 15,062.42601436110240- 0- 0- 0- 0- 0110240$ 40,195.11$ 21,741.96$ 61,937.07873282201514- 0- 0115202519$ 82,848.31$ 9,271.15$ 92,119.46541632102227- 0- 0- 0- 0- 0102227
Sep-21$ 37,122.42$ 2,759.81$ 39,882.23621437113248- 0- 0- 0- 0- 0113248$ 72,009.46$ 28,845.08$ 100,854.54893382204517- 0- 0115205522$ 83,820.23$ 9,533.30$ 93,353.53531637106242- 0- 0- 0- 0- 0106242
Oct-21$ 93,622.43$ 4,058.90$ 97,681.33641437115250- 0- 0- 0- 0- 0115250$ 60,410.71$ 24,538.59$ 84,949.30893381203510- 0- 0115204515$ 111,207.63$ 10,024.62$ 121,232.25511637104240- 0- 0- 0- 0- 0104240
Nov-21$ 45,123.85$ 2,611.83$ 47,735.68641338115250- 0- 0- 0- 0- 0115250$ 115,021.07$ 28,018.65$ 143,039.72923279203505- 0- 0115204510$ 208,233.16$ 10,617.69$ 218,850.85501637103236- 0- 0- 0- 0- 0103236
Dec-21$ 28,747.14$ 27,512.79$ 56,259.93661337116249- 0- 0- 0- 0- 0116249$ 130,829.80$ 31,836.95$ 162,666.75883280200506- 0- 0115201511$ 121,009.64$ 20,593.26$ 141,602.90501636102233- 0- 0- 0- 0- 0102233
Jan-22$ 36,028.81$ 30,165.15$ 66,193.96681437119253- 0- 0- 0- 0- 0119253$ 112,794.80$ 46,580.30$ 159,375.10913281204517- 0- 0115205522$ 92,836.71$ 15,074.59$ 107,911.30491636101232- 0- 0- 0- 0- 0101232
Feb-22$ 53,461.55$ 9,941.68$ 63,403.23671439120260- 0- 0- 0- 0- 0120260$ 64,402.76$ 16,825.99$ 81,228.75913177199502- 0- 0115200507$ 188,890.39$ 19,578.91$ 208,469.30471538100234- 0- 0- 0- 0- 0100234
Mar-22$ 22,306.13$ 57,818.98$ 80,125.11651340118259- 0- 0- 0- 0- 0118259$ 92,346.23$ 32,467.65$ 124,813.88883476198500- 0- 0115199505$ 160,065.83$ 16,888.43$ 176,954.26491540104243- 0- 0- 0- 0- 0104243
Apr-22$ 22,047.00$ 30,788.22$ 52,835.22651239116253- 0- 0- 0- 0- 0116253$ 73,158.27$ 41,490.97$ 114,649.24873574196493- 0- 0115197498$ 185,970.46$ 14,728.74$ 200,699.20471540102241- 0- 0- 0- 0- 0102241
May-22$ 48,914.24$ 32,208.63$ 81,122.87661239117254- 0- 0- 0- 0- 0117254$ 127,719.35$ 40,711.39$ 168,430.74853575195492- 0- 0115196497$ 63,644.74$ 16,295.54$ 79,940.2845143998231- 0- 0- 0- 0- 098231
Jun-22$ 41,694.16$ 33,656.44$ 75,350.60621339114252- 0- 0- 0- 0- 0114252$ 157,763.08$ 34,141.44$ 191,904.52853676197497- 0- 0115198502$ 91,851.51$ 30,321.21$ 122,172.72471442103250- 0- 0- 0- 0- 0103250
Jul-22$ 66,319.60$ 22,544.68$ 88,864.28551542112268- 0- 0- 0- 0- 0112268$ 64,505.11$ 6,834.48$ 71,339.59953974208499- 0- 03312211511$ 47,393.88$ 2,964.61$ 50,358.49501637103239- 0- 0- 0- 0- 0103239
Aug-22$ 18,572.76$ 27,472.49$ 46,045.25591544118279- 0- 0- 0- 0- 0118279$ 66,069.25$ 26,760.35$ 92,829.60973973209502- 0- 0337212509$ 55,075.89$ 15,783.45$ 70,859.34531538106242- 0- 0- 0- 0- 0106242
Sep-22$ 38,281.10$ 55,118.81$ 93,399.91571544116277- 0- 0- 0- 0- 0116277$ 108,908.90$ 27,119.94$ 136,028.84983873209503- 0- 0337212510$ 141,947.42$ 10,920.76$ 152,868.18561638110249- 0- 0- 0- 0- 0110249
Oct-22$ 49,809.87$ 33,858.68$ 83,668.55581444116279- 0- 0- 0- 0- 0116279$ 55,211.30$ 29,249.91$ 84,461.21963974209502- 0- 0337212509$ 39,955.14$ 10,336.08$ 50,291.22601638114254- 0- 0- 0- 0- 0114254
Nov-22$ 80,088.43$ 42,708.30$ 122,796.73621545122290- 0- 0- 0- 0- 0122290$ 64,149.66$ 33,739.60$ 97,889.26974074211503- 0- 0337214510$ 33,736.91$ 25,336.07$ 59,072.98611637114251- 0- 0- 0- 0- 0114251
Dec-22$ 37,162.56$ 34,639.15$ 71,801.71631546124294- 0- 0- 0- 0- 0124294$ 63,731.38$ 33,118.04$ 96,849.42964073209495- 0- 0337212502$ 64,405.58$ 20,697.38$ 85,102.96611737115253- 0- 0- 0- 0- 0115253
Jan-23$ 57,177.45$ 63,656.11$ 120,833.56671546128299- 0- 0- 0- 0- 0128299$ 134,801.12$ 21,785.55$ 156,586.67934174208499- 0- 0337211506$ 98,347.63$ 15,082.57$ 113,430.20631738118258- 0- 0- 0- 0- 0118258
Feb-23$ 49,899.77$ 36,649.74$ 86,549.51671547129301- 0- 0- 0- 0- 0129301$ 104,796.60$ 32,803.93$ 137,600.53954172208497- 0- 0337211504$ 32,224.34$ 32,399.67$ 64,624.01641740121270- 0- 0- 0- 0- 0121270
Mar-23$ 28,567.94$ 35,873.95$ 64,441.89661347126296- 0- 0- 0- 0- 0126296$ 67,170.71$ 36,468.63$ 103,639.34944272208498- 0- 0337211505$ 76,175.55$ 40,309.03$ 116,484.58641740121270- 0- 0- 0- 0- 0121270
Apr-23$ 41,600.00$ 64,307.42$ 105,907.42681447129299- 0- 0- 0- 0- 0129299$ 245,761.71$ 51,140.64$ 296,902.35944172207493- 0- 0227209500$ 96,257.46$ 17,665.16$ 113,922.62661940125277- 0- 0- 0- 0- 0125277
May-23$ 86,349.51$ (11,107.07)$ 75,242.44721748137312- 0- 0- 0- 0- 0137312$ 154,548.02$ 42,006.33$ 196,554.35934072205497- 0- 0227207504$ 96,683.10$ 36,161.28$ 132,844.38652040125278- 0- 0- 0- 0- 0125278
Jun-23$ 77,236.11$ 40,826.20$ 118,062.31751749141318- 0- 0- 0- 0- 0141318$ 136,709.78$ 46,137.22$ 182,847.00934072205492- 0- 0227207499$ 123,408.89$ 47,811.37$ 171,220.26652042127281- 0- 0- 0- 0- 0127281
Jul-23$ 90,523.71$ 51,507.61$ 142,031.32761755148341- 0- 0- 0- 0- 0148341$ 98,472.85$ 13,166.21$ 111,639.06913979209511- 0- 0227211518$ 98,363.00$ 10,735.98$ 109,098.98622138121268- 0- 0- 0- 0- 0121268
Aug-23$ 36,500.20$ 35,858.92$ 72,359.12811659156362- 0- 0- 0- 0- 0156362$ 72,132.64$ 31,772.98$ 103,905.62953980214520- 0- 0227216527$ 23,328.56$ 30,355.11$ 53,683.67642439127279- 0- 0- 0- 0- 0127279
Sep-23$ 38,887.57$ 36,305.77$ 75,193.34801760157366- 0- 0- 0- 0- 0157366$ 58,264.61$ 28,691.77$ 86,956.38963878212507- 0- 0227214514$ 53,313.93$ 33,195.51$ 86,509.44662337126270- 0- 0- 0- 0- 0126270
Oct-23$ 45,321.24$ 41,479.32$ 86,800.56781761156370- 0- 0- 0- 0- 0156370$ 88,463.63$ 28,312.78$ 116,776.41984078216515- 0- 0227218522$ (31,736.21)$ 15,889.00$ (15,847.21)692338130274- 0- 0- 0- 0- 0130274
Nov-23$ 28,162.29$ 39,292.19$ 67,454.48821661159372- 0- 0- 0- 0- 0159372$ 93,618.19$ 43,464.95$ 137,083.14983978215512- 0- 0227217519$ 36,341.57$ 43,976.37$ 80,317.94712338132277- 0- 0- 0- 0- 0132277
Dec-23$ 41,268.15$ (1,945.66)$ 39,322.49831661160373- 0- 0- 0- 0- 0160373$ 83,977.46$ 37,292.26$ 121,269.721013980220529- 0- 0227222536$ 89,631.98$ 30,972.18$ 120,604.16712338132277- 0- 0- 0- 0- 0132277
Jan-24$ 58,140.82$ 19,678.16$ 77,818.98841663163380- 0- 0- 0- 0- 0163380$ 221,597.48$ 52,324.27$ 273,921.751003978217520- 0- 0227219527$ 200,864.94$ 29,833.45$ 230,698.39752242139294- 0- 0- 0- 0- 0139294
Feb-24$ 68,827.21$ 11,792.30$ 80,619.51831663162379- 0- 0- 0- 0- 0162379$ 77,491.76$ 39,298.74$ 116,790.501003977216517- 0- 0227218524$ 96,575.39$ 38,573.04$ 135,148.43732043136291- 0- 0- 0- 0- 0136291
Mar-24$ 31,172.65$ 48,713.32$ 79,885.97841664164385- 0- 0- 0- 0- 0164385$ 104,951.54$ 71,175.50$ 176,127.04993876213509- 0- 0227215516$ 82,447.11$ 49,221.41$ 131,668.52722043135290- 0- 0- 0- 0- 0135290
Apr-24$ 85,329.04$ 21,854.83$ 107,183.87881664168389- 0- 0- 0- 0- 0168389$ 239,384.75$ 67,917.70$ 307,302.451003877215513- 0- 0227217520$ 278,641.70$ 34,438.87$ 313,080.57712042133283- 0- 0- 0- 0- 0133283
May-24$ 60,166.19$ 36,404.71$ 96,570.90901663169387- 0- 0- 0- 0- 0169387$ 134,061.51$ 78,452.21$ 212,513.721003777214509- 0- 0227216516$ 51,647.55$ 36,485.04$ 88,132.59711944134291- 0- 0- 0- 0- 0134291
Jun-24$ 105,989.93$ 17,500.05$ 123,489.98911661168378- 0- 0- 0- 0- 0168378$ 145,729.08$ 43,380.86$ 189,109.941003777214509- 0- 0227216516$ 126,426.03$ 51,789.04$ 178,215.07721943134286- 0- 0- 0- 0- 0134286
Jul-24$ 62,651.10$ 29,787.41$ 92,438.51942260176377- 0- 0- 0- 0- 0176377$ 251,303.21$ 33,468.04$ 284,771.25984177216510- 01239219519$ 65,378.22$ 83,427.25$ 148,805.47741945138288- 0- 0- 0- 0- 0138288
Aug-24$ 39,164.00$ 10,804.84$ 49,968.841002462186394- 0- 0- 0- 0- 0186394$ 72,745.59$ 26,053.70$ 98,799.291034278223523- 01239226532$ 101,208.55$ 43,402.43$ 144,610.98741849141300- 0- 0- 0- 0- 0141300
Sep-24$ 75,022.49$ 40,651.98$ 115,674.471002463187398- 0- 0- 0- 0- 0187398$ 136,649.42$ 31,356.60$ 168,006.02994179219523- 01239222532$ 335,401.20$ 85,008.15$ 420,409.35721949140301- 0- 0- 0- 0- 0140301
Oct-24$ 105,431.35$ 35,713.97$ 141,145.321022462188395- 0- 0- 0- 0- 0188395$ 145,966.10$ 50,896.95$ 196,863.05964178215517- 01239218526$ 248,594.74$ 47,326.90$ 295,921.64712050141305- 0- 0- 0- 0- 0141305
Nov-24$ 72,056.30$ 42,220.92$ 114,277.221012463188397- 0- 0- 0- 0- 0188397$ 120,465.96$ 50,385.30$ 170,851.26954378216518- 01239219527$ 103,196.94$ 84,328.66$ 187,525.60702150141308- 0- 0- 0- 0- 0141308
Dec-24$ 139,095.14$ 46,434.60$ 185,529.741002365188401- 0- 0- 0- 0- 0188401$ 122,111.46$ 43,587.84$ 165,699.30964378217520- 01239220529$ 262,366.82$ 52,538.96$ 314,905.78712250143311- 0- 0- 0- 0- 0143311
Jan-25$ 136,932.94$ 12,269.74$ 149,202.681012266189404- 0- 0- 0- 0- 0189404$ 238,328.36$ 58,825.09$ 297,153.45984276216509- 01239219518$ 157,268.65$ 74,800.86$ 232,069.51732250145315- 0- 0- 0- 0- 0145315
Feb-25$ 111,960.19$ 37,564.90$ 149,525.091002267189406- 0- 0- 0- 0- 0189406$ 240,965.79$ 51,687.21$ 292,653.00994274215504- 01239218513$ 173,465.89$ 62,851.77$ 236,317.66732250145316- 0- 0- 0- 0- 0145316
Mar-25$ 150,654.13$ 26,678.37$ 177,332.501002366189403- 0- 0- 0- 0- 0189403$ 177,727.85$ 75,909.23$ 253,637.08994274215504- 01239218513$ 167,002.59$ 35,307.03$ 202,309.62752151147322- 0- 0- 0- 0- 0147322
Apr-25$ 38,429.29$ 31,110.69$ 69,539.981042466194409- 0- 0- 0- 0- 0194409$ 135,544.16$ 59,404.21$ 194,948.371014173215501- 01239218510$ 120,996.81$ 64,440.75$ 185,437.56762051147322- 0- 0- 0- 0- 0147322
May-25$ 139,305.35$ 64,360.19$ 203,665.541052466195410- 0- 0- 0- 0- 0195410$ 207,303.62$ 59,523.14$ 266,826.76984073211497- 01239214506$ 202,467.04$ 99,930.10$ 302,397.14772050147320- 0- 0- 0- 0- 0147320
Jun-25$ 111,671.05$ 32,179.68$ 143,850.731032265190399- 0- 0- 0- 0- 0190399$ 146,032.24$ 59,184.37$ 205,216.61974172210495- 01239213504$ 109,413.88$ 45,965.82$ 155,379.70761948143308- 0- 0- 0- 0- 0143308
Jul-25$ 139,859.82$ 7,335.13$ 147,194.951012563189391- 0- 0- 0- 0- 0189395$ 124,176.35$ 10,995.23$ 135,171.58924175208507- 022411212518$ 85,380.09$ 25,827.89$ 111,207.98742149144315- 0- 0- 0- 0- 0144315
Aug-25$ 52,911.99$ 27,526.52$ 80,438.511062866200417- 0- 0- 0- 0- 0200421$ 113,803.04$ 27,580.35$ 141,383.39903978207518- 022411211529$ 59,652.24$ 8,269.20$ 67,921.44752249146319- 0- 0- 0- 0- 0146319
Sep-25$ 168,705.92$ 28,629.67$ 197,335.591032868199427- 0- 0- 0- 0- 0199430$ 99,391.48$ 45,841.32$ 145,232.80884080208529- 022411212540$ 93,308.00$ 54,163.19$ 147,471.19791949147317- 0- 0- 0- 0- 0147317
Oct-25$ 95,886.61$ 46,416.83$ 142,303.441003167198426- 0- 0- 0- 0- 0198429$ 90,774.63$ 50,121.75$ 140,896.38904181212537- 022411216548$ 147,632.23$ 25,972.65$ 173,604.88801949148318- 0- 0- 0- 0- 0148318
Nov-25$ 96,152.66$ 21,075.17$ 117,227.831023166199419- 0- 0- 0- 0- 0199426$ 199,873.54$ 46,737.94$ 246,611.48864281209535- 022411213546$ 103,307.46$ 37,518.11$ 140,825.57812049150321- 0- 0- 0- 0- 0150321
Dec-25$ 154,376.01$ 25,238.67$ 179,614.681023166199425- 0- 0- 0- 0- 0199425$ 120,172.79$ 52,628.86$ 172,801.65864281209535- 022411213546$ 103,342.67$ 13,259.74$ 116,602.41821950151323- 0- 0- 0- 0- 0151323
Jan-26$ 99,952.81$ 56,365.53$ 156,318.341003165196420- 0- 0- 0- 0- 0196420$ 273,808.38$ 54,526.85$ 328,335.23804482206536- 022411210547$ 106,972.28$ 50,011.96$ 156,984.24811950150324- 0- 0- 0- 0- 0150324
Feb-26$ 141,634.67$ 31,988.05$ 173,622.721033164198419- 0- 0- 0- 0- 0198419$ 142,529.14$ 58,088.42$ 200,617.56824381206533- 022411210544$ 97,730.19$ 17,574.83$ 115,305.02812049150324- 0- 0- 0- 0- 0150324

High Claimants

2020 Plan Year
$100,000+ Paid
Member ID - Consistent in each yearMemberPLANCATEGORYDIAGNOSISTotal Paid
1SpouseTraditional PPOInfectious and Parasitic DiseasesEnd Stage Renal Disease$531,644.50
2SubscriberValuecare PPOInjury and PoisoningTraumatic Subdural Hemorrhage With Loss Of Consciousness Of Unspecified Duration, Initial Encounter$323,944.51
3SubscriberValuecare PPONeoplasmsEncounter For Antineoplastic Chemotherapy$292,005.67
4SubscriberTraditional PPOCirculatory SystemPrimary Pulmonary Hypertension$255,888.94
5SubscriberTraditional PPONeoplasmsMultiple Myeloma In Remission$239,949.41
6SubscriberTraditional PPONervous SystemChronic Migraine Without Aura, Intractable, With Status Migrainosus$214,921.45
7SubscriberTraditional HDHPMusculoskeletal SystemDermatopolymyositis, Unspecified, Organ Involvement Unspecified$205,017.79
8SpouseTraditional PPODigestive SystemCrohn'S Disease, Unspecified, Without Complications$194,469.34
9DependentTraditional PPOGenitourinary SystemEnd Stage Renal Disease$183,358.18
10SubscriberValuecare PPONeoplasmsMultiple Myeloma Not Having Achieved Remission$166,222.17
11DependentValuecare PPOEndocrine, Nutritional and Metabolic DiseasesCommon Variable Immunodeficiency With Predominant Abnormalities Of B-Cell Numbers And Function$160,046.39
12SpouseValuecare PPONeoplasmsEncounter For Antineoplastic Radiation Therapy$157,705.53
13SpouseValuecare PPOCirculatory SystemSecondary Pulmonary Arterial Hypertension$157,583.18
14SubscriberTraditional PPONeoplasmsMalignant Neoplasm Of Overlapping Sites Of Right Female Breast$146,363.08
15SubscriberTraditional HDHPInfectious and Parasitic DiseasesSepsis, Unspecified Organism$144,177.71
16SubscriberFocal Point HDHPDigestive SystemOther Specified Noninfective Gastroenteritis And Colitis$137,716.43
17SubscriberTraditional PPOMusculoskeletal SystemSpinal Stenosis, Lumbar Region With Neurogenic Claudication$133,789.86
18DependentTraditional HDHPEndocrine, Nutritional and Metabolic DiseasesHereditary Hypogammaglobulinemia$120,680.57
19SubscriberValuecare PPOCirculatory SystemAtherosclerotic Heart Disease Of Native Coronary Artery With Unstable Angina Pectoris$115,247.39
20SubscriberTraditional HDHPNeoplasmsMalignant Neoplasm Of Unspecified Site Of Left Female Breast$114,821.20
21SubscriberValuecare HDHPNervous SystemMultiple Sclerosis$113,579.75
22SpouseValuecare PPOMusculoskeletal SystemSpinal Stenosis, Lumbar Region Without Neurogenic Claudication$112,843.73
23SpouseValuecare PPOGenitourinary SystemAcute Kidney Failure, Unspecified$110,981.57
24DependentValuecare PPONervous SystemSensorineural Hearing Loss, Bilateral$108,101.91
25SpouseTraditional HDHPCirculatory SystemSepsis, Unspecified Organism$105,781.40
26SubscriberTraditional PPOMusculoskeletal SystemSpinal Stenosis, Lumbar Region Without Neurogenic Claudication$102,398.13
27SubscriberValuecare HDHPNervous SystemMultiple Sclerosis$101,642.92
2021 Plan Year
$100,000+ Paid
Member ID - Consistent in each yearMemberPLANCATEGORYDIAGNOSISTotal Paid
28SubscriberValuecare PPOEndocrine, Nutritional and Metabolic DiseasesThyrotoxicosis with diffuse goiter without thyrotoxic crisis or storm$495,901.30
10SubscriberValuecare PPONeoplasmsEncounter for antineoplastic chemotherapy$432,545.49
4SubscriberTraditional PPONervous SystemOcular pain, left eye$322,675.03
7SubscriberTraditional HDHPNeoplasmsEncounter for antineoplastic chemotherapy$318,231.53
6SubscriberTraditional PPOGenitourinary SystemAcute kidney failure, unspecified$295,847.87
8SpouseTraditional PPODigestive SystemCrohn's disease of large intestine without complications$237,830.94
11DependentValuecare PPOEndocrine, Nutritional and Metabolic DiseasesCommon variable immunodeficiency, unspecified$235,941.19
1SpouseTraditional PPOInfectious and Parasitic DiseasesSepsis, unspecified organism$226,909.89
5SubscriberTraditional PPONeoplasmsMultiple myeloma not having achieved remission$195,875.97
16SubscriberFocal Point HDHPDigestive SystemChronic cholecystitis$188,466.25
14SubscriberTraditional PPONeoplasmsEncounter for antineoplastic radiation therapy$180,450.25
22SpouseValuecare PPOCirculatory SystemAtherosclerotic heart disease of native coronary artery with unstable angina pectoris$180,191.34
29SpouseValuecare PPOCongenital AnomaliesCongenital insufficiency of aortic valve$167,903.17
30DependentTraditional PPODigestive SystemAcute pancreatitis without necrosis or infection, unspecified$154,118.49
31SpouseTraditional HDHPInjury and PoisoningInfection and inflammatory reaction due to cardiac valve prosthesis, initial encounter$145,326.23
32SpouseValuecare PPONeoplasmsMalignant neoplasm of upper-outer quadrant of right female breast$133,767.57
33SpouseValuecare PPOMusculoskeletal SystemSpinal stenosis, lumbar region with neurogenic claudication$132,229.12
34SpouseTraditional PPOMusculoskeletal SystemPostlaminectomy syndrome, not elsewhere classified$130,385.88
35SubscriberTraditional HDHPCirculatory SystemNonrheumatic aortic (valve) stenosis with insufficiency$124,241.03
36SpouseTraditional PPOMusculoskeletal SystemPyogenic arthritis, unspecified$120,548.92
37SubscriberTraditional PPOCirculatory SystemNonrheumatic aortic (valve) stenosis$113,309.87
38SpouseTraditional PPOCirculatory SystemAtypical atrial flutter$110,294.55
39SubscriberValuecare PPODigestive SystemUlcerative colitis, unspecified, without complications$107,481.03
40SubscriberValuecare PPOMusculoskeletal SystemSyncope and collapse$106,946.63
41SpouseValuecare PPOMusculoskeletal SystemOther muscle spasm$103,372.65
2022 Plan Year
$100,000+ Paid
Member ID - Consistent in each yearMemberPLANCATEGORYDIAGNOSISTotal Paid
42DependentTraditional PPOCertain Conditions Originating in the Perinatal PeriodSingle liveborn infant, delivered by cesarean374798.9
8SpouseTraditional PPODigestive SystemCrohn's disease, unspecified, without complications370976.69
16SubscriberFocal Point HDHPDigestive SystemCrohn's disease of small intestine with intestinal obstruction341086.98
43SpouseValuecare PPOFactors Influencing Health Status - ZcodesEncounter for antineoplastic chemotherapy300074.15
6SubscriberTraditional PPONervous SystemChronic migraine without aura, intractable, with status migrainosus266687.23
44SubscriberValuecare PPOFactors Influencing Health Status - ZcodesEncounter for antineoplastic radiation therapy245852.55
45SpouseValuecare PPONeoplasmsMalignant neoplasm of lower lobe, right bronchus or lung242533.77
10SubscriberValuecare PPOFactors Influencing Health Status - ZcodesEncounter for antineoplastic chemotherapy239728.89
4SubscriberTraditional PPOEye Diseases and DisordersSenile ectropion of right lower eyelid225715.27
46DependentTraditional PPONeoplasmsAcute lymphoblastic leukemia not having achieved remission216498.04
14SubscriberTraditional PPOInfectious and Parasitic DiseasesSepsis due to Escherichia coli [E. coli]214435.65
47SubscriberValuecare PPOFactors Influencing Health Status - ZcodesEncounter for antineoplastic chemotherapy203859.13
40SubscriberValuecare PPOMusculoskeletal SystemOther intervertebral disc displacement, thoracic region202773.26
17SubscriberTraditional PPOPregnancy, Childbirth, and PuerperiumPreterm labor third trimester with preterm delivery third trimester, not applicable or unspecified184906.96
48SubscriberFocal Point PPOGenitourinary SystemEnd stage renal disease168594.33
49SpouseTraditional PPOCirculatory SystemHemiplegia and hemiparesis following nontraumatic intracerebral hemorrhage affecting right dominant side143159.47
11DependentValuecare PPOBlood and Blood-Forming OrgansCommon variable immunodeficiency with predominant abnormalities of B-cell numbers and function142644.39
50SpouseTraditional HDHPERROR:#N/AERROR:#N/A135607.06
51DependentValuecare HDHPMusculoskeletal SystemSpinal stenosis, lumbar region without neurogenic claudication130663.82
52SubscriberValuecare PPOEndocrine, Nutritional and Metabolic DiseasesType 2 diabetes mellitus with other specified complication118948.18
53DependentValuecare PPOInfectious and Parasitic DiseasesCOVID-19116671.63
54SubscriberValuecare PPOMusculoskeletal SystemSpinal stenosis, lumbar region with neurogenic claudication113002.27
27SubscriberValuecare HDHPNervous SystemMultiple sclerosis110577.26
55SpouseValuecare PPOBlood and Blood-Forming OrgansCommon variable immunodeficiency, unspecified109584.34
41SpouseValuecare PPONervous SystemOther muscle spasm107631.67
56SpouseTraditional PPODigestive SystemCalculus of gallbladder with acute cholecystitis with obstruction105814.71
57SubscriberValuecare PPOCirculatory SystemEssential (primary) hypertension103193.41
7SubscriberTraditional HDHPFactors Influencing Health Status - ZcodesIron deficiency anemia, unspecified101653.17
2023 Plan Year
$100,000+ Paid
Member ID - Consistent in each yearMemberPLANCATEGORYDIAGNOSISTotal Paid
8SpouseTraditional PPODigestive SystemCrohn's disease, unspecified, without complications423988.2
58DependentTraditional PPOCongenital AnomaliesCoarctation of aorta367656.92
6SubscriberTraditional PPONervous SystemChronic migraine without aura, intractable, with status migrainosus284854.69
43SpouseValuecare PPOFactors Influencing Health Status - ZcodesEncounter for antineoplastic chemotherapy254218.1
45SpouseValuecare PPONeoplasmsMalignant neoplasm of unspecified part of unspecified bronchus or lung253326.85
59SubscriberValuecare PPOInjury and PoisoningOther specified fracture of left pubis, initial encounter for closed fracture249918.76
60SubscriberTraditional PPOFactors Influencing Health Status - ZcodesEncounter for antineoplastic chemotherapy234946.79
48SubscriberFocal Point PPOCirculatory SystemHypertensive heart and chronic kidney disease with heart failure and with stage 5 chronic kidney disease, or end stage renal disease222855.68
16SubscriberFocal Point HDHPDigestive SystemCrohn's disease of both small and large intestine with intestinal obstruction202426.12
61SubscriberValuecare HDHPFactors Influencing Health Status - ZcodesEncounter for antineoplastic radiation therapy201910.09
47SubscriberValuecare PPOFactors Influencing Health Status - ZcodesEncounter for antineoplastic chemotherapy183190.14
62SubscriberFocal Point PPOInfectious and Parasitic DiseasesKidney transplant rejection161914.86
63SubscriberValuecare PPOFactors Influencing Health Status - ZcodesEncounter for antineoplastic chemotherapy161721.09
38SpouseTraditional PPOFactors Influencing Health Status - ZcodesEncounter for adjustment and management of automatic implantable cardiac defibrillator142504.41
64SpouseTraditional HDHPInjury and PoisoningTraumatic hemopneumothorax, initial encounter130507.4
41SpouseValuecare PPONervous SystemMultiple sclerosis126684.57
65SubscriberValuecare PPOInfectious and Parasitic DiseasesViral wart, unspecified122452.92
66SubscriberValuecare PPOFactors Influencing Health Status - ZcodesAcquired absence of right leg below knee122246.82
67SpouseValuecare PPONeoplasmsMalignant neoplasm of prostate121745.16
14SubscriberTraditional PPOMusculoskeletal SystemEncounter for screening for malignant neoplasm of colon118204.86
68DependentTraditional PPOMental and Developmental DisordersBipolar disorder, unspecified114935.56
40SubscriberValuecare PPOMusculoskeletal SystemPain in thoracic spine113643.94
69SubscriberValuecare PPOSkin and Subcutaneous TissuePain in thoracic spine111676.59
27SubscriberValuecare HDHPSymptoms, Signs, and Ill-Defined Conditions - RCodesSubacute cough111478.93
70SpouseTraditional PPOGenitourinary SystemEnd stage renal disease110624.01
71SpouseValuecare PPOMusculoskeletal SystemRadiculopathy, lumbar region104664.89
72SubscriberTraditional HDHPFactors Influencing Health Status - ZcodesEncounter for antineoplastic radiation therapy103651.22
73SpouseFocal Point PPOInfectious and Parasitic DiseasesSepsis due to Methicillin susceptible Staphylococcus aureus103544.48
4SubscriberTraditional PPOEye Diseases and DisordersAftercare following surgery for neoplasm103358.43
55SpouseValuecare PPOBlood and Blood-Forming OrgansCommon variable immunodeficiency, unspecified101300.2
2024 Plan Year
$100,000+ Paid
Member ID - Consistent in each yearMemberPLANCATEGORYDIAGNOSISTotal Paid
74SubscriberValuecare PPOInfectious and Parasitic DiseasesSepsis, unspecified organism$716,836.57
8SpouseTraditional PPODigestive SystemCrohn's disease, unspecified, without complications$354,338.77
62SubscriberFocal Point PPOGenitourinary SystemEnd stage renal disease$317,339.08
75SubscriberTraditional HDHPInfectious and Parasitic DiseasesSepsis, unspecified organism$288,548.49
76DependentTraditional HDHPCirculatory SystemCerebral infarction due to unspecified occlusion or stenosis of left middle cerebral artery$282,437.03
77DependentTraditional HDHPMusculoskeletal SystemPain in left foot$273,368.77
6SubscriberTraditional PPONervous SystemChronic migraine without aura, intractable, with status migrainosus$255,801.32
78SpouseValuecare PPOCirculatory SystemHypertensive heart disease with heart failure$213,844.48
45SpouseValuecare PPONeoplasmsMalignant neoplasm of lower lobe, right bronchus or lung$196,465.89
79SubscriberFocal Point PPOFactors Influencing Health Status - ZcodesEncounter for antineoplastic chemotherapy$182,274.40
80DependentValuecare PPOMental and Developmental DisordersDisruptive mood dysregulation disorder$181,511.88
40SubscriberValuecare PPONeoplasmsMalignant neoplasm of left kidney, except renal pelvis$173,151.23
81SubscriberValuecare PPOFactors Influencing Health Status - ZcodesEncounter for antineoplastic chemotherapy$156,029.80
82SubscriberTraditional PPODigestive SystemLeft sided colitis without complications$155,382.13
15SubscriberTraditional HDHPEndocrine, Nutritional and Metabolic DiseasesHypo-osmolality and hyponatremia$154,413.43
83SubscriberValuecare HDHPEndocrine, Nutritional and Metabolic DiseasesType 2 diabetes mellitus with ketoacidosis without coma$146,152.89
84SubscriberTraditional HDHPEye Diseases and DisordersCombined forms of age-related cataract, left eye$145,613.01
52SubscriberValuecare PPONeoplasmsMalignant neoplasm of lower lobe, right bronchus or lung$144,685.43
27SubscriberValuecare HDHPNervous SystemMultiple sclerosis$143,319.71
85SpouseTraditional PPOFactors Influencing Health Status - ZcodesEncounter for antineoplastic radiation therapy$142,117.89
86SpouseValuecare PPOCirculatory SystemAtypical atrial flutter$133,460.85
16SubscriberFocal Point HDHPDigestive SystemCrohn's disease of both small and large intestine with intestinal obstruction$127,760.86
41SpouseValuecare PPONervous SystemMultiple sclerosis$127,359.04
87SpouseValuecare PPONeoplasmsGastrointestinal stromal tumor of stomach$123,790.12
88SubscriberTraditional PPOGenitourinary SystemHydronephrosis with renal and ureteral calculous obstruction$120,230.93
89SubscriberValuecare HDHPMusculoskeletal SystemPostlaminectomy syndrome, not elsewhere classified$114,942.03

This is the start of the file's text. The full file is on GovTribe.

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