10-Exhibit C Report of Medical and RX Claims 2022.xlsx
XLSX spreadsheet 214 KB Posted
- Attached to
- Medical Stop-Loss Insurance Coverage
- Solicitation number
- ITB-25-00380
- Issued by
- Hillsborough County, Florida
About this file
This document is a monthly healthcare claims and enrollment report for the Hillsborough County Board of County Commissioners, covering medical and prescription healthcare benefits from January through December 2022. The report details healthcare experience across multiple benefit options including High Deductible Health Plan (HDHP) Modern Plan and OAP Traditional Plan, with enrollment and claims data broken down by various county departments and branches such as Property, BOCC Active, Clerk, Court, and various retiree categories.
The report reveals comprehensive financial and enrollment metrics, including total subscribers of 69,017, total members of 148,289, and total claims of $104,187,563 for the year. The monthly per member per month (PMPM) costs ranged from $534 to $782, with total ASO fees of $1,439,815. The enrollment was primarily distributed across active employees, retirees under 65, and retirees over 65, with significant representation in the BOCC Active and OAP Traditional Plan categories. The data supports a parallel state and local contract opportunity for medical stop-loss insurance coverage, with an estimated project budget of $43,970,461.98 for a 10-year period, seeking competitive sealed bids from experienced insurance providers.
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 2022 thru December 2022 | |||||||||||||||
| 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/MONTH | BENEFIT OPTION | FIXED CHARGES | IN NETWORK | OUT OF NETWORK | DRUG | GROSS CLAIMS | STOP LOSS | NET CLAIMS | HSA FUND ACTIVITY | TOTAL HSA & CLAIMS | TOTAL ASO FEES | TOTAL SUBS | TOTAL MBRS | TOTAL PEPM | TOTAL PMPM |
| Jan-22 | HDHP MODERN PLAN | $137,060 | $1,304,977 | $27,024 | $276,363 | $1,745,424 | $0 | $1,745,424 | $487,213 | $2,232,636 | ($946) | 2,378 | 4,591 | $734 | $380 |
| OAP COVERAGE NOW | $0 | ($9,281) | $0 | $0 | ($9,281) | $0 | ($9,281) | $0 | ($9,281) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $293,301 | $4,281,901 | $30,833 | $1,637,173 | $6,243,208 | ($656) | $6,242,552 | $0 | $6,242,552 | ($1,514) | 3,385 | 7,924 | $1,844 | $788 | |
| Jan-2022 Total | $430,360 | $5,577,596 | $57,857 | $1,913,537 | $7,979,350 | ($656) | $7,978,694 | $487,213 | $8,465,906 | ($2,460) | 5,763 | 12,515 | $1,384 | $638 | |
| Feb-22 | HDHP MODERN PLAN | $146,944 | $1,349,436 | $92,760 | $460,418 | $2,049,559 | $0 | $2,049,559 | $446,482 | $2,496,041 | ($1,230) | 2,372 | 4,575 | $864 | $448 |
| OAP COVERAGE NOW | $0 | ($2,382) | ($128) | $0 | ($2,509) | $0 | ($2,509) | $0 | ($2,509) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $315,637 | $2,590,276 | $56,073 | $1,624,155 | $4,586,141 | $0 | $4,586,141 | $0 | $4,586,141 | ($2,397) | 3,361 | 7,854 | $1,365 | $584 | |
| Feb-2022 Total | $462,581 | $3,937,331 | $148,706 | $2,084,573 | $6,633,191 | $0 | $6,633,191 | $446,482 | $7,079,673 | ($3,627) | 5,733 | 12,429 | $1,157 | $534 | |
| Mar-22 | HDHP MODERN PLAN | $110,595 | $2,631,403 | $37,034 | $527,860 | $3,306,892 | ($205,528) | $3,101,364 | $415,340 | $3,516,704 | ($1,672) | 2,379 | 4,580 | $1,304 | $677 |
| OAP COVERAGE NOW | $0 | ($223) | $0 | $0 | ($223) | $0 | ($223) | $0 | ($223) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $247,505 | $4,217,712 | $109,546 | $1,656,421 | $6,231,185 | $13,229 | $6,244,414 | $0 | $6,244,414 | ($3,154) | 3,348 | 7,811 | $1,865 | $799 | |
| Mar-2022 Total | $358,100 | $6,848,893 | $146,580 | $2,184,281 | $9,537,854 | ($192,299) | $9,345,555 | $415,340 | $9,760,895 | ($4,826) | 5,727 | 12,391 | $1,632 | $754 | |
| Apr-22 | HDHP MODERN PLAN | $142,571 | $1,569,178 | $10,046 | $442,727 | $2,164,521 | ($4,827) | $2,159,694 | $353,527 | $2,513,221 | ($554) | 2,388 | 4,589 | $904 | $471 |
| OAP COVERAGE NOW | $0 | ($650) | $0 | $0 | ($650) | $0 | ($650) | $0 | ($650) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $300,151 | $4,109,642 | $74,473 | $1,912,268 | $6,396,533 | $0 | $6,396,533 | $0 | $6,396,533 | ($2,145) | 3,325 | 7,755 | $1,924 | $825 | |
| Apr-2022 Total | $442,721 | $5,678,170 | $84,518 | $2,354,995 | $8,560,404 | ($4,827) | $8,555,577 | $353,527 | $8,909,105 | ($2,699) | 5,713 | 12,344 | $1,498 | $693 | |
| May-22 | HDHP MODERN PLAN | $143,137 | $1,476,448 | $4,390 | $594,614 | $2,218,588 | ($3,778) | $2,214,810 | $411,316 | $2,626,126 | $74,971 | 2,376 | 4,567 | $932 | $485 |
| OAP TRADITIONAL PLAN | $297,206 | $4,054,227 | $72,856 | $1,890,480 | $6,314,769 | $0 | $6,314,769 | $0 | $6,314,769 | $104,429 | 3,315 | 7,701 | $1,905 | $820 | |
| May-2022 Total | $440,343 | $5,530,675 | $77,246 | $2,485,093 | $8,533,357 | ($3,778) | $8,529,579 | $411,316 | $8,940,895 | $179,400 | 5,691 | 12,268 | $1,499 | $695 | |
| Jun-22 | HDHP MODERN PLAN | $144,876 | $1,716,939 | $5,430 | $578,046 | $2,445,291 | ($5,623) | $2,439,668 | $348,318 | $2,787,986 | $75,002 | 2,373 | 4,554 | $1,028 | $536 |
| OAP COVERAGE NOW | $0 | ($79,055) | $0 | $0 | ($79,055) | $0 | ($79,055) | $0 | ($79,055) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $317,571 | $4,047,454 | $16,214 | $1,672,270 | $6,053,509 | $0 | $6,053,509 | $0 | $6,053,509 | $104,019 | 3,301 | 7,655 | $1,834 | $791 | |
| Jun-2022 Total | $462,447 | $5,685,338 | $21,644 | $2,250,316 | $8,419,746 | ($5,623) | $8,414,122 | $348,318 | $8,762,440 | $179,021 | 5,674 | 12,209 | $1,483 | $689 | |
| Jul-22 | HDHP MODERN PLAN | $142,479 | $1,354,904 | $3,191 | $484,040 | $1,984,614 | ($2,226) | $1,982,388 | $314,685 | $2,297,073 | $75,601 | 2,397 | 4,597 | $827 | $431 |
| OAP COVERAGE NOW | $0 | ($48,806) | $0 | $0 | ($48,806) | $0 | ($48,806) | $0 | ($48,806) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $302,126 | $4,247,094 | $15,127 | $1,564,512 | $6,128,859 | $0 | $6,128,859 | $0 | $6,128,859 | $103,672 | 3,292 | 7,643 | $1,862 | $802 | |
| Jul-2022 Total | $444,605 | $5,553,193 | $18,318 | $2,048,553 | $8,064,668 | ($2,226) | $8,062,442 | $314,685 | $8,377,127 | $179,273 | 5,689 | 12,240 | $1,417 | $659 | |
| Aug-22 | HDHP MODERN PLAN | $140,735 | $1,637,305 | $15,291 | $557,960 | $2,351,291 | ($71,223) | $2,280,068 | $325,707 | $2,605,776 | $76,264 | 2,416 | 4,615 | $944 | $494 |
| OAP COVERAGE NOW | $0 | ($3,414) | $0 | $0 | ($3,414) | $0 | ($3,414) | $0 | ($3,414) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $294,235 | $4,555,992 | $128,601 | $1,836,589 | $6,815,418 | $0 | $6,815,418 | $0 | $6,815,418 | $103,798 | 3,291 | 7,615 | $2,071 | $895 | |
| Aug-2022 Total | $434,970 | $6,189,883 | $143,892 | $2,394,549 | $9,163,294 | ($71,223) | $9,092,072 | $325,707 | $9,417,779 | $180,062 | 5,707 | 12,230 | $1,593 | $743 | |
| Sep-22 | HDHP MODERN PLAN | $147,889 | $1,691,859 | $6,128 | $598,517 | $2,444,392 | ($149,185) | $2,295,207 | $252,134 | $2,547,341 | $77,525 | 2,455 | 4,674 | $935 | $491 |
| OAP COVERAGE NOW | $0 | ($276) | $0 | $0 | ($276) | $0 | ($276) | $0 | ($276) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $310,241 | $4,230,341 | $18,080 | $1,760,038 | $6,318,700 | $0 | $6,318,700 | $0 | $6,318,700 | $104,271 | 3,302 | 7,624 | $1,914 | $829 | |
| Sep-2022 Total | $458,130 | $5,921,923 | $24,208 | $2,358,555 | $8,762,816 | ($149,185) | $8,613,631 | $252,134 | $8,865,764 | $181,797 | 5,757 | 12,298 | $1,496 | $700 | |
| Oct-22 | HDHP MODERN PLAN | $144,859 | $1,803,070 | $6,104 | $493,040 | $2,447,074 | ($31,203) | $2,415,871 | $273,690 | $2,689,560 | $78,282 | 2,480 | 4,703 | $974 | $514 |
| OAP COVERAGE NOW | $0 | ($6,000) | $0 | $0 | ($6,000) | $0 | ($6,000) | $0 | ($6,000) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $294,212 | $4,462,966 | $58,756 | $1,740,780 | $6,556,714 | $0 | $6,556,714 | $0 | $6,556,714 | $104,587 | 3,320 | 7,652 | $1,975 | $857 | |
| Oct-2022 Total | $439,071 | $6,260,036 | $64,860 | $2,233,819 | $8,997,787 | ($31,203) | $8,966,584 | $273,690 | $9,240,274 | $182,869 | 5,800 | 12,355 | $1,546 | $726 | |
| Nov-22 | HDHP MODERN PLAN | $146,446 | $2,455,660 | $31,372 | $669,752 | $3,303,230 | ($82,826) | $3,220,404 | $297,148 | $3,517,552 | $78,882 | 2,501 | 4,740 | $1,288 | $679 |
| OAP COVERAGE NOW | $0 | ($600) | $0 | $0 | ($600) | $0 | ($600) | $0 | ($600) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $297,523 | $4,243,628 | $36,455 | $1,766,203 | $6,343,809 | ($285,526) | $6,058,284 | $0 | $6,058,284 | $105,375 | 3,341 | 7,693 | $1,813 | $788 | |
| Nov-2022 Total | $443,969 | $6,698,689 | $67,827 | $2,435,954 | $9,646,439 | ($368,351) | $9,278,088 | $297,148 | $9,575,236 | $184,257 | 5,842 | 12,433 | $1,588 | $746 | |
| Dec-22 | HDHP MODERN PLAN | $150,193 | $2,231,108 | $115,668 | $647,603 | $3,144,572 | ($38,065) | $3,106,507 | $291,872 | $3,398,379 | $80,332 | 2,547 | 4,818 | $1,220 | $645 |
| OAP COVERAGE NOW | $0 | ($467) | $0 | $0 | ($467) | $0 | ($467) | $0 | ($467) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $304,904 | $4,619,781 | $20,212 | $1,799,656 | $6,744,553 | ($14,868) | $6,729,685 | $0 | $6,729,685 | $106,416 | 3,374 | 7,759 | $1,995 | $867 | |
| Dec-2022 Total | $455,097 | $6,850,422 | $135,880 | $2,447,258 | $9,888,657 | ($52,932) | $9,835,725 | $291,872 | $10,127,596 | $186,748 | 5,921 | 12,577 | $1,661 | $782 |
| BENEFIT OPTION Totals | HDHP MODERN PLAN | $1,697,783 | $21,222,288 | $354,438 | $6,330,939 | $29,605,448 | ($594,484) | $29,010,964 | $4,217,431 | $33,228,395 | $612,457 | 29,062 | 55,603 | $998 | $522 |
| OAP COVERAGE NOW | $0 | ($151,155) | ($128) | $0 | ($151,282) | $0 | ($151,282) | $0 | ($151,282) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $3,574,612 | $49,661,015 | $637,226 | $20,860,545 | $74,733,397 | ($287,820) | $74,445,577 | $0 | $74,445,577 | $827,357 | 39,955 | 92,686 | $1,863 | $803 | |
| Grand Total | $5,272,395 | $70,732,148 | $991,536 | $27,191,484 | $104,187,563 | ($882,304) | $103,305,259 | $4,217,431 | $107,522,690 | $1,439,815 | 69,017 | 148,289 | $1,497 | $697 |
&G &7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law. ADVICE Reporting System &8Page &P of &N Date: 1/6/2023
Enrollment Counts
| HILLSBOROUGH COUNTY BOARD OF COUNTY COMM |
| ASO SUBSCRIBER ENROLLMENT BY TIER |
| January 2022 thru December 2022 |
| YTD/MONTH | BENEFIT OPTION | EMP ONLY | EMP + SPOUSE | EMP+ CHILD(REN) | EMP + FAMILY | TOTAL |
| Jan-22 | HDHP MODERN PLAN | 1,261 | 333 | 305 | 479 | 2,378 |
| OAP TRADITIONAL PLAN | 1,249 | 694 | 360 | 1,082 | 3,385 | |
| Jan-2022 Total | 2,510 | 1,027 | 665 | 1,561 | 5,763 | |
| Feb-22 | HDHP MODERN PLAN | 1,256 | 335 | 304 | 477 | 2,372 |
| OAP TRADITIONAL PLAN | 1,245 | 683 | 356 | 1,077 | 3,361 | |
| Feb-2022 Total | 2,501 | 1,018 | 660 | 1,554 | 5,733 | |
| Mar-22 | HDHP MODERN PLAN | 1,263 | 337 | 301 | 478 | 2,379 |
| OAP TRADITIONAL PLAN | 1,248 | 677 | 353 | 1,070 | 3,348 | |
| Mar-2022 Total | 2,511 | 1,014 | 654 | 1,548 | 5,727 | |
| Apr-22 | HDHP MODERN PLAN | 1,270 | 337 | 300 | 481 | 2,388 |
| OAP TRADITIONAL PLAN | 1,244 | 663 | 352 | 1,066 | 3,325 | |
| Apr-2022 Total | 2,514 | 1,000 | 652 | 1,547 | 5,713 | |
| May-22 | HDHP MODERN PLAN | 1,268 | 330 | 294 | 484 | 2,376 |
| OAP TRADITIONAL PLAN | 1,253 | 652 | 350 | 1,060 | 3,315 | |
| May-2022 Total | 2,521 | 982 | 644 | 1,544 | 5,691 | |
| Jun-22 | HDHP MODERN PLAN | 1,265 | 334 | 294 | 480 | 2,373 |
| OAP TRADITIONAL PLAN | 1,250 | 650 | 352 | 1,049 | 3,301 | |
| Jun-2022 Total | 2,515 | 984 | 646 | 1,529 | 5,674 | |
| Jul-22 | HDHP MODERN PLAN | 1,280 | 339 | 295 | 483 | 2,397 |
| OAP TRADITIONAL PLAN | 1,252 | 643 | 345 | 1,052 | 3,292 | |
| Jul-2022 Total | 2,532 | 982 | 640 | 1,535 | 5,689 | |
| Aug-22 | HDHP MODERN PLAN | 1,297 | 344 | 295 | 480 | 2,416 |
| OAP TRADITIONAL PLAN | 1,263 | 634 | 348 | 1,046 | 3,291 | |
| Aug-2022 Total | 2,560 | 978 | 643 | 1,526 | 5,707 | |
| Sep-22 | HDHP MODERN PLAN | 1,323 | 348 | 302 | 482 | 2,455 |
| OAP TRADITIONAL PLAN | 1,276 | 634 | 348 | 1,044 | 3,302 | |
| Sep-2022 Total | 2,599 | 982 | 650 | 1,526 | 5,757 | |
| Oct-22 | HDHP MODERN PLAN | 1,341 | 350 | 304 | 485 | 2,480 |
| OAP TRADITIONAL PLAN | 1,284 | 635 | 357 | 1,044 | 3,320 | |
| Oct-2022 Total | 2,625 | 985 | 661 | 1,529 | 5,800 | |
| Nov-22 | HDHP MODERN PLAN | 1,354 | 346 | 311 | 490 | 2,501 |
| OAP TRADITIONAL PLAN | 1,294 | 639 | 358 | 1,050 | 3,341 | |
| Nov-2022 Total | 2,648 | 985 | 669 | 1,540 | 5,842 | |
| Dec-22 | HDHP MODERN PLAN | 1,387 | 349 | 316 | 495 | 2,547 |
| OAP TRADITIONAL PLAN | 1,313 | 643 | 359 | 1,059 | 3,374 | |
| Dec-2022 Total | 2,700 | 992 | 675 | 1,554 | 5,921 |
| BENEFIT OPTION Totals | HDHP MODERN PLAN | 15,565 | 4,082 | 3,621 | 5,794 | 29,062 |
| OAP TRADITIONAL PLAN | 15,171 | 7,847 | 4,238 | 12,699 | 39,955 | |
| Grand Total | 30,736 | 11,929 | 7,859 | 18,493 | 69,017 |
&7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law. ADVICE Reporting System &8Page &P of &N
Exp BenOpt R12-1
| HILLSBOROUGH COUNTY BOARD OF COUNTY COMM | |||||||||||||||
| MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT | |||||||||||||||
| January 2022 thru December 2022 | |||||||||||||||
| 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/MONTH | BENEFIT OPTION | FIXED CHARGES | IN NETWORK | OUT OF NETWORK | DRUG | GROSS CLAIMS | STOP LOSS | NET CLAIMS | HSA FUND ACTIVITY | TOTAL HSA & CLAIMS | TOTAL ASO FEES | TOTAL SUBS | TOTAL MBRS | TOTAL PEPM | TOTAL PMPM |
| Jan-22 | HDHP MODERN PLAN | $137,060 | $1,304,977 | $27,024 | $276,363 | $1,745,424 | $0 | $1,745,424 | $487,213 | $2,232,636 | ($946) | 2,378 | 4,591 | $734 | $380 |
| OAP COVERAGE NOW | $0 | ($9,281) | $0 | $0 | ($9,281) | $0 | ($9,281) | $0 | ($9,281) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $293,301 | $4,281,901 | $30,833 | $1,637,173 | $6,243,208 | ($656) | $6,242,552 | $0 | $6,242,552 | ($1,514) | 3,385 | 7,924 | $1,844 | $788 | |
| Jan-2022 Total | $430,360 | $5,577,596 | $57,857 | $1,913,537 | $7,979,350 | ($656) | $7,978,694 | $487,213 | $8,465,906 | ($2,460) | 5,763 | 12,515 | $1,384 | $638 | |
| Feb-22 | HDHP MODERN PLAN | $146,944 | $1,349,436 | $92,760 | $460,418 | $2,049,559 | $0 | $2,049,559 | $446,482 | $2,496,041 | ($1,230) | 2,372 | 4,575 | $864 | $448 |
| OAP COVERAGE NOW | $0 | ($2,382) | ($128) | $0 | ($2,509) | $0 | ($2,509) | $0 | ($2,509) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $315,637 | $2,590,276 | $56,073 | $1,624,155 | $4,586,141 | $0 | $4,586,141 | $0 | $4,586,141 | ($2,397) | 3,361 | 7,854 | $1,365 | $584 | |
| Feb-2022 Total | $462,581 | $3,937,331 | $148,706 | $2,084,573 | $6,633,191 | $0 | $6,633,191 | $446,482 | $7,079,673 | ($3,627) | 5,733 | 12,429 | $1,157 | $534 | |
| Mar-22 | HDHP MODERN PLAN | $110,595 | $2,631,403 | $37,034 | $527,860 | $3,306,892 | ($205,528) | $3,101,364 | $415,340 | $3,516,704 | ($1,672) | 2,379 | 4,580 | $1,304 | $677 |
| OAP COVERAGE NOW | $0 | ($223) | $0 | $0 | ($223) | $0 | ($223) | $0 | ($223) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $247,505 | $4,217,712 | $109,546 | $1,656,421 | $6,231,185 | $13,229 | $6,244,414 | $0 | $6,244,414 | ($3,154) | 3,348 | 7,811 | $1,865 | $799 | |
| Mar-2022 Total | $358,100 | $6,848,893 | $146,580 | $2,184,281 | $9,537,854 | ($192,299) | $9,345,555 | $415,340 | $9,760,895 | ($4,826) | 5,727 | 12,391 | $1,632 | $754 | |
| Apr-22 | HDHP MODERN PLAN | $142,571 | $1,569,178 | $10,046 | $442,727 | $2,164,521 | ($4,827) | $2,159,694 | $353,527 | $2,513,221 | ($554) | 2,388 | 4,589 | $904 | $471 |
| OAP COVERAGE NOW | $0 | ($650) | $0 | $0 | ($650) | $0 | ($650) | $0 | ($650) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $300,151 | $4,109,642 | $74,473 | $1,912,268 | $6,396,533 | $0 | $6,396,533 | $0 | $6,396,533 | ($2,145) | 3,325 | 7,755 | $1,924 | $825 | |
| Apr-2022 Total | $442,721 | $5,678,170 | $84,518 | $2,354,995 | $8,560,404 | ($4,827) | $8,555,577 | $353,527 | $8,909,105 | ($2,699) | 5,713 | 12,344 | $1,498 | $693 | |
| May-22 | HDHP MODERN PLAN | $143,137 | $1,476,448 | $4,390 | $594,614 | $2,218,588 | ($3,778) | $2,214,810 | $411,316 | $2,626,126 | $74,971 | 2,376 | 4,567 | $932 | $485 |
| OAP TRADITIONAL PLAN | $297,206 | $4,054,227 | $72,856 | $1,890,480 | $6,314,769 | $0 | $6,314,769 | $0 | $6,314,769 | $104,429 | 3,315 | 7,701 | $1,905 | $820 | |
| May-2022 Total | $440,343 | $5,530,675 | $77,246 | $2,485,093 | $8,533,357 | ($3,778) | $8,529,579 | $411,316 | $8,940,895 | $179,400 | 5,691 | 12,268 | $1,499 | $695 | |
| Jun-22 | HDHP MODERN PLAN | $144,876 | $1,716,939 | $5,430 | $578,046 | $2,445,291 | ($5,623) | $2,439,668 | $348,318 | $2,787,986 | $75,002 | 2,373 | 4,554 | $1,028 | $536 |
| OAP COVERAGE NOW | $0 | ($79,055) | $0 | $0 | ($79,055) | $0 | ($79,055) | $0 | ($79,055) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $317,571 | $4,047,454 | $16,214 | $1,672,270 | $6,053,509 | $0 | $6,053,509 | $0 | $6,053,509 | $104,019 | 3,301 | 7,655 | $1,834 | $791 | |
| Jun-2022 Total | $462,447 | $5,685,338 | $21,644 | $2,250,316 | $8,419,746 | ($5,623) | $8,414,122 | $348,318 | $8,762,440 | $179,021 | 5,674 | 12,209 | $1,483 | $689 | |
| Jul-22 | HDHP MODERN PLAN | $142,479 | $1,354,904 | $3,191 | $484,040 | $1,984,614 | ($2,226) | $1,982,388 | $314,685 | $2,297,073 | $75,601 | 2,397 | 4,597 | $827 | $431 |
| OAP COVERAGE NOW | $0 | ($48,806) | $0 | $0 | ($48,806) | $0 | ($48,806) | $0 | ($48,806) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $302,126 | $4,247,094 | $15,127 | $1,564,512 | $6,128,859 | $0 | $6,128,859 | $0 | $6,128,859 | $103,672 | 3,292 | 7,643 | $1,862 | $802 | |
| Jul-2022 Total | $444,605 | $5,553,193 | $18,318 | $2,048,553 | $8,064,668 | ($2,226) | $8,062,442 | $314,685 | $8,377,127 | $179,273 | 5,689 | 12,240 | $1,417 | $659 | |
| Aug-22 | HDHP MODERN PLAN | $140,735 | $1,637,305 | $15,291 | $557,960 | $2,351,291 | ($71,223) | $2,280,068 | $325,707 | $2,605,776 | $76,264 | 2,416 | 4,615 | $944 | $494 |
| OAP COVERAGE NOW | $0 | ($3,414) | $0 | $0 | ($3,414) | $0 | ($3,414) | $0 | ($3,414) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $294,235 | $4,555,992 | $128,601 | $1,836,589 | $6,815,418 | $0 | $6,815,418 | $0 | $6,815,418 | $103,798 | 3,291 | 7,615 | $2,071 | $895 | |
| Aug-2022 Total | $434,970 | $6,189,883 | $143,892 | $2,394,549 | $9,163,294 | ($71,223) | $9,092,072 | $325,707 | $9,417,779 | $180,062 | 5,707 | 12,230 | $1,593 | $743 | |
| Sep-22 | HDHP MODERN PLAN | $147,889 | $1,691,859 | $6,128 | $598,517 | $2,444,392 | ($149,185) | $2,295,207 | $252,134 | $2,547,341 | $77,525 | 2,455 | 4,674 | $935 | $491 |
| OAP COVERAGE NOW | $0 | ($276) | $0 | $0 | ($276) | $0 | ($276) | $0 | ($276) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $310,241 | $4,230,341 | $18,080 | $1,760,038 | $6,318,700 | $0 | $6,318,700 | $0 | $6,318,700 | $104,271 | 3,302 | 7,624 | $1,914 | $829 | |
| Sep-2022 Total | $458,130 | $5,921,923 | $24,208 | $2,358,555 | $8,762,816 | ($149,185) | $8,613,631 | $252,134 | $8,865,764 | $181,797 | 5,757 | 12,298 | $1,496 | $700 | |
| Oct-22 | HDHP MODERN PLAN | $144,859 | $1,803,070 | $6,104 | $493,040 | $2,447,074 | ($31,203) | $2,415,871 | $273,690 | $2,689,560 | $78,282 | 2,480 | 4,703 | $974 | $514 |
| OAP COVERAGE NOW | $0 | ($6,000) | $0 | $0 | ($6,000) | $0 | ($6,000) | $0 | ($6,000) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $294,212 | $4,462,966 | $58,756 | $1,740,780 | $6,556,714 | $0 | $6,556,714 | $0 | $6,556,714 | $104,587 | 3,320 | 7,652 | $1,975 | $857 | |
| Oct-2022 Total | $439,071 | $6,260,036 | $64,860 | $2,233,819 | $8,997,787 | ($31,203) | $8,966,584 | $273,690 | $9,240,274 | $182,869 | 5,800 | 12,355 | $1,546 | $726 | |
| Nov-22 | HDHP MODERN PLAN | $146,446 | $2,455,660 | $31,372 | $669,752 | $3,303,230 | ($82,826) | $3,220,404 | $297,148 | $3,517,552 | $78,882 | 2,501 | 4,740 | $1,288 | $679 |
| OAP COVERAGE NOW | $0 | ($600) | $0 | $0 | ($600) | $0 | ($600) | $0 | ($600) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $297,523 | $4,243,628 | $36,455 | $1,766,203 | $6,343,809 | ($285,526) | $6,058,284 | $0 | $6,058,284 | $105,375 | 3,341 | 7,693 | $1,813 | $788 | |
| Nov-2022 Total | $443,969 | $6,698,689 | $67,827 | $2,435,954 | $9,646,439 | ($368,351) | $9,278,088 | $297,148 | $9,575,236 | $184,257 | 5,842 | 12,433 | $1,588 | $746 | |
| Dec-22 | HDHP MODERN PLAN | $150,193 | $2,231,108 | $115,668 | $647,603 | $3,144,572 | ($38,065) | $3,106,507 | $291,872 | $3,398,379 | $80,332 | 2,547 | 4,818 | $1,220 | $645 |
| OAP COVERAGE NOW | $0 | ($467) | $0 | $0 | ($467) | $0 | ($467) | $0 | ($467) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $304,904 | $4,619,781 | $20,212 | $1,799,656 | $6,744,553 | ($14,868) | $6,729,685 | $0 | $6,729,685 | $106,416 | 3,374 | 7,759 | $1,995 | $867 | |
| Dec-2022 Total | $455,097 | $6,850,422 | $135,880 | $2,447,258 | $9,888,657 | ($52,932) | $9,835,725 | $291,872 | $10,127,596 | $186,748 | 5,921 | 12,577 | $1,661 | $782 |
| BENEFIT OPTION Totals | HDHP MODERN PLAN | $1,697,783 | $21,222,288 | $354,438 | $6,330,939 | $29,605,448 | ($594,484) | $29,010,964 | $4,217,431 | $33,228,395 | $612,457 | 29,062 | 55,603 | $998 | $522 |
| OAP COVERAGE NOW | $0 | ($151,155) | ($128) | $0 | ($151,282) | $0 | ($151,282) | $0 | ($151,282) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $3,574,612 | $49,661,015 | $637,226 | $20,860,545 | $74,733,397 | ($287,820) | $74,445,577 | $0 | $74,445,577 | $827,357 | 39,955 | 92,686 | $1,863 | $803 | |
| Grand Total | $5,272,395 | $70,732,148 | $991,536 | $27,191,484 | $104,187,563 | ($882,304) | $103,305,259 | $4,217,431 | $107,522,690 | $1,439,815 | 69,017 | 148,289 | $1,497 | $697 |
&7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law. ADVICE Reporting System &8Page &P of &N
Exp R12 Branch BenOpt-1
| HILLSBOROUGH COUNTY BOARD OF COUNTY COMM | ||||||||||||||||
| MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT | ||||||||||||||||
| January 2022 thru December 2022 | ||||||||||||||||
| 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/MONTH | BENEFIT OPTION | BRANCH | FIXED CHARGES | IN NETWORK | OUT OF NETWORK | DRUG | GROSS CLAIMS | STOP LOSS | NET CLAIMS | HSA FUND ACTIVITY | TOTAL HSA & CLAIMS | TOTAL ASO FEES | TOTAL SUBS | TOTAL MBRS | TOTAL PEPM | TOTAL PMPM |
| Jan-22 | HDHP MODERN PLAN | 002-PROPERTY ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | 1 | $0 | $0 |
| 002H-PROPERTY APPRAISERS ACTIVE | $2,587 | $9,637 | $150 | $261 | $12,634 | $0 | $12,634 | $12,957 | $25,592 | $0 | 49 | 94 | $258 | $134 | ||
| 003-BOCC ACTIVE | $114,616 | $1,053,086 | $25,221 | $215,285 | $1,408,208 | $0 | $1,408,208 | $398,560 | $1,806,768 | ($1,009) | 1,940 | 3,835 | $726 | $367 | ||
| 016H-PORT AUTHORITY ACTIVE | $0 | ($2,585) | $0 | $0 | ($2,585) | $0 | ($2,585) | $0 | ($2,585) | $0 | 0 | 0 | $0 | $0 | ||
| 017H-EXPRESSWAY ACTIVE | $1,052 | $11,776 | $0 | $568 | $13,396 | $0 | $13,396 | $1,736 | $15,133 | $0 | 17 | 35 | $788 | $383 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $295 | $219 | $0 | $100 | $614 | $0 | $614 | $1,448 | $2,063 | $0 | 7 | 11 | $88 | $56 | ||
| 019H-ARTS ACTIVE | ($0) | ($641) | $0 | $0 | ($641) | $0 | ($641) | $0 | ($641) | $0 | 0 | 0 | $0 | $0 | ||
| 020-COURT ACTIVE | $830 | $6,824 | $0 | $3,121 | $10,775 | $0 | $10,775 | $3,728 | $14,503 | $0 | 12 | 30 | $898 | $359 | ||
| 021-C BOARD ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 1 | 2 | $0 | $0 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $646 | $33,976 | $100 | $539 | $35,262 | $0 | $35,262 | $4,511 | $39,772 | $0 | 9 | 20 | $3,918 | $1,763 | ||
| 022-CLERK ACTIVE | $13,177 | $62,529 | $1,152 | $38,146 | $115,005 | $0 | $115,005 | $54,303 | $169,308 | ($189) | 247 | 445 | $466 | $258 | ||
| 202-PROPERTY RETIREE UNDER 65 | $26 | $54 | $200 | $520 | $800 | $0 | $800 | $274 | $1,074 | $0 | 3 | 3 | $267 | $267 | ||
| 203-BOCC RETIREE UNDER 65 | $3,087 | $83,724 | $100 | $15,111 | $102,023 | $0 | $102,023 | $8,717 | $110,740 | ($63) | 72 | 93 | $1,417 | $1,097 | ||
| 218-SPORTS RETIREE UNDER 65 | $26 | $0 | $0 | $0 | $26 | $0 | $26 | $0 | $26 | $0 | 1 | 1 | $26 | $26 | ||
| 222-CLERK RETIREE UNDER 65 | $352 | $45,670 | $100 | $1,200 | $47,322 | $0 | $47,322 | $977 | $48,299 | $0 | 8 | 9 | $5,915 | $5,258 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $157 | $191 | $0 | $1,041 | $1,389 | $0 | $1,389 | $0 | $1,389 | $189 | 8 | 8 | $174 | $174 | ||
| 311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $52 | $0 | $0 | $0 | $52 | $0 | $52 | $0 | $52 | $32 | 0 | 0 | $0 | $0 | ||
| 312-BOCC RETIREE OVER 65 FAMILY | $105 | $0 | $0 | $19 | $123 | $0 | $123 | $0 | $123 | $0 | 0 | 0 | $0 | $0 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $52 | $518 | $0 | $452 | $1,021 | $0 | $1,021 | $0 | $1,021 | $63 | 3 | 3 | $340 | $340 | ||
| 803-BOCC COBRA | ($2) | $0 | $0 | $0 | ($2) | $0 | ($2) | $0 | ($2) | $32 | 1 | 1 | ($2) | ($2) | ||
| 822-CLERK COBRA | ($1) | $0 | $0 | $0 | ($1) | $0 | ($1) | $0 | ($1) | $0 | 0 | 0 | $0 | $0 | ||
| BENEFIT OPTION Total | $137,060 | $1,304,977 | $27,024 | $276,363 | $1,745,424 | $0 | $1,745,424 | $487,213 | $2,232,636 | ($946) | 2,378 | 4,591 | $734 | $380 | ||
| OAP COVERAGE NOW | 003-BOCC ACTIVE | $0 | ($67) | $0 | $0 | ($67) | $0 | ($67) | $0 | ($67) | $0 | 0 | 0 | $0 | $0 | |
| 022-CLERK ACTIVE | $0 | ($8,696) | $0 | $0 | ($8,696) | $0 | ($8,696) | $0 | ($8,696) | $0 | 0 | 0 | $0 | $0 | ||
| 203-BOCC RETIREE UNDER 65 | $0 | ($518) | $0 | $0 | ($518) | $0 | ($518) | $0 | ($518) | $0 | 0 | 0 | $0 | $0 | ||
| BENEFIT OPTION Total | $0 | ($9,281) | $0 | $0 | ($9,281) | $0 | ($9,281) | $0 | ($9,281) | $0 | 0 | 0 | $0 | $0 | ||
| OAP TRADITIONAL PLAN | 002-PROPERTY ACTIVE | $229 | $0 | $0 | $0 | $229 | $0 | $229 | $0 | $229 | $0 | 3 | 5 | $76 | $46 | |
| 002H-PROPERTY APPRAISERS ACTIVE | $5,193 | $56,076 | $100 | $60,177 | $121,546 | $0 | $121,546 | $0 | $121,546 | $0 | 54 | 139 | $2,251 | $874 | ||
| 003-BOCC ACTIVE | $237,549 | $3,131,172 | $24,555 | $1,231,856 | $4,625,133 | ($656) | $4,624,476 | $0 | $4,624,476 | ($1,388) | 2,602 | 6,437 | $1,777 | $718 | ||
| 016H-PORT AUTHORITY ACTIVE | $0 | ($20) | $0 | $0 | ($20) | $0 | ($20) | $0 | ($20) | $0 | 0 | 0 | $0 | $0 | ||
| 017H-EXPRESSWAY ACTIVE | $987 | $7,008 | $231 | $1,057 | $9,283 | $0 | $9,283 | $0 | $9,283 | $0 | 8 | 22 | $1,160 | $422 | ||
| 018-SPORTS ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 1 | 2 | $0 | $0 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $3,817 | $98,591 | $100 | $7,249 | $109,756 | $0 | $109,756 | $0 | $109,756 | $0 | 42 | 103 | $2,613 | $1,066 | ||
| 020-COURT ACTIVE | $3,362 | $15,471 | $0 | $15,467 | $34,301 | $0 | $34,301 | $0 | $34,301 | $0 | 37 | 84 | $927 | $408 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $1,867 | $7,436 | $953 | $9,497 | $19,753 | $0 | $19,753 | $0 | $19,753 | $0 | 23 | 49 | $859 | $403 | ||
| 022-CLERK ACTIVE | $22,602 | $284,833 | $2,449 | $89,992 | $399,876 | $0 | $399,876 | $0 | $399,876 | ($126) | 283 | 607 | $1,413 | $659 | ||
| 202-PROPERTY RETIREE UNDER 65 | $492 | $2,038 | $0 | $652 | $3,181 | $0 | $3,181 | $0 | $3,181 | $0 | 9 | 9 | $353 | $353 | ||
| 203-BOCC RETIREE UNDER 65 | $11,163 | $158,708 | $1,969 | $100,866 | $272,707 | $0 | $272,707 | $0 | $272,707 | ($189) | 187 | 259 | $1,458 | $1,053 | ||
| 217-EXPRESSWAY RETIREE UNDER 65 | ($8) | $0 | $0 | $0 | ($8) | $0 | ($8) | $0 | ($8) | $0 | 0 | 0 | $0 | $0 | ||
| 218-SPORTS RETIREE UNDER 65 | $103 | $52 | $0 | $111 | $266 | $0 | $266 | $0 | $266 | $0 | 3 | 3 | $89 | $89 | ||
| 220-COURT RETIREE UNDER 65 | $119 | $323 | $0 | $672 | $1,113 | $0 | $1,113 | $0 | $1,113 | $0 | 3 | 3 | $371 | $371 | ||
| 221-C BOARD RETIREE UNDER 65 | $33 | $86 | $0 | $147 | $267 | $0 | $267 | $0 | $267 | $0 | 1 | 1 | $267 | $267 | ||
| 222-CLERK RETIREE UNDER 65 | $547 | $1,112 | $95 | $927 | $2,680 | $0 | $2,680 | $0 | $2,680 | $0 | 12 | 14 | $223 | $191 | ||
| 305-PROPERTY RETIREE OVER 65 SINGLE | $66 | $34 | $0 | $3 | $103 | $0 | $103 | $0 | $103 | $0 | 2 | 2 | $51 | $51 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $1,589 | $95,588 | $140 | $54,799 | $152,116 | $0 | $152,116 | $0 | $152,116 | $32 | 56 | 56 | $2,716 | $2,716 | ||
| 310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $924 | $4,937 | $12 | $15,999 | $21,872 | $0 | $21,872 | $0 | $21,872 | $32 | 13 | 25 | $1,682 | $875 | ||
| 311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $984 | $349,725 | $81 | $23,110 | $373,901 | $0 | $373,901 | $0 | $373,901 | ($32) | 14 | 28 | $26,707 | $13,354 | ||
| 312-BOCC RETIREE OVER 65 FAMILY | $1,291 | $63,759 | $168 | $2,896 | $68,114 | $0 | $68,114 | $0 | $68,114 | $0 | 12 | 49 | $5,676 | $1,390 | ||
| 367-EXPRESSWAY RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $33 | $0 | $0 | $2 | $34 | $0 | $34 | $0 | $34 | $0 | 1 | 1 | $34 | $34 | ||
| 370-SPORTS RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $39 | $259 | $0 | $164 | $461 | $0 | $461 | $0 | $461 | $0 | 1 | 1 | $461 | $461 | ||
| 377-COURT RETIREE OVER 65 SINGLE | $32 | $0 | $0 | $0 | $32 | $0 | $32 | $0 | $32 | $0 | 1 | 1 | $32 | $32 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $261 | $1,890 | ($19) | $1,130 | $3,263 | $0 | $3,263 | $0 | $3,263 | ($32) | 8 | 8 | $408 | $408 | ||
| 387-CLERK RETIREE OVER 65 PLUS SPOUSE (BOTH MEDICARE) | $66 | $652 | $0 | $14,818 | $15,537 | $0 | $15,537 | $0 | $15,537 | $0 | 1 | 2 | $15,537 | $7,769 | ||
| 388-CLERK RETIREE OVER 65 FAMILY | $33 | $59 | $0 | $36 | $128 | $0 | $128 | $0 | $128 | $0 | 1 | 1 | $128 | $128 | ||
| 803-BOCC COBRA | $59 | $2,489 | $0 | $5,546 | $8,094 | $0 | $8,094 | $0 | $8,094 | $189 | 6 | 12 | $1,349 | $675 | ||
| 822-CLERK COBRA | ($33) | ($379) | $0 | $0 | ($413) | $0 | ($413) | $0 | ($413) | $0 | 0 | 0 | $0 | $0 | ||
| 826-EXPRESSWAY OVER AGE DEP | ($98) | $0 | $0 | $0 | ($98) | $0 | ($98) | $0 | ($98) | $0 | 1 | 1 | ($98) | ($98) | ||
| BENEFIT OPTION Total | $293,301 | $4,281,901 | $30,833 | $1,637,173 | $6,243,208 | ($656) | $6,242,552 | $0 | $6,242,552 | ($1,514) | 3,385 | 7,924 | $1,844 | $788 | ||
| Jan-2022 Total | $430,360 | $5,577,596 | $57,857 | $1,913,537 | $7,979,350 | ($656) | $7,978,694 | $487,213 | $8,465,906 | ($2,460) | 5,763 | 12,515 | $1,384 | $638 | ||
| Feb-22 | HDHP MODERN PLAN | 002H-PROPERTY APPRAISERS ACTIVE | $3,933 | $6,324 | $1,100 | $1,496 | $12,854 | $0 | $12,854 | $7,548 | $20,402 | ($32) | 47 | 88 | $273 | $146 |
| 003-BOCC ACTIVE | $122,023 | $1,218,485 | $86,985 | $372,709 | $1,800,203 | $0 | $1,800,203 | $354,844 | $2,155,047 | ($1,262) | 1,934 | 3,825 | $931 | $471 | ||
| 017H-EXPRESSWAY ACTIVE | $1,188 | $9,234 | $200 | $53 | $10,675 | $0 | $10,675 | $11,585 | $22,261 | ($32) | 16 | 34 | $667 | $314 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $329 | $0 | $0 | $42 | $371 | $0 | $371 | $2,950 | $3,321 | $0 | 7 | 11 | $53 | $34 | ||
| 020-COURT ACTIVE | $896 | $1,625 | $200 | $6,223 | $8,944 | $0 | $8,944 | $2,868 | $11,812 | $0 | 12 | 30 | $745 | $298 | ||
| 021-C BOARD ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 1 | 2 | $0 | $0 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $660 | $14,484 | $600 | $3,376 | $19,121 | $0 | $19,121 | $2,593 | $21,713 | $0 | 9 | 20 | $2,125 | $956 | ||
| 022-CLERK ACTIVE | $13,970 | $43,119 | $2,775 | $52,844 | $112,708 | $0 | $112,708 | $45,742 | $158,450 | ($221) | 248 | 445 | $454 | $253 | ||
| 202-PROPERTY RETIREE UNDER 65 | $81 | $394 | $100 | $0 | $575 | $0 | $575 | $0 | $575 | $0 | 3 | 3 | $192 | $192 | ||
| 203-BOCC RETIREE UNDER 65 | $3,196 | $20,526 | $700 | $18,962 | $43,384 | $0 | $43,384 | $15,761 | $59,145 | ($32) | 74 | 95 | $586 | $457 | ||
| 218-SPORTS RETIREE UNDER 65 | $27 | $0 | $0 | $0 | $27 | $0 | $27 | $0 | $27 | $0 | 1 | 1 | $27 | $27 | ||
| 222-CLERK RETIREE UNDER 65 | $363 | $33,925 | $100 | $906 | $35,294 | $0 | $35,294 | $2,591 | $37,885 | $63 | 9 | 10 | $3,922 | $3,529 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $161 | $982 | $0 | $3,326 | $4,469 | $0 | $4,469 | $0 | $4,469 | $189 | 8 | 8 | $559 | $559 | ||
| 311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $54 | $0 | $0 | $0 | $54 | $0 | $54 | $0 | $54 | $32 | 0 | 0 | $0 | $0 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $54 | $337 | $0 | $481 | $872 | $0 | $872 | $0 | $872 | $63 | 3 | 3 | $291 | $291 | ||
| 803-BOCC COBRA | $9 | $0 | $0 | $0 | $9 | $0 | $9 | $0 | $9 | $0 | 0 | 0 | $0 | $0 | ||
| BENEFIT OPTION Total | $146,944 | $1,349,436 | $92,760 | $460,418 | $2,049,559 | $0 | $2,049,559 | $446,482 | $2,496,041 | ($1,230) | 2,372 | 4,575 | $864 | $448 | ||
| OAP COVERAGE NOW | 003-BOCC ACTIVE | $0 | ($372) | $0 | $0 | ($372) | $0 | ($372) | $0 | ($372) | $0 | 0 | 0 | $0 | $0 | |
| 022-CLERK ACTIVE | $0 | ($1,962) | ($128) | $0 | ($2,090) | $0 | ($2,090) | $0 | ($2,090) | $0 | 0 | 0 | $0 | $0 | ||
| 203-BOCC RETIREE UNDER 65 | $0 | ($28) | $0 | $0 | ($28) | $0 | ($28) | $0 | ($28) | $0 | 0 | 0 | $0 | $0 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $0 | ($20) | $0 | $0 | ($20) | $0 | ($20) | $0 | ($20) | $0 | 0 | 0 | $0 | $0 | ||
| BENEFIT OPTION Total | $0 | ($2,382) | ($128) | $0 | ($2,509) | $0 | ($2,509) | $0 | ($2,509) | $0 | 0 | 0 | $0 | $0 | ||
| OAP TRADITIONAL PLAN | 002-PROPERTY ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 3 | 5 | $0 | $0 | |
| 002H-PROPERTY APPRAISERS ACTIVE | $6,531 | $29,673 | $623 | $35,526 | $72,353 | $0 | $72,353 | $0 | $72,353 | $32 | 55 | 142 | $1,316 | $510 | ||
| 003-BOCC ACTIVE | $253,693 | $1,922,092 | $47,102 | $1,207,574 | $3,430,461 | $0 | $3,430,461 | $0 | $3,430,461 | ($2,050) | 2,582 | 6,380 | $1,329 | $538 | ||
| 017H-EXPRESSWAY ACTIVE | $837 | $8,136 | $400 | $1,755 | $11,127 | $0 | $11,127 | $0 | $11,127 | ($32) | 7 | 18 | $1,590 | $618 | ||
| 018-SPORTS ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 1 | 2 | $0 | $0 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $3,942 | $157,363 | $1,311 | $5,205 | $167,821 | $0 | $167,821 | $0 | $167,821 | ($63) | 40 | 101 | $4,196 | $1,662 | ||
| 020-COURT ACTIVE | $3,373 | $17,212 | $800 | $25,004 | $46,389 | $0 | $46,389 | $0 | $46,389 | $32 | 38 | 87 | $1,221 | $533 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $1,942 | $5,622 | $428 | $8,492 | $16,485 | $0 | $16,485 | $0 | $16,485 | $0 | 23 | 49 | $717 | $336 | ||
| 022-CLERK ACTIVE | $25,914 | $165,970 | $3,633 | $101,780 | $297,297 | $0 | $297,297 | $0 | $297,297 | ($158) | 282 | 605 | $1,054 | $491 | ||
| 202-PROPERTY RETIREE UNDER 65 | $493 | ($801) | $0 | $558 | $249 | $0 | $249 | $0 | $249 | $0 | 9 | 9 | $28 | $28 | ||
| 203-BOCC RETIREE UNDER 65 | $11,514 | $197,456 | $811 | $98,735 | $308,516 | $0 | $308,516 | $0 | $308,516 | ($378) | 184 | 253 | $1,677 | $1,219 | ||
| 218-SPORTS RETIREE UNDER 65 | $105 | $778 | $0 | $132 | $1,015 | $0 | $1,015 | $0 | $1,015 | $0 | 3 | 3 | $338 | $338 | ||
| 220-COURT RETIREE UNDER 65 | $121 | $128 | $0 | $232 | $480 | $0 | $480 | $0 | $480 | $0 | 3 | 3 | $160 | $160 | ||
| 221-C BOARD RETIREE UNDER 65 | $34 | $276 | $0 | $1,411 | $1,720 | $0 | $1,720 | $0 | $1,720 | $0 | 1 | 1 | $1,720 | $1,720 | ||
| 222-CLERK RETIREE UNDER 65 | $615 | $2,619 | $143 | $1,168 | $4,545 | $0 | $4,545 | $0 | $4,545 | ($32) | 12 | 14 | $379 | $325 | ||
| 305-PROPERTY RETIREE OVER 65 SINGLE | $67 | $108 | $0 | $487 | $662 | $0 | $662 | $0 | $662 | $0 | 2 | 2 | $331 | $331 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $1,798 | $23,133 | $356 | $73,331 | $98,618 | $0 | $98,618 | $0 | $98,618 | $126 | 58 | 58 | $1,700 | $1,700 | ||
| 310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $740 | ($2,153) | $17 | $12,852 | $11,456 | $0 | $11,456 | $0 | $11,456 | $63 | 14 | 27 | $818 | $424 | ||
| 311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $941 | $6,438 | $244 | $28,308 | $35,931 | $0 | $35,931 | $0 | $35,931 | ($32) | 14 | 28 | $2,567 | $1,283 | ||
| 312-BOCC RETIREE OVER 65 FAMILY | $1,959 | $54,977 | $168 | $2,820 | $59,923 | $0 | $59,923 | $0 | $59,923 | ($32) | 11 | 46 | $5,448 | $1,303 | ||
| 367-EXPRESSWAY RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $34 | $91 | $0 | $0 | $125 | $0 | $125 | $0 | $125 | $0 | 1 | 1 | $125 | $125 | ||
| 370-SPORTS RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $40 | $211 | $0 | $1,635 | $1,885 | $0 | $1,885 | $0 | $1,885 | $0 | 1 | 1 | $1,885 | $1,885 | ||
| 377-COURT RETIREE OVER 65 SINGLE | $32 | $0 | $0 | $0 | $32 | $0 | $32 | $0 | $32 | $0 | 1 | 1 | $32 | $32 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $266 | $3,501 | $37 | $573 | $4,378 | $0 | $4,378 | $0 | $4,378 | ($32) | 8 | 8 | $547 | $547 | ||
| 387-CLERK RETIREE OVER 65 PLUS SPOUSE (BOTH MEDICARE) | $67 | $111 | $0 | $15,040 | $15,218 | $0 | $15,218 | $0 | $15,218 | $0 | 1 | 2 | $15,218 | $7,609 | ||
| 388-CLERK RETIREE OVER 65 FAMILY | $34 | $191 | $0 | $36 | $261 | $0 | $261 | $0 | $261 | $0 | 1 | 1 | $261 | $261 | ||
| 803-BOCC COBRA | $547 | ($2,852) | $0 | $1,500 | ($805) | $0 | ($805) | $0 | ($805) | $158 | 5 | 6 | ($161) | ($134) | ||
| 826-EXPRESSWAY OVER AGE DEP | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 1 | 1 | $0 | $0 | ||
| BENEFIT OPTION Total | $315,637 | $2,590,276 | $56,073 | $1,624,155 | $4,586,141 | $0 | $4,586,141 | $0 | $4,586,141 | ($2,397) | 3,361 | 7,854 | $1,365 | $584 | ||
| Feb-2022 Total | $462,581 | $3,937,331 | $148,706 | $2,084,573 | $6,633,191 | $0 | $6,633,191 | $446,482 | $7,079,673 | ($3,627) | 5,733 | 12,429 | $1,157 | $534 | ||
| Mar-22 | HDHP MODERN PLAN | 002-PROPERTY ACTIVE | $65 | $0 | $0 | $0 | $65 | $0 | $65 | $0 | $65 | $0 | 0 | 0 | $0 | $0 |
| 002H-PROPERTY APPRAISERS ACTIVE | $2,079 | $32,634 | $300 | $4,900 | $39,912 | $0 | $39,912 | $10,757 | $50,669 | ($32) | 45 | 83 | $887 | $481 | ||
| 003-BOCC ACTIVE | $91,857 | $2,369,920 | $35,894 | $408,843 | $2,906,514 | ($205,528) | $2,700,986 | $347,251 | $3,048,237 | ($1,388) | 1,944 | 3,842 | $1,389 | $703 | ||
| 017H-EXPRESSWAY ACTIVE | $912 | $473 | $100 | $1,292 | $2,777 | $0 | $2,777 | $5,346 | $8,124 | $0 | 16 | 34 | $174 | $82 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $265 | $532 | $0 | $1,316 | $2,113 | $0 | $2,113 | $398 | $2,510 | $0 | 7 | 11 | $302 | $192 | ||
| 019H-ARTS ACTIVE | ($1) | $0 | $0 | $0 | ($1) | $0 | ($1) | $0 | ($1) | $0 | 0 | 0 | $0 | $0 | ||
| 020-COURT ACTIVE | $732 | $3,866 | $0 | $2,637 | $7,235 | $0 | $7,235 | $2,315 | $9,550 | $0 | 12 | 30 | $603 | $241 | ||
| 021-C BOARD ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 1 | 2 | $0 | $0 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $572 | $6,937 | $0 | $3,568 | $11,077 | $0 | $11,077 | $2,907 | $13,984 | $0 | 9 | 20 | $1,231 | $554 | ||
| 022-CLERK ACTIVE | $10,761 | $93,418 | $640 | $63,570 | $168,388 | $0 | $168,388 | $32,736 | $201,124 | ($473) | 246 | 437 | $685 | $385 | ||
| 202-PROPERTY RETIREE UNDER 65 | $74 | $0 | $0 | $0 | $74 | $0 | $74 | $0 | $74 | $0 | 3 | 3 | $25 | $25 | ||
| 203-BOCC RETIREE UNDER 65 | $2,735 | $27,300 | $100 | $31,603 | $61,737 | $0 | $61,737 | $13,227 | $74,965 | ($32) | 74 | 95 | $834 | $650 | ||
| 218-SPORTS RETIREE UNDER 65 | $15 | $0 | $0 | $0 | $15 | $0 | $15 | $0 | $15 | $0 | 1 | 1 | $15 | $15 | ||
| 220-COURT RETIREE UNDER 65 | ($3) | $0 | $0 | $0 | ($3) | $0 | ($3) | $0 | ($3) | $0 | 0 | 0 | $0 | $0 | ||
| 222-CLERK RETIREE UNDER 65 | $347 | $86,622 | $0 | $2,421 | $89,390 | $0 | $89,390 | $403 | $89,792 | ($32) | 9 | 10 | $9,932 | $8,939 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $114 | $8,807 | $0 | $7,218 | $16,139 | $0 | $16,139 | $0 | $16,139 | $221 | 9 | 9 | $1,793 | $1,793 | ||
| 311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $41 | $0 | $0 | $24 | $65 | $0 | $65 | $0 | $65 | $0 | 0 | 0 | $0 | $0 | ||
| 312-BOCC RETIREE OVER 65 FAMILY | ($12) | $0 | $0 | $0 | ($12) | $0 | ($12) | $0 | ($12) | $0 | 0 | 0 | $0 | $0 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $41 | $895 | $0 | $469 | $1,406 | $0 | $1,406 | $0 | $1,406 | $63 | 3 | 3 | $469 | $469 | ||
| 802-PROPERTY COBRA | ($2) | $0 | $0 | $0 | ($2) | $0 | ($2) | $0 | ($2) | $0 | 0 | 0 | $0 | $0 | ||
| 803-BOCC COBRA | $18 | $0 | $0 | $0 | $18 | $0 | $18 | $0 | $18 | $0 | 0 | 0 | $0 | $0 | ||
| 822-CLERK COBRA | ($17) | $0 | $0 | $0 | ($17) | $0 | ($17) | $0 | ($17) | $0 | 0 | 0 | $0 | $0 | ||
| BENEFIT OPTION Total | $110,595 | $2,631,403 | $37,034 | $527,860 | $3,306,892 | ($205,528) | $3,101,364 | $415,340 | $3,516,704 | ($1,672) | 2,379 | 4,580 | $1,304 | $677 | ||
| OAP COVERAGE NOW | 003-BOCC ACTIVE | $0 | ($41) | $0 | $0 | ($41) | $0 | ($41) | $0 | ($41) | $0 | 0 | 0 | $0 | $0 | |
| 022-CLERK ACTIVE | $0 | ($94) | $0 | $0 | ($94) | $0 | ($94) | $0 | ($94) | $0 | 0 | 0 | $0 | $0 | ||
| 203-BOCC RETIREE UNDER 65 | $0 | ($88) | $0 | $0 | ($88) | $0 | ($88) | $0 | ($88) | $0 | 0 | 0 | $0 | $0 | ||
| BENEFIT OPTION Total | $0 | ($223) | $0 | $0 | ($223) | $0 | ($223) | $0 | ($223) | $0 | 0 | 0 | $0 | $0 | ||
| OAP TRADITIONAL PLAN | 002-PROPERTY ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 3 | 5 | $0 | $0 | |
| 002H-PROPERTY APPRAISERS ACTIVE | $4,714 | $29,435 | $614 | $60,345 | $95,108 | $0 | $95,108 | $0 | $95,108 | $0 | 56 | 144 | $1,698 | $660 | ||
| 003-BOCC ACTIVE | $199,729 | $3,265,541 | $77,683 | $1,234,344 | $4,777,297 | $13,229 | $4,790,526 | $0 | $4,790,526 | ($2,271) | 2,574 | 6,346 | $1,861 | $755 | ||
| 017H-EXPRESSWAY ACTIVE | $523 | $4,216 | $100 | $329 | $5,169 | $0 | $5,169 | $0 | $5,169 | $0 | 7 | 18 | $738 | $287 | ||
| 018-SPORTS ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 1 | 2 | $0 | $0 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $4,279 | $140,545 | $400 | $7,746 | $152,970 | $0 | $152,970 | $0 | $152,970 | $0 | 40 | 101 | $3,824 | $1,515 | ||
| 020-COURT ACTIVE | $2,949 | $45,157 | $0 | $13,250 | $61,356 | $0 | $61,356 | $0 | $61,356 | $0 | 38 | 87 | $1,615 | $705 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $1,648 | $3,665 | $513 | $10,518 | $16,343 | $0 | $16,343 | $0 | $16,343 | ($32) | 22 | 47 | $743 | $348 | ||
| 022-CLERK ACTIVE | $19,323 | $391,096 | $1,852 | $78,199 | $490,470 | $0 | $490,470 | $0 | $490,470 | ($221) | 281 | 603 | $1,745 | $813 | ||
| 202-PROPERTY RETIREE UNDER 65 | $239 | $27,641 | $2,086 | $650 | $30,616 | $0 | $30,616 | $0 | $30,616 | $0 | 9 | 9 | $3,402 | $3,402 | ||
| 203-BOCC RETIREE UNDER 65 | $8,422 | $186,023 | $8,881 | $92,239 | $295,565 | $0 | $295,565 | $0 | $295,565 | ($725) | 180 | 246 | $1,642 | $1,201 | ||
| 217-EXPRESSWAY RETIREE UNDER 65 | ($3) | $0 | $0 | $0 | ($3) | $0 | ($3) | $0 | ($3) | $0 | 0 | 0 | $0 | $0 | ||
| 218-SPORTS RETIREE UNDER 65 | $90 | $95 | $0 | $0 | $185 | $0 | $185 | $0 | $185 | $0 | 3 | 3 | $62 | $62 | ||
| 220-COURT RETIREE UNDER 65 | $102 | $10 | $0 | $606 | $718 | $0 | $718 | $0 | $718 | $0 | 3 | 3 | $239 | $239 | ||
| 221-C BOARD RETIREE UNDER 65 | $27 | $176 | $0 | $1,058 | $1,261 | $0 | $1,261 | $0 | $1,261 | $0 | 1 | 1 | $1,261 | $1,261 | ||
| 222-CLERK RETIREE UNDER 65 | $433 | $1,040 | $0 | $1,740 | $3,214 | $0 | $3,214 | $0 | $3,214 | ($95) | 11 | 13 | $292 | $247 | ||
| 305-PROPERTY RETIREE OVER 65 SINGLE | $55 | $1,750 | $0 | $26 | $1,831 | $0 | $1,831 | $0 | $1,831 | $0 | 2 | 2 | $916 | $916 | ||
| 307-PROPERTY RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | ($12) | $0 | $0 | $0 | ($12) | $0 | ($12) | $0 | ($12) | $0 | 0 | 0 | $0 | $0 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $1,444 | $27,117 | $7,813 | $90,791 | $127,165 | $0 | $127,165 | $0 | $127,165 | $63 | 58 | 58 | $2,192 | $2,192 | ||
| 310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $854 | $5,041 | $0 | $12,959 | $18,854 | $0 | $18,854 | $0 | $18,854 | $63 | 14 | 27 | $1,347 | $698 | ||
| 311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $617 | $4,932 | $214 | $28,820 | $34,583 | $0 | $34,583 | $0 | $34,583 | ($32) | 14 | 28 | $2,470 | $1,235 | ||
| 312-BOCC RETIREE OVER 65 FAMILY | $1,612 | $64,099 | $2,654 | $2,366 | $70,731 | $0 | $70,731 | $0 | $70,731 | ($32) | 12 | 47 | $5,894 | $1,505 | ||
| 367-EXPRESSWAY RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $26 | $41 | $0 | $0 | $67 | $0 | $67 | $0 | $67 | $0 | 1 | 1 | $67 | $67 | ||
| 370-SPORTS RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $33 | $89 | $0 | $1,580 | $1,703 | $0 | $1,703 | $0 | $1,703 | $0 | 1 | 1 | $1,703 | $1,703 | ||
| 377-COURT RETIREE OVER 65 SINGLE | $26 | $0 | $0 | $0 | $26 | $0 | $26 | $0 | $26 | $0 | 1 | 1 | $26 | $26 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $88 | $1,271 | $6,736 | $2,006 | $10,101 | $0 | $10,101 | $0 | $10,101 | ($32) | 8 | 8 | $1,263 | $1,263 | ||
| 387-CLERK RETIREE OVER 65 PLUS SPOUSE (BOTH MEDICARE) | $55 | $420 | $0 | $15,193 | $15,668 | $0 | $15,668 | $0 | $15,668 | $0 | 1 | 2 | $15,668 | $7,834 | ||
| 388-CLERK RETIREE OVER 65 FAMILY | $27 | $509 | $0 | $189 | $725 | $0 | $725 | $0 | $725 | $0 | 1 | 1 | $725 | $725 | ||
| 803-BOCC COBRA | $209 | ($95) | $0 | $1,465 | $1,579 | $0 | $1,579 | $0 | $1,579 | $158 | 5 | 6 | $316 | $263 | ||
| 822-CLERK COBRA | ($4) | $17,899 | $0 | $0 | $17,895 | $0 | $17,895 | $0 | $17,895 | $0 | 0 | 0 | $0 | $0 | ||
| 826-EXPRESSWAY OVER AGE DEP | ($1) | $0 | $0 | $0 | ($1) | $0 | ($1) | $0 | ($1) | $0 | 1 | 1 | ($1) | ($1) | ||
| BENEFIT OPTION Total | $247,505 | $4,217,712 | $109,546 | $1,656,421 | $6,231,185 | $13,229 | $6,244,414 | $0 | $6,244,414 | ($3,154) | 3,348 | 7,811 | $1,865 | $799 | ||
| Mar-2022 Total | $358,100 | $6,848,893 | $146,580 | $2,184,281 | $9,537,854 | ($192,299) | $9,345,555 | $415,340 | $9,760,895 | ($4,826) | 5,727 | 12,391 | $1,632 | $754 | ||
| Apr-22 | HDHP MODERN PLAN | 002H-PROPERTY APPRAISERS ACTIVE | $2,580 | $12,438 | $0 | $5,147 | $20,164 | $0 | $20,164 | $4,580 | $24,744 | $0 | 44 | 82 | $458 | $246 |
| 003-BOCC ACTIVE | $119,488 | $1,425,920 | $9,746 | $320,672 | $1,875,825 | ($4,827) | $1,870,998 | $289,596 | $2,160,594 | ($617) | 1,949 | 3,848 | $960 | $486 | ||
| 017H-EXPRESSWAY ACTIVE | $1,122 | $9,282 | $0 | $351 | $10,755 | $0 | $10,755 | $3,825 | $14,580 | $0 | 17 | 37 | $633 | $291 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $329 | $17 | $100 | $42 | $488 | $0 | $488 | $409 | $898 | $0 | 7 | 11 | $70 | $44 | ||
| 020-COURT ACTIVE | $897 | $5,913 | $0 | $3,977 | $10,787 | $0 | $10,787 | $1,979 | $12,766 | ($32) | 11 | 25 | $981 | $431 | ||
| 021-C BOARD ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 1 | 2 | $0 | $0 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $680 | $2,177 | $0 | $3,416 | $6,273 | $0 | $6,273 | $1,938 | $8,211 | $0 | 9 | 20 | $697 | $314 | ||
| 022-CLERK ACTIVE | $13,491 | $76,209 | $200 | $76,328 | $166,228 | $0 | $166,228 | $38,041 | $204,268 | ($63) | 251 | 439 | $662 | $379 | ||
| 202-PROPERTY RETIREE UNDER 65 | $81 | $537 | $0 | $40 | $657 | $0 | $657 | $254 | $911 | $0 | 3 | 3 | $219 | $219 | ||
| 203-BOCC RETIREE UNDER 65 | $3,165 | $23,694 | $0 | $23,090 | $49,949 | $0 | $49,949 | $10,045 | $59,994 | ($126) | 72 | 94 | $694 | $531 | ||
| 218-SPORTS RETIREE UNDER 65 | $27 | $0 | $0 | $0 | $27 | $0 | $27 | $0 | $27 | $0 | 1 | 1 | $27 | $27 | ||
| 222-CLERK RETIREE UNDER 65 | $417 | $11,179 | $0 | $4,517 | $16,113 | $0 | $16,113 | $2,860 | $18,973 | ($32) | 10 | 14 | $1,611 | $1,151 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $188 | $1,192 | $0 | $4,634 | $6,014 | $0 | $6,014 | $0 | $6,014 | $221 | 9 | 9 | $668 | $668 | ||
| 311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $54 | $0 | $0 | $0 | $54 | $0 | $54 | $0 | $54 | $0 | 0 | 0 | $0 | $0 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $54 | $621 | $0 | $514 | $1,188 | $0 | $1,188 | $0 | $1,188 | $95 | 4 | 4 | $297 | $297 | ||
| 803-BOCC COBRA | ($1) | $0 | $0 | $0 | ($1) | $0 | ($1) | $0 | ($1) | $0 | 0 | 0 | $0 | $0 | ||
| BENEFIT OPTION Total | $142,571 | $1,569,178 | $10,046 | $442,727 | $2,164,521 | ($4,827) | $2,159,694 | $353,527 | $2,513,221 | ($554) | 2,388 | 4,589 | $904 | $471 | ||
| OAP COVERAGE NOW | 003-BOCC ACTIVE | $0 | ($650) | $0 | $0 | ($650) | $0 | ($650) | $0 | ($650) | $0 | 0 | 0 | $0 | $0 | |
| BENEFIT OPTION Total | $0 | ($650) | $0 | $0 | ($650) | $0 | ($650) | $0 | ($650) | $0 | 0 | 0 | $0 | $0 | ||
| OAP TRADITIONAL PLAN | 002-PROPERTY ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 3 | 5 | $0 | $0 | |
| 002H-PROPERTY APPRAISERS ACTIVE | $5,705 | $48,375 | $267 | $33,680 | $88,027 | $0 | $88,027 | $0 | $88,027 | ($63) | 54 | 138 | $1,630 | $638 | ||
| 003-BOCC ACTIVE | $243,030 | $3,107,508 | $68,357 | $1,393,623 | $4,812,518 | $0 | $4,812,518 | $0 | $4,812,518 | ($1,451) | 2,560 | 6,313 | $1,880 | $762 | ||
| 017H-EXPRESSWAY ACTIVE | $653 | $3,909 | $0 | $756 | $5,318 | $0 | $5,318 | $0 | $5,318 | $0 | 6 | 16 | $886 | $332 | ||
| 018-SPORTS ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 1 | 2 | $0 | $0 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $3,869 | $41,533 | $311 | $9,538 | $55,252 | $0 | $55,252 | $0 | $55,252 | ($63) | 38 | 97 | $1,454 | $570 | ||
| 020-COURT ACTIVE | $3,508 | $25,334 | $311 | $20,123 | $49,277 | $0 | $49,277 | $0 | $49,277 | $32 | 39 | 90 | $1,264 | $548 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $1,851 | $16,071 | $414 | $19,609 | $37,945 | $0 | $37,945 | $0 | $37,945 | $0 | 22 | 47 | $1,725 | $807 | ||
| 022-CLERK ACTIVE | $23,273 | $310,915 | $1,362 | $84,326 | $419,876 | $0 | $419,876 | $0 | $419,876 | ($189) | 278 | 595 | $1,510 | $706 | ||
| 202-PROPERTY RETIREE UNDER 65 | $333 | $4,532 | $131 | $849 | $5,844 | $0 | $5,844 | $0 | $5,844 | $0 | 9 | 9 | $649 | $649 | ||
| 203-BOCC RETIREE UNDER 65 | $10,570 | $461,466 | $31 | $118,934 | $591,001 | $0 | $591,001 | $0 | $591,001 | ($378) | 180 | 245 | $3,283 | $2,412 | ||
| 218-SPORTS RETIREE UNDER 65 | $105 | $796 | $0 | $291 | $1,191 | $0 | $1,191 | $0 | $1,191 | $0 | 3 | 3 | $397 | $397 | ||
| 220-COURT RETIREE UNDER 65 | $121 | $160 | $0 | $1,790 | $2,071 | $0 | $2,071 | $0 | $2,071 | $0 | 3 | 3 | $690 | $690 | ||
| 221-C BOARD RETIREE UNDER 65 | $34 | $1,619 | $0 | $1,083 | $2,735 | $0 | $2,735 | $0 | $2,735 | $0 | 1 | 1 | $2,735 | $2,735 | ||
| 222-CLERK RETIREE UNDER 65 | $688 | $2,685 | $141 | $1,226 | $4,739 | $0 | $4,739 | $0 | $4,739 | ($63) | 12 | 13 | $395 | $365 | ||
| 305-PROPERTY RETIREE OVER 65 SINGLE | $67 | $189 | $0 | $18 | $274 | $0 | $274 | $0 | $274 | $0 | 2 | 2 | $137 | $137 | ||
| 307-PROPERTY RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ($32) | 0 | 0 | $0 | $0 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $1,789 | $55,536 | $2,744 | $152,654 | $212,723 | $0 | $212,723 | $0 | $212,723 | ($32) | 57 | 57 | $3,732 | $3,732 | ||
| 310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $927 | $1,948 | $0 | $13,906 | $16,782 | $0 | $16,782 | $0 | $16,782 | $0 | 14 | 27 | $1,199 | $622 | ||
| 311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $874 | $7,361 | $78 | $40,107 | $48,420 | $0 | $48,420 | $0 | $48,420 | $0 | 13 | 26 | $3,725 | $1,862 | ||
| 312-BOCC RETIREE OVER 65 FAMILY | $1,986 | $15,905 | $266 | $2,566 | $20,723 | $0 | $20,723 | $0 | $20,723 | ($32) | 12 | 46 | $1,727 | $451 | ||
| 367-EXPRESSWAY RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $34 | $191 | $0 | $119 | $344 | $0 | $344 | $0 | $344 | $0 | 1 | 1 | $344 | $344 | ||
| 370-SPORTS RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $40 | $1,904 | $0 | $278 | $2,222 | $0 | $2,222 | $0 | $2,222 | $0 | 1 | 1 | $2,222 | $2,222 | ||
| 377-COURT RETIREE OVER 65 SINGLE | $32 | $0 | $0 | $0 | $32 | $0 | $32 | $0 | $32 | $0 | 1 | 1 | $32 | $32 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $233 | $57 | $60 | $309 | $658 | $0 | $658 | $0 | $658 | $0 | 8 | 8 | $82 | $82 | ||
| 387-CLERK RETIREE OVER 65 PLUS SPOUSE (BOTH MEDICARE) | $67 | $239 | $0 | $15,242 | $15,549 | $0 | $15,549 | $0 | $15,549 | $0 | 1 | 2 | $15,549 | $7,774 | ||
| 388-CLERK RETIREE OVER 65 FAMILY | $34 | $0 | $0 | $0 | $34 | $0 | $34 | $0 | $34 | ($32) | 0 | 0 | $0 | $0 | ||
| 803-BOCC COBRA | $330 | $2,253 | $0 | $1,240 | $3,823 | $0 | $3,823 | $0 | $3,823 | $158 | 5 | 6 | $765 | $637 | ||
| 822-CLERK COBRA | $0 | ($844) | $0 | $0 | ($844) | $0 | ($844) | $0 | ($844) | $0 | 0 | 0 | $0 | $0 | ||
| 826-EXPRESSWAY OVER AGE DEP | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 1 | 1 | $0 | $0 | ||
| BENEFIT OPTION Total | $300,151 | $4,109,642 | $74,473 | $1,912,268 | $6,396,533 | $0 | $6,396,533 | $0 | $6,396,533 | ($2,145) | 3,325 | 7,755 | $1,924 | $825 | ||
| Apr-2022 Total | $442,721 | $5,678,170 | $84,518 | $2,354,995 | $8,560,404 | ($4,827) | $8,555,577 | $353,527 | $8,909,105 | ($2,699) | 5,713 | 12,344 | $1,498 | $693 | ||
| May-22 | HDHP MODERN PLAN | 002H-PROPERTY APPRAISERS ACTIVE | $2,533 | $5,096 | $100 | $4,615 | $12,344 | $0 | $12,344 | $13,573 | $25,917 | $1,356 | 43 | 79 | $287 | $156 |
| 003-BOCC ACTIVE | $119,617 | $1,239,115 | $3,990 | $462,241 | $1,824,963 | ($3,778) | $1,821,185 | $321,843 | $2,143,028 | $61,093 | 1,937 | 3,830 | $940 | $476 | ||
| 017H-EXPRESSWAY ACTIVE | $1,203 | $10,256 | $0 | $662 | $12,120 | $0 | $12,120 | $5,344 | $17,464 | $536 | 17 | 37 | $713 | $328 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $329 | $474 | $0 | $21 | $824 | $0 | $824 | $2,274 | $3,099 | $221 | 7 | 11 | $118 | $75 | ||
| 019H-ARTS ACTIVE | $0 | $16 | $0 | $0 | $16 | $0 | $16 | $0 | $16 | $0 | 0 | 0 | $0 | $0 | ||
| 020-COURT ACTIVE | $763 | $800 | $0 | $6,763 | $8,326 | $0 | $8,326 | $2,346 | $10,672 | $378 | 12 | 26 | $694 | $320 | ||
| 021-C BOARD ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 1 | 2 | $0 | $0 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $680 | $1,586 | $0 | $3,965 | $6,231 | $0 | $6,231 | $5,264 | $11,494 | $347 | 10 | 21 | $623 | $297 | ||
| 022-CLERK ACTIVE | $13,352 | $105,027 | $200 | $85,320 | $203,899 | $0 | $203,899 | $48,195 | $252,094 | $7,853 | 249 | 435 | $819 | $469 | ||
| 202-PROPERTY RETIREE UNDER 65 | $81 | $0 | $0 | $0 | $81 | $0 | $81 | $0 | $81 | $95 | 3 | 3 | $27 | $27 | ||
| 203-BOCC RETIREE UNDER 65 | $3,961 | $18,865 | $0 | $19,148 | $41,974 | $0 | $41,974 | $11,948 | $53,921 | $2,397 | 73 | 95 | $575 | $442 | ||
| 218-SPORTS RETIREE UNDER 65 | $27 | $0 | $0 | $0 | $27 | $0 | $27 | $0 | $27 | $32 | 1 | 1 | $27 | $27 | ||
| 222-CLERK RETIREE UNDER 65 | $328 | $94,093 | $100 | $7,478 | $101,999 | $0 | $101,999 | $530 | $102,529 | $347 | 10 | 14 | $10,200 | $7,286 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $188 | $607 | $0 | $3,895 | $4,691 | $0 | $4,691 | $0 | $4,691 | $221 | 9 | 9 | $521 | $521 | ||
| 311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | ($8) | $0 | $0 | $0 | ($8) | $0 | ($8) | $0 | ($8) | $0 | 0 | 0 | $0 | $0 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $84 | $514 | $0 | $505 | $1,103 | $0 | $1,103 | $0 | $1,103 | $95 | 4 | 4 | $276 | $276 | ||
| BENEFIT OPTION Total | $143,137 | $1,476,448 | $4,390 | $594,614 | $2,218,588 | ($3,778) | $2,214,810 | $411,316 | $2,626,126 | $74,971 | 2,376 | 4,567 | $932 | $485 | ||
| OAP TRADITIONAL PLAN | 002-PROPERTY ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 3 | 5 | $0 | $0 | |
| 002H-PROPERTY APPRAISERS ACTIVE | $5,515 | $61,938 | $929 | $78,765 | $147,146 | $0 | $147,146 | $0 | $147,146 | $1,829 | 55 | 139 | $2,675 | $1,059 | ||
| 003-BOCC ACTIVE | $240,667 | $3,109,101 | $62,216 | $1,416,764 | $4,828,748 | $0 | $4,828,748 | $0 | $4,828,748 | $80,269 | 2,551 | 6,267 | $1,893 | $771 | ||
| 017H-EXPRESSWAY ACTIVE | $601 | $3,354 | $0 | $1,411 | $5,366 | $0 | $5,366 | $0 | $5,366 | $189 | 6 | 16 | $894 | $335 | ||
| 018-SPORTS ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 1 | 2 | $0 | $0 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $3,724 | $33,282 | $0 | $6,070 | $43,077 | $0 | $43,077 | $0 | $43,077 | $1,167 | 37 | 93 | $1,164 | $463 | ||
| 020-COURT ACTIVE | $5,521 | $35,537 | $0 | $18,023 | $59,081 | $0 | $59,081 | $0 | $59,081 | $1,230 | 39 | 90 | $1,515 | $656 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $1,865 | $20,320 | $241 | $8,496 | $30,921 | $0 | $30,921 | $0 | $30,921 | $694 | 22 | 47 | $1,406 | $658 | ||
| 022-CLERK ACTIVE | $22,896 | $230,673 | $1,358 | $94,250 | $349,178 | $0 | $349,178 | $0 | $349,178 | $8,768 | 278 | 596 | $1,256 | $586 | ||
| 202-PROPERTY RETIREE UNDER 65 | $333 | $27,685 | $628 | $544 | $29,190 | $0 | $29,190 | $0 | $29,190 | $284 | 9 | 9 | $3,243 | $3,243 | ||
| 203-BOCC RETIREE UNDER 65 | $9,497 | $294,097 | $250 | $106,453 | $410,298 | $0 | $410,298 | $0 | $410,298 | $5,993 | 182 | 245 | $2,254 | $1,675 | ||
| 218-SPORTS RETIREE UNDER 65 | $105 | $538 | $0 | $370 | $1,013 | $0 | $1,013 | $0 | $1,013 | $95 | 3 | 3 | $338 | $338 | ||
| 220-COURT RETIREE UNDER 65 | $121 | $268 | $0 | $494 | $883 | $0 | $883 | $0 | $883 | $95 | 3 | 3 | $294 | $294 | ||
| 221-C BOARD RETIREE UNDER 65 | $34 | $37 | $0 | $1,395 | $1,466 | $0 | $1,466 | $0 | $1,466 | $32 | 1 | 1 | $1,466 | $1,466 | ||
| 222-CLERK RETIREE UNDER 65 | $282 | $1,692 | $0 | $1,016 | $2,990 | $0 | $2,990 | $0 | $2,990 | $378 | 12 | 13 | $249 | $230 | ||
| 305-PROPERTY RETIREE OVER 65 SINGLE | $67 | $165 | $0 | $15 | $247 | $0 | $247 | $0 | $247 | $63 | 2 | 2 | $123 | $123 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $1,808 | $105,789 | $6,164 | $97,445 | $211,206 | $0 | $211,206 | $0 | $211,206 | $1,672 | 58 | 58 | $3,641 | $3,641 | ||
| 310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $885 | $11,550 | $0 | $14,696 | $27,130 | $0 | $27,130 | $0 | $27,130 | $347 | 12 | 23 | $2,261 | $1,180 | ||
| 311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $874 | $66,464 | $1,040 | $22,935 | $91,313 | $0 | $91,313 | $0 | $91,313 | $410 | 13 | 26 | $7,024 | $3,512 | ||
| 312-BOCC RETIREE OVER 65 FAMILY | $1,833 | $48,100 | $0 | $2,908 | $52,841 | $0 | $52,841 | $0 | $52,841 | $442 | 11 | 45 | $4,804 | $1,174 | ||
| 367-EXPRESSWAY RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $34 | $18 | $0 | $134 | $186 | $0 | $186 | $0 | $186 | $32 | 1 | 1 | $186 | $186 | ||
| 370-SPORTS RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $40 | $615 | $0 | $1,769 | $2,423 | $0 | $2,423 | $0 | $2,423 | $32 | 1 | 1 | $2,423 | $2,423 | ||
| 377-COURT RETIREE OVER 65 SINGLE | $32 | $0 | $0 | $0 | $32 | $0 | $32 | $0 | $32 | $32 | 1 | 1 | $32 | $32 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $233 | $1,060 | $30 | $564 | $1,887 | $0 | $1,887 | $0 | $1,887 | $221 | 8 | 8 | $236 | $236 | ||
| 387-CLERK RETIREE OVER 65 PLUS SPOUSE (BOTH MEDICARE) | $67 | $1,004 | $0 | $15,172 | $16,244 | $0 | $16,244 | $0 | $16,244 | $32 | 1 | 2 | $16,244 | $8,122 | ||
| 803-BOCC COBRA | $174 | $940 | $0 | $791 | $1,905 | $0 | $1,905 | $0 | $1,905 | $126 | 4 | 4 | $476 | $476 | ||
| 826-EXPRESSWAY OVER AGE DEP | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 1 | 1 | $0 | $0 | ||
| BENEFIT OPTION Total | $297,206 | $4,054,227 | $72,856 | $1,890,480 | $6,314,769 | $0 | $6,314,769 | $0 | $6,314,769 | $104,429 | 3,315 | 7,701 | $1,905 | $820 | ||
| May-2022 Total | $440,343 | $5,530,675 | $77,246 | $2,485,093 | $8,533,357 | ($3,778) | $8,529,579 | $411,316 | $8,940,895 | $179,400 | 5,691 | 12,268 | $1,499 | $695 | ||
| Jun-22 | HDHP MODERN PLAN | 002H-PROPERTY APPRAISERS ACTIVE | $2,445 | $7,520 | $100 | $3,521 | $13,586 | $0 | $13,586 | $6,880 | $20,466 | $1,356 | 43 | 80 | $316 | $170 |
| 003-BOCC ACTIVE | $119,883 | $1,470,602 | $3,820 | $432,149 | $2,026,454 | ($5,623) | $2,020,831 | $277,475 | $2,298,306 | $60,778 | 1,923 | 3,803 | $1,051 | $531 | ||
| 017H-EXPRESSWAY ACTIVE | $2,372 | $3,656 | $0 | $1,813 | $7,842 | $0 | $7,842 | $6,883 | $14,725 | $536 | 17 | 37 | $461 | $212 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $329 | $25 | $0 | $1,328 | $1,682 | $0 | $1,682 | $2,250 | $3,932 | $252 | 8 | 13 | $210 | $129 | ||
| 020-COURT ACTIVE | $790 | $3,558 | $0 | $3,609 | $7,957 | $0 | $7,957 | $1,757 | $9,714 | $378 | 12 | 26 | $663 | $306 | ||
| 021-C BOARD ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 1 | 2 | $0 | $0 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $707 | $1,619 | $0 | $4,023 | $6,349 | $0 | $6,349 | $3,229 | $9,578 | $347 | 10 | 21 | $635 | $302 | ||
| 022-CLERK ACTIVE | $13,460 | $219,798 | $1,511 | $82,275 | $317,042 | $0 | $317,042 | $38,299 | $355,341 | $8,106 | 257 | 445 | $1,234 | $712 | ||
| 202-PROPERTY RETIREE UNDER 65 | $81 | $0 | $0 | $40 | $121 | $0 | $121 | $85 | $206 | $95 | 3 | 3 | $40 | $40 | ||
| 203-BOCC RETIREE UNDER 65 | $4,070 | $10,223 | $0 | $31,972 | $46,265 | $0 | $46,265 | $11,700 | $57,965 | $2,429 | 74 | 95 | $625 | $487 | ||
| 218-SPORTS RETIREE UNDER 65 | $27 | $0 | $0 | $0 | $27 | $0 | $27 | $0 | $27 | $32 | 1 | 1 | $27 | $27 | ||
| 222-CLERK RETIREE UNDER 65 | $467 | $15 | $0 | $11,810 | $12,292 | $0 | $12,292 | ($239) | $12,053 | $347 | 10 | 14 | $1,229 | $878 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $188 | $0 | $0 | $4,967 | $5,155 | $0 | $5,155 | $0 | $5,155 | $221 | 9 | 9 | $573 | $573 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $81 | $68 | $0 | $539 | $688 | $0 | $688 | $0 | $688 | $95 | 4 | 4 | $172 | $172 | ||
| 803-BOCC COBRA | ($22) | ($146) | $0 | $0 | ($168) | $0 | ($168) | $0 | ($168) | $32 | 1 | 1 | ($168) | ($168) | ||
| BENEFIT OPTION Total | $144,876 | $1,716,939 | $5,430 | $578,046 | $2,445,291 | ($5,623) | $2,439,668 | $348,318 | $2,787,986 | $75,002 | 2,373 | 4,554 | $1,028 | $536 | ||
| OAP COVERAGE NOW | 003-BOCC ACTIVE | $0 | ($79,055) | $0 | $0 | ($79,055) | $0 | ($79,055) | $0 | ($79,055) | $0 | 0 | 0 | $0 | $0 | |
| BENEFIT OPTION Total | $0 | ($79,055) | $0 | $0 | ($79,055) | $0 | ($79,055) | $0 | ($79,055) | $0 | 0 | 0 | $0 | $0 | ||
| OAP TRADITIONAL PLAN | 002-PROPERTY ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 3 | 5 | $0 | $0 | |
| 002H-PROPERTY APPRAISERS ACTIVE | $5,548 | $25,115 | $650 | $34,561 | $65,875 | $0 | $65,875 | $0 | $65,875 | $1,829 | 55 | 138 | $1,198 | $477 | ||
| 003-BOCC ACTIVE | $248,985 | $3,351,602 | $12,215 | $1,284,218 | $4,897,021 | $0 | $4,897,021 | $0 | $4,897,021 | $79,922 | 2,540 | 6,235 | $1,928 | $785 | ||
| 017H-EXPRESSWAY ACTIVE | $601 | $4,060 | $0 | $1,123 | $5,784 | $0 | $5,784 | $0 | $5,784 | $189 | 6 | 16 | $964 | $361 | ||
| 018-SPORTS ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 1 | 2 | $0 | $0 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $3,569 | $58,923 | $100 | $9,861 | $72,453 | $0 | $72,453 | $0 | $72,453 | $1,135 | 35 | 89 | $2,070 | $814 | ||
| 020-COURT ACTIVE | $5,087 | $42,739 | $520 | $20,222 | $68,568 | $0 | $68,568 | $0 | $68,568 | $1,167 | 37 | 83 | $1,853 | $826 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $3,355 | $39,482 | $274 | $8,538 | $51,649 | $0 | $51,649 | $0 | $51,649 | $725 | 23 | 48 | $2,246 | $1,076 | ||
| 022-CLERK ACTIVE | $23,168 | $323,285 | $907 | $96,009 | $443,369 | $0 | $443,369 | $0 | $443,369 | $8,800 | 279 | 596 | $1,589 | $744 | ||
| 202-PROPERTY RETIREE UNDER 65 | $333 | $2,712 | ($1,253) | $1,385 | $3,176 | $0 | $3,176 | $0 | $3,176 | $284 | 9 | 9 | $353 | $353 | ||
| 203-BOCC RETIREE UNDER 65 | $14,153 | $110,046 | $1,820 | $87,031 | $213,051 | $0 | $213,051 | $0 | $213,051 | $5,898 | 182 | 245 | $1,171 | $870 | ||
| 218-SPORTS RETIREE UNDER 65 | $105 | $1,408 | $0 | $291 | $1,803 | $0 | $1,803 | $0 | $1,803 | $95 | 3 | 3 | $601 | $601 | ||
| 220-COURT RETIREE UNDER 65 | $121 | $719 | $0 | $251 | $1,091 | $0 | $1,091 | $0 | $1,091 | $95 | 3 | 3 | $364 | $364 | ||
| 221-C BOARD RETIREE UNDER 65 | $34 | $42 | $0 | $1,219 | $1,295 | $0 | $1,295 | $0 | $1,295 | $32 | 1 | 1 | $1,295 | $1,295 | ||
| 222-CLERK RETIREE UNDER 65 | $499 | $3,605 | $80 | $964 | $5,148 | $0 | $5,148 | $0 | $5,148 | $378 | 12 | 13 | $429 | $396 | ||
| 305-PROPERTY RETIREE OVER 65 SINGLE | $67 | $0 | $0 | $6 | $73 | $0 | $73 | $0 | $73 | $63 | 2 | 2 | $37 | $37 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $7,834 | $8,467 | $458 | $55,317 | $72,076 | $0 | $72,076 | $0 | $72,076 | $1,766 | 58 | 58 | $1,243 | $1,243 | ||
| 310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $750 | $3,371 | $22 | $14,643 | $18,786 | $0 | $18,786 | $0 | $18,786 | $315 | 11 | 21 | $1,708 | $895 | ||
| 311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $877 | $8,225 | $244 | $35,348 | $44,694 | $0 | $44,694 | $0 | $44,694 | $442 | 14 | 28 | $3,192 | $1,596 | ||
| 312-BOCC RETIREE OVER 65 FAMILY | $1,885 | $60,892 | $100 | $1,786 | $64,663 | $0 | $64,663 | $0 | $64,663 | $410 | 10 | 42 | $6,466 | $1,540 | ||
| 367-EXPRESSWAY RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $34 | $0 | $77 | $0 | $110 | $0 | $110 | $0 | $110 | $32 | 1 | 1 | $110 | $110 | ||
| 370-SPORTS RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $40 | $422 | $0 | $1,728 | $2,189 | $0 | $2,189 | $0 | $2,189 | $32 | 1 | 1 | $2,189 | $2,189 | ||
| 377-COURT RETIREE OVER 65 SINGLE | $32 | $0 | $0 | $0 | $32 | $0 | $32 | $0 | $32 | $32 | 1 | 1 | $32 | $32 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $233 | $555 | $0 | $1,011 | $1,798 | $0 | $1,798 | $0 | $1,798 | $221 | 8 | 8 | $225 | $225 | ||
| 387-CLERK RETIREE OVER 65 PLUS SPOUSE (BOTH MEDICARE) | $67 | ($7) | $0 | $15,966 | $16,027 | $0 | $16,027 | $0 | $16,027 | $32 | 1 | 2 | $16,027 | $8,013 | ||
| 803-BOCC COBRA | $195 | $319 | $0 | $792 | $1,306 | $0 | $1,306 | $0 | $1,306 | $126 | 4 | 4 | $327 | $327 | ||
| 822-CLERK COBRA | $0 | $1,474 | $0 | $0 | $1,474 | $0 | $1,474 | $0 | $1,474 | $0 | 0 | 0 | $0 | $0 | ||
| 826-EXPRESSWAY OVER AGE DEP | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 1 | 1 | $0 | $0 | ||
| BENEFIT OPTION Total | $317,571 | $4,047,454 | $16,214 | $1,672,270 | $6,053,509 | $0 | $6,053,509 | $0 | $6,053,509 | $104,019 | 3,301 | 7,655 | $1,834 | $791 | ||
| Jun-2022 Total | $462,447 | $5,685,338 | $21,644 | $2,250,316 | $8,419,746 | ($5,623) | $8,414,122 | $348,318 | $8,762,440 | $179,021 | 5,674 | 12,209 | $1,483 | $689 | ||
| Jul-22 | HDHP MODERN PLAN | 002H-PROPERTY APPRAISERS ACTIVE | $2,493 | $7,729 | $0 | $3,660 | $13,883 | $0 | $13,883 | $6,766 | $20,649 | $1,388 | 43 | 80 | $323 | $174 |
| 003-BOCC ACTIVE | $119,125 | $1,175,081 | $2,410 | $357,087 | $1,653,702 | ($2,226) | $1,651,476 | $249,750 | $1,901,226 | $61,156 | 1,940 | 3,835 | $851 | $431 | ||
| 017H-EXPRESSWAY ACTIVE | $1,216 | $3,805 | $300 | $315 | $5,636 | $0 | $5,636 | $16,381 | $22,017 | $568 | 18 | 42 | $313 | $134 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $393 | $0 | $0 | $47 | $440 | $0 | $440 | $279 | $719 | $252 | 8 | 13 | $55 | $34 | ||
| 020-COURT ACTIVE | $793 | $35,588 | $0 | $3,171 | $39,552 | $0 | $39,552 | $3,493 | $43,045 | $378 | 12 | 26 | $3,296 | $1,521 | ||
| 021-C BOARD ACTIVE | $174 | $0 | $0 | $0 | $174 | $0 | $174 | $0 | $174 | $0 | 0 | 0 | $0 | $0 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $535 | $4,614 | $0 | $4,655 | $9,805 | $0 | $9,805 | $964 | $10,769 | $315 | 10 | 21 | $980 | $467 | ||
| 022-CLERK ACTIVE | $13,747 | $65,427 | $481 | $70,555 | $150,211 | $0 | $150,211 | $32,148 | $182,358 | $8,263 | 263 | 454 | $571 | $331 |
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 .