Exhibit_2_-_Claims_Experience1.xlsx

XLSX spreadsheet 140 KB Posted

Attached to
Health Plan Administrative Services
Solicitation number
RFP26-0046
Issued by
Orange County, Orlando City, Florida

About this file

This document is a comprehensive claims experience and membership exhibit for the City of Orlando's health insurance plans, specifically detailing medical and pharmacy claims data from January 2021 through February 2025. The exhibit covers two primary plan types: EPO Choice (EP1) and POS Choice Plus (PS1), with detailed monthly breakdowns of subscriber types, including single subscribers, subscribers plus spouse, subscribers plus child/children, and subscribers plus family. The data tracks total membership, claims paid, and provides granular insights into high-cost claimants across different diagnosis categories.

The exhibit reveals significant claims variability, with total medical claims reaching $212,034,026 and pharmacy claims totaling $106,159,790 during the tracked period. Notable high-cost claimants include individuals with complex medical conditions such as hypophosphatasia, various cancer types, heart conditions, and chronic diseases. The membership data shows a relatively stable enrollment, with slight fluctuations across active and retired employee categories. The City of Orlando's health plans demonstrate a sophisticated approach to tracking healthcare utilization, with detailed documentation of claims experience that could be valuable for future plan design, pricing negotiations, and risk management strategies.

View the file

Other files

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

COO_Membership by Plan by Month

EXHIBIT 2
CITY OF ORLANDO
Row LabelsSum of Single SubscribersSum of Subscribers plus SpouseSum of Subscribers plus Child/ChildrenSum of Subscribers plus FamilySum of Total Members
EPO Choice (EP1)
2023-0132097335176818849
2023-0232157345196828860
2023-0332167315216788844
2023-0432327385196758929
2023-0532467265226778860
2023-0632657275256808896
2023-0732837315286828940
2023-0832867355306818944
2023-0933387325376829011
2023-1033567275376859031
2023-1133617275356849031
2023-1233667285366859055
2024-0133687205236748971
2024-0233787125266768988
2024-0333917095326739004
2024-0433927115406749036
2024-0534117095446759065
2024-0634167045486719055
2024-0734437055476749088
2024-0834617055506749114
2024-0934816965516749126
2024-1034756975516709225
2024-1134966915516699111
2024-1235166865586629118
2025-0135396815436439004
2025-0235486735436449001
2025-0335636715466419005
2025-0436076695456449054
2025-0536076705416489059
2025-0636116665386519063
Total102076212441610320109270337
POS Choice Plus (PS1)
2023-0110819411201
2023-0210819411201
2023-0310719411201
2023-0410518412205
2023-0510317411193
2023-0610317411193
2023-0710117411191
2023-0810116411189
2023-0910116411189
2023-1010416411192
2023-1110516411193
2023-1210217411192
2024-0112018610214
2024-0212317610215
2024-0312417610216
2024-0412017610212
2024-051201769209
2024-061181769207
2024-071181769207
2024-081211769210
2024-091201769209
2024-101181769216
2024-111181769207
2024-121191769212
2025-0112716412224
2025-0212816413229
2025-0313115413230
2025-0413314413230
2025-0513514413232
2025-0613714413234
Total34785011443226253
Grand Total105554217451624720431276590

Claims Lags

