7-Exhibit E Report of Medical and RX Claims 2024.xls

XLS spreadsheet 380 KB Posted

Attached to
Medical Stop-Loss Insurance Coverage
Solicitation number
ITB-25-00380
Issued by
Hillsborough County, Florida

About this file

This file is a comprehensive Medical and RX Claims Experience Report for the Hillsborough County Board of County Commissioners, covering healthcare enrollment and claims data for January through December 2024. The report details healthcare coverage across multiple benefit options, including the High Deductible Health Plan (HDHP) Modern Plan and OAP Traditional Plan, with enrollment tracking for active employees and retirees across various county departments such as Board of County Commissioners, Property Appraisers, Expressway, Sports Authority, Court, Children's Board, and Clerk's Office.

The report provides granular monthly financial data, including fixed charges, in-network and out-of-network claims, drug claims, and total healthcare expenses. Total annual enrollment is 67,841 subscribers, with 30,465 in the HDHP Modern Plan and 37,376 in the OAP Traditional Plan. The grand total healthcare expenditure for 2024 is $113,261,833, with total claims of $108,492,014, ASO fees of $1,403,374, and a per member per month (PMPM) cost of $755. The document also includes a de-identified claims report highlighting individual claims exceeding $100,000, which supports the related state and local contract opportunity for medical stop-loss insurance coverage with an estimated project budget of $43,970,461.98.

View the file

Other files

Show all 15

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

Exp by BenOpt-1

HILLSBOROUGH COUNTY BOARD OF COUNTY COMM
MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT
January 2024 thru December 2024
Rating Type : RETROSPECTIVE EXPERIENCE RATED
Reported Premium: ASO Fees
Reported Claims: All Claims, Debit, Clms Fwrd, Check, ATM
Note: Paid claim dollars include amounts deducted from your account and paid to vendors for cost containment services.
YTD/MONTHBENEFIT OPTIONFIXED CHARGESIN NETWORKOUT OF NETWORKDRUGGROSS CLAIMSSTOP LOSSNET CLAIMSHSA FUND ACTIVITYTOTAL HSA & CLAIMSTOTAL ASO FEESTOTAL SUBSTOTAL MBRSTOTAL PEPMTOTAL PMPM
Jan-24HDHP MODERN PLAN$171,249$1,774,652$45,221$591,379$2,582,501$0$2,582,501$637,897$3,220,399$25,1212,5184,761$1,026$542
OAP COVERAGE NOW$0($686)$0$0($686)$0($686)$0($686)$000$0$0
OAP TRADITIONAL PLAN$343,150$3,622,265$30,205$1,849,034$5,844,654($103)$5,844,551$0$5,844,551$49,1243,1287,265$1,868$804
Jan-2024 Total$514,399$5,396,231$75,426$2,440,413$8,426,469($103)$8,426,366$637,897$9,064,264$74,2455,64612,026$1,492$701
Feb-24HDHP MODERN PLAN$170,209$1,497,681$17,498$392,335$2,077,723$0$2,077,723$506,379$2,584,102$26,1492,5194,758$825$437
OAP TRADITIONAL PLAN$343,850$3,744,825$32,715$1,191,919$5,313,309$0$5,313,309$0$5,313,309$50,6563,1287,244$1,699$733
Feb-2024 Total$514,059$5,242,506$50,213$1,584,254$7,391,032$0$7,391,032$506,379$7,897,411$76,8045,64712,002$1,309$616
Mar-24HDHP MODERN PLAN$176,774$1,956,584$53,598$728,446$2,915,403$0$2,915,403$450,697$3,366,100$24,7012,5164,743$1,159$615
OAP COVERAGE NOW$0($495)$0$0($495)$0($495)$0($495)$000$0$0
OAP TRADITIONAL PLAN$361,844$3,275,534$154,756$1,882,414$5,674,548$687$5,675,235$0$5,675,235$49,2453,1197,228$1,820$785
Mar-2024 Total$538,618$5,231,623$208,355$2,610,860$8,589,457$687$8,590,144$450,697$9,040,840$73,9465,63511,971$1,524$718
Apr-24HDHP MODERN PLAN$186,639$2,027,343$9,851$658,557$2,882,390$0$2,882,390$446,242$3,328,632$25,1762,5154,720$1,146$611
OAP COVERAGE NOW$0($1,396)$0$0($1,396)$0($1,396)$0($1,396)$000$0$0
OAP TRADITIONAL PLAN$370,824$4,930,021$124,843$2,051,767$7,477,454($103,527)$7,373,928$0$7,373,928$49,5033,1247,221$2,360$1,021
Apr-2024 Total$557,463$6,955,968$134,694$2,710,325$10,358,449($103,527)$10,254,923$446,242$10,701,165$74,6795,63911,941$1,819$859
May-24HDHP MODERN PLAN$171,220$1,863,259$9,665$639,386$2,683,529$0$2,683,529$451,949$3,135,478$25,2742,5424,769$1,056$563
OAP TRADITIONAL PLAN$348,400$4,387,520$144,146$1,888,443$6,768,509($28,349)$6,740,161$0$6,740,161$49,1263,1277,233$2,155$932
May-2024 Total$519,620$6,250,778$153,811$2,527,829$9,452,038($28,349)$9,423,689$451,949$9,875,638$74,3995,66912,002$1,662$785
Jun-24HDHP MODERN PLAN$176,938$1,534,352$164,831$671,856$2,547,976$0$2,547,976$381,019$2,928,995$24,2762,5354,744$1,005$537
OAP COVERAGE NOW$0($2,150)$0$0($2,150)$0($2,150)$0($2,150)$000$0$0
OAP TRADITIONAL PLAN$353,660$4,479,137$50,634$1,820,444$6,703,876($627,488)$6,076,387$0$6,076,387$48,6033,1267,236$1,944$840
Jun-2024 Total$530,598$6,011,339$215,465$2,492,300$9,249,702($627,488)$8,622,214$381,019$9,003,233$72,8785,66111,980$1,523$720
Jul-24HDHP MODERN PLAN$185,416$1,501,833$78,431$625,531$2,391,211$0$2,391,211$358,178$2,749,389$24,4152,5454,750$940$503
OAP COVERAGE NOW$0$2,377$0$0$2,377$0$2,377$0$2,377$000$0$0
OAP TRADITIONAL PLAN$377,775$4,130,363$66,129$1,862,221$6,436,488($30,518)$6,405,970$0$6,405,970$48,0333,1167,215$2,056$888
Jul-2024 Total$563,191$5,634,574$144,560$2,487,752$8,830,076($30,518)$8,799,558$358,178$9,157,736$72,4485,66111,965$1,554$735
Aug-24HDHP MODERN PLAN$166,216$1,718,595$18,488$720,218$2,623,516($34,716)$2,588,800$357,211$2,946,011$69,8552,5764,789$1,005$541
OAP COVERAGE NOW$0($931)$0$0($931)$0($931)$0($931)$000$0$0
OAP TRADITIONAL PLAN$331,136$5,750,609$71,424$1,833,592$7,986,762($326,419)$7,660,343$0$7,660,343$96,6163,1147,205$2,460$1,063
Aug-2024 Total$497,352$7,468,273$89,912$2,553,810$10,609,346($361,134)$10,248,212$357,211$10,605,423$166,4715,69011,994$1,801$854
Sep-24HDHP MODERN PLAN$208,514$1,781,716$84,292$847,755$2,922,277($374)$2,921,903$295,230$3,217,132$81,4052,5844,796$1,131$609
OAP COVERAGE NOW$0($120,282)$16,091$0($104,191)$0($104,191)$0($104,191)$000$0$0
OAP TRADITIONAL PLAN$409,986$5,537,132$70,362$1,883,571$7,901,052($383,170)$7,517,881$0$7,517,881$97,8063,1017,169$2,424$1,049
Sep-2024 Total$618,500$7,198,566$170,745$2,731,326$10,719,137($383,545)$10,335,592$295,230$10,630,822$179,2105,68511,965$1,818$864
Oct-24HDHP MODERN PLAN$187,874$1,354,256($44,308)$638,600$2,136,422($7,145)$2,129,277$263,228$2,392,505$81,4362,5854,794$824$444
OAP TRADITIONAL PLAN$353,845$4,490,809$98,985$1,797,998$6,741,637($179,298)$6,562,339$0$6,562,339$97,6483,0967,153$2,120$917
Oct-2024 Total$541,719$5,845,065$54,677$2,436,598$8,878,059($186,443)$8,691,616$263,228$8,954,844$179,0845,68111,947$1,530$728
Nov-24HDHP MODERN PLAN$210,685$2,073,071$15,569$730,663$3,029,987($4,348)$3,025,639$308,604$3,334,243$81,6572,5794,796$1,173$631
OAP TRADITIONAL PLAN$407,700$4,253,657$55,147$1,972,315$6,688,820($267,197)$6,421,623$0$6,421,623$97,4273,0907,136$2,078$900
Nov-2024 Total$618,385$6,326,728$70,716$2,702,979$9,718,807($271,545)$9,447,262$308,604$9,755,866$179,0845,66911,932$1,666$792
Dec-24HDHP MODERN PLAN$196,523$1,437,945$453,302$713,511$2,801,280($9)$2,801,272$313,187$3,114,459$82,1622,5944,815$1,080$582
OAP COVERAGE NOW$0($419)$0$0($419)$0($419)$0($419)$000$0$0
OAP TRADITIONAL PLAN$425,215$3,674,167$68,700$1,601,699$5,769,782($309,231)$5,460,552$0$5,460,552$97,9633,1077,152$1,757$763
Dec-2024 Total$621,738$5,111,693$522,002$2,315,210$8,570,644($309,239)$8,261,404$313,187$8,574,591$180,1255,70111,967$1,449$690
BENEFIT OPTION TotalsHDHP MODERN PLAN$2,208,256$20,521,286$906,436$7,958,238$31,594,217($46,591)$31,547,625$4,769,820$36,317,445$571,62530,60857,235$1,031$551
OAP COVERAGE NOW$0($123,981)$16,091$0($107,890)$0($107,890)$0($107,890)$000$0$0
OAP TRADITIONAL PLAN$4,427,388$52,276,040$968,046$21,635,417$79,306,891($2,254,612)$77,052,278$0$77,052,278$831,74837,37686,457$2,062$891
Grand Total$6,635,644$72,673,345$1,890,574$29,593,655$110,793,218($2,301,204)$108,492,014$4,769,820$113,261,833$1,403,37467,984143,692$1,596$755

&R &8Page &P of &N Date: 1/8/2025&CADVICE Reporting System&L&G &7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law.

Enrollment Counts

HILLSBOROUGH COUNTY BOARD OF COUNTY COMM
ASO SUBSCRIBER ENROLLMENT BY TIER
January 2024 thru December 2024
YTD/MONTHBENEFIT OPTIONEMP ONLYEMP + SPOUSEEMP+ CHILD(REN)EMP + FAMILYTOTAL
Jan-24HDHP MODERN PLAN1,3643423144842,504
OAP TRADITIONAL PLAN1,1936043151,0163,128
Jan-2024 Total2,5579466291,5005,632
Feb-24HDHP MODERN PLAN1,3663433114852,505
OAP TRADITIONAL PLAN1,1976003191,0123,128
Feb-2024 Total2,5639436301,4975,633
Mar-24HDHP MODERN PLAN1,3673383124842,501
OAP TRADITIONAL PLAN1,1905993191,0113,119
Mar-2024 Total2,5579376311,4955,620
Apr-24HDHP MODERN PLAN1,3773363084802,501
OAP TRADITIONAL PLAN1,2015933221,0083,124
Apr-2024 Total2,5789296301,4885,625
May-24HDHP MODERN PLAN1,3923343194832,528
OAP TRADITIONAL PLAN1,2035933211,0103,127
May-2024 Total2,5959276401,4935,655
Jun-24HDHP MODERN PLAN1,3923313214772,521
OAP TRADITIONAL PLAN1,2035893211,0133,126
Jun-2024 Total2,5959206421,4905,647
Jul-24HDHP MODERN PLAN1,3993363234732,531
OAP TRADITIONAL PLAN1,2015853191,0113,116
Jul-2024 Total2,6009216421,4845,647
Aug-24HDHP MODERN PLAN1,4243363314702,561
OAP TRADITIONAL PLAN1,2075833171,0073,114
Aug-2024 Total2,6319196481,4775,675
Sep-24HDHP MODERN PLAN1,4313393304692,569
OAP TRADITIONAL PLAN1,2015803181,0023,101
Sep-2024 Total2,6329196481,4715,670
Oct-24HDHP MODERN PLAN1,4323383364652,571
OAP TRADITIONAL PLAN1,2035773189983,096
Oct-2024 Total2,6359156541,4635,667
Nov-24HDHP MODERN PLAN1,4343443324692,579
OAP TRADITIONAL PLAN1,2035763169953,090
Nov-2024 Total2,6379206481,4645,669
Dec-24HDHP MODERN PLAN1,4483403354712,594
OAP TRADITIONAL PLAN1,2165793209923,107
Dec-2024 Total2,6649196551,4635,701
BENEFIT OPTION TotalsHDHP MODERN PLAN16,8264,0573,8725,71030,465
OAP TRADITIONAL PLAN14,4187,0583,82512,07537,376
Grand Total31,24411,1157,69717,78567,841

&R &8Page &P of &N Date: 1/8/2025&CADVICE Reporting System&L&G &7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law.

Exp BenOpt R12-1