EXHIBIT 2
CITY OF ORLANDO
MEDICAL CLAIMS
Paid MonthTotal PaidJan-21Feb-21Mar-21Apr-21May-21Jun-21Jul-21Aug-21Sep-21Oct-21Nov-21Dec-21Jan-22Feb-22Mar-22Apr-22May-22Jun-22Jul-22Aug-22Sep-22Oct-22Nov-22Dec-22Jan-23Feb-23Mar-23Apr-23May-23Jun-23Jul-23Aug-23Sep-23Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24Sep-24Oct-24Nov-24Dec-24
Jan-21$1,050,092$1,050,092$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Feb-21$2,832,388$1,989,283$843,105$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Mar-21$3,840,333$646,865$1,900,944$1,292,523$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Apr-21$3,354,458$186,544$552,608$1,380,909$1,234,398$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
May-21$3,801,451$59,903$122,034$536,417$1,826,223$1,256,875$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jun-21$3,814,222$29,923$63,489$147,492$518,885$1,772,830$1,281,603$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jul-21$3,896,782$13,442$48,567$119,569$274,199$329,627$1,996,926$1,114,453$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Aug-21$5,467,761$25,592$17,303$78,820$115,575$174,864$1,104,888$2,835,449$1,115,270$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Sep-21$4,340,736$19,412$12,727$20,871$36,339$74,574$186,621$496,498$2,068,480$1,425,214$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Oct-21$4,511,343$23,977$20,652$14,678$67,477$39,312$92,332$193,080$843,663$1,985,099$1,231,073$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Nov-21$4,123,553$3,775$12,616$11,819$47,757$51,843$35,523$75,588$134,514$359,705$2,260,590$1,129,823$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Dec-21$4,498,294$3,817$6,651$9,318$43,728-$7,299$27,238$49,969$68,384$586,702$551,344$1,847,444$1,310,999$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jan-22$3,593,897$4,570$6,304$545$4,247$22,926$6,666$26,228-$19,396$70,783$232,553$638,971$1,372,384$1,227,116$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Feb-22$3,794,767$8,608$5,680$10,678$26,308$19,278$1,064$11,267$9,332$48,195$71,401$122,218$316,172$2,075,523$1,069,044$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Mar-22$4,901,331$8,825$13,641$3,032-$4,987$7,170$9,896$22,383$6,599$431,097$537,875$35,583$157,149$650,429$1,687,514$1,335,126$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Apr-22$4,633,369$4,577$17,132$1,677$2,545$6,736$15,381$4,740$8,447$29,233$30,607$44,290$87,812$135,123$415,525$2,282,622$1,546,922$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
May-22$3,966,276$3,967-$1,531-$1,125-$3,164$43-$18,678-$1,928$3,247-$7,590$161,289$24,184$30,023$36,229$73,390$440,136$2,077,225$1,150,558$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jun-22$4,208,319$245-$1,522$4,332$1,046$4,243$22,733$122,253$3,122$6,028$10,309$10,704$104,801$50,702$22,890$145,248$364,360$2,116,487$1,220,338$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jul-22$4,083,956$1,180$627-$52$18,822$22,599$16,647$364,549$5,617-$320,963-$279,770$4,420$6,217$33,830$47,848$107,619$190,322$482,173$2,198,008$1,184,264$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Aug-22$4,362,093$2,559$1$702$2,850$1,919-$282$442$2,180$1,982$1,430-$654$1,771$34,064$62,373$36,137$77,956$133,152$383,459$2,349,929$1,270,125$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Sep-22$4,564,189$7,247$2,442$7,719-$259-$143$1,294-$20,651$892$2,334$8,166$3,160$86,847$5,311$7,115$8,521$128,057$101,587$226,466$458,300$2,205,530$1,324,252$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Oct-22$3,229,651$53-$376-$25,786$671$1,607$8,800$105-$1,176$1,626-$4,061$145$2,173$11,605$7,516$8,480$8,702$23,345$29,687$41,909$456,573$1,676,421$981,632$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Nov-22$4,676,462-$57-$209$410$93$698$95$2,558$301-$121$1,420$484-$1,031$547-$232$22,450$4,028$14,429$42,006$144,911$188,673$313,001$2,637,420$1,304,588$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Dec-22$6,923,629-$959$110$3,231$9,206$10,420-$504$709,074$1,190$8,244$1,312$2,841$60,064$34,839$6,789$16,843$40,957$95,035$5,144$73,660$96,134$637,612$1,113,104$2,248,309$1,750,976$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jan-23$3,644,367$346$47$52$168-$7,128-$172$365$412-$1,414-$103$5,959$461$13,693$11,747-$772$30,862$5,931$35,792$30,028$46,809$76,327$128,278$688,336$1,827,573$750,771$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Feb-23$2,846,993-$368-$90$829$1,789$1,857$516$1,649$2,623$6,507$9,882-$2,631$96$12,586-$3,326$7,264$5,977$8,073$6,645$136,810$116,136$54,121$147,089$93,246$198,617$1,340,932$700,161$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Mar-23$5,323,819$853$905$311$398$1,486$263$623$2,900$602$1,571-$230$166-$558$191$1,961$34,779-$23,089$27,664$6,546$24,624$42,544$88,534$49,375$213,391$1,069,451$2,166,194$1,612,363$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Apr-23$3,673,617$29,788$0$2,071$770$324$1,812$3,357$1,518$1,314$2,001$1,571$2,087$1,727$870$10,295$3,895$13,411$42,876$5,059$7,675$68,693-$188,119$11,422$85,197$230,960$487,952$1,546,727$1,298,368$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
May-23$4,853,819$19$0$324$529$15-$651$623$397$358$364$244$2,864$1,251$953$8,773$1,830-$974$5,382$3,059$7,388$10,261$66,685$24,216$25,346$166,265$163,872$517,498$2,172,001$1,674,927$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jun-23$4,015,372$0$0-$1,053$0$0$319$0-$277$117$1,185$52-$166$405$621$1,477$1,710-$2,500$6,659$3,476-$46-$62,153$20,820$4,849$42,192$43,419$62,363$121,132$610,383$1,952,382$1,208,008$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jul-23$5,003,860$0$0$0$0$0$179$0$292$1,342-$1,172-$311-$117$577-$50$9,215-$7,972$35,707$15,607$4,301$3,262$17,624$12,985-$1,774$3,338$366,420$22,868$49,640$491,754$1,400,348$1,561,299$1,018,497$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Aug-23$3,543,900$0-$1,362-$12,563$8,376-$7,817$4,361-$4,661-$491-$532-$97$38,524-$1,506-$22,410$3,123$567$10,712$17,705-$1,632$7,353$28,007$569$10,985-$212,541$14,042$54$53,619$11,422$28,236$304,849$559,610$1,468,965$1,238,435$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Sep-23$2,700,516$1,501$244$812-$6,302-$1,719-$32$0$237-$22$100-$44-$14,290$2,776$119$27,789$270-$29,163-$10,120-$3,187-$1,229$1,137-$11,155$51,567-$4,124-$16,855$2,720$2,205$105,411$64,082$165,666$288,798$1,373,195$710,130$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Oct-23$5,470,900$0$0$0$643-$643$360$607$47$330$145$4,460-$69,502-$19,402$13,191-$25,040$4,030-$57,157$4,054$1,870$30,002$725-$1,411$4,441$8,836$11,367$900$11,011$20,344$33,624$105,070$842,647$1,284,581$1,945,740$1,315,029$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Nov-23$3,956,703-$67$0$0-$85-$352$0-$5,617-$328-$1,204-$679$223$707-$343-$227$700$397$7,585$846-$905$1,787-$3,163-$1,312$6,954$4,246$17,776$4,596$11,034-$2,778$22,562$14,945$59,260$184,802$318,910$2,042,690$1,273,744$0$0$0$0$0$0$0$0$0$0$0$0$0
Dec-23$6,498,486$0$0$0$60$92$0-$1,078-$974$369-$239$0-$323-$2,276$255$0$1,761$787$134-$2,553$103-$255-$62$1,672$2,055$6,170$8,100$7,450$1,054-$2,401$26,099$32,064$72,693$975,227$1,153,097$2,595,660$1,623,743$0$0$0$0$0$0$0$0$0$0$0$0
Jan-24$4,071,129$0$0$0$0$0$0-$17$0$0$0$0-$322$323$27,375-$147$909$903$1,687$1,881$1,062$1,946$566$1,547$554$3,590$6,618$3,182$418$5,570$2,607-$8,349$15,644$39,602$137,711$394,468$2,355,261$1,076,539$0$0$0$0$0$0$0$0$0$0$0
Feb-24$4,514,797-$1,983-$1,831-$1,051-$2,943-$3,735-$1,574-$2,560-$2,013-$1,935-$6,834-$50,069-$902-$496-$1,715-$535-$1,573$462-$1,298$377$712$494-$152,035-$2,543$22,659-$15,360-$6,462$3,070$5,538$79,555$89,618$94,148$22,613$65,341$3,969$183,501$515,438$2,622,115$1,064,633$0$0$0$0$0$0$0$0$0$0
Mar-24$3,982,300$0$0$0-$2,777$0$0$121$81-$185$81$9,566$0$257$826$225-$66$100$128-$20$7,273$1,811$13,079$718$1,888$3,185$4,165$4,352$33,182$1,578$23,539$5,289$10,171$21,534$14,042$51,128$188,660$554,443$1,744,371$1,289,558$0$0$0$0$0$0$0$0$0
Apr-24$4,658,987$0$0$0$647$0-$855$0$0$0$0-$285$451$0$0-$3,771$210-$131-$93-$426$181$157-$381$637$4,907$220$1,798$31,842$1,900$12,633$9,182$31,223$7,662$5,480-$23,411$56,622$16,965$154,327$613,557$2,131,191$1,606,550$0$0$0$0$0$0$0$0
May-24$5,164,424$0$0$0$0-$195$0$91$0$0$0$0$20$572$0$0$844$885$0$99-$334$948$519-$56,142$1,038$816$1,991$5,616-$15,493-$136$9,866$16,815$2,322$7,327$15,309$27,226$38,494$101,805$119,896$731,936$2,512,067$1,640,223$0$0$0$0$0$0$0
Jun-24$4,707,231$0$0-$44$0$0$0$127-$219$0$0-$175$0$90-$115$0$0$0-$22-$197$0-$102-$20-$29$622$1,831$1,122$64$768-$45,972$1,502-$495$12,700-$24,029$94,044$26,756$14,432$21,789$59,999$121,316$492,565$2,307,049$1,621,875$0$0$0$0$0$0
Jul-24$4,205,266$0$0-$142$0$0$0$0-$611$0-$95$1,583$0-$262$44$0$233$32,811$841$227$0$0$1,768$895-$9,690$830$613-$1,203-$33,588-$7,851$1,290$20,889$2,243$2,603$15,226$21,199-$6,872$25,708$49,135$113,109$103,684$367,036$2,058,864$1,444,749$0$0$0$0$0
Aug-24$4,977,004$0$0$0$0$0$0$0$0$1,935$0$0$0$10$0$83-$591$62-$192$700-$58$53$305$204,107$584$397-$24,539$1,857$9,391-$10,930$4,440$5,331$1,998$5,368$1,457$5,224-$24,141$11,848$144,679$48,338$50,731$86,881$281,791$2,323,786$1,846,098$0$0$0$0
Sep-24$3,846,606-$10-$6-$83-$3-$2$0$0$0-$99$626$274$566$134$3,662$0-$127-$75$514-$13,755$0-$61$1,957$3,234$1,104$765$3,072$229$1,854$4,115$954$1,253$1,487-$394$4,630$5,540$9,254$13,439-$6,048-$3,344$26,501$37,189$44,127$187,462$2,062,422$1,454,249$0$0$0
Oct-24$3,792,709$0-$22$0$0$0$0$0$0$0$0$0$5$0$0$0$0$1,190$1,129$23$863$63$1,128$2,518$3,178$90$736$2,910$3,520$1,351$590$3,989-$543$17,754-$30,798$1,988-$75,283-$3,314$24,206$37,460$3,749$18,735$43,532$68,142$302,095$2,062,307$1,299,418$0$0
Nov-24$4,881,300$0$0$0$0$0$0$0$0$0-$56$0-$181$97-$69$0$0$0$571-$20-$209$0$455$491$239$255$152$314$1,898$545$667$830$537-$1,467-$22,037$176$4,329-$28,326$70,026$104,295$40,711$31,072$14,893$35,690$222,700$399,129$2,455,399$1,548,196$0
Dec-24$4,534,168$0$0$0$0$8,420$0$0$0$0$0$0$0$0$17-$57$50$0$693$5$0$35$2,061$683$934$1,272$680$2,763$2,003$5,573$8,181$901$5,131-$14,804$555-$7,548$17,596$2,255$5,264$6,035$5,552$34,244$3,794$19,464$73,173$516,690$523,800$1,864,555$1,444,199
Jan-25$5,031,739$0$0$0$0$0$0$0$0$13$0-$368-$422$0$0$14$966$29$246$0-$393$0-$32$0$0$235$17-$10,359$251$6,626$1,052$2,724-$2,545$14,197$2,214-$1,297$3,505-$7,550-$12,072-$191-$1,942$5,762$49,813$24,485$39,602$103,586$141,082$850,641$2,659,275
Feb-25$3,664,659$0$0$0$0$0$0$0$0$0$0$88$0$0$0-$238$811-$777$0$0$94$779$1,151-$82$2,535-$190$1,402$5,135$5,618$2,789$3,273$1,761$4,447-$3,103-$6,547-$806$11,134$2,316$7,108$5,571$13,740$12,419$33,789$4,620$16,563$14,432$27,508$47,937$226,851
TOTAL$212,034,026$4,123,516$3,640,881$3,607,239$4,223,230$3,780,723$4,792,768$5,999,686$4,254,262$4,635,066$4,822,218$3,872,041$3,455,073$4,284,066$3,457,263$4,440,984$4,528,445$4,128,541$4,243,220$4,433,726$4,490,744$4,163,840$4,875,994$4,430,696$4,202,238$3,984,667$3,664,710$3,940,253$4,742,032$5,505,818$3,797,460$3,886,539$4,237,573$4,085,416$4,717,178$4,633,580$4,692,514$4,547,393$3,884,753$4,585,273$4,853,906$4,540,610$4,152,480$4,108,398$4,562,653$4,550,392$4,447,208$4,311,328$4,330,326
PHARMACY CLAIMS
Paid MonthTotal PaidJan-21Feb-21Mar-21Apr-21May-21Jun-21Jul-21Aug-21Sep-21Oct-21Nov-21Dec-21Jan-22Feb-22Mar-22Apr-22May-22Jun-22Jul-22Aug-22Sep-22Oct-22Nov-22Dec-22Jan-23Feb-23Mar-23Apr-23May-23Jun-23Jul-23Aug-23Sep-23Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24Sep-24Oct-24Nov-24Dec-24
Jan-21$927,498$927,498$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Feb-21$2,022,179$952,422$1,069,757$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Mar-21$1,616,472-$2,496$692,650$926,318$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Apr-21$2,006,807-$34-$3,821$1,139,816$870,847$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
May-21$1,882,025$0-$38-$3,533$1,069,511$816,086$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jun-21$2,052,807$0$0$3,171$5,682$843,063$1,200,891$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jul-21$1,536,481$17$0$57-$738-$561$696,665$841,040$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Aug-21$1,858,521$0$34$40$457-$32-$304$1,033,864$824,461$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Sep-21$1,962,133$0$17$40$0$0$40$55$1,084,812$877,169$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Oct-21$2,025,125$287$597$75$0-$6$35$80-$1,549$938,501$1,087,106$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Nov-21$2,054,340$29$316$282$17$252$710$319$226-$121$939,528$1,112,782$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Dec-21$1,963,166$0$0$0$0$0$80$0$4$322-$639$837,871$1,125,528$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jan-22$1,964,242$0$0$0$0$0$0$0-$23-$199$229-$226$827,233$1,137,227$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Feb-22$1,942,364$0$0$0$0$0$0$0$0$0-$67$319-$339$922,458$1,019,994$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Mar-22$1,817,804$15-$213-$211-$196$45$15$15$15$175$255$18$70$513$838,998$978,290$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Apr-22$2,011,680$0$266$0$1,904$0$264$264$0$0$264$264$30$518-$3,449$848,818$1,162,538$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
May-22$1,876,031$0$0$0$0$0$0$0$0$0$0$0-$27$0$253$557$769,900$1,105,349$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jun-22$1,953,137$30$0$30$0$0$0$0$15$0$0$118$0$324$45$332-$27$942,074$1,010,195$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jul-22$1,851,066$0$0$0$0$0$0$51$0$0$0-$31$0$0$0$0-$6-$21$807,711$1,043,361$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Aug-22$2,028,728$0$0$0$0$0$0$0$0$0$0$0$0$0$0$40$0-$199-$1,742$1,046,431$984,198$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Sep-22$2,129,287$26$0$0$0$0$0$0$0$0$0$0$0$0$0$0$64$50-$158-$15,232$939,529$1,205,007$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Oct-22$2,081,117$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$11$2$106-$304$768,448$1,312,854$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Nov-22$2,105,140$0$0$0$0$0$0$0$0$0$0-$792-$349$0$0$0$0$272$272$272$264-$1,091$844,368$1,261,924$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Dec-22$1,879,123$0$0$0$0$0$0$0$0$0-$792-$752-$1,585-$837$0-$837-$834$11$0$11-$9$65$693$862,620$1,021,370$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jan-23$2,160,584$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0-$178$413$346-$43$1,063,662$1,096,384$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Feb-23$2,080,860$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$389-$1,349$1,047,454$1,034,366$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Mar-23$1,982,772$0$0$0$0$0$0$0$0$568$0$284$284$0$194$285$0$0$0$5-$1,958-$160$0$101-$786-$4,562$789,334$1,199,181$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Apr-23$2,000,994$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$2$0$0$2$0$0-$258$24-$1,420$925,655$1,076,990$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
May-23$2,157,265$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0-$13,649$772$959,610$1,210,533$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jun-23$2,304,134$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0-$6-$382-$208-$208$0$637$101$518-$2,013$1,109,448$1,196,246$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jul-23$2,024,787$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$253$924,152$1,100,383$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Aug-23$2,385,466$0$0$0$0$0$0-$349-$349$0$0$0$0$0$0$0$0$0$0$0-$299$0$0$0$0$0-$879$0$302-$277-$823$1,223,467$1,164,675$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Sep-23$2,303,978$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$9$60$20-$816-$5,006$1,065,955$1,243,755$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Oct-23$2,205,851$0$0$0$0$40$0$120$240$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0-$18$0$0$0$0$0-$1,314$998,482$1,208,300$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Nov-23$2,458,245$237$0$0$0$0$0-$18-$18-$31$176$71-$500-$451-$493-$525-$523-$522-$533-$521-$522-$521-$512$0$0$0$0$0$0-$28-$6-$322-$1,191$1,297$1,112,494$1,351,206$0$0$0$0$0$0$0$0$0$0$0$0$0
Dec-23$2,246,786-$237$0$0$0$0$0$0$0-$4-$186-$73-$4-$111-$32$0$0$0$0$0-$37$0$0$0$0$0$0$0$0$0$0$0$1,033$173-$929$860,096$1,387,099$0$0$0$0$0$0$0$0$0$0$0$0
Jan-24$2,242,218$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0-$17-$21$0$15$0$9$277-$1,223$1,228,478$1,014,700$0$0$0$0$0$0$0$0$0$0$0
Feb-24$2,516,255$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0-$409$0-$408$0$0$0$0$0$0$0$0$0$73$0$0$0$0$0$961$668-$1,912$1,304,651$1,212,631$0$0$0$0$0$0$0$0$0$0
Mar-24$2,049,815$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$11-$269$763,697$1,286,377$0$0$0$0$0$0$0$0$0
Apr-24$2,592,695$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0-$71$0$0$0$47$23$1,020$15,268$1,110,160$1,466,249$0$0$0$0$0$0$0$0
May-24$2,387,661$0$0$0$0$0$0$0$0$0$0$0$0$0-$40$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$8-$9$0$246$1,595$2,534$980,710$1,402,617$0$0$0$0$0$0$0
Jun-24$2,275,367$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$51-$59$0-$2,235-$1,432$1,271,810$1,007,231$0$0$0$0$0$0
Jul-24$2,357,904$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$12-$2-$51$0$0$293-$128$223$941,417$1,416,140$0$0$0$0$0
Aug-24$2,681,896$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0-$46-$200$30$0$98-$675$0-$5$793$1,272,459$1,409,443$0$0$0$0
Sep-24$2,530,833$0$0$0$0$0$0$0$0$0$11$0$0$0$32$0$0$0$0$0$0$0$0$0$3$15$0$0$0$0$0$0$0$0$0$0$0$0$0-$675$0$0$129$2,163$1,193,523$1,335,633$0$0$0
Oct-24$2,653,411$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$164$4$0$0$0$0$0$1,221$0$0$870$4$0$1,014$4$1,835$43$917-$556$1,345,352$1,302,539$0$0
Nov-24$2,857,929$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$4$0$0$326$0$0$0$0$0$0$0$0$0$70$115$0$0$0$6$0$0$0$0$0$0-$1,625-$571$1,440,396$1,419,209$0
Dec-24$2,449,483$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$2,971$0-$9,411$0$0-$373-$1,342-$7,618$1,084,720$1,380,536
Jan-25$2,448,665$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$9,411$0$0$0$0-$1,220-$183$1,190,583
Feb-25$2,256,663$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$100$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0-$491$0$0$7$0-$882-$3,663
TOTAL$106,159,790$1,877,794$1,759,564$2,066,085$1,947,483$1,658,887$1,898,397$1,875,443$1,907,834$1,816,380$2,025,884$1,949,851$1,950,341$2,059,640$1,855,503$1,826,960$1,930,703$2,047,025$1,815,341$2,074,436$1,920,679$1,971,780$2,157,865$2,124,782$2,082,641$2,140,053$1,807,999$2,126,139$2,035,005$2,319,927$2,118,753$2,318,466$2,229,227$2,245,053$2,321,078$2,210,582$2,614,599$2,320,301$1,993,289$2,399,764$2,445,403$2,676,480$1,949,123$2,691,679$2,600,412$2,679,078$2,734,098$2,502,862$2,567,456