HILLSBOROUGH COUNTY BOARD OF COUNTY COMM
MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT
January 2024 thru December 2024
Rating Type : RETROSPECTIVE EXPERIENCE RATED
Reported Premium: ASO Fees
Reported Claims: All Claims, Debit, Clms Fwrd, Check, ATM
Paid claim dollars include amounts deducted from your account and paid to vendors for cost containment services.
YTD/MONTHBENEFIT OPTIONFIXED CHARGESIN NETWORKOUT OF NETWORKDRUGGROSS CLAIMSSTOP LOSSNET CLAIMSHSA FUND ACTIVITYTOTAL HSA & CLAIMSTOTAL ASO FEESTOTAL SUBSTOTAL MBRSTOTAL PEPMTOTAL PMPM
Jan-24HDHP MODERN PLAN$171,249$1,774,652$45,221$591,379$2,582,501$0$2,582,501$637,897$3,220,399$25,1212,5184,761$1,026$542
OAP COVERAGE NOW$0($686)$0$0($686)$0($686)$0($686)$000$0$0
OAP TRADITIONAL PLAN$343,150$3,622,265$30,205$1,849,034$5,844,654($103)$5,844,551$0$5,844,551$49,1243,1287,265$1,868$804
Jan-2024 Total$514,399$5,396,231$75,426$2,440,413$8,426,469($103)$8,426,366$637,897$9,064,264$74,2455,64612,026$1,492$701
Feb-24HDHP MODERN PLAN$170,209$1,497,681$17,498$392,335$2,077,723$0$2,077,723$506,379$2,584,102$26,1492,5194,758$825$437
OAP TRADITIONAL PLAN$343,850$3,744,825$32,715$1,191,919$5,313,309$0$5,313,309$0$5,313,309$50,6563,1287,244$1,699$733
Feb-2024 Total$514,059$5,242,506$50,213$1,584,254$7,391,032$0$7,391,032$506,379$7,897,411$76,8045,64712,002$1,309$616
Mar-24HDHP MODERN PLAN$176,774$1,956,584$53,598$728,446$2,915,403$0$2,915,403$450,697$3,366,100$24,7012,5164,743$1,159$615
OAP COVERAGE NOW$0($495)$0$0($495)$0($495)$0($495)$000$0$0
OAP TRADITIONAL PLAN$361,844$3,275,534$154,756$1,882,414$5,674,548$687$5,675,235$0$5,675,235$49,2453,1197,228$1,820$785
Mar-2024 Total$538,618$5,231,623$208,355$2,610,860$8,589,457$687$8,590,144$450,697$9,040,840$73,9465,63511,971$1,524$718
Apr-24HDHP MODERN PLAN$186,639$2,027,343$9,851$658,557$2,882,390$0$2,882,390$446,242$3,328,632$25,1762,5154,720$1,146$611
OAP COVERAGE NOW$0($1,396)$0$0($1,396)$0($1,396)$0($1,396)$000$0$0
OAP TRADITIONAL PLAN$370,824$4,930,021$124,843$2,051,767$7,477,454($103,527)$7,373,928$0$7,373,928$49,5033,1247,221$2,360$1,021
Apr-2024 Total$557,463$6,955,968$134,694$2,710,325$10,358,449($103,527)$10,254,923$446,242$10,701,165$74,6795,63911,941$1,819$859
May-24HDHP MODERN PLAN$171,220$1,863,259$9,665$639,386$2,683,529$0$2,683,529$451,949$3,135,478$25,2742,5424,769$1,056$563
OAP TRADITIONAL PLAN$348,400$4,387,520$144,146$1,888,443$6,768,509($28,349)$6,740,161$0$6,740,161$49,1263,1277,233$2,155$932
May-2024 Total$519,620$6,250,778$153,811$2,527,829$9,452,038($28,349)$9,423,689$451,949$9,875,638$74,3995,66912,002$1,662$785
Jun-24HDHP MODERN PLAN$176,938$1,534,352$164,831$671,856$2,547,976$0$2,547,976$381,019$2,928,995$24,2762,5354,744$1,005$537
OAP COVERAGE NOW$0($2,150)$0$0($2,150)$0($2,150)$0($2,150)$000$0$0
OAP TRADITIONAL PLAN$353,660$4,479,137$50,634$1,820,444$6,703,876($627,488)$6,076,387$0$6,076,387$48,6033,1267,236$1,944$840
Jun-2024 Total$530,598$6,011,339$215,465$2,492,300$9,249,702($627,488)$8,622,214$381,019$9,003,233$72,8785,66111,980$1,523$720
Jul-24HDHP MODERN PLAN$185,416$1,501,833$78,431$625,531$2,391,211$0$2,391,211$358,178$2,749,389$24,4152,5454,750$940$503
OAP COVERAGE NOW$0$2,377$0$0$2,377$0$2,377$0$2,377$000$0$0
OAP TRADITIONAL PLAN$377,775$4,130,363$66,129$1,862,221$6,436,488($30,518)$6,405,970$0$6,405,970$48,0333,1167,215$2,056$888
Jul-2024 Total$563,191$5,634,574$144,560$2,487,752$8,830,076($30,518)$8,799,558$358,178$9,157,736$72,4485,66111,965$1,554$735
Aug-24HDHP MODERN PLAN$166,216$1,718,595$18,488$720,218$2,623,516($34,716)$2,588,800$357,211$2,946,011$69,8552,5764,789$1,005$541
OAP COVERAGE NOW$0($931)$0$0($931)$0($931)$0($931)$000$0$0
OAP TRADITIONAL PLAN$331,136$5,750,609$71,424$1,833,592$7,986,762($326,419)$7,660,343$0$7,660,343$96,6163,1147,205$2,460$1,063
Aug-2024 Total$497,352$7,468,273$89,912$2,553,810$10,609,346($361,134)$10,248,212$357,211$10,605,423$166,4715,69011,994$1,801$854
Sep-24HDHP MODERN PLAN$208,514$1,781,716$84,292$847,755$2,922,277($374)$2,921,903$295,230$3,217,132$81,4052,5844,796$1,131$609
OAP COVERAGE NOW$0($120,282)$16,091$0($104,191)$0($104,191)$0($104,191)$000$0$0
OAP TRADITIONAL PLAN$409,986$5,537,132$70,362$1,883,571$7,901,052($383,170)$7,517,881$0$7,517,881$97,8063,1017,169$2,424$1,049
Sep-2024 Total$618,500$7,198,566$170,745$2,731,326$10,719,137($383,545)$10,335,592$295,230$10,630,822$179,2105,68511,965$1,818$864
Oct-24HDHP MODERN PLAN$187,874$1,354,256($44,308)$638,600$2,136,422($7,145)$2,129,277$263,228$2,392,505$81,4362,5854,794$824$444
OAP TRADITIONAL PLAN$353,845$4,490,809$98,985$1,797,998$6,741,637($179,298)$6,562,339$0$6,562,339$97,6483,0967,153$2,120$917
Oct-2024 Total$541,719$5,845,065$54,677$2,436,598$8,878,059($186,443)$8,691,616$263,228$8,954,844$179,0845,68111,947$1,530$728
Nov-24HDHP MODERN PLAN$210,685$2,073,071$15,569$730,663$3,029,987($4,348)$3,025,639$308,604$3,334,243$81,6572,5794,796$1,173$631
OAP TRADITIONAL PLAN$407,700$4,253,657$55,147$1,972,315$6,688,820($267,197)$6,421,623$0$6,421,623$97,4273,0907,136$2,078$900
Nov-2024 Total$618,385$6,326,728$70,716$2,702,979$9,718,807($271,545)$9,447,262$308,604$9,755,866$179,0845,66911,932$1,666$792
Dec-24HDHP MODERN PLAN$196,523$1,437,945$453,302$713,511$2,801,280($9)$2,801,272$313,187$3,114,459$82,1622,5944,815$1,080$582
OAP COVERAGE NOW$0($419)$0$0($419)$0($419)$0($419)$000$0$0
OAP TRADITIONAL PLAN$425,215$3,674,167$68,700$1,601,699$5,769,782($309,231)$5,460,552$0$5,460,552$97,9633,1077,152$1,757$763
Dec-2024 Total$621,738$5,111,693$522,002$2,315,210$8,570,644($309,239)$8,261,404$313,187$8,574,591$180,1255,70111,967$1,449$690
BENEFIT OPTION TotalsHDHP MODERN PLAN$2,208,256$20,521,286$906,436$7,958,238$31,594,217($46,591)$31,547,625$4,769,820$36,317,445$571,62530,60857,235$1,031$551
OAP COVERAGE NOW$0($123,981)$16,091$0($107,890)$0($107,890)$0($107,890)$000$0$0
OAP TRADITIONAL PLAN$4,427,388$52,276,040$968,046$21,635,417$79,306,891($2,254,612)$77,052,278$0$77,052,278$831,74837,37686,457$2,062$891
Grand Total$6,635,644$72,673,345$1,890,574$29,593,655$110,793,218($2,301,204)$108,492,014$4,769,820$113,261,833$1,403,37467,984143,692$1,596$755

&R &8Page &P of &N Date: 1/8/2025&CADVICE Reporting System&L&G &7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law.

Exp R12 Branch BenOpt-1