2024 Claimants Over $150K

EXHIBIT 2
Claimant Payments over $150,000
City of Orlando
Paid Dates: 1/1/2024 - 12/31/2024
Case #RelationshipDiagnosisYTDPaid MonthRemember to Delete Hidden Section in email Version
202301202302202303202304202305202306202307202308202309202310202311202312Stop Loss - None
1*SubscriberHypophosphatasia$ 1,818,062.41$224,179$70,076$52,636$75,772$77,066$90,766$51,910
2SubscriberHeart failure and stage 1 through stage 4 chronic kidney disease, or unspecified chronic kidney disease$ 747,504.36
3SpouseMalignant neoplasm of upper-outer quadrant of left female breast$ 695,229.96
4SubscriberDiverticulitis of large intestine without perforation or abscess without bleeding$ 530,299.34
5SubscriberSepsis, unspecified organism$ 513,028.83
6SpouseMalignant Neoplasm of the bone.$ 459,154.25
7SubscriberMultiple myeloma not having achieved remission$ 444,805.31
8SpouseMalignant neoplasm of lower lobe, right bronchus or lung$ 443,357.67
9SubscriberMalignant neoplasm of abdomen$ 382,629.81
10SpouseProstate cancer and is undergoing radiation therapy as part of their treatment.$ 359,502.22
11SubscriberMultiple myeloma not having achieved remission$ 358,071.42
12DependentRespiratory distress of newborn, unspecified$ 344,484.71
13SubscriberMalignant neoplasm of pancreas, unspecified$ 344,318.55
14SpouseEnd stage renal disease$ 321,390.57
15SubscriberMalignant neoplasm of lung$ 320,224.50
16SubscriberSjögren syndrome, unspecified$ 316,112.96
17SubscriberChronic lymphocytic leukemia of B-cell type not having achieved remission$ 305,735.44
18ChildCystic fibrosis with pulmonary manifestations$ 295,233.73
19SubscriberMalignant neoplasm of head of pancreas$ 288,136.90
20ChildUnspecified abnormal finding of blood chemistry; localized enlarged lymph nodes.$ 283,642.28
21SubscriberSepsis, unspecified organism$ 277,183.80
22SpouseThrombosis from cardiac prosthetic device$ 264,499.25
23SubscriberNewborn with acongenital heart defect; complications related to blood clots in the lower extremities$ 264,015.77
24SubscriberPolycystic kidney disease (Jynarque drug $20k)$ 263,994.68
25SubscriberBladder disorder, unspecified · Diseases of the genitourinary system$ 263,325.60
26Subscriberocclusion and stenosis of the left carotid artery$ 252,839.37
27SubscriberMalignant neoplasm of prostate$ 249,761.35
28SpouseMechanical failure of a spinal fixation device; complications from a previous spinal fusion surgery$ 245,149.99
29SpouseMultiple Sclerosis$ 242,978.63
30SubscriberOther injury of ascending [right] colon, initial encounter$ 238,755.23
31SubscriberMalignant neoplasm of overlapping sites of bladder$ 229,474.01
32ChildXyrem (sodium oxybate)to treat narcolepsy.$ 216,259.70
33SubscriberRadiation therapy for a malignant tumor in the connective and soft tissues of the left lower limb, with additional unspecified soft tissue disorders.$ 215,407.86
34SubscriberProstate cancer patient undergoing long-term treatment with agents that affect estrogen receptors and estrogen levels.$ 208,929.81
35SpouseAtherosclerotic heart disease and hypertensive heart disease, along with acidosis.$ 206,128.31
36ChildPitolisant HCl used to treat cataplexy in individuals with narcolepsy.$ 197,871.70
37SpouseRadiculopathy in the lumbar region; displaced fracture of the second metatarsal bone in the left foot.$ 194,804.48
38SubscriberInpatient hospital stay; Surgical$ 194,562.13$3,410$247,860$209,454$33,416$62,307$2,819$29,784
39SubscriberRheumatic disorders of both mitral and aortic valves$ 194,408.93$383,662$120$0$0$0$0$0
40SubscriberCrohn’s disease, hypertensive heart and chronic kidney disease, atherosclerotic heart disease, and aortic atherosclerosis.$ 193,889.01$35,307$208,746$109,887$7,050$741$197$327
41SubscriberThyroid cancer, a solitary pulmonary nodule, and is undergoing long-term medication therapy.$ 187,252.75$18,632$8,301$21,050$22,013$12,964$7,492$240,247
42SubscriberHumira$ 184,530.27$65,256$25,515$60,686$27,235$26,511$61,081$26,009
43SubscriberAntineoplastic immunotherapy for prostate cancer.$ 183,628.69
44SpouseMalignant neoplasm of upper-outer quadrant of right female breast$ 183,162.59$78$96,401$78,350$101,165$4,069$0$0
45SubscriberRiociguat to treat pulmonary arterial hypertension and chronic thromboembolic pulmonary hypertension.$ 182,806.96$730,525$657,019$532,062$266,650$183,657$162,355$348,278$0$0$0$0$0
46ChildCystic fibrosis with pulmonary manifestations$ 177,260.30
47SpouseChronic inflammatory demyelinating polyneuritis (CIDP)$ 176,736.34
48ChildAtherosclerotic heart disease of the native coronary artery with unspecified angina pectoris.$ 173,872.79
49SubscriberDarolutamide is primarily used to treat prostate cancer that has not spread to other parts of the body$ 173,482.59
50ChildSemaglutide$ 173,375.44
51SubscriberMultiple myeloma that has not achieved remission.$ 172,573.40
52SubscriberHumira$ 169,182.46
53SubscriberCerebral infarction, unspecified$ 167,587.15
54SubscriberMalignant neoplasm of lower third of esophagus$ 166,940.40
55SubscriberCrohn’s disease of the large intestine without complications$ 165,509.76
56SubscriberInfection following a procedure, other surgical site, initial encounter$ 164,039.66
57SubscriberChronic lymphocytic leukemia$ 161,397.05
58Spousecomplications related to retained placenta after childbirth.$ 159,837.06
59SubscriberSepsis, or blood poisoning, organism is unspecified$ 157,388.65
60ChildTetralogy of Fallot (heart disease-congenital- female dependent 13 yo/o)$ 157,161.73
61SpouseUnspecified ovarian cyst on the left side (ER visit)$ 156,200.03
62ChildCrohn's disease of both small and large intestine without complication$ 154,943.29
63SubscriberAtherosclerotic heart disease with unspecified angina, and hypertensive chronic kidney disease.$ 157,285.35
*Laser MemberClaims over $150,000