HILLSBOROUGH COUNTY BOARD OF COUNTY COMM
MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT
January 2024 thru December 2024
Rating Type : RETROSPECTIVE EXPERIENCE RATED
Reported Premium: ASO Fees
Reported Claims: All Claims, Debit, Clms Fwrd, Check, ATM
Paid claim dollars include amounts deducted from your account and paid to vendors for cost containment services.
YTD/MONTHBENEFIT OPTIONBRANCHFIXED CHARGESIN NETWORKOUT OF NETWORKDRUGGROSS CLAIMSSTOP LOSSNET CLAIMSHSA FUND ACTIVITYTOTAL HSA & CLAIMSTOTAL ASO FEESTOTAL SUBSTOTAL MBRSTOTAL PEPMTOTAL PMPM
Jan-24HDHP MODERN PLAN002-PROPERTY ACTIVE$534$0$0$0$534$0$534$0$534$000$0$0
002H-PROPERTY APPRAISERS ACTIVE$2,949$7,497$991$5,615$17,051$0$17,051$11,197$28,248$884991$348$187
003-BOCC ACTIVE$146,053$1,363,168$44,035$435,021$1,988,277$0$1,988,277$535,893$2,524,169$21,9602,0964,053$949$491
017H-EXPRESSWAY ACTIVE$1,418$14,889$0$3,685$19,992$0$19,992$12,993$32,984$271435$1,428$571
018H-SPORTS AUTHORITY ACTIVE$702$384$0$2,263$3,349$0$3,349$1,539$4,888$211118$304$186
020-COURT ACTIVE$674$1,672$0$5,950$8,296$0$8,296$2,029$10,325$164815$1,037$553
021H-CHILDREN 'S BOARD ACTIVE$882$1,000$0$20,912$22,795$0$22,795$1,566$24,361$291540$1,520$570
022-CLERK ACTIVE$15,077$136,231$0$74,600$225,907$0$225,907$63,004$288,911$2,786250420$904$538
202-PROPERTY RETIREE UNDER 65$182$794$0$829$1,805$0$1,805$366$2,171$1011$1,805$1,805
203-BOCC RETIREE UNDER 65$1,960$236,717$0$18,438$257,115$0$257,115$4,813$261,929$725163$5,041$4,081
222-CLERK RETIREE UNDER 65$490$3,129$0$23,137$26,757$0$26,757$4,498$31,254$271315$2,058$1,784
309-BOCC RETIREE OVER 65 SINGLE$183$755$14$511$1,462$0$1,462$0$1,462($95)66$244$244
385-CLERK RETIREE OVER 65 SINGLE$117$8,329$182$418$9,046$0$9,046$0$9,046($32)22$4,523$4,523
803-BOCC COBRA$29$89$0$0$117$0$117$0$117$6322$59$59
BENEFIT OPTION Total$171,249$1,774,652$45,221$591,379$2,582,501$0$2,582,501$637,897$3,220,399$25,1212,5184,761$1,026$542
OAP COVERAGE NOW003-BOCC ACTIVE$0($686)$0$0($686)$0($686)$0($686)$000$0$0
BENEFIT OPTION Total$0($686)$0$0($686)$0($686)$0($686)$000$0$0
OAP TRADITIONAL PLAN002-PROPERTY ACTIVE$76$0$0$0$76$0$76$0$76$000$0$0
002H-PROPERTY APPRAISERS ACTIVE$5,810$13,061$67$37,252$56,190$0$56,190$0$56,190$5056129$1,003$436
003-BOCC ACTIVE$285,815$2,949,176$21,400$1,506,573$4,762,964($96)$4,762,868$0$4,762,868$43,1852,4545,988$1,941$795
016H-PORT AUTHORITY ACTIVE$11$0$0$0$11$0$11$0$11$000$0$0
017H-EXPRESSWAY ACTIVE$828$10,106$147$1,860$12,941$0$12,941$0$12,941$16822$1,618$588
018H-SPORTS AUTHORITY ACTIVE$4,802$16,324$756$6,472$28,354$0$28,354$0$28,354$5845107$630$265
020-COURT ACTIVE$4,255$9,539$305$12,369$26,468$0$26,468$0$26,468$6273569$756$384
021H-CHILDREN 'S BOARD ACTIVE$2,583$13,449$161$6,049$22,241$0$22,241$0$22,241$742346$967$483
022-CLERK ACTIVE$25,545$287,289$3,210$131,159$447,203$0$447,203$0$447,203$5,078259563$1,727$794
202-PROPERTY RETIREE UNDER 65$25($27)$0$0($2)$0($2)$0($2)$3322($1)($1)
203-BOCC RETIREE UNDER 65$9,965$189,214$1,146$68,495$268,819($7)$268,812$0$268,812$286155223$1,734$1,205
218-SPORTS RETIREE UNDER 65$217$595$0$1,009$1,821$0$1,821$0$1,821($24)34$607$455
220-COURT RETIREE UNDER 65$43$7,939$0$55$8,037$0$8,037$0$8,037$3322$4,019$4,019
221-C BOARD RETIREE UNDER 65$43$0$0$619$662$0$662$0$662$211$662$662
222-CLERK RETIREE UNDER 65$384$1,854$140$918$3,295$0$3,295$0$3,295($18)66$549$549
305-PROPERTY RETIREE OVER 65 SINGLE$193$0$0$0$193$0$193$0$193$022$96$96
306-PROPERTY RETIREE OVER 65 SPOUSE (ONE MEDICARE)$313$75$0$586$974$0$974$0$974$200$0$0
309-BOCC RETIREE OVER 65 SINGLE($186)$12,505$471$38,833$51,622$0$51,622$0$51,622($279)4545$1,147$1,147
310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE)$227$80,480$0$3,880$84,586$0$84,586$0$84,586($18)816$10,573$5,287
311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE)$992$23,987$2,383$21,439$48,800$0$48,800$0$48,800$231223$4,067$2,122
312-BOCC RETIREE OVER 65 FAMILY$413$1,171$0$0$1,584$0$1,584$0$1,584$426$792$264
367-EXPRESSWAY RETIREE OVER 65 SPOUSE (BOTH MEDICARE)$43$1,610$0$0$1,653$0$1,653$0$1,653($30)00$0$0
370-SPORTS RETIREE OVER 65 SPOUSE (ONE MEDICARE)$48$15$0$8$72$0$72$0$72$211$72$72
377-COURT RETIREE OVER 65 SINGLE$1$0$0$0$1$0$1$0$1$000$0$0
384-C BOARD RETIREE OVER 65 FAMILY$104$3,870$0$7,911$11,884$0$11,884$0$11,884$212$11,884$5,942
385-CLERK RETIREE OVER 65 SINGLE$235($71)$20$1,576$1,759$0$1,759$0$1,759($79)55$352$352
802-PROPERTY COBRA$43$0$0$0$43$0$43$0$43$3211$43$43
803-BOCC COBRA$281$15$0$1,121$1,417$0$1,417$0$1,417$3211$1,417$1,417
822-CLERK COBRA$43$91$0$851$985$0$985$0$985$3211$985$985
BENEFIT OPTION Total$343,150$3,622,265$30,205$1,849,034$5,844,654($103)$5,844,551$0$5,844,551$49,1243,1287,265$1,868$804
Jan-2024 Total$514,399$5,396,231$75,426$2,440,413$8,426,469($103)$8,426,366$637,897$9,064,264$74,2455,64612,026$1,492$701
Feb-24HDHP MODERN PLAN002H-PROPERTY APPRAISERS ACTIVE$3,219$13,006$0$3,049$19,274$0$19,274$14,295$33,569$564887$402$222
003-BOCC ACTIVE$144,768$1,267,498$17,498$303,920$1,733,684$0$1,733,684$411,222$2,144,906$23,0212,1004,058$826$427
016H-PORT AUTHORITY ACTIVE$55$0$0$0$55$0$55$0$55$000$0$0
017H-EXPRESSWAY ACTIVE$1,338$5,852$0$2,297$9,487$0$9,487$6,149$15,636$271434$678$279
018H-SPORTS AUTHORITY ACTIVE$637$193$0$483$1,312$0$1,312$5,051$6,364$211118$119$73
019H-ARTS ACTIVE$0($380)$0$0($380)$0($380)$0($380)$000$0$0
020-COURT ACTIVE$543$12,843$0$7,679$21,064$0$21,064$3,526$24,590$164815$2,633$1,404
021H-CHILDREN 'S BOARD ACTIVE$1,380$13,195$0$4,379$18,955$0$18,955$3,056$22,011$291540$1,264$474
022-CLERK ACTIVE$15,100$77,706$0$49,151$141,957$0$141,957$49,622$191,579$2,784248417$572$340
202-PROPERTY RETIREE UNDER 65$183$892$0$1,127$2,202$0$2,202$248$2,450$1011$2,202$2,202
203-BOCC RETIREE UNDER 65$2,185$98,280$0$11,596$112,061$0$112,061$10,243$122,305$725163$2,197$1,779
222-CLERK RETIREE UNDER 65$574$3,019$0$7,036$10,629$0$10,629$2,966$13,595$271315$818$709
309-BOCC RETIREE OVER 65 SINGLE$137$164$0$1,493$1,794$0$1,794$0$1,794($95)66$299$299
385-CLERK RETIREE OVER 65 SINGLE$62$5,413$0$125$5,599$0$5,599$0$5,599($32)22$2,800$2,800
803-BOCC COBRA$28$0$0$0$28$0$28$0$28$6322$14$14
BENEFIT OPTION Total$170,209$1,497,681$17,498$392,335$2,077,723$0$2,077,723$506,379$2,584,102$26,1492,5194,758$825$437
OAP TRADITIONAL PLAN002H-PROPERTY APPRAISERS ACTIVE$6,872$24,055$67$29,943$60,936$0$60,936$0$60,936$2056128$1,088$476
003-BOCC ACTIVE$283,430$2,924,555$24,878$958,969$4,191,833$0$4,191,833$0$4,191,833$44,6542,4555,974$1,707$702
016H-PORT AUTHORITY ACTIVE($9)$0$0$0($9)$0($9)$0($9)$000$0$0
017H-EXPRESSWAY ACTIVE$959$1,542$0$117$2,618$0$2,618$0$2,618$16822$327$119
018H-SPORTS AUTHORITY ACTIVE$4,986$39,237$0$7,540$51,762$0$51,762$0$51,762$2744105$1,176$493
020-COURT ACTIVE$3,366$21,596$0$14,585$39,548$0$39,548$0$39,548$6583671$1,099$557
021H-CHILDREN 'S BOARD ACTIVE$2,203$13,365$328$7,352$23,248$0$23,248$0$23,248$1382548$930$484
022-CLERK ACTIVE$26,389$289,163$704$66,462$382,718$0$382,718$0$382,718$5,139258558$1,483$686
202-PROPERTY RETIREE UNDER 65$6($7)$0$0($1)$0($1)$0($1)$3322($0)($0)
203-BOCC RETIREE UNDER 65$10,581$374,120$1,373$49,168$435,242$0$435,242$0$435,242$223155222$2,808$1,961
218-SPORTS RETIREE UNDER 65$217$0$0$333$550$0$550$0$550($55)23$275$183
220-COURT RETIREE UNDER 65$87$4,613$0$99$4,799$0$4,799$0$4,799$3322$2,399$2,399
221-C BOARD RETIREE UNDER 65$43$43$0$1,179$1,265$0$1,265$0$1,265$211$1,265$1,265
222-CLERK RETIREE UNDER 65$242$1,666$0$0$1,909$0$1,909$0$1,909($18)66$318$318
305-PROPERTY RETIREE OVER 65 SINGLE$0$0$0$0$0$0$0$0$0$022$0$0
306-PROPERTY RETIREE OVER 65 SPOUSE (ONE MEDICARE)$53$69$2,770$0$2,892$0$2,892$0$2,892$200$0$0
309-BOCC RETIREE OVER 65 SINGLE$2,079$16,449$1,309$20,753$40,591$0$40,591$0$40,591($184)4545$902$902
310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE)$506$1,815$18$4,473$6,813$0$6,813$0$6,813($18)816$852$426
311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE)$993$10,543$977$14,836$27,349$0$27,349$0$27,349($8)1122$2,486$1,243
312-BOCC RETIREE OVER 65 FAMILY$253$52$0$42$346$0$346$0$346$426$173$58
367-EXPRESSWAY RETIREE OVER 65 SPOUSE (BOTH MEDICARE)$0$5,901$0$0$5,901$0$5,901$0$5,901($30)00$0$0
370-SPORTS RETIREE OVER 65 SPOUSE (ONE MEDICARE)$48$902$0$3,435$4,386$0$4,386$0$4,386$211$4,386$4,386
377-COURT RETIREE OVER 65 SINGLE($3)$0$0$0($3)$0($3)$0($3)$000$0$0
384-C BOARD RETIREE OVER 65 FAMILY$104$11,623$0$158$11,884$0$11,884$0$11,884$212$11,884$5,942
385-CLERK RETIREE OVER 65 SINGLE$343$722$200$246$1,509$0$1,509$0$1,509($79)55$302$302
802-PROPERTY COBRA$43$0$0$0$43$0$43$0$43$3211$43$43
803-BOCC COBRA$14$0$0$1,100$1,115$0$1,115$0$1,115$3211$1,115$1,115
822-CLERK COBRA$43$2,800$93$11,128$14,065$0$14,065$0$14,065$3211$14,065$14,065
BENEFIT OPTION Total$343,850$3,744,825$32,715$1,191,919$5,313,309$0$5,313,309$0$5,313,309$50,6563,1287,244$1,699$733
Feb-2024 Total$514,059$5,242,506$50,213$1,584,254$7,391,032$0$7,391,032$506,379$7,897,411$76,8045,64712,002$1,309$616
Mar-24HDHP MODERN PLAN002H-PROPERTY APPRAISERS ACTIVE$3,043$8,744$0$7,702$19,489$0$19,489$6,113$25,602$864887$406$224
003-BOCC ACTIVE$151,982$1,488,621$53,490$534,187$2,228,279$0$2,228,279$364,526$2,592,805$21,5502,1044,052$1,059$550
016H-PORT AUTHORITY ACTIVE$7$0$0$0$7$0$7$0$7$000$0$0
017H-EXPRESSWAY ACTIVE$1,311$1,578$0$357$3,246$0$3,246$7,673$10,919$271434$232$95
018H-SPORTS AUTHORITY ACTIVE$541$1,020$0$4,115$5,676$0$5,676$2,002$7,678$211118$516$315
020-COURT ACTIVE$380$8,620$0$6,527$15,527$0$15,527$936$16,462$164815$1,941$1,035
021H-CHILDREN 'S BOARD ACTIVE$1,425$5,830$0$17,072$24,328$0$24,328$7,262$31,589$291540$1,622$608
022-CLERK ACTIVE$15,182$252,454$109$105,798$373,542$0$373,542$46,822$420,364$2,622240406$1,556$920
202-PROPERTY RETIREE UNDER 65$150$3,159$0$1,753$5,061$0$5,061$752$5,813$1011$5,061$5,061
203-BOCC RETIREE UNDER 65$2,337$159,797$0$20,111$182,244$0$182,244$9,921$192,165$1015163$3,573$2,893
218-SPORTS RETIREE UNDER 65($1)$0$0$0($1)$0($1)$0($1)$000$0$0
222-CLERK RETIREE UNDER 65$439$14,028$0$25,021$39,488$0$39,488$4,691$44,179$271315$3,038$2,633
309-BOCC RETIREE OVER 65 SINGLE($8)$10,968$0$4,184$15,144$0$15,144$0$15,144$066$2,524$2,524
310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE)($11)$0$0$0($11)$0($11)$0($11)$000$0$0
385-CLERK RETIREE OVER 65 SINGLE$45$1,764$0$1,530$3,339$0$3,339$0$3,339($32)22$1,670$1,670
803-BOCC COBRA($47)$0$0$91$44$0$44$0$44$9534$15$11
BENEFIT OPTION Total$176,774$1,956,584$53,598$728,446$2,915,403$0$2,915,403$450,697$3,366,100$24,7012,5164,743$1,159$615
OAP COVERAGE NOW003-BOCC ACTIVE$0($495)$0$0($495)$0($495)$0($495)$000$0$0
BENEFIT OPTION Total$0($495)$0$0($495)$0($495)$0($495)$000$0$0
OAP TRADITIONAL PLAN002H-PROPERTY APPRAISERS ACTIVE$6,265$19,460$0$48,283$74,008$0$74,008$0$74,008$5056128$1,322$578
003-BOCC ACTIVE$301,661$2,676,237$137,139$1,464,612$4,579,650$687$4,580,337$0$4,580,337$43,1272,4475,961$1,872$768
017H-EXPRESSWAY ACTIVE$920$10,242$147$2,276$13,585$0$13,585$0$13,585$16822$1,698$617
018H-SPORTS AUTHORITY ACTIVE$4,063$60,448$2,841$5,176$72,527$0$72,527$0$72,527$8845107$1,612$678
020-COURT ACTIVE$3,023$20,136$305$26,349$49,812$0$49,812$0$49,812$5423671$1,384$702
021H-CHILDREN 'S BOARD ACTIVE$2,375$7,411$420$5,686$15,892$0$15,892$0$15,892$492548$636$331
022-CLERK ACTIVE$27,606$172,046$3,431$144,310$347,393$0$347,393$0$347,393$4,869256555$1,357$626
202-PROPERTY RETIREE UNDER 65($373)($252)$0$47($578)$0($578)$0($578)$3322($289)($289)
203-BOCC RETIREE UNDER 65$13,615$200,249$6,358$105,794$326,015$0$326,015$0$326,015$192155220$2,103$1,482
218-SPORTS RETIREE UNDER 65$66$413$0$968$1,447$0$1,447$0$1,447$423$723$482
220-COURT RETIREE UNDER 65$317$11,265$0$60$11,643$0$11,643$0$11,643$422$5,821$5,821
221-C BOARD RETIREE UNDER 65$37$0$0$59$95$0$95$0$95$211$95$95
222-CLERK RETIREE UNDER 65$181$920$0$2,171$3,271$0$3,271$0$3,271$1266$545$545
305-PROPERTY RETIREE OVER 65 SINGLE($1)$0$0$0($1)$0($1)$0($1)$022($0)($0)
306-PROPERTY RETIREE OVER 65 SPOUSE (ONE MEDICARE)$46$0$0$0$46$0$46$0$46$200$0$0
308-PROPERTY RETIREE OVER 65 FAMILY($1)$0$0$0($1)$0($1)$0($1)$000$0$0
309-BOCC RETIREE OVER 65 SINGLE$63$41$1,324$26,885$28,312$0$28,312$0$28,312$2004545$629$629
310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE)$465$83,899$0$4,985$89,349$0$89,349$0$89,349$12816$11,169$5,584
311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE)$794$7,869$1,450$25,603$35,715$0$35,715$0$35,715$211122$3,247$1,623
312-BOCC RETIREE OVER 65 FAMILY$295$84$0$1,537$1,916$0$1,916$0$1,916$426$958$319
367-EXPRESSWAY RETIREE OVER 65 SPOUSE (BOTH MEDICARE)($7)$0$0$0($7)$0($7)$0($7)$000$0$0
370-SPORTS RETIREE OVER 65 SPOUSE (ONE MEDICARE)$58$699$0$106$864$0$864$0$864$211$864$864
377-COURT RETIREE OVER 65 SINGLE($121)$0$0$0($121)$0($121)$0($121)$000$0$0
384-C BOARD RETIREE OVER 65 FAMILY$93$172$999$10,825$12,089$0$12,089$0$12,089$212$12,089$6,045
385-CLERK RETIREE OVER 65 SINGLE$289$2,000$130$1,077$3,496$0$3,496$0$3,496($79)55$699$699
387-CLERK RETIREE OVER 65 PLUS SPOUSE (BOTH MEDICARE)($1)$0$0$0($1)$0($1)$0($1)$000$0$0
802-PROPERTY COBRA$40$0$0$50$90$0$90$0$90$3211$90$90
803-BOCC COBRA$42$722$0$1,306$2,070$0$2,070$0$2,070$3211$2,070$2,070
822-CLERK COBRA$36$1,473$213$4,250$5,972$0$5,972$0$5,972$3211$5,972$5,972
826-EXPRESSWAY OVER AGE DEP($2)$0$0$0($2)$0($2)$0($2)$000$0$0
BENEFIT OPTION Total$361,844$3,275,534$154,756$1,882,414$5,674,548$687$5,675,235$0$5,675,235$49,2453,1197,228$1,820$785
Mar-2024 Total$538,618$5,231,623$208,355$2,610,860$8,589,457$687$8,590,144$450,697$9,040,840$73,9465,63511,971$1,524$718
Apr-24HDHP MODERN PLAN002-PROPERTY ACTIVE($83)$0$0$0($83)$0($83)$0($83)$000$0$0
002H-PROPERTY APPRAISERS ACTIVE$3,325$6,797$0$6,586$16,708$0$16,708$9,106$25,814$544786$355$194
003-BOCC ACTIVE$157,551$1,757,712$7,526$530,297$2,453,086$0$2,453,086$374,329$2,827,416$21,8812,1064,033$1,165$608
017H-EXPRESSWAY ACTIVE$1,333$1,111$0$1,373$3,817$0$3,817$6,048$9,864$271434$273$112
018H-SPORTS AUTHORITY ACTIVE$640$819$0$5,780$7,239$0$7,239$2,496$9,735$211118$658$402
020-COURT ACTIVE$540$64,436$0$10,638$75,613$0$75,613$2,146$77,759$164815$9,452$5,041
021H-CHILDREN 'S BOARD ACTIVE$1,399$6,348$0$4,084$11,831$0$11,831$4,934$16,765$291540$789$296
022-CLERK ACTIVE$16,752$148,709$2,357$57,021$224,839$0$224,839$36,045$260,884$2,800240406$937$554
202-PROPERTY RETIREE UNDER 65$189$1,153$0$955$2,297$0$2,297$606$2,902$1011$2,297$2,297
203-BOCC RETIREE UNDER 65$3,918$12,771$0$19,275$35,963$0$35,963$8,229$44,192$995062$719$580
222-CLERK RETIREE UNDER 65$601$21,188$0$17,633$39,422$0$39,422$2,304$41,726($4)1315$3,032$2,628
309-BOCC RETIREE OVER 65 SINGLE$165$1,426($32)$4,732$6,290$0$6,290$0$6,290$066$1,048$1,048
385-CLERK RETIREE OVER 65 SINGLE($32)$3,489$0$171$3,628$0$3,628$0$3,628$3222$1,814$1,814
803-BOCC COBRA$344$1,385$0$12$1,741$0$1,741$0$1,741$6322$871$871
BENEFIT OPTION Total$186,639$2,027,343$9,851$658,557$2,882,390$0$2,882,390$446,242$3,328,632$25,1762,5154,720$1,146$611
OAP COVERAGE NOW003-BOCC ACTIVE$0($856)$0$0($856)$0($856)$0($856)$000$0$0
203-BOCC RETIREE UNDER 65$0($539)$0$0($539)$0($539)$0($539)$000$0$0
BENEFIT OPTION Total$0($1,396)$0$0($1,396)$0($1,396)$0($1,396)$000$0$0
OAP TRADITIONAL PLAN002-PROPERTY ACTIVE($228)$0$0$0($228)$0($228)$0($228)$000$0$0
002H-PROPERTY APPRAISERS ACTIVE$6,033$87,636$0$27,189$120,858$0$120,858$0$120,858$1754125$2,238$967
003-BOCC ACTIVE$306,827$3,783,857$120,593$1,690,743$5,902,019($103,527)$5,798,493$0$5,798,493$43,4482,4565,959$2,361$973
017H-EXPRESSWAY ACTIVE$961$2,598$0$2,187$5,746$0$5,746$0$5,746$16822$718$261
018H-SPORTS AUTHORITY ACTIVE$5,004$116,580$0$16,244$137,829$0$137,829$0$137,829$8845107$3,063$1,288
020-COURT ACTIVE$3,424$66,023$0$19,876$89,323$0$89,323$0$89,323$5443772$2,414$1,241
021H-CHILDREN 'S BOARD ACTIVE$2,474$17,167$731$10,074$30,447$0$30,447$0$30,447$472447$1,269$648
022-CLERK ACTIVE$27,880$332,314($1,199)$130,897$489,892$0$489,892$0$489,892$4,841256555$1,914$883
202-PROPERTY RETIREE UNDER 65$211$0$0$0$211$0$211$0$211$422$106$106
203-BOCC RETIREE UNDER 65$13,864$401,930$2,431$53,884$472,109$0$472,109$0$472,109$190153218$3,086$2,166
218-SPORTS RETIREE UNDER 65$142$1,640$0$215$1,997$0$1,997$0$1,997$423$999$666
220-COURT RETIREE UNDER 65$87$34,213$0$250$34,549$0$34,549$0$34,549$422$17,274$17,274
221-C BOARD RETIREE UNDER 65$43$0$0$3,274$3,318$0$3,318$0$3,318$211$3,318$3,318
222-CLERK RETIREE UNDER 65$140$981$0$220$1,341$0$1,341$0$1,341$1266$224$224
305-PROPERTY RETIREE OVER 65 SINGLE($228)$0$0$0($228)$0($228)$0($228)$022($114)($114)
306-PROPERTY RETIREE OVER 65 SPOUSE (ONE MEDICARE)($61)$0$0$0($61)$0($61)$0($61)$200$0$0
309-BOCC RETIREE OVER 65 SINGLE$1,801$2,713$593$38,642$43,749$0$43,749$0$43,749$1984444$994$994
310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE)$869$1,339$34$5,057$7,298$0$7,298$0$7,298$12816$912$456
311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE)$950$1,710$1,107$20,764$24,531$0$24,531$0$24,531$211122$2,230$1,115
312-BOCC RETIREE OVER 65 FAMILY$294$76,255$0$0$76,549$0$76,549$0$76,549$426$38,275$12,758
370-SPORTS RETIREE OVER 65 SPOUSE (ONE MEDICARE)$48$1,387$0$1$1,436$0$1,436$0$1,436$211$1,436$1,436
384-C BOARD RETIREE OVER 65 FAMILY$104$482$544$7,848$8,978$0$8,978$0$8,978$212$8,978$4,489
385-CLERK RETIREE OVER 65 SINGLE$347$570$9$617$1,542$0$1,542$0$1,542($79)55$308$308
802-PROPERTY COBRA$43$375$0$0$418$0$418$0$418$3211$418$418
803-BOCC COBRA($248)$136$0$243$131$0$131$0$131$6322$65$65
822-CLERK COBRA$43$116$0$23,543$23,703$0$23,703$0$23,703$3211$23,703$23,703
BENEFIT OPTION Total$370,824$4,930,021$124,843$2,051,767$7,477,454($103,527)$7,373,928$0$7,373,928$49,5033,1247,221$2,360$1,021
Apr-2024 Total$557,463$6,955,968$134,694$2,710,325$10,358,449($103,527)$10,254,923$446,242$10,701,165$74,6795,63911,941$1,819$859
May-24HDHP MODERN PLAN002H-PROPERTY APPRAISERS ACTIVE$3,072$18,952$0$10,613$32,637$0$32,637$9,902$42,539$844786$694$380
003-BOCC ACTIVE$145,815$1,523,909$4,906$493,851$2,168,481$0$2,168,481$381,452$2,549,933$21,9112,1314,071$1,018$533
017H-EXPRESSWAY ACTIVE$1,328$11,666$0$1,764$14,758$0$14,758$5,907$20,665$271435$1,054$422
018H-SPORTS AUTHORITY ACTIVE$640$33,763$0$3,695$38,098$0$38,098$3,007$41,104$211119$3,463$2,005
020-COURT ACTIVE$540$41,247$0$2,736$44,523$0$44,523$509$45,032$164815$5,565$2,968
021H-CHILDREN 'S BOARD ACTIVE$1,380$4,178$0$8,794$14,351$0$14,351$3,877$18,228$311646$897$312
022-CLERK ACTIVE$14,910$137,373$4,738$84,386$241,407$0$241,407$31,418$272,825$2,869242410$998$589
202-PROPERTY RETIREE UNDER 65$189$30$0$1,112$1,330$0$1,330$31$1,361$1011$1,330$1,330
203-BOCC RETIREE UNDER 65$2,382$57,312$21$7,740$67,455$0$67,455$10,712$78,167$984961$1,377$1,106
222-CLERK RETIREE UNDER 65$607$28,814$0$19,066$48,486$0$48,486$5,134$53,620($4)1315$3,730$3,232
309-BOCC RETIREE OVER 65 SINGLE$165$2,022$0$5,522$7,709$0$7,709$0$7,709$066$1,285$1,285
385-CLERK RETIREE OVER 65 SINGLE$38$3,688$0$36$3,762$0$3,762$0$3,762$022$1,881$1,881
803-BOCC COBRA$156$304$0$72$532$0$532$0$532$6322$266$266
BENEFIT OPTION Total$171,220$1,863,259$9,665$639,386$2,683,529$0$2,683,529$451,949$3,135,478$25,2742,5424,769$1,056$563
OAP TRADITIONAL PLAN002H-PROPERTY APPRAISERS ACTIVE$6,002$24,213$147$25,318$55,680$0$55,680$0$55,680$7453124$1,051$449
003-BOCC ACTIVE$285,439$3,607,056$120,558$1,521,168$5,534,220($28,349)$5,505,872$0$5,505,872$43,0102,4625,973$2,236$922
017H-EXPRESSWAY ACTIVE$966$5,499$0$1,402$7,867$0$7,867$0$7,867$16822$983$358
018H-SPORTS AUTHORITY ACTIVE$7,081$60,107$0$4,085$71,273$0$71,273$0$71,273$5242100$1,697$713
020-COURT ACTIVE$3,436$17,373$305$29,055$50,169$0$50,169$0$50,169$5443772$1,356$697
021H-CHILDREN 'S BOARD ACTIVE$2,259$17,506$894$3,107$23,766$0$23,766$0$23,766$472447$990$506
022-CLERK ACTIVE$26,308$294,750$5,410$147,265$473,734$0$473,734$0$473,734$4,946260566$1,822$837
202-PROPERTY RETIREE UNDER 65$97$0$0$0$97$0$97$0$97$422$48$48
203-BOCC RETIREE UNDER 65$10,628$201,192$947$77,232$289,999$0$289,999$0$289,999$217153217$1,895$1,336
218-SPORTS RETIREE UNDER 65$142$76$0$252$471$0$471$0$471$423$235$157
220-COURT RETIREE UNDER 65$87$32,594$0$23$32,705$0$32,705$0$32,705$422$16,352$16,352
221-C BOARD RETIREE UNDER 65$43$242$0$0$286$0$286$0$286$211$286$286
222-CLERK RETIREE UNDER 65$255$5,767$0$2,081$8,102$0$8,102$0$8,102$1266$1,350$1,350
305-PROPERTY RETIREE OVER 65 SINGLE$0$0$0$0$0$0$0$0$0$022$0$0
306-PROPERTY RETIREE OVER 65 SPOUSE (ONE MEDICARE)$53$0$0$0$53$0$53$0$53$200$0$0
309-BOCC RETIREE OVER 65 SINGLE$3,126$8,176$6,049$26,734$44,085$0$44,085$0$44,085$1064242$1,050$1,050
310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE)$523$3,792$0$5,499$9,813$0$9,813$0$9,813$12714$1,402$701
311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE)$950$93,951$8,249$15,325$118,475$0$118,475$0$118,475$211122$10,770$5,385
312-BOCC RETIREE OVER 65 FAMILY$294($70)$0$1,534$1,758$0$1,758$0$1,758$426$879$293
367-EXPRESSWAY RETIREE OVER 65 SPOUSE (BOTH MEDICARE)$0$2,877$0$0$2,877$0$2,877$0$2,877$000$0$0
370-SPORTS RETIREE OVER 65 SPOUSE (ONE MEDICARE)$163$260$0$1,694$2,116$0$2,116$0$2,116$211$2,116$2,116
384-C BOARD RETIREE OVER 65 FAMILY$104$53$1,543$7,910$9,609$0$9,609$0$9,609$212$9,609$4,804
385-CLERK RETIREE OVER 65 SINGLE$347$2,015$45$1,291$3,698$0$3,698$0$3,698($79)55$740$740
802-PROPERTY COBRA$43$257$0$0$300$0$300$0$300$3211$300$300
803-BOCC COBRA$14$0$0$0$14$0$14$0$14$6322$7$7
822-CLERK COBRA$43$9,833$0$17,469$27,345$0$27,345$0$27,345$3211$27,345$27,345
BENEFIT OPTION Total$348,400$4,387,520$144,146$1,888,443$6,768,509($28,349)$6,740,161$0$6,740,161$49,1263,1277,233$2,155$932
May-2024 Total$519,620$6,250,778$153,811$2,527,829$9,452,038($28,349)$9,423,689$451,949$9,875,638$74,3995,66912,002$1,662$785
Jun-24HDHP MODERN PLAN002H-PROPERTY APPRAISERS ACTIVE$3,089$11,959$0$6,574$21,622$0$21,622$15,111$36,733$844786$460$251
003-BOCC ACTIVE$150,401$1,268,460$159,696$515,450$2,094,007$0$2,094,007$321,223$2,415,231$21,0672,1264,055$985$516
017H-EXPRESSWAY ACTIVE$1,562$13,988$0$1,124$16,674$0$16,674$4,675$21,348$271435$1,191$476
018H-SPORTS AUTHORITY ACTIVE$674$2,068$0$3,607$6,348$0$6,348$3,887$10,235$211119$577$334
020-COURT ACTIVE$540$14,892$0$9,654$25,086$0$25,086$1,128$26,213$164815$3,136$1,672
021H-CHILDREN 'S BOARD ACTIVE$1,638$5,466$0$5,028$12,132$0$12,132$1,499$13,631$331745$714$270
022-CLERK ACTIVE$15,488$149,274$5,242$89,008$259,012$0$259,012$26,703$285,714$2,743239401$1,084$646
202-PROPERTY RETIREE UNDER 65$189$303$0$549$1,040$0$1,040$30$1,070$1011$1,040$1,040
203-BOCC RETIREE UNDER 65$2,445$32,095$0$15,956$50,497$0$50,497$5,576$56,073$984961$1,031$828
222-CLERK RETIREE UNDER 65$487$26,787$0$18,512$45,786$0$45,786$1,187$46,973($34)1316$3,522$2,862
309-BOCC RETIREE OVER 65 SINGLE$165$3,938$0$5,806$9,909$0$9,909$0$9,909$066$1,652$1,652
385-CLERK RETIREE OVER 65 SINGLE$190$5,123($108)$588$5,794$0$5,794$0$5,794$022$2,897$2,897
803-BOCC COBRA$70$0$0$0$70$0$70$0$70$6322$35$35
BENEFIT OPTION Total$176,938$1,534,352$164,831$671,856$2,547,976$0$2,547,976$381,019$2,928,995$24,2762,5354,744$1,005$537
OAP COVERAGE NOW003-BOCC ACTIVE$0($2,150)$0$0($2,150)$0($2,150)$0($2,150)$000$0$0
BENEFIT OPTION Total$0($2,150)$0$0($2,150)$0($2,150)$0($2,150)$000$0$0
OAP TRADITIONAL PLAN002H-PROPERTY APPRAISERS ACTIVE$6,031$41,876$397$25,984$74,288$0$74,288$0$74,288$7453124$1,402$599
003-BOCC ACTIVE$290,776$3,182,367$32,385$1,485,671$4,991,199($627,488)$4,363,711$0$4,363,711$42,5162,4625,978$1,772$730
017H-EXPRESSWAY ACTIVE$990$3,202$0$3,314$7,507$0$7,507$0$7,507$16822$938$341
018H-SPORTS AUTHORITY ACTIVE$4,733$259,352$156$7,643$271,883$0$271,883$0$271,883$824299$6,473$2,746
020-COURT ACTIVE$3,463$108,651$0$19,864$131,979$0$131,979$0$131,979$5183873$3,473$1,808
021H-CHILDREN 'S BOARD ACTIVE$2,320$42,890$966$7,323$53,500$0$53,500$0$53,500$472447$2,229$1,138
022-CLERK ACTIVE$27,358$359,273$10,060$122,423$519,114$0$519,114$0$519,114$4,855259567$2,004$916
202-PROPERTY RETIREE UNDER 65$97($22)$0$0$75$0$75$0$75$422$38$38
203-BOCC RETIREE UNDER 65$13,201$306,256$879$72,497$392,833$0$392,833$0$392,833$150150211$2,619$1,862
218-SPORTS RETIREE UNDER 65$142$503$0$1,011$1,656$0$1,656$0$1,656$423$828$552
220-COURT RETIREE UNDER 65$94$57,339$0$1,666$59,099$0$59,099$0$59,099$422$29,549$29,549
221-C BOARD RETIREE UNDER 65$43$17$0$2,046$2,107$0$2,107$0$2,107$211$2,107$2,107
222-CLERK RETIREE UNDER 65$268$2,573$0$446$3,287$0$3,287$0$3,287$1266$548$548
305-PROPERTY RETIREE OVER 65 SINGLE$0$0$0$0$0$0$0$0$0$022$0$0
306-PROPERTY RETIREE OVER 65 SPOUSE (ONE MEDICARE)$53$0$1,174$0$1,227$0$1,227$0$1,227$200$0$0
309-BOCC RETIREE OVER 65 SINGLE$1,692$20,948$1,935$27,351$51,927$0$51,927$0$51,927$1374242$1,236$1,236
310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE)$526$87,732$0$6,537$94,795$0$94,795$0$94,795$43816$11,849$5,925
311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE)$950$5,453$2,681$20,563$29,647$0$29,647$0$29,647$211122$2,695$1,348
312-BOCC RETIREE OVER 65 FAMILY$291$77$0$24$392$0$392$0$392$426$196$65
370-SPORTS RETIREE OVER 65 SPOUSE (ONE MEDICARE)$43$75$0$130$248$0$248$0$248$000$0$0
384-C BOARD RETIREE OVER 65 FAMILY$104$152$0$14,060$14,316$0$14,316$0$14,316$212$14,316$7,158
385-CLERK RETIREE OVER 65 SINGLE$347$375$0$1,536$2,258$0$2,258$0$2,258($79)55$452$452
802-PROPERTY COBRA$43$0$0$27$70$0$70$0$70$3211$70$70
803-BOCC COBRA$52$44$0$290$386$0$386$0$386$12644$97$97
822-CLERK COBRA$43$4$0$38$85$0$85$0$85$3211$85$85
BENEFIT OPTION Total$353,660$4,479,137$50,634$1,820,444$6,703,876($627,488)$6,076,387$0$6,076,387$48,6033,1267,236$1,944$840
Jun-2024 Total$530,598$6,011,339$215,465$2,492,300$9,249,702($627,488)$8,622,214$381,019$9,003,233$72,8785,66111,980$1,523$720
Jul-24HDHP MODERN PLAN002H-PROPERTY APPRAISERS ACTIVE$3,071$26,836$0$5,282$35,190$0$35,190$6,350$41,540$1784685$765$414
003-BOCC ACTIVE$157,665$1,175,514$70,973$510,078$1,914,231$0$1,914,231$305,591$2,219,822$21,2782,1424,066$894$471
017H-EXPRESSWAY ACTIVE$1,263$5,223$495$1,393$8,374$0$8,374$6,465$14,838$271435$598$239
018H-SPORTS AUTHORITY ACTIVE$715$5,982$0$5,621$12,318$0$12,318$1,625$13,943($10)1016$1,232$770
020-COURT ACTIVE$2,030$2,914$0$9,903$14,847$0$14,847$1,977$16,824$164815$1,856$990
021H-CHILDREN 'S BOARD ACTIVE$1,727$7,534$0$5,196$14,457$0$14,457$4,287$18,745($0)1543$964$336
022-CLERK ACTIVE$14,688$224,361$6,878$47,200$293,127$0$293,127$23,809$316,936$2,713238403$1,232$727
202-PROPERTY RETIREE UNDER 65$267$2,412$0$8$2,687$0$2,687$84$2,771($116)11$2,687$2,687
203-BOCC RETIREE UNDER 65$3,022$8,548$0$13,733$25,303$0$25,303$5,777$31,080$924658$550$436
221-C BOARD RETIREE UNDER 65$0$0$0$84$84$0$84$0$84$3211$84$84
222-CLERK RETIREE UNDER 65$626$36,218$0$21,466$58,310$0$58,310$2,212$60,522$271417$4,165$3,430
309-BOCC RETIREE OVER 65 SINGLE$165$4,053$0$4,524$8,741$0$8,741$0$8,741$066$1,457$1,457
385-CLERK RETIREE OVER 65 SINGLE$98$2,237$85$1,043$3,464$0$3,464$0$3,464($32)22$1,732$1,732
803-BOCC COBRA$79$0$0$0$79$0$79$0$79$6322$40$40
BENEFIT OPTION Total$185,416$1,501,833$78,431$625,531$2,391,211$0$2,391,211$358,178$2,749,389$24,4152,5454,750$940$503
OAP COVERAGE NOW003-BOCC ACTIVE$0$159$0$0$159$0$159$0$159$000$0$0
203-BOCC RETIREE UNDER 65$0$2,218$0$0$2,218$0$2,218$0$2,218$000$0$0
BENEFIT OPTION Total$0$2,377$0$0$2,377$0$2,377$0$2,377$000$0$0
OAP TRADITIONAL PLAN002H-PROPERTY APPRAISERS ACTIVE$6,935$49,509$440$18,578$75,463$0$75,463$0$75,463$7452120$1,451$629
003-BOCC ACTIVE$310,320$3,284,675$66,083$1,523,959$5,185,038($30,518)$5,154,520$0$5,154,520$41,8892,4535,959$2,101$865
017H-EXPRESSWAY ACTIVE$994$1,364$0$2,813$5,171$0$5,171$0$5,171$16822$646$235
018H-SPORTS AUTHORITY ACTIVE$5,424$59,877$0$19,778$85,079$0$85,079$0$85,079$804196$2,075$886
020-COURT ACTIVE$4,374$50,099$0$19,923$74,396$0$74,396$0$74,396$5163772$2,011$1,033
021H-CHILDREN 'S BOARD ACTIVE$2,301$12,098$619$7,329$22,347$0$22,347$0$22,347$452346$972$486
022-CLERK ACTIVE$30,341$456,322($5,590)$128,646$609,719$0$609,719$0$609,719$4,792257563$2,372$1,083
202-PROPERTY RETIREE UNDER 65$92($1,160)$0$24($1,044)$0($1,044)$0($1,044)$422($522)($522)
203-BOCC RETIREE UNDER 65$12,185$198,835$364$67,741$279,125$0$279,125$0$279,125$245153219$1,824$1,275
218-SPORTS RETIREE UNDER 65$142$1,735$0$1,886$3,763$0$3,763$0$3,763$423$1,882$1,254
220-COURT RETIREE UNDER 65$91$1,328$0$11$1,430$0$1,430$0$1,430$422$715$715
221-C BOARD RETIREE UNDER 65$43$132$88$1,210$1,474$0$1,474$0$1,474$211$1,474$1,474
222-CLERK RETIREE UNDER 65$269$740$0$1,120$2,128$0$2,128$0$2,128$4378$304$266
305-PROPERTY RETIREE OVER 65 SINGLE$0$0$0$0$0$0$0$0$0$022$0$0
306-PROPERTY RETIREE OVER 65 SPOUSE (ONE MEDICARE)$53$0$196$0$249$0$249$0$249($30)00$0$0
309-BOCC RETIREE OVER 65 SINGLE$1,815$34,429$399$26,567$63,210$0$63,210$0$63,210$1084242$1,505$1,505
310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE)$350$3,680$0$5,658$9,688$0$9,688$0$9,688$73816$1,211$605
311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE)$950$15,528$3,303$25,974$45,755$0$45,755$0$45,755$211122$4,160$2,080
312-BOCC RETIREE OVER 65 FAMILY$288($76,204)$0$245($75,671)$0($75,671)$0($75,671)$426($37,836)($12,612)
370-SPORTS RETIREE OVER 65 SPOUSE (ONE MEDICARE)($114)$0$0$0($114)$0($114)$0($114)$000$0$0
384-C BOARD RETIREE OVER 65 FAMILY$304$342$0$7,319$7,966$0$7,966$0$7,966$212$7,966$3,983

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 .