2023 Claimants Over $150K

EXHIBIT 2
Claimant Payments over $150,000
City of Orlando
Paid Dates: 1/1/2023 - 12/31/2023
Case #StatusRelationshipDiagnosisYTDPaid MonthRemember to Delete Hidden Section in email Version
202301202302202303202304202305202306202307202308202309202310202311202312Stop Loss - None
1Active*SubscriberHypophosphatasia$1,444,501$224,179$70,076$52,636$75,772$77,066$90,766$51,910
2RetiredRetired SubscriberTransplantation of Bilateral Lungs, Allogeneic, Open Approach$1,124,143
3ActiveChildPreterm newborn, gestational age 32 completed week$840,881
4RetiredRetired SubscriberSepsis, unspecified organism$568,371
5RetiredSpouseAtherosclerotic heart disease of native coronary artery without angina pectoris$462,608
6RetiredSpouseMalignant neoplasm of rectum$423,595
7ActiveSubscriberMalignant neoplasm of mandible$406,069
8ActiveSubscriberAcute on chronic diastolic (congestive) heart failure$398,018
9ActiveSpouseMultiple sclerosis$395,030
10ActiveNewbornPrimary atelectasis of newborn$377,123
11ActiveSubscriberDiverticulosis of large intestine without perforation or abscess with bleeding$367,378
12RetiredRetired SubscriberNonrheumatic mitral (valve) insufficiency$346,333
13Retired*Retired SubscriberMalignant neoplasm of unspecified site of unspecified eye$342,740
14ActiveSubscriberMultiple myeloma not having achieved remission$329,362
15RetiredSpouseType 2 diabetes mellitus with diabetic peripheral angiopathy with gangrene$321,411
16RetiredRetired SubscriberHypertensive heart disease with heart failure$316,398
17ActiveSpouseMalignant neoplasm of overlapping sites of right female breast$274,808
18ActiveSpouseMalignant neoplasm of unspecified site of left female breast$270,189
19ActiveSubscriberIntrahepatic bile duct carcinoma$268,525
20ActiveSpouseMalignant neoplasm of upper-outer quadrant of left female breast$263,270
21ActiveSpouseType 2 diabetes mellitus with diabetic peripheral angiopathy with gangrene$254,235
22RetiredRetired SubscriberHypertensive heart and chronic kidney disease with heart failure and stage 1 through stage 4 chronic kidney disease, or unspecified chronic kidney disease$237,094
23ActiveSubscriberAutosomal dominant polycystic kidney disease (ADPKD)$235,944
24ActiveSubscriberDisplaced comminuted fracture of shaft of right tibia, initial encounter for open fracture type IIIA, IIIB, or IIIC$225,518
25RetiredSpousePrimary pulmonary hypertension$223,095
26ActiveSubscriberMalignant neoplasm of sigmoid colon$219,547
27RetiredRetired SubscriberMalignant neoplasm of prostate$219,462
28ActiveSubscriberPulmonary fibrosis, unspecified$210,714
29RetiredSpouseMalignant neoplasm of Endometrium$206,145
30ActiveSubscriberAtherosclerotic heart disease of native coronary artery with other forms of angina pectoris$204,612
31RetiredRetired SubscriberMalignant neoplasm of breast$201,288
32RetiredChildHidradenitis suppurativa$199,230
33ActiveSubscriberAtherosclerotic heart disease of native coronary artery without angina pectoris$197,141
34ActiveSubscriberHidradenitis suppurativa$195,702
35RetiredRetired SubscriberCongenital insufficiency of aortic valve$189,657
36RetiredRetired SubscriberSpondylolysis, lumbar region$189,485
37ActiveSubscriberMalignant neoplasm of prostate$187,565
38ActiveSubscriberGeneralized Anxiety Disorder.$185,536$3,410$247,860$209,454$33,416$62,307$2,819$29,784
39ActiveSubscriberPartial intestinal obstruction, unspecified as to cause$178,470$383,662$120$0$0$0$0$0
40RetiredRetired SubscriberPulmonary hypertension, unspecified$176,120$35,307$208,746$109,887$7,050$741$197$327
41ActiveSubscriberSaddle embolus of pulmonary artery with acute cor pulmonale$174,498$18,632$8,301$21,050$22,013$12,964$7,492$240,247
42ActiveSubscriberMalignant neoplasm of overlapping sites of right female breast$172,859$65,256$25,515$60,686$27,235$26,511$61,081$26,009
43ActiveSpouseSepsis, unspecified organism$168,927$28,136$44,581$77,458$28,744$24,273$42,551$37,815
44ActiveSubscriberCrohn's disease, unspecified, without complications$166,479$78$96,401$78,350$101,165$4,069$0$0
45RetiredRetired SubscriberChronic inflammatory demyelinating polyneuritis$163,342$758,661$701,600$609,520$295,394$207,930$204,905$386,093$0$0$0$0$0
46RetiredRetired SubscriberMalignant neoplasm of thyroid gland$162,766
47RetiredRetired SubscriberAtherosclerotic heart disease of native coronary artery with unstable angina pectoris$161,520
48ActiveSpouseOther hypertrophic cardiomyopathy$155,053
49RetiredRetired SubscriberOther specified types of non-Hodgkin lymphoma, extranodal and solid organ sites$154,377
50RetiredRetired SubscriberMultiple myeloma not having achieved remission$153,119
51RetiredRetired SubscriberChronic obstructive pulmonary disease, unspecified$152,565
52ActiveSubscriberCrohn's disease, unspecified, without complications$150,277
$15,613,095
*Laser Member

&G &P

2022 Claimants Over $150K

EXHIBIT 2
Claimant Payments over $150,000
City of Orlando
Paid Dates: 1/1/2022 - 12/31/2022
Case #RelationshipDiagnosisYTD
Status
1RetiredSubscriberMalignant neoplasm of right choroid$1,454,424
2Active*SubscriberHypophosphatasia$1,425,460
3ActiveDependentMeckel's diverticulum$935,334
4ActiveSubscriberMultiple myeloma not having achieved remission$852,204
5ActiveSubscriberHairy cell leukemia not having achieved remission$665,511
6RetiredSubscriberDiffuse large B-cell lymphoma, extranodal and solid organ sites$663,449
7ActiveDependentAcute lymphoblastic leukemia not having achieved remission$459,267
8RetiredSubscriberMalignant neoplasm of rectum$421,653
9ActiveSubscriberMultiple myeloma not having achieved remission$410,502
10RetiredSubscriberMalignant neoplasm of brain, unspecified$399,721
11ActiveSpouseCOVID-19$359,051
12ActiveSubscriberMalignant neoplasm of upper-outer quadrant of right female breast$354,374
13ActiveSpouseMalignant neoplasm of overlapping sites of left female breast$325,385
14RetiredSpouseMalignant neoplasm of endometrium$309,790
15ActiveSubscriberAcute and subacute infective endocarditis$296,241
16ActiveSubscriberMalignant neoplasm of retromolar area$283,823
17ActiveSpouseEnd stage renal disease$277,497
18RetiredSubscriberUlcerative (chronic) pancolitis without complications$275,323
19ActiveSubscriberSepsis, unspecified organism$274,810
20ActiveSpouseBenign neoplasm of cecum$273,237
21ActiveSubscriberMalignant neoplasm of sigmoid colon$267,730
22Retired*SubscriberMalignant neoplasm of thyroid gland$264,681
23ActiveSubscriberMalignant neoplasm of overlapping sites of right female breast$259,878
24ActiveSubscriberPolycystic kidney disease (Jynarque $17k)$259,791
25ActiveSubscriberSecondary malignant neoplasm of bone$251,251
26RetiredSubscriberInfection and inflammatory reaction due to peritoneal dialysis catheter, initial encounter; ESRD patient$243,586
27RetiredSubscriberBreast Cancer (Verzenio $14k)$236,828
28ActiveSubscriberMalignant neoplasm of overlapping sites of left female breast$232,365
29RetiredSubscriberHuman immunodeficiency virus [HIV] disease$231,068
30ActiveSpouseMultiple Sclerosis$227,262
31Retired*SubscriberMultiple myeloma not having achieved remission$223,206
32ActiveSpouseMalignant neoplasm of upper-outer quadrant of left female breast$220,997
33Retired*SubscriberMalignant neoplasm of prostate$217,707
34ActiveSubscriberMalignant neoplasm of prostate$212,465
35RetiredDependentMechanical loosening of other internal prosthetic joint, initial encounter$206,331
36ActiveSubscriberMalignant neoplasm of bladder, unspecified$199,164
37RetiredSpouseSpinal stenosis, lumbar region with neurogenic claudication$199,121
38Retired*SubscriberMultiple myeloma not having achieved remission$198,334
39ActiveSubscriberHidradenitis suppurativa$197,489
40RetiredSpouseMultiple Sclerosis$192,451
41ActiveDependentRespiratory distress syndrome of newborn$189,081
42Retired*SubscriberWaldenström macroglobulinemia$188,000
43ActiveSpouseAtherosclerotic heart disease of native coronary artery without angina pectoris$185,169
44ActiveSubscriberCystic Fibrosis$182,612
45Retired*SpouseMalignant neoplasm of upper respiratory tract, part unspecified$180,141
46ActiveSubscriberMalignant neoplasm of prostate$176,092
47ActiveSubscriberCrohn's disease, unspecified, without complications$176,012
48Retired*SubscriberMalignant neoplasm of prostate$170,436
49Retired*SubscriberMalignant neoplasm of lower third of esophagus$165,139
50RetiredSpouseSpinal stenosis, lumbar region without neurogenic claudication$162,178
51ActiveSpouseMalignant neoplasm of unspecified site of right female breast$161,867
52ActiveSubscriberCrohn's disease of both small and large intestine without complications$161,078
53Retired*SubscriberChronic obstructive pulmonary disease with (acute) exacerbation$160,128
54RetiredSpouseSepsis, unspecified organism$159,985
55ActiveSpouseMalignant neoplasm of unspecified site of unspecified female breast$159,484
56ActiveDependentHidradenitis suppurativa$158,907
57RetiredSubscriberThyrotoxicosis with diffuse goiter without thyrotoxic crisis or storm$158,234
58Retired*SpousePulmonary arterial hypertension$156,499
59ActiveSubscriberPartial intestinal obstruction, unspecified as to cause$155,610
$18,465,411
*Laser Member

Raw_Data

Membership By Month
Report Filter:
({Type of Coverage} = Medical) And ({-Policy Number} = 000706664) And ({Membership Year/Month} = 2025-062025-052025-042025-032025-022025-012024-122024-112024-102024-092024-082024-072024-062024-052024-042024-032024-022024-012023-122023-112023-102023-092023-082023-072023-062023-052023-042023-032023-022023-01)
Plan VariationEmployment StatusProductMembership Year/MonthSingle SubscribersSubscribers plus SpouseSubscribers plus Child/ChildrenSubscribers plus FamilyTotal SubscribersNon-Positively Enrolled DependentsPositively Enrolled DependentsTotal Members
0281ActiveEPO Choice (EP1)2023-01601070310
0281ActiveEPO Choice (EP1)2023-02601070310
0281ActiveEPO Choice (EP1)2023-03601070310
0281ActiveEPO Choice (EP1)2023-04701080311
0281ActiveEPO Choice (EP1)2023-05701080311
0281ActiveEPO Choice (EP1)2023-0650106039
0281ActiveEPO Choice (EP1)2023-0750106039
0281ActiveEPO Choice (EP1)2023-0840105038
0281ActiveEPO Choice (EP1)2023-0940105038
0281ActiveEPO Choice (EP1)2023-1030104037
0281ActiveEPO Choice (EP1)2023-1130104037
0281ActiveEPO Choice (EP1)2023-1240105038
0281ActiveEPO Choice (EP1)2024-01800190211
0281ActiveEPO Choice (EP1)2024-0290009009
0281ActiveEPO Choice (EP1)2024-0390009009
0281ActiveEPO Choice (EP1)2024-0410000100010
0281ActiveEPO Choice (EP1)2024-0580008008
0281ActiveEPO Choice (EP1)2024-0670007007
0281ActiveEPO Choice (EP1)2024-0740004004
0281ActiveEPO Choice (EP1)2024-0840004004
0281ActiveEPO Choice (EP1)2024-0940004004
0281ActiveEPO Choice (EP1)2024-1040004004
0281ActiveEPO Choice (EP1)2024-1140004004
0281ActiveEPO Choice (EP1)2024-1251006017
0281ActiveEPO Choice (EP1)2025-0130003003
0281ActiveEPO Choice (EP1)2025-0220002002
0281ActiveEPO Choice (EP1)2025-0320002002
0281ActiveEPO Choice (EP1)2025-0420002002
0281ActiveEPO Choice (EP1)2025-0530003003
0281ActiveEPO Choice (EP1)2025-0620002002
0281ActiveEPO Choice (EP1)Total1501121164039203
0281RetiredEPO Choice (EP1)2023-0110001001
0281RetiredEPO Choice (EP1)2023-0210001001
0281RetiredEPO Choice (EP1)2023-0310001001
0281RetiredEPO Choice (EP1)2023-0410001001
0281RetiredEPO Choice (EP1)2023-0510001001
0281RetiredEPO Choice (EP1)2023-0610001001
0281RetiredEPO Choice (EP1)2023-0710001001
0281RetiredEPO Choice (EP1)2023-0810001001
0281RetiredEPO Choice (EP1)2023-0910001001
0281RetiredEPO Choice (EP1)2023-1010001001
0281RetiredEPO Choice (EP1)2023-1110001001
0281RetiredEPO Choice (EP1)2023-1210001001
0281RetiredEPO Choice (EP1)2024-0110001001
0281RetiredEPO Choice (EP1)2024-0210001001
0281RetiredEPO Choice (EP1)2024-0310001001
0281RetiredEPO Choice (EP1)2024-0410001001
0281RetiredEPO Choice (EP1)2024-0510001001
0281RetiredEPO Choice (EP1)2024-0610001001
0281RetiredEPO Choice (EP1)Total18000180018
0286ActivePOS Choice Plus (PS1)2023-0110001001
0286ActivePOS Choice Plus (PS1)2023-0210001001
0286ActivePOS Choice Plus (PS1)2023-0310001001
0286ActivePOS Choice Plus (PS1)2023-0410001001
0286ActivePOS Choice Plus (PS1)Total40004004
0364ActiveEPO Choice (EP1)2023-011,4662393514412,49702,1804,677
0364ActiveEPO Choice (EP1)2023-021,4742403544412,50902,1794,688
0364ActiveEPO Choice (EP1)2023-031,4732403524392,50402,1724,676
0364ActiveEPO Choice (EP1)2023-041,4842443524382,51802,1824,700
0364ActiveEPO Choice (EP1)2023-051,4892393524412,52102,1804,701
0364ActiveEPO Choice (EP1)2023-061,4992403534422,53402,1834,717
0364ActiveEPO Choice (EP1)2023-071,5202433534482,56402,2064,770
0364ActiveEPO Choice (EP1)2023-081,5242463544482,57202,2064,778
0364ActiveEPO Choice (EP1)2023-091,5752443594522,63002,2224,852
0364ActiveEPO Choice (EP1)2023-101,5882443604532,64502,2264,871
0364ActiveEPO Choice (EP1)2023-111,5922453584522,64702,2224,869
0364ActiveEPO Choice (EP1)2023-121,5992463614532,65902,2394,898
0364ActiveEPO Choice (EP1)2024-011,5832403574532,63302,2394,872
0364ActiveEPO Choice (EP1)2024-021,5892313584592,63702,2564,893
0364ActiveEPO Choice (EP1)2024-031,5962293604562,64102,2524,893
0364ActiveEPO Choice (EP1)2024-041,6012303674602,65802,2774,935
0364ActiveEPO Choice (EP1)2024-051,6152313724602,67802,2854,963
0364ActiveEPO Choice (EP1)2024-061,6122293744562,67102,2714,942
0364ActiveEPO Choice (EP1)2024-071,6382283774542,69702,2654,962
0364ActiveEPO Choice (EP1)2024-081,6572293814532,72002,2694,989
0364ActiveEPO Choice (EP1)2024-091,6822253804532,74002,2695,009
0364ActiveEPO Choice (EP1)2024-101,6762273814492,73302,2604,993
0364ActiveEPO Choice (EP1)2024-111,6962243814472,74802,2535,001

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 .