13-Exhibit D Report of Medical and RX Claims 2023.xls
XLS spreadsheet 400 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 comprehensive monthly healthcare claims and enrollment report for the Hillsborough County Board of County Commissioners covering medical insurance plans from January through December 2023. The report details two primary benefit options: a High Deductible Health Plan (HDHP) Modern Plan and an OAP Traditional Plan, with enrollment and claims data tracked across various county departments including Property, BOCC Active, Expressway, Sports Authority, Court, Children's Board, and Clerk's offices. The report encompasses active employees, retirees under and over 65, and includes COBRA participants, tracking subscriber counts, membership tiers, claims experience, and financial metrics.
The financial data reveals total claims of $104,112,975 across all plans, with net claims after stop-loss adjustments of $102,597,531. The total membership fluctuated between 5,649 and 5,846 subscribers monthly, with total members ranging from 12,060 to 12,365. The HDHP Modern Plan had 29,706 total subscribers for the year, while the OAP Traditional Plan had 38,444. The report includes detailed breakdowns of fixed charges, in-network and out-of-network claims, drug costs, and ASO (Administrative Services Only) fees, providing a granular view of the county's healthcare spending and utilization across different employee and retiree categories.
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 2023 thru December 2023 | |||||||||||||||
| 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-23 | HDHP MODERN PLAN | $148,499 | $1,446,140 | $80,487 | $389,137 | $2,064,263 | ($7) | $2,064,256 | $458,703 | $2,522,959 | ($71,466) | 2,406 | 4,579 | $858 | $451 |
| OAP COVERAGE NOW | $0 | ($252) | $0 | $0 | ($252) | $0 | ($252) | $0 | ($252) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $303,857 | $4,179,388 | $14,037 | $1,665,313 | $6,162,595 | ($4,946) | $6,157,649 | $0 | $6,157,649 | ($95,511) | 3,243 | 7,481 | $1,899 | $823 | |
| Jan-2023 Total | $452,356 | $5,625,276 | $94,524 | $2,054,450 | $8,226,606 | ($4,953) | $8,221,653 | $458,703 | $8,680,356 | ($166,976) | 5,649 | 12,060 | $1,455 | $682 | |
| Feb-23 | HDHP MODERN PLAN | $154,466 | $1,109,452 | $20,750 | $493,692 | $1,778,360 | $0 | $1,778,360 | $474,794 | $2,253,154 | $4,338 | 2,395 | 4,558 | $743 | $390 |
| OAP COVERAGE NOW | $0 | ($5) | $0 | $0 | ($5) | $0 | ($5) | $0 | ($5) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $329,135 | $3,122,383 | $22,201 | $1,725,507 | $5,199,226 | $0 | $5,199,226 | $0 | $5,199,226 | $5,193 | 3,216 | 7,440 | $1,617 | $699 | |
| Feb-2023 Total | $483,601 | $4,231,829 | $42,952 | $2,219,199 | $6,977,581 | $0 | $6,977,581 | $474,794 | $7,452,376 | $9,530 | 5,611 | 11,998 | $1,244 | $582 | |
| Mar-23 | HDHP MODERN PLAN | $155,307 | $1,234,260 | $9,328 | $524,089 | $1,922,984 | $0 | $1,922,984 | $498,997 | $2,421,981 | $3,652 | 2,390 | 4,564 | $805 | $421 |
| OAP COVERAGE NOW | $0 | ($2) | $0 | $0 | ($2) | $0 | ($2) | $0 | ($2) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $339,193 | $3,861,754 | $68,402 | $1,611,172 | $5,880,520 | $0 | $5,880,520 | $0 | $5,880,520 | $3,819 | 3,196 | 7,382 | $1,840 | $797 | |
| Mar-2023 Total | $494,499 | $5,096,012 | $77,730 | $2,135,261 | $7,803,502 | $0 | $7,803,502 | $498,997 | $8,302,499 | $7,471 | 5,586 | 11,946 | $1,397 | $653 | |
| Apr-23 | HDHP MODERN PLAN | $147,029 | $1,267,186 | $3,845 | $538,460 | $1,956,520 | $0 | $1,956,520 | $378,078 | $2,334,598 | $75,917 | 2,402 | 4,583 | $815 | $427 |
| OAP COVERAGE NOW | $0 | ($265) | $0 | $0 | ($265) | $0 | ($265) | $0 | ($265) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $308,528 | $4,110,704 | $59,406 | $1,839,271 | $6,317,910 | ($13,882) | $6,304,028 | $0 | $6,304,028 | $100,928 | 3,174 | 7,350 | $1,986 | $858 | |
| Apr-2023 Total | $455,557 | $5,377,624 | $63,251 | $2,377,731 | $8,274,164 | ($13,882) | $8,260,282 | $378,078 | $8,638,360 | $176,845 | 5,576 | 11,933 | $1,481 | $692 | |
| May-23 | HDHP MODERN PLAN | $149,621 | $1,321,089 | $9,863 | $534,566 | $2,015,139 | $0 | $2,015,139 | $402,061 | $2,417,200 | $39,929 | 2,409 | 4,591 | $837 | $439 |
| OAP COVERAGE NOW | $0 | ($10,860) | $0 | $0 | ($10,860) | $0 | ($10,860) | $0 | ($10,860) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $315,206 | $3,693,368 | $62,948 | $1,769,992 | $5,841,513 | ($1,956) | $5,839,557 | $0 | $5,839,557 | $99,795 | 3,176 | 7,350 | $1,839 | $794 | |
| May-2023 Total | $464,827 | $5,003,596 | $72,811 | $2,304,558 | $7,845,792 | ($1,956) | $7,843,836 | $402,061 | $8,245,897 | $139,725 | 5,585 | 11,941 | $1,404 | $657 | |
| Jun-23 | HDHP MODERN PLAN | $160,374 | $1,371,045 | $11,948 | $632,607 | $2,175,974 | $0 | $2,175,974 | $397,569 | $2,573,544 | $78,598 | 2,466 | 4,667 | $882 | $466 |
| OAP COVERAGE NOW | $0 | ($5,140) | $0 | $0 | ($5,140) | $0 | ($5,140) | $0 | ($5,140) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $339,075 | $3,839,725 | $44,713 | $1,779,110 | $6,002,623 | ($17,966) | $5,984,657 | $0 | $5,984,657 | $101,874 | 3,190 | 7,384 | $1,876 | $810 | |
| Jun-2023 Total | $499,449 | $5,205,630 | $56,661 | $2,411,717 | $8,173,457 | ($17,966) | $8,155,492 | $397,569 | $8,553,061 | $180,472 | 5,656 | 12,051 | $1,442 | $677 | |
| Jul-23 | HDHP MODERN PLAN | $150,098 | $1,318,998 | $5,623 | $587,975 | $2,062,693 | $0 | $2,062,693 | $360,006 | $2,422,699 | $79,355 | 2,488 | 4,696 | $829 | $439 |
| OAP COVERAGE NOW | $0 | ($8,415) | $0 | $0 | ($8,415) | $0 | ($8,415) | $0 | ($8,415) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $304,245 | $4,256,962 | $37,328 | $1,887,299 | $6,485,833 | ($44,277) | $6,441,556 | $0 | $6,441,556 | $102,000 | 3,184 | 7,381 | $2,023 | $873 | |
| Jul-2023 Total | $454,343 | $5,567,544 | $42,950 | $2,475,273 | $8,540,111 | ($44,277) | $8,495,834 | $360,006 | $8,855,840 | $181,355 | 5,672 | 12,077 | $1,498 | $703 | |
| Aug-23 | HDHP MODERN PLAN | $159,668 | $1,562,434 | ($888) | $637,315 | $2,358,529 | $0 | $2,358,529 | $356,445 | $2,714,973 | $79,985 | 2,505 | 4,724 | $942 | $499 |
| OAP TRADITIONAL PLAN | $320,156 | $4,725,683 | $9,797 | $1,950,055 | $7,005,691 | ($87,171) | $6,918,520 | $0 | $6,918,520 | $102,473 | 3,202 | 7,411 | $2,161 | $934 | |
| Aug-2023 Total | $479,824 | $6,288,117 | $8,909 | $2,587,370 | $9,364,220 | ($87,171) | $9,277,049 | $356,445 | $9,633,493 | $182,459 | 5,707 | 12,135 | $1,626 | $764 | |
| Sep-23 | HDHP MODERN PLAN | $168,137 | $1,639,157 | $38,781 | $577,316 | $2,423,391 | $0 | $2,423,391 | $321,283 | $2,744,674 | $80,742 | 2,524 | 4,761 | $960 | $509 |
| OAP COVERAGE NOW | $0 | ($139) | $0 | $0 | ($139) | $0 | ($139) | $0 | ($139) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $318,772 | $4,596,662 | $21,882 | $1,807,309 | $6,744,625 | ($212,984) | $6,531,641 | $0 | $6,531,641 | $102,663 | 3,206 | 7,418 | $2,037 | $881 | |
| Sep-2023 Total | $486,910 | $6,235,680 | $60,663 | $2,384,625 | $9,167,877 | ($212,984) | $8,954,894 | $321,283 | $9,276,177 | $183,405 | 5,730 | 12,179 | $1,563 | $735 | |
| Oct-23 | HDHP MODERN PLAN | $161,335 | $1,552,587 | $50,399 | $732,082 | $2,496,403 | $0 | $2,496,403 | $342,254 | $2,838,658 | $81,468 | 2,544 | 4,783 | $981 | $522 |
| OAP TRADITIONAL PLAN | $321,646 | $4,856,941 | $32,155 | $1,972,634 | $7,183,376 | ($609,069) | $6,574,307 | $0 | $6,574,307 | $102,537 | 3,203 | 7,424 | $2,053 | $886 | |
| Oct-2023 Total | $482,981 | $6,409,528 | $82,554 | $2,704,716 | $9,679,780 | ($609,069) | $9,070,710 | $342,254 | $9,412,964 | $184,004 | 5,747 | 12,207 | $1,578 | $743 | |
| Nov-23 | HDHP MODERN PLAN | $176,867 | $2,111,140 | $86,567 | $621,891 | $2,996,464 | $0 | $2,996,464 | $304,954 | $3,301,418 | $80,932 | 2,566 | 4,826 | $1,168 | $621 |
| OAP TRADITIONAL PLAN | $350,493 | $3,959,645 | ($4,965) | $2,066,089 | $6,371,261 | ($300,124) | $6,071,138 | $0 | $6,071,138 | $101,306 | 3,219 | 7,448 | $1,886 | $815 | |
| Nov-2023 Total | $527,360 | $6,070,784 | $81,602 | $2,687,980 | $9,367,726 | ($300,124) | $9,067,602 | $304,954 | $9,372,556 | $182,238 | 5,785 | 12,274 | $1,567 | $739 | |
| Dec-23 | HDHP MODERN PLAN | $181,814 | $2,283,298 | $109,975 | $744,924 | $3,320,011 | $0 | $3,320,011 | $287,997 | $3,608,008 | $82,351 | 2,611 | 4,888 | $1,272 | $679 |
| OAP COVERAGE NOW | $0 | ($23) | $0 | $0 | ($23) | $0 | ($23) | $0 | ($23) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $380,445 | $4,961,165 | $22,577 | $2,007,983 | $7,372,171 | ($223,062) | $7,149,109 | $0 | $7,149,109 | $101,780 | 3,235 | 7,477 | $2,210 | $956 | |
| Dec-2023 Total | $562,259 | $7,244,440 | $132,552 | $2,752,907 | $10,692,158 | ($223,062) | $10,469,097 | $287,997 | $10,757,094 | $184,131 | 5,846 | 12,365 | $1,791 | $847 | |
| BENEFIT OPTION Totals | HDHP MODERN PLAN | $1,913,214 | $18,216,785 | $426,679 | $7,014,053 | $27,570,731 | ($7) | $27,570,724 | $4,583,141 | $32,153,865 | $615,801 | 29,706 | 56,220 | $928 | $490 |
| OAP COVERAGE NOW | $0 | ($25,102) | $0 | $0 | ($25,102) | $0 | ($25,102) | $0 | ($25,102) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $3,930,752 | $50,164,379 | $390,481 | $22,081,734 | $76,567,346 | ($1,515,437) | $75,051,909 | $0 | $75,051,909 | $828,857 | 38,444 | 88,946 | $1,952 | $844 | |
| Grand Total | $5,843,966 | $68,356,062 | $817,160 | $29,095,787 | $104,112,975 | ($1,515,444) | $102,597,531 | $4,583,141 | $107,180,672 | $1,444,658 | 68,150 | 145,166 | $1,505 | $707 |
&R &8Page &P of &N Date: 1/8/2024&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 2023 thru December 2023 | ||||||
| YTD/MONTH | BENEFIT OPTION | EMP ONLY | EMP + SPOUSE | EMP+ CHILD(REN) | EMP + FAMILY | TOTAL |
| Jan-23 | HDHP MODERN PLAN | 1,297 | 351 | 293 | 465 | 2,406 |
| OAP TRADITIONAL PLAN | 1,247 | 615 | 344 | 1,037 | 3,243 | |
| Jan-2023 Total | 2,544 | 966 | 637 | 1,502 | 5,649 | |
| Feb-23 | HDHP MODERN PLAN | 1,291 | 347 | 293 | 464 | 2,395 |
| OAP TRADITIONAL PLAN | 1,234 | 606 | 344 | 1,032 | 3,216 | |
| Feb-2023 Total | 2,525 | 953 | 637 | 1,496 | 5,611 | |
| Mar-23 | HDHP MODERN PLAN | 1,287 | 346 | 292 | 465 | 2,390 |
| OAP TRADITIONAL PLAN | 1,230 | 600 | 345 | 1,021 | 3,196 | |
| Mar-2023 Total | 2,517 | 946 | 637 | 1,486 | 5,586 | |
| Apr-23 | HDHP MODERN PLAN | 1,292 | 352 | 292 | 466 | 2,402 |
| OAP TRADITIONAL PLAN | 1,215 | 599 | 338 | 1,022 | 3,174 | |
| Apr-2023 Total | 2,507 | 951 | 630 | 1,488 | 5,576 | |
| May-23 | HDHP MODERN PLAN | 1,300 | 350 | 291 | 468 | 2,409 |
| OAP TRADITIONAL PLAN | 1,219 | 601 | 337 | 1,019 | 3,176 | |
| May-2023 Total | 2,519 | 951 | 628 | 1,487 | 5,585 | |
| Jun-23 | HDHP MODERN PLAN | 1,348 | 352 | 293 | 473 | 2,466 |
| OAP TRADITIONAL PLAN | 1,223 | 610 | 335 | 1,022 | 3,190 | |
| Jun-2023 Total | 2,571 | 962 | 628 | 1,495 | 5,656 | |
| Jul-23 | HDHP MODERN PLAN | 1,362 | 356 | 298 | 472 | 2,488 |
| OAP TRADITIONAL PLAN | 1,221 | 604 | 337 | 1,022 | 3,184 | |
| Jul-2023 Total | 2,583 | 960 | 635 | 1,494 | 5,672 | |
| Aug-23 | HDHP MODERN PLAN | 1,373 | 358 | 300 | 474 | 2,505 |
| OAP TRADITIONAL PLAN | 1,232 | 610 | 341 | 1,019 | 3,202 | |
| Aug-2023 Total | 2,605 | 968 | 641 | 1,493 | 5,707 | |
| Sep-23 | HDHP MODERN PLAN | 1,390 | 350 | 305 | 479 | 2,524 |
| OAP TRADITIONAL PLAN | 1,239 | 608 | 338 | 1,021 | 3,206 | |
| Sep-2023 Total | 2,629 | 958 | 643 | 1,500 | 5,730 | |
| Oct-23 | HDHP MODERN PLAN | 1,408 | 352 | 305 | 479 | 2,544 |
| OAP TRADITIONAL PLAN | 1,239 | 604 | 339 | 1,021 | 3,203 | |
| Oct-2023 Total | 2,647 | 956 | 644 | 1,500 | 5,747 | |
| Nov-23 | HDHP MODERN PLAN | 1,424 | 349 | 309 | 484 | 2,566 |
| OAP TRADITIONAL PLAN | 1,251 | 607 | 340 | 1,021 | 3,219 | |
| Nov-2023 Total | 2,675 | 956 | 649 | 1,505 | 5,785 | |
| Dec-23 | HDHP MODERN PLAN | 1,459 | 354 | 313 | 485 | 2,611 |
| OAP TRADITIONAL PLAN | 1,262 | 606 | 339 | 1,028 | 3,235 | |
| Dec-2023 Total | 2,721 | 960 | 652 | 1,513 | 5,846 | |
| BENEFIT OPTION Totals | HDHP MODERN PLAN | 16,231 | 4,217 | 3,584 | 5,674 | 29,706 |
| OAP TRADITIONAL PLAN | 14,812 | 7,270 | 4,077 | 12,285 | 38,444 | |
| Grand Total | 31,043 | 11,487 | 7,661 | 17,959 | 68,150 |
&R &8Page &P of &N Date: 1/8/2024&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 2023 thru December 2023 | |||||||||||||||
| 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-23 | HDHP MODERN PLAN | $148,499 | $1,446,140 | $80,487 | $389,137 | $2,064,263 | ($7) | $2,064,256 | $458,703 | $2,522,959 | ($71,466) | 2,406 | 4,579 | $858 | $451 |
| OAP COVERAGE NOW | $0 | ($252) | $0 | $0 | ($252) | $0 | ($252) | $0 | ($252) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $303,857 | $4,179,388 | $14,037 | $1,665,313 | $6,162,595 | ($4,946) | $6,157,649 | $0 | $6,157,649 | ($95,511) | 3,243 | 7,481 | $1,899 | $823 | |
| Jan-2023 Total | $452,356 | $5,625,276 | $94,524 | $2,054,450 | $8,226,606 | ($4,953) | $8,221,653 | $458,703 | $8,680,356 | ($166,976) | 5,649 | 12,060 | $1,455 | $682 | |
| Feb-23 | HDHP MODERN PLAN | $154,466 | $1,109,452 | $20,750 | $493,692 | $1,778,360 | $0 | $1,778,360 | $474,794 | $2,253,154 | $4,338 | 2,395 | 4,558 | $743 | $390 |
| OAP COVERAGE NOW | $0 | ($5) | $0 | $0 | ($5) | $0 | ($5) | $0 | ($5) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $329,135 | $3,122,383 | $22,201 | $1,725,507 | $5,199,226 | $0 | $5,199,226 | $0 | $5,199,226 | $5,193 | 3,216 | 7,440 | $1,617 | $699 | |
| Feb-2023 Total | $483,601 | $4,231,829 | $42,952 | $2,219,199 | $6,977,581 | $0 | $6,977,581 | $474,794 | $7,452,376 | $9,530 | 5,611 | 11,998 | $1,244 | $582 | |
| Mar-23 | HDHP MODERN PLAN | $155,307 | $1,234,260 | $9,328 | $524,089 | $1,922,984 | $0 | $1,922,984 | $498,997 | $2,421,981 | $3,652 | 2,390 | 4,564 | $805 | $421 |
| OAP COVERAGE NOW | $0 | ($2) | $0 | $0 | ($2) | $0 | ($2) | $0 | ($2) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $339,193 | $3,861,754 | $68,402 | $1,611,172 | $5,880,520 | $0 | $5,880,520 | $0 | $5,880,520 | $3,819 | 3,196 | 7,382 | $1,840 | $797 | |
| Mar-2023 Total | $494,499 | $5,096,012 | $77,730 | $2,135,261 | $7,803,502 | $0 | $7,803,502 | $498,997 | $8,302,499 | $7,471 | 5,586 | 11,946 | $1,397 | $653 | |
| Apr-23 | HDHP MODERN PLAN | $147,029 | $1,267,186 | $3,845 | $538,460 | $1,956,520 | $0 | $1,956,520 | $378,078 | $2,334,598 | $75,917 | 2,402 | 4,583 | $815 | $427 |
| OAP COVERAGE NOW | $0 | ($265) | $0 | $0 | ($265) | $0 | ($265) | $0 | ($265) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $308,528 | $4,110,704 | $59,406 | $1,839,271 | $6,317,910 | ($13,882) | $6,304,028 | $0 | $6,304,028 | $100,928 | 3,174 | 7,350 | $1,986 | $858 | |
| Apr-2023 Total | $455,557 | $5,377,624 | $63,251 | $2,377,731 | $8,274,164 | ($13,882) | $8,260,282 | $378,078 | $8,638,360 | $176,845 | 5,576 | 11,933 | $1,481 | $692 | |
| May-23 | HDHP MODERN PLAN | $149,621 | $1,321,089 | $9,863 | $534,566 | $2,015,139 | $0 | $2,015,139 | $402,061 | $2,417,200 | $39,929 | 2,409 | 4,591 | $837 | $439 |
| OAP COVERAGE NOW | $0 | ($10,860) | $0 | $0 | ($10,860) | $0 | ($10,860) | $0 | ($10,860) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $315,206 | $3,693,368 | $62,948 | $1,769,992 | $5,841,513 | ($1,956) | $5,839,557 | $0 | $5,839,557 | $99,795 | 3,176 | 7,350 | $1,839 | $794 | |
| May-2023 Total | $464,827 | $5,003,596 | $72,811 | $2,304,558 | $7,845,792 | ($1,956) | $7,843,836 | $402,061 | $8,245,897 | $139,725 | 5,585 | 11,941 | $1,404 | $657 | |
| Jun-23 | HDHP MODERN PLAN | $160,374 | $1,371,045 | $11,948 | $632,607 | $2,175,974 | $0 | $2,175,974 | $397,569 | $2,573,544 | $78,598 | 2,466 | 4,667 | $882 | $466 |
| OAP COVERAGE NOW | $0 | ($5,140) | $0 | $0 | ($5,140) | $0 | ($5,140) | $0 | ($5,140) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $339,075 | $3,839,725 | $44,713 | $1,779,110 | $6,002,623 | ($17,966) | $5,984,657 | $0 | $5,984,657 | $101,874 | 3,190 | 7,384 | $1,876 | $810 | |
| Jun-2023 Total | $499,449 | $5,205,630 | $56,661 | $2,411,717 | $8,173,457 | ($17,966) | $8,155,492 | $397,569 | $8,553,061 | $180,472 | 5,656 | 12,051 | $1,442 | $677 | |
| Jul-23 | HDHP MODERN PLAN | $150,098 | $1,318,998 | $5,623 | $587,975 | $2,062,693 | $0 | $2,062,693 | $360,006 | $2,422,699 | $79,355 | 2,488 | 4,696 | $829 | $439 |
| OAP COVERAGE NOW | $0 | ($8,415) | $0 | $0 | ($8,415) | $0 | ($8,415) | $0 | ($8,415) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $304,245 | $4,256,962 | $37,328 | $1,887,299 | $6,485,833 | ($44,277) | $6,441,556 | $0 | $6,441,556 | $102,000 | 3,184 | 7,381 | $2,023 | $873 | |
| Jul-2023 Total | $454,343 | $5,567,544 | $42,950 | $2,475,273 | $8,540,111 | ($44,277) | $8,495,834 | $360,006 | $8,855,840 | $181,355 | 5,672 | 12,077 | $1,498 | $703 | |
| Aug-23 | HDHP MODERN PLAN | $159,668 | $1,562,434 | ($888) | $637,315 | $2,358,529 | $0 | $2,358,529 | $356,445 | $2,714,973 | $79,985 | 2,505 | 4,724 | $942 | $499 |
| OAP TRADITIONAL PLAN | $320,156 | $4,725,683 | $9,797 | $1,950,055 | $7,005,691 | ($87,171) | $6,918,520 | $0 | $6,918,520 | $102,473 | 3,202 | 7,411 | $2,161 | $934 | |
| Aug-2023 Total | $479,824 | $6,288,117 | $8,909 | $2,587,370 | $9,364,220 | ($87,171) | $9,277,049 | $356,445 | $9,633,493 | $182,459 | 5,707 | 12,135 | $1,626 | $764 | |
| Sep-23 | HDHP MODERN PLAN | $168,137 | $1,639,157 | $38,781 | $577,316 | $2,423,391 | $0 | $2,423,391 | $321,283 | $2,744,674 | $80,742 | 2,524 | 4,761 | $960 | $509 |
| OAP COVERAGE NOW | $0 | ($139) | $0 | $0 | ($139) | $0 | ($139) | $0 | ($139) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $318,772 | $4,596,662 | $21,882 | $1,807,309 | $6,744,625 | ($212,984) | $6,531,641 | $0 | $6,531,641 | $102,663 | 3,206 | 7,418 | $2,037 | $881 | |
| Sep-2023 Total | $486,910 | $6,235,680 | $60,663 | $2,384,625 | $9,167,877 | ($212,984) | $8,954,894 | $321,283 | $9,276,177 | $183,405 | 5,730 | 12,179 | $1,563 | $735 | |
| Oct-23 | HDHP MODERN PLAN | $161,335 | $1,552,587 | $50,399 | $732,082 | $2,496,403 | $0 | $2,496,403 | $342,254 | $2,838,658 | $81,468 | 2,544 | 4,783 | $981 | $522 |
| OAP TRADITIONAL PLAN | $321,646 | $4,856,941 | $32,155 | $1,972,634 | $7,183,376 | ($609,069) | $6,574,307 | $0 | $6,574,307 | $102,537 | 3,203 | 7,424 | $2,053 | $886 | |
| Oct-2023 Total | $482,981 | $6,409,528 | $82,554 | $2,704,716 | $9,679,780 | ($609,069) | $9,070,710 | $342,254 | $9,412,964 | $184,004 | 5,747 | 12,207 | $1,578 | $743 | |
| Nov-23 | HDHP MODERN PLAN | $176,867 | $2,111,140 | $86,567 | $621,891 | $2,996,464 | $0 | $2,996,464 | $304,954 | $3,301,418 | $80,932 | 2,566 | 4,826 | $1,168 | $621 |
| OAP TRADITIONAL PLAN | $350,493 | $3,959,645 | ($4,965) | $2,066,089 | $6,371,261 | ($300,124) | $6,071,138 | $0 | $6,071,138 | $101,306 | 3,219 | 7,448 | $1,886 | $815 | |
| Nov-2023 Total | $527,360 | $6,070,784 | $81,602 | $2,687,980 | $9,367,726 | ($300,124) | $9,067,602 | $304,954 | $9,372,556 | $182,238 | 5,785 | 12,274 | $1,567 | $739 | |
| Dec-23 | HDHP MODERN PLAN | $181,814 | $2,283,298 | $109,975 | $744,924 | $3,320,011 | $0 | $3,320,011 | $287,997 | $3,608,008 | $82,351 | 2,611 | 4,888 | $1,272 | $679 |
| OAP COVERAGE NOW | $0 | ($23) | $0 | $0 | ($23) | $0 | ($23) | $0 | ($23) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $380,445 | $4,961,165 | $22,577 | $2,007,983 | $7,372,171 | ($223,062) | $7,149,109 | $0 | $7,149,109 | $101,780 | 3,235 | 7,477 | $2,210 | $956 | |
| Dec-2023 Total | $562,259 | $7,244,440 | $132,552 | $2,752,907 | $10,692,158 | ($223,062) | $10,469,097 | $287,997 | $10,757,094 | $184,131 | 5,846 | 12,365 | $1,791 | $847 | |
| BENEFIT OPTION Totals | HDHP MODERN PLAN | $1,913,214 | $18,216,785 | $426,679 | $7,014,053 | $27,570,731 | ($7) | $27,570,724 | $4,583,141 | $32,153,865 | $615,801 | 29,706 | 56,220 | $928 | $490 |
| OAP COVERAGE NOW | $0 | ($25,102) | $0 | $0 | ($25,102) | $0 | ($25,102) | $0 | ($25,102) | $0 | 0 | 0 | $0 | $0 | |
| OAP TRADITIONAL PLAN | $3,930,752 | $50,164,379 | $390,481 | $22,081,734 | $76,567,346 | ($1,515,437) | $75,051,909 | $0 | $75,051,909 | $828,857 | 38,444 | 88,946 | $1,952 | $844 | |
| Grand Total | $5,843,966 | $68,356,062 | $817,160 | $29,095,787 | $104,112,975 | ($1,515,444) | $102,597,531 | $4,583,141 | $107,180,672 | $1,444,658 | 68,150 | 145,166 | $1,505 | $707 |
&R &8Page &P of &N Date: 1/8/2024&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 2023 thru December 2023 | ||||||||||||||||
| 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-23 | HDHP MODERN PLAN | 002-PROPERTY ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 3 | 5 | $0 | $0 |
| 002H-PROPERTY APPRAISERS ACTIVE | $2,582 | $40,920 | $0 | $1,589 | $45,091 | $0 | $45,091 | $15,122 | $60,212 | ($1,244) | 42 | 83 | $1,074 | $543 | ||
| 003-BOCC ACTIVE | $124,580 | $1,160,253 | $80,451 | $286,750 | $1,652,034 | ($7) | $1,652,027 | $382,526 | $2,034,552 | ($58,419) | 1,978 | 3,874 | $835 | $426 | ||
| 017H-EXPRESSWAY ACTIVE | $1,304 | $6,731 | $0 | $402 | $8,436 | $0 | $8,436 | $10,454 | $18,890 | ($470) | 17 | 39 | $496 | $216 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $427 | $0 | $0 | $87 | $514 | $0 | $514 | $3,052 | $3,567 | ($249) | 9 | 14 | $57 | $37 | ||
| 020-COURT ACTIVE | $810 | $3,188 | $0 | $3,048 | $7,046 | $0 | $7,046 | $1,363 | $8,409 | ($306) | 10 | 23 | $705 | $306 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $656 | $18,831 | $0 | $5,464 | $24,951 | $0 | $24,951 | $1,909 | $26,860 | ($278) | 9 | 19 | $2,772 | $1,313 | ||
| 022-CLERK ACTIVE | $13,911 | $79,653 | $0 | $54,905 | $148,469 | $0 | $148,469 | $34,785 | $183,254 | ($7,670) | 247 | 413 | $601 | $359 | ||
| 202-PROPERTY RETIREE UNDER 65 | $119 | $0 | $0 | $0 | $119 | $0 | $119 | $500 | $619 | ($138) | 5 | 5 | $24 | $24 | ||
| 203-BOCC RETIREE UNDER 65 | $2,820 | $133,192 | $0 | $25,828 | $161,840 | $0 | $161,840 | $8,407 | $170,246 | ($1,858) | 56 | 70 | $2,890 | $2,312 | ||
| 218-SPORTS RETIREE UNDER 65 | $27 | $0 | $0 | $0 | $27 | $0 | $27 | $0 | $27 | ($28) | 1 | 1 | $27 | $27 | ||
| 222-CLERK RETIREE UNDER 65 | $497 | $895 | $0 | $6,468 | $7,861 | $0 | $7,861 | $585 | $8,445 | ($302) | 11 | 13 | $715 | $605 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $507 | $44 | $36 | $3,841 | $4,428 | $0 | $4,428 | $0 | $4,428 | ($347) | 11 | 11 | $403 | $403 | ||
| 310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 2 | 4 | $0 | $0 | ||
| 312-BOCC RETIREE OVER 65 FAMILY | $152 | $0 | $0 | $0 | $152 | $0 | $152 | $0 | $152 | ($32) | 0 | 0 | $0 | $0 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $108 | $1,760 | $0 | $755 | $2,623 | $0 | $2,623 | $0 | $2,623 | ($126) | 5 | 5 | $525 | $525 | ||
| 803-BOCC COBRA | $0 | $673 | $0 | $0 | $673 | $0 | $673 | $0 | $673 | $0 | 0 | 0 | $0 | $0 | ||
| BENEFIT OPTION Total | $148,499 | $1,446,140 | $80,487 | $389,137 | $2,064,263 | ($7) | $2,064,256 | $458,703 | $2,522,959 | ($71,466) | 2,406 | 4,579 | $858 | $451 | ||
| OAP COVERAGE NOW | 003-BOCC ACTIVE | $0 | ($252) | $0 | $0 | ($252) | $0 | ($252) | $0 | ($252) | $0 | 0 | 0 | $0 | $0 | |
| BENEFIT OPTION Total | $0 | ($252) | $0 | $0 | ($252) | $0 | ($252) | $0 | ($252) | $0 | 0 | 0 | $0 | $0 | ||
| OAP TRADITIONAL PLAN | 002-PROPERTY ACTIVE | $344 | $0 | $0 | $0 | $344 | $0 | $344 | $0 | $344 | $0 | 1 | 2 | $344 | $172 | |
| 002H-PROPERTY APPRAISERS ACTIVE | $4,737 | $49,970 | $0 | $42,583 | $97,289 | $0 | $97,289 | $0 | $97,289 | ($1,465) | 53 | 127 | $1,836 | $766 | ||
| 003-BOCC ACTIVE | $243,554 | $3,393,681 | $10,707 | $1,295,295 | $4,943,237 | ($4,946) | $4,938,291 | $0 | $4,938,291 | ($73,885) | 2,521 | 6,110 | $1,959 | $808 | ||
| 017H-EXPRESSWAY ACTIVE | $617 | $8,457 | $279 | $431 | $9,785 | $0 | $9,785 | $0 | $9,785 | ($166) | 6 | 17 | $1,631 | $576 | ||
| 018-SPORTS ACTIVE | $57 | $0 | $0 | $0 | $57 | $0 | $57 | $0 | $57 | $0 | 0 | 0 | $0 | $0 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $4,921 | $40,651 | $0 | $4,226 | $49,797 | $0 | $49,797 | $0 | $49,797 | ($1,271) | 45 | 113 | $1,107 | $441 | ||
| 020-COURT ACTIVE | $3,431 | $49,896 | $0 | $14,879 | $68,206 | $0 | $68,206 | $0 | $68,206 | ($1,135) | 39 | 87 | $1,749 | $784 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $1,965 | $35,700 | $166 | $8,522 | $46,353 | $0 | $46,353 | $0 | $46,353 | ($685) | 28 | 58 | $1,655 | $799 | ||
| 022-CLERK ACTIVE | $25,402 | $362,851 | $1,106 | $134,788 | $524,147 | $0 | $524,147 | $0 | $524,147 | ($8,060) | 266 | 570 | $1,970 | $920 | ||
| 202-PROPERTY RETIREE UNDER 65 | $291 | $4,081 | $87 | $736 | $5,195 | $0 | $5,195 | $0 | $5,195 | ($166) | 2 | 2 | $2,598 | $2,598 | ||
| 203-BOCC RETIREE UNDER 65 | $13,434 | $171,128 | $367 | $106,880 | $291,809 | $0 | $291,809 | $0 | $291,809 | ($5,449) | 169 | 252 | $1,727 | $1,158 | ||
| 218-SPORTS RETIREE UNDER 65 | $71 | $0 | $0 | $87 | $158 | $0 | $158 | $0 | $158 | ($55) | 2 | 2 | $79 | $79 | ||
| 220-COURT RETIREE UNDER 65 | $5 | $5,721 | $0 | $1,429 | $7,155 | $0 | $7,155 | $0 | $7,155 | ($28) | 1 | 1 | $7,155 | $7,155 | ||
| 221-C BOARD RETIREE UNDER 65 | $34 | $18 | $0 | $32 | $84 | $0 | $84 | $0 | $84 | ($28) | 1 | 1 | $84 | $84 | ||
| 222-CLERK RETIREE UNDER 65 | $539 | $2,164 | $141 | $1,131 | $3,975 | $0 | $3,975 | $0 | $3,975 | ($332) | 12 | 13 | $331 | $306 | ||
| 305-PROPERTY RETIREE OVER 65 SINGLE | $34 | $0 | $0 | $0 | $34 | $0 | $34 | $0 | $34 | ($28) | 2 | 2 | $17 | $17 | ||
| 306-PROPERTY RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 2 | 2 | $0 | $0 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $2,080 | $15,818 | $1,910 | $9,869 | $29,676 | $0 | $29,676 | $0 | $29,676 | ($1,597) | 56 | 56 | $530 | $530 | ||
| 310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $663 | $1,102 | $0 | $891 | $2,656 | $0 | $2,656 | $0 | $2,656 | ($249) | 10 | 19 | $266 | $140 | ||
| 311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $941 | $7,585 | ($780) | $36,505 | $44,251 | $0 | $44,251 | $0 | $44,251 | ($391) | 11 | 22 | $4,023 | $2,011 | ||
| 312-BOCC RETIREE OVER 65 FAMILY | $187 | $21,201 | $0 | $4,461 | $25,850 | $0 | $25,850 | $0 | $25,850 | ($166) | 4 | 13 | $6,462 | $1,988 | ||
| 367-EXPRESSWAY RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $34 | $0 | $0 | $0 | $34 | $0 | $34 | $0 | $34 | ($28) | 1 | 1 | $34 | $34 | ||
| 370-SPORTS RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $40 | $1,830 | $0 | $1,635 | $3,505 | $0 | $3,505 | $0 | $3,505 | ($28) | 1 | 1 | $3,505 | $3,505 | ||
| 377-COURT RETIREE OVER 65 SINGLE | $32 | $0 | $0 | $0 | $32 | $0 | $32 | $0 | $32 | ($28) | 0 | 0 | $0 | $0 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $300 | $7,260 | $54 | $610 | $8,224 | $0 | $8,224 | $0 | $8,224 | ($247) | 8 | 8 | $1,028 | $1,028 | ||
| 387-CLERK RETIREE OVER 65 PLUS SPOUSE (BOTH MEDICARE) | $67 | $143 | $0 | $261 | $471 | $0 | $471 | $0 | $471 | ($30) | 0 | 0 | $0 | $0 | ||
| 803-BOCC COBRA | $34 | $134 | $0 | $60 | $228 | $0 | $228 | $0 | $228 | $0 | 0 | 0 | $0 | $0 | ||
| 822-CLERK COBRA | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $32 | 1 | 1 | $0 | $0 | ||
| 826-EXPRESSWAY OVER AGE DEP | $44 | $0 | $0 | $0 | $44 | $0 | $44 | $0 | $44 | ($28) | 1 | 1 | $44 | $44 | ||
| BENEFIT OPTION Total | $303,857 | $4,179,388 | $14,037 | $1,665,313 | $6,162,595 | ($4,946) | $6,157,649 | $0 | $6,157,649 | ($95,511) | 3,243 | 7,481 | $1,899 | $823 | ||
| Jan-2023 Total | $452,356 | $5,625,276 | $94,524 | $2,054,450 | $8,226,606 | ($4,953) | $8,221,653 | $458,703 | $8,680,356 | ($166,976) | 5,649 | 12,060 | $1,455 | $682 | ||
| Feb-23 | HDHP MODERN PLAN | 002-PROPERTY ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 3 | 5 | $0 | $0 |
| 002H-PROPERTY APPRAISERS ACTIVE | $2,907 | $46,252 | $0 | $2,922 | $52,082 | $0 | $52,082 | $14,359 | $66,440 | $117 | 42 | 83 | $1,240 | $627 | ||
| 003-BOCC ACTIVE | $129,925 | $923,989 | $20,706 | $345,588 | $1,420,208 | $0 | $1,420,208 | $366,357 | $1,786,565 | $3,089 | 1,968 | 3,850 | $722 | $369 | ||
| 017H-EXPRESSWAY ACTIVE | $1,395 | $1,641 | $0 | $1,776 | $4,811 | $0 | $4,811 | $18,254 | $23,066 | $33 | 17 | 38 | $283 | $127 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $460 | $178 | $0 | $1,564 | $2,202 | $0 | $2,202 | $1,229 | $3,431 | $18 | 9 | 14 | $245 | $157 | ||
| 020-COURT ACTIVE | $1,077 | $1,488 | $0 | $5,792 | $8,357 | $0 | $8,357 | $1,482 | $9,840 | ($10) | 10 | 23 | $836 | $363 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $650 | $826 | $0 | $9,395 | $10,870 | $0 | $10,870 | $4,207 | $15,078 | $18 | 9 | 19 | $1,208 | $572 | ||
| 022-CLERK ACTIVE | $13,718 | $70,117 | $0 | $88,029 | $171,865 | $0 | $171,865 | $53,016 | $224,881 | $343 | 244 | 413 | $704 | $416 | ||
| 202-PROPERTY RETIREE UNDER 65 | $157 | $6 | $0 | $2,277 | $2,440 | $0 | $2,440 | $0 | $2,440 | $10 | 5 | 5 | $488 | $488 | ||
| 203-BOCC RETIREE UNDER 65 | $3,043 | $41,033 | $45 | $22,841 | $66,962 | $0 | $66,962 | $14,091 | $81,053 | $131 | 59 | 75 | $1,135 | $893 | ||
| 218-SPORTS RETIREE UNDER 65 | $29 | $0 | $0 | $0 | $29 | $0 | $29 | $0 | $29 | $0 | 0 | 0 | $0 | $0 | ||
| 222-CLERK RETIREE UNDER 65 | $490 | $21,748 | $0 | $8,911 | $31,149 | $0 | $31,149 | $1,798 | $32,947 | $53 | 11 | 13 | $2,832 | $2,396 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $278 | $276 | $0 | $3,795 | $4,349 | $0 | $4,349 | $0 | $4,349 | $315 | 11 | 11 | $395 | $395 | ||
| 310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $1 | $0 | $0 | $180 | $181 | $0 | $181 | $0 | $181 | $32 | 2 | 4 | $91 | $45 | ||
| 312-BOCC RETIREE OVER 65 FAMILY | $70 | $0 | $0 | $0 | $70 | $0 | $70 | $0 | $70 | $32 | 0 | 0 | $0 | $0 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $119 | $1,897 | $0 | $543 | $2,559 | $0 | $2,559 | $0 | $2,559 | $158 | 5 | 5 | $512 | $512 | ||
| 803-BOCC COBRA | $146 | $0 | $0 | $80 | $226 | $0 | $226 | $0 | $226 | $0 | 0 | 0 | $0 | $0 | ||
| BENEFIT OPTION Total | $154,466 | $1,109,452 | $20,750 | $493,692 | $1,778,360 | $0 | $1,778,360 | $474,794 | $2,253,154 | $4,338 | 2,395 | 4,558 | $743 | $390 | ||
| OAP COVERAGE NOW | 003-BOCC ACTIVE | $0 | ($5) | $0 | $0 | ($5) | $0 | ($5) | $0 | ($5) | $0 | 0 | 0 | $0 | $0 | |
| BENEFIT OPTION Total | $0 | ($5) | $0 | $0 | ($5) | $0 | ($5) | $0 | ($5) | $0 | 0 | 0 | $0 | $0 | ||
| OAP TRADITIONAL PLAN | 002-PROPERTY ACTIVE | $66 | $0 | $0 | $0 | $66 | $0 | $66 | $0 | $66 | $0 | 1 | 2 | $66 | $33 | |
| 002H-PROPERTY APPRAISERS ACTIVE | $5,504 | $45,176 | $0 | $19,150 | $69,831 | $0 | $69,831 | $0 | $69,831 | $72 | 52 | 125 | $1,343 | $559 | ||
| 003-BOCC ACTIVE | $266,246 | $2,296,276 | $18,378 | $1,362,924 | $3,943,824 | $0 | $3,943,824 | $0 | $3,943,824 | $4,077 | 2,502 | 6,083 | $1,576 | $648 | ||
| 017H-EXPRESSWAY ACTIVE | $695 | $5,687 | $0 | $1,084 | $7,466 | $0 | $7,466 | $0 | $7,466 | $12 | 6 | 17 | $1,244 | $439 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $5,767 | $51,936 | $0 | $15,692 | $73,395 | $0 | $73,395 | $0 | $73,395 | $27 | 44 | 108 | $1,668 | $680 | ||
| 020-COURT ACTIVE | $4,056 | $40,655 | $1,598 | $25,302 | $71,611 | $0 | $71,611 | $0 | $71,611 | $19 | 40 | 91 | $1,790 | $787 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $2,409 | $19,193 | $0 | $17,598 | $39,200 | $0 | $39,200 | $0 | $39,200 | $21 | 26 | 54 | $1,508 | $726 | ||
| 022-CLERK ACTIVE | $24,948 | $373,964 | $993 | $95,109 | $495,013 | $0 | $495,013 | $0 | $495,013 | $426 | 261 | 563 | $1,897 | $879 | ||
| 202-PROPERTY RETIREE UNDER 65 | $251 | $3,326 | $0 | $2,653 | $6,230 | $0 | $6,230 | $0 | $6,230 | $12 | 2 | 2 | $3,115 | $3,115 | ||
| 203-BOCC RETIREE UNDER 65 | $13,111 | $227,071 | ($181) | $96,451 | $336,452 | $0 | $336,452 | $0 | $336,452 | $353 | 167 | 249 | $2,015 | $1,351 | ||
| 218-SPORTS RETIREE UNDER 65 | $80 | $287 | $0 | $1,506 | $1,873 | $0 | $1,873 | $0 | $1,873 | $4 | 2 | 2 | $936 | $936 | ||
| 220-COURT RETIREE UNDER 65 | $38 | $26,147 | $0 | $105 | $26,290 | $0 | $26,290 | $0 | $26,290 | $2 | 1 | 1 | $26,290 | $26,290 | ||
| 221-C BOARD RETIREE UNDER 65 | $38 | $90 | $0 | $225 | $353 | $0 | $353 | $0 | $353 | $2 | 1 | 1 | $353 | $353 | ||
| 222-CLERK RETIREE UNDER 65 | $556 | $1,752 | $140 | $2,628 | $5,076 | $0 | $5,076 | $0 | $5,076 | $57 | 14 | 16 | $363 | $317 | ||
| 305-PROPERTY RETIREE OVER 65 SINGLE | $38 | $0 | $0 | $0 | $38 | $0 | $38 | $0 | $38 | $2 | 2 | 2 | $19 | $19 | ||
| 306-PROPERTY RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 2 | 2 | $0 | $0 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $2,251 | $22,330 | $1,066 | $21,897 | $47,545 | $0 | $47,545 | $0 | $47,545 | $119 | 56 | 56 | $849 | $849 | ||
| 310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $683 | $381 | $146 | $4,452 | $5,661 | $0 | $5,661 | $0 | $5,661 | ($14) | 10 | 19 | $566 | $298 | ||
| 311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $890 | ($740) | $36 | $37,015 | $37,201 | $0 | $37,201 | $0 | $37,201 | ($67) | 11 | 22 | $3,382 | $1,691 | ||
| 312-BOCC RETIREE OVER 65 FAMILY | $814 | $5,843 | $7 | $4,357 | $11,021 | $0 | $11,021 | $0 | $11,021 | $12 | 4 | 13 | $2,755 | $848 | ||
| 367-EXPRESSWAY RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $38 | $0 | $0 | $0 | $38 | $0 | $38 | $0 | $38 | $2 | 1 | 1 | $38 | $38 | ||
| 370-SPORTS RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $44 | $388 | $0 | $32 | $465 | $0 | $465 | $0 | $465 | $2 | 1 | 1 | $465 | $465 | ||
| 377-COURT RETIREE OVER 65 SINGLE | $37 | $0 | $0 | $0 | $37 | $0 | $37 | $0 | $37 | $2 | 0 | 0 | $0 | $0 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $449 | $2,522 | $19 | $493 | $3,483 | $0 | $3,483 | $0 | $3,483 | $49 | 8 | 8 | $435 | $435 | ||
| 387-CLERK RETIREE OVER 65 PLUS SPOUSE (BOTH MEDICARE) | $77 | $97 | $0 | $16,207 | $16,381 | $0 | $16,381 | $0 | $16,381 | ($30) | 0 | 0 | $0 | $0 | ||
| 803-BOCC COBRA | $0 | ($125) | $0 | $0 | ($125) | $0 | ($125) | $0 | ($125) | $0 | 0 | 0 | $0 | $0 | ||
| 822-CLERK COBRA | $0 | $127 | $0 | $627 | $754 | $0 | $754 | $0 | $754 | $32 | 1 | 1 | $754 | $754 | ||
| 826-EXPRESSWAY OVER AGE DEP | $49 | $0 | $0 | $0 | $49 | $0 | $49 | $0 | $49 | $2 | 1 | 1 | $49 | $49 | ||
| BENEFIT OPTION Total | $329,135 | $3,122,383 | $22,201 | $1,725,507 | $5,199,226 | $0 | $5,199,226 | $0 | $5,199,226 | $5,193 | 3,216 | 7,440 | $1,617 | $699 | ||
| Feb-2023 Total | $483,601 | $4,231,829 | $42,952 | $2,219,199 | $6,977,581 | $0 | $6,977,581 | $474,794 | $7,452,376 | $9,530 | 5,611 | 11,998 | $1,244 | $582 | ||
| Mar-23 | HDHP MODERN PLAN | 002-PROPERTY ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 3 | 5 | $0 | $0 |
| 002H-PROPERTY APPRAISERS ACTIVE | $2,637 | $43,904 | $308 | $8,272 | $55,121 | $0 | $55,121 | $10,729 | $65,850 | $119 | 43 | 87 | $1,282 | $634 | ||
| 003-BOCC ACTIVE | $127,491 | $994,267 | $8,787 | $366,135 | $1,496,681 | $0 | $1,496,681 | $406,546 | $1,903,227 | $2,466 | 1,962 | 3,859 | $763 | $388 | ||
| 017H-EXPRESSWAY ACTIVE | $1,231 | $4,254 | $0 | $741 | $6,226 | $0 | $6,226 | $10,029 | $16,255 | $33 | 17 | 39 | $366 | $160 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $373 | $121 | $0 | $111 | $605 | $0 | $605 | $329 | $934 | $18 | 9 | 13 | $67 | $47 | ||
| 020-COURT ACTIVE | $510 | $13,171 | $0 | $5,390 | $19,071 | $0 | $19,071 | $2,607 | $21,678 | $20 | 10 | 23 | $1,907 | $829 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $579 | $624 | $0 | $7,451 | $8,653 | $0 | $8,653 | $5,249 | $13,903 | $18 | 9 | 19 | $961 | $455 | ||
| 022-CLERK ACTIVE | $16,897 | $93,775 | $0 | $84,461 | $195,132 | $0 | $195,132 | $41,340 | $236,472 | $280 | 244 | 407 | $800 | $479 | ||
| 202-PROPERTY RETIREE UNDER 65 | $132 | $410 | $0 | ($804) | ($261) | $0 | ($261) | $16 | ($245) | $10 | 5 | 5 | ($52) | ($52) | ||
| 203-BOCC RETIREE UNDER 65 | $2,701 | $57,289 | $208 | $38,710 | $98,908 | $0 | $98,908 | $20,439 | $119,347 | $129 | 58 | 74 | $1,705 | $1,337 | ||
| 218-SPORTS RETIREE UNDER 65 | ($7) | $0 | $0 | $0 | ($7) | $0 | ($7) | $0 | ($7) | $0 | 0 | 0 | $0 | $0 | ||
| 222-CLERK RETIREE UNDER 65 | $2,077 | $20,999 | $0 | $7,554 | $30,629 | $0 | $30,629 | $1,714 | $32,343 | $55 | 12 | 14 | $2,552 | $2,188 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $224 | $932 | $0 | $5,539 | $6,695 | $0 | $6,695 | $0 | $6,695 | $315 | 11 | 11 | $609 | $609 | ||
| 310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $190 | $0 | $0 | $0 | $190 | $0 | $190 | $0 | $190 | $0 | 1 | 2 | $190 | $95 | ||
| 312-BOCC RETIREE OVER 65 FAMILY | $66 | $175 | $0 | $0 | $241 | $0 | $241 | $0 | $241 | $0 | 0 | 0 | $0 | $0 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $199 | $4,255 | $25 | $530 | $5,010 | $0 | $5,010 | $0 | $5,010 | $158 | 5 | 5 | $1,002 | $1,002 | ||
| 803-BOCC COBRA | $7 | $82 | $0 | $0 | $89 | $0 | $89 | $0 | $89 | $32 | 1 | 1 | $89 | $89 | ||
| BENEFIT OPTION Total | $155,307 | $1,234,260 | $9,328 | $524,089 | $1,922,984 | $0 | $1,922,984 | $498,997 | $2,421,981 | $3,652 | 2,390 | 4,564 | $805 | $421 | ||
| OAP COVERAGE NOW | 003-BOCC ACTIVE | $0 | ($1) | $0 | $0 | ($1) | $0 | ($1) | $0 | ($1) | $0 | 0 | 0 | $0 | $0 | |
| 017-EXPRESSWAY ACTIVE | $0 | ($1) | $0 | $0 | ($1) | $0 | ($1) | $0 | ($1) | $0 | 0 | 0 | $0 | $0 | ||
| BENEFIT OPTION Total | $0 | ($2) | $0 | $0 | ($2) | $0 | ($2) | $0 | ($2) | $0 | 0 | 0 | $0 | $0 | ||
| OAP TRADITIONAL PLAN | 002-PROPERTY ACTIVE | $66 | $0 | $0 | $0 | $66 | $0 | $66 | $0 | $66 | $0 | 1 | 2 | $66 | $33 | |
| 002H-PROPERTY APPRAISERS ACTIVE | $5,000 | $46,848 | $721 | $30,489 | $83,058 | $0 | $83,058 | $0 | $83,058 | $101 | 52 | 125 | $1,597 | $664 | ||
| 003-BOCC ACTIVE | $278,864 | $2,878,105 | $57,674 | $1,283,743 | $4,498,386 | $0 | $4,498,386 | $0 | $4,498,386 | $2,760 | 2,481 | 6,028 | $1,813 | $746 | ||
| 017H-EXPRESSWAY ACTIVE | $708 | $1,843 | $0 | $762 | $3,313 | $0 | $3,313 | $0 | $3,313 | $12 | 6 | 17 | $552 | $195 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $4,027 | $81,349 | $218 | $4,266 | $89,860 | $0 | $89,860 | $0 | $89,860 | $56 | 44 | 108 | $2,042 | $832 | ||
| 020-COURT ACTIVE | $3,802 | $38,345 | $0 | $14,245 | $56,393 | $0 | $56,393 | $0 | $56,393 | $48 | 40 | 91 | $1,410 | $620 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $1,923 | $27,143 | $327 | $1,894 | $31,287 | $0 | $31,287 | $0 | $31,287 | $80 | 26 | 53 | $1,203 | $590 | ||
| 022-CLERK ACTIVE | $24,625 | $355,847 | $4,994 | $93,881 | $479,347 | $0 | $479,347 | $0 | $479,347 | $235 | 257 | 554 | $1,865 | $865 | ||
| 202-PROPERTY RETIREE UNDER 65 | $188 | $1,067 | $0 | $688 | $1,943 | $0 | $1,943 | $0 | $1,943 | $12 | 2 | 2 | $972 | $972 | ||
| 203-BOCC RETIREE UNDER 65 | $15,600 | $113,416 | $128 | $82,014 | $211,157 | $0 | $211,157 | $0 | $211,157 | $347 | 170 | 253 | $1,242 | $835 | ||
| 218-SPORTS RETIREE UNDER 65 | $61 | $931 | $0 | $0 | $991 | $0 | $991 | $0 | $991 | $4 | 2 | 2 | $496 | $496 | ||
| 220-COURT RETIREE UNDER 65 | ($65) | $936 | $0 | $126 | $997 | $0 | $997 | $0 | $997 | $2 | 1 | 1 | $997 | $997 | ||
| 221-C BOARD RETIREE UNDER 65 | $31 | $236 | $0 | $1,720 | $1,987 | $0 | $1,987 | $0 | $1,987 | $2 | 1 | 1 | $1,987 | $1,987 | ||
| 222-CLERK RETIREE UNDER 65 | $466 | $1,876 | $0 | $1,274 | $3,615 | $0 | $3,615 | $0 | $3,615 | $55 | 13 | 14 | $278 | $258 | ||
| 305-PROPERTY RETIREE OVER 65 SINGLE | $26 | $14 | $0 | $0 | $41 | $0 | $41 | $0 | $41 | $2 | 2 | 2 | $20 | $20 | ||
| 306-PROPERTY RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 2 | 2 | $0 | $0 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $1,819 | $17,731 | $2,569 | $27,159 | $49,279 | $0 | $49,279 | $0 | $49,279 | $115 | 57 | 57 | $865 | $865 | ||
| 310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $1,519 | $2,437 | $72 | $2,740 | $6,767 | $0 | $6,767 | $0 | $6,767 | ($46) | 10 | 19 | $677 | $356 | ||
| 311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $746 | $8,795 | $57 | $30,791 | $40,389 | $0 | $40,389 | $0 | $40,389 | $23 | 12 | 24 | $3,366 | $1,683 | ||
| 312-BOCC RETIREE OVER 65 FAMILY | ($991) | $266,181 | $81 | $9,790 | $275,060 | $0 | $275,060 | $0 | $275,060 | ($51) | 4 | 13 | $68,765 | $21,158 | ||
| 367-EXPRESSWAY RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $31 | $0 | $0 | $0 | $31 | $0 | $31 | $0 | $31 | $2 | 1 | 1 | $31 | $31 | ||
| 370-SPORTS RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $37 | $17,550 | $0 | $1,837 | $19,424 | $0 | $19,424 | $0 | $19,424 | $2 | 1 | 1 | $19,424 | $19,424 | ||
| 377-COURT RETIREE OVER 65 SINGLE | $30 | $0 | $0 | $0 | $30 | $0 | $30 | $0 | $30 | $2 | 0 | 0 | $0 | $0 | ||
| 384-C BOARD RETIREE OVER 65 FAMILY | $0 | $0 | $0 | $6,853 | $6,853 | $0 | $6,853 | $0 | $6,853 | $32 | 1 | 2 | $6,853 | $3,427 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $326 | $117 | $1,561 | $967 | $2,971 | $0 | $2,971 | $0 | $2,971 | $20 | 8 | 8 | $371 | $371 | ||
| 387-CLERK RETIREE OVER 65 PLUS SPOUSE (BOTH MEDICARE) | ($13) | $418 | $0 | $0 | $405 | $0 | $405 | $0 | $405 | ($30) | 0 | 0 | $0 | $0 | ||
| 388-CLERK RETIREE OVER 65 FAMILY | ($2) | $0 | $0 | $0 | ($2) | $0 | ($2) | $0 | ($2) | $0 | 0 | 0 | $0 | $0 | ||
| 803-BOCC COBRA | $126 | $0 | $0 | $0 | $126 | $0 | $126 | $0 | $126 | $0 | 0 | 0 | $0 | $0 | ||
| 822-CLERK COBRA | $199 | $569 | $0 | $15,934 | $16,702 | $0 | $16,702 | $0 | $16,702 | $32 | 1 | 1 | $16,702 | $16,702 | ||
| 826-EXPRESSWAY OVER AGE DEP | $43 | $0 | $0 | $0 | $43 | $0 | $43 | $0 | $43 | $2 | 1 | 1 | $43 | $43 | ||
| BENEFIT OPTION Total | $339,193 | $3,861,754 | $68,402 | $1,611,172 | $5,880,520 | $0 | $5,880,520 | $0 | $5,880,520 | $3,819 | 3,196 | 7,382 | $1,840 | $797 | ||
| Mar-2023 Total | $494,499 | $5,096,012 | $77,730 | $2,135,261 | $7,803,502 | $0 | $7,803,502 | $498,997 | $8,302,499 | $7,471 | 5,586 | 11,946 | $1,397 | $653 | ||
| Apr-23 | HDHP MODERN PLAN | 002-PROPERTY ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 3 | 5 | $0 | $0 |
| 002H-PROPERTY APPRAISERS ACTIVE | $3,128 | $27,296 | $0 | $3,209 | $33,633 | $0 | $33,633 | $11,687 | $45,319 | $1,451 | 43 | 86 | $782 | $391 | ||
| 003-BOCC ACTIVE | $124,668 | $1,004,961 | $3,845 | $389,752 | $1,523,227 | $0 | $1,523,227 | $303,490 | $1,826,716 | $62,197 | 1,973 | 3,880 | $772 | $393 | ||
| 017H-EXPRESSWAY ACTIVE | $1,403 | $3,710 | $0 | $2,433 | $7,546 | $0 | $7,546 | $5,983 | $13,529 | $536 | 17 | 39 | $444 | $193 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $423 | ($156) | $0 | $299 | $566 | $0 | $566 | $4,393 | $4,959 | $284 | 9 | 13 | $63 | $44 | ||
| 020-COURT ACTIVE | $763 | $28,996 | $0 | $510 | $30,269 | $0 | $30,269 | $1,092 | $31,361 | $315 | 10 | 23 | $3,027 | $1,316 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $650 | $2,594 | $0 | $15,592 | $18,836 | $0 | $18,836 | $1,394 | $20,231 | $284 | 9 | 19 | $2,093 | $991 | ||
| 022-CLERK ACTIVE | $11,596 | $123,160 | $0 | $79,381 | $214,136 | $0 | $214,136 | $35,722 | $249,857 | $7,759 | 246 | 407 | $870 | $526 | ||
| 202-PROPERTY RETIREE UNDER 65 | $157 | $24,487 | $0 | $769 | $25,414 | $0 | $25,414 | $0 | $25,414 | $158 | 5 | 5 | $5,083 | $5,083 | ||
| 203-BOCC RETIREE UNDER 65 | $3,099 | $25,669 | $0 | $31,566 | $60,334 | $0 | $60,334 | $13,131 | $73,465 | $2,050 | 58 | 74 | $1,040 | $815 | ||
| 222-CLERK RETIREE UNDER 65 | $558 | $21,492 | $0 | $9,117 | $31,166 | $0 | $31,166 | $1,187 | $32,353 | $410 | 12 | 14 | $2,597 | $2,226 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $284 | $36 | $0 | $5,221 | $5,540 | $0 | $5,540 | $0 | $5,540 | $315 | 11 | 11 | $504 | $504 | ||
| 310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $58 | $0 | $0 | $81 | $140 | $0 | $140 | $0 | $140 | $0 | 1 | 2 | $140 | $70 | ||
| 312-BOCC RETIREE OVER 65 FAMILY | $58 | $0 | $0 | $0 | $58 | $0 | $58 | $0 | $58 | $0 | 0 | 0 | $0 | $0 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $146 | $3,623 | $0 | $530 | $4,299 | $0 | $4,299 | $0 | $4,299 | $158 | 5 | 5 | $860 | $860 | ||
| 803-BOCC COBRA | $38 | $1,318 | $0 | $0 | $1,356 | $0 | $1,356 | $0 | $1,356 | $0 | 0 | 0 | $0 | $0 | ||
| BENEFIT OPTION Total | $147,029 | $1,267,186 | $3,845 | $538,460 | $1,956,520 | $0 | $1,956,520 | $378,078 | $2,334,598 | $75,917 | 2,402 | 4,583 | $815 | $427 | ||
| OAP COVERAGE NOW | 003-BOCC ACTIVE | $0 | ($263) | $0 | $0 | ($263) | $0 | ($263) | $0 | ($263) | $0 | 0 | 0 | $0 | $0 | |
| 018-SPORTS ACTIVE | $0 | ($1) | $0 | $0 | ($1) | $0 | ($1) | $0 | ($1) | $0 | 0 | 0 | $0 | $0 | ||
| 022-CLERK ACTIVE | $0 | ($1) | $0 | $0 | ($1) | $0 | ($1) | $0 | ($1) | $0 | 0 | 0 | $0 | $0 | ||
| BENEFIT OPTION Total | $0 | ($265) | $0 | $0 | ($265) | $0 | ($265) | $0 | ($265) | $0 | 0 | 0 | $0 | $0 | ||
| OAP TRADITIONAL PLAN | 002-PROPERTY ACTIVE | $66 | $0 | $0 | $0 | $66 | $0 | $66 | $0 | $66 | $0 | 1 | 2 | $66 | $33 | |
| 002H-PROPERTY APPRAISERS ACTIVE | $5,418 | $81,255 | $2,964 | $29,557 | $119,194 | $0 | $119,194 | $0 | $119,194 | $1,609 | 51 | 124 | $2,337 | $961 | ||
| 003-BOCC ACTIVE | $250,110 | $2,956,037 | $40,324 | $1,473,842 | $4,720,314 | ($13,882) | $4,706,432 | $0 | $4,706,432 | $77,904 | 2,469 | 6,013 | $1,906 | $783 | ||
| 017H-EXPRESSWAY ACTIVE | $687 | $7,676 | $0 | $262 | $8,625 | $0 | $8,625 | $0 | $8,625 | $158 | 5 | 14 | $1,725 | $616 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $4,303 | $301,181 | $240 | $6,724 | $312,448 | $0 | $312,448 | $0 | $312,448 | $1,356 | 43 | 106 | $7,266 | $2,948 | ||
| 020-COURT ACTIVE | $4,167 | $54,798 | $0 | $20,986 | $79,951 | $0 | $79,951 | $0 | $79,951 | $1,262 | 40 | 92 | $1,999 | $869 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $3,397 | $15,469 | $0 | $1,226 | $20,092 | $0 | $20,092 | $0 | $20,092 | $852 | 27 | 54 | $744 | $372 | ||
| 022-CLERK ACTIVE | $21,769 | $501,826 | $184 | $117,009 | $640,788 | $0 | $640,788 | $0 | $640,788 | $8,043 | 255 | 550 | $2,513 | $1,165 | ||
| 202-PROPERTY RETIREE UNDER 65 | $251 | $1,558 | $0 | $775 | $2,584 | $0 | $2,584 | $0 | $2,584 | $189 | 2 | 2 | $1,292 | $1,292 | ||
| 203-BOCC RETIREE UNDER 65 | $12,294 | $116,635 | $14,400 | $89,798 | $233,127 | $0 | $233,127 | $0 | $233,127 | $5,898 | 170 | 251 | $1,371 | $929 | ||
| 218-SPORTS RETIREE UNDER 65 | $80 | $586 | $0 | $227 | $893 | $0 | $893 | $0 | $893 | $63 | 2 | 2 | $447 | $447 | ||
| 220-COURT RETIREE UNDER 65 | $38 | $217 | $0 | $16 | $271 | $0 | $271 | $0 | $271 | $32 | 1 | 1 | $271 | $271 | ||
| 221-C BOARD RETIREE UNDER 65 | $38 | $25 | $53 | $46 | $163 | $0 | $163 | $0 | $163 | $32 | 1 | 1 | $163 | $163 | ||
| 222-CLERK RETIREE UNDER 65 | $682 | $4,013 | $0 | $3,327 | $8,022 | $0 | $8,022 | $0 | $8,022 | $347 | 11 | 11 | $729 | $729 | ||
| 305-PROPERTY RETIREE OVER 65 SINGLE | $38 | $186 | $0 | $0 | $224 | $0 | $224 | $0 | $224 | $32 | 2 | 2 | $112 | $112 | ||
| 306-PROPERTY RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 2 | 2 | $0 | $0 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $2,229 | $9,028 | $577 | $35,671 | $47,505 | $0 | $47,505 | $0 | $47,505 | $1,892 | 54 | 54 | $880 | $880 | ||
| 310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $445 | $8,846 | $28 | $2,471 | $11,790 | $0 | $11,790 | $0 | $11,790 | $284 | 10 | 19 | $1,179 | $621 | ||
| 311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $921 | $2,639 | $521 | $26,019 | $30,099 | $0 | $30,099 | $0 | $30,099 | $378 | 12 | 24 | $2,508 | $1,254 | ||
| 312-BOCC RETIREE OVER 65 FAMILY | $883 | $45,401 | $0 | $5,225 | $51,508 | $0 | $51,508 | $0 | $51,508 | $126 | 4 | 13 | $12,877 | $3,962 | ||
| 367-EXPRESSWAY RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $38 | $215 | $0 | $83 | $336 | $0 | $336 | $0 | $336 | $32 | 1 | 1 | $336 | $336 | ||
| 370-SPORTS RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $43 | $80 | $0 | $1,706 | $1,830 | $0 | $1,830 | $0 | $1,830 | $32 | 1 | 1 | $1,830 | $1,830 | ||
| 377-COURT RETIREE OVER 65 SINGLE | $37 | $0 | $0 | $0 | $37 | $0 | $37 | $0 | $37 | $32 | 0 | 0 | $0 | $0 | ||
| 384-C BOARD RETIREE OVER 65 FAMILY | $93 | $0 | $0 | $6,992 | $7,084 | $0 | $7,084 | $0 | $7,084 | $32 | 1 | 2 | $7,084 | $3,542 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $379 | $2,712 | $115 | $1,185 | $4,392 | $0 | $4,392 | $0 | $4,392 | $315 | 8 | 8 | $549 | $549 | ||
| 802-PROPERTY COBRA | $0 | ($969) | $0 | $0 | ($969) | $0 | ($969) | $0 | ($969) | $0 | 0 | 0 | $0 | $0 | ||
| 803-BOCC COBRA | $8 | $860 | $0 | $0 | $868 | $0 | $868 | $0 | $868 | $0 | 0 | 0 | $0 | $0 | ||
| 822-CLERK COBRA | $77 | $430 | $0 | $16,124 | $16,631 | $0 | $16,631 | $0 | $16,631 | $32 | 1 | 1 | $16,631 | $16,631 | ||
| 826-EXPRESSWAY OVER AGE DEP | $38 | $0 | $0 | $0 | $38 | $0 | $38 | $0 | $38 | $0 | 0 | 0 | $0 | $0 | ||
| BENEFIT OPTION Total | $308,528 | $4,110,704 | $59,406 | $1,839,271 | $6,317,910 | ($13,882) | $6,304,028 | $0 | $6,304,028 | $100,928 | 3,174 | 7,350 | $1,986 | $858 | ||
| Apr-2023 Total | $455,557 | $5,377,624 | $63,251 | $2,377,731 | $8,274,164 | ($13,882) | $8,260,282 | $378,078 | $8,638,360 | $176,845 | 5,576 | 11,933 | $1,481 | $692 | ||
| May-23 | HDHP MODERN PLAN | 002-PROPERTY ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 3 | 5 | $0 | $0 |
| 002H-PROPERTY APPRAISERS ACTIVE | $3,107 | $225,770 | $99 | $5,960 | $234,935 | $0 | $234,935 | $10,820 | $245,755 | $297 | 43 | 85 | $5,464 | $2,764 | ||
| 003-BOCC ACTIVE | $125,818 | $971,852 | $9,682 | $384,331 | $1,491,683 | $0 | $1,491,683 | $338,747 | $1,830,430 | $27,300 | 1,986 | 3,893 | $751 | $383 | ||
| 017H-EXPRESSWAY ACTIVE | $1,403 | $8,479 | $0 | $2,491 | $12,373 | $0 | $12,373 | $5,370 | $17,743 | $536 | 17 | 39 | $728 | $317 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $423 | $235 | $0 | $1,506 | $2,164 | $0 | $2,164 | $173 | $2,337 | $284 | 9 | 13 | $240 | $166 | ||
| 020-COURT ACTIVE | $959 | $21,193 | $0 | $11,463 | $33,616 | $0 | $33,616 | $1,728 | $35,343 | $315 | 10 | 23 | $3,362 | $1,462 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $650 | $1,843 | $0 | $15,727 | $18,220 | $0 | $18,220 | $1,552 | $19,771 | $284 | 9 | 19 | $2,024 | $959 | ||
| 022-CLERK ACTIVE | $13,398 | $73,578 | $0 | $80,176 | $167,151 | $0 | $167,151 | $36,233 | $203,384 | $7,917 | 244 | 408 | $685 | $410 | ||
| 202-PROPERTY RETIREE UNDER 65 | $165 | $333 | $0 | $532 | $1,031 | $0 | $1,031 | $0 | $1,031 | $158 | 5 | 5 | $206 | $206 | ||
| 203-BOCC RETIREE UNDER 65 | $2,773 | $4,591 | $0 | $17,776 | $25,140 | $0 | $25,140 | $6,105 | $31,245 | $1,955 | 54 | 69 | $466 | $364 | ||
| 222-CLERK RETIREE UNDER 65 | $558 | $7,038 | $0 | $8,964 | $16,560 | $0 | $16,560 | $1,333 | $17,893 | $410 | 12 | 14 | $1,380 | $1,183 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $174 | $4,208 | $59 | $5,059 | $9,501 | $0 | $9,501 | $0 | $9,501 | $315 | 11 | 11 | $864 | $864 | ||
| 310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE) | ($22) | $0 | $0 | $0 | ($22) | $0 | ($22) | $0 | ($22) | $0 | 1 | 2 | ($22) | ($11) | ||
| 312-BOCC RETIREE OVER 65 FAMILY | ($32) | $0 | $0 | $0 | ($32) | $0 | ($32) | $0 | ($32) | $0 | 0 | 0 | $0 | $0 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $146 | $1,970 | $23 | $580 | $2,718 | $0 | $2,718 | $0 | $2,718 | $158 | 5 | 5 | $544 | $544 | ||
| 803-BOCC COBRA | $101 | $0 | $0 | $0 | $101 | $0 | $101 | $0 | $101 | $0 | 0 | 0 | $0 | $0 | ||
| BENEFIT OPTION Total | $149,621 | $1,321,089 | $9,863 | $534,566 | $2,015,139 | $0 | $2,015,139 | $402,061 | $2,417,200 | $39,929 | 2,409 | 4,591 | $837 | $439 | ||
| OAP COVERAGE NOW | 003-BOCC ACTIVE | $0 | ($10,860) | $0 | $0 | ($10,860) | $0 | ($10,860) | $0 | ($10,860) | $0 | 0 | 0 | $0 | $0 | |
| BENEFIT OPTION Total | $0 | ($10,860) | $0 | $0 | ($10,860) | $0 | ($10,860) | $0 | ($10,860) | $0 | 0 | 0 | $0 | $0 | ||
| OAP TRADITIONAL PLAN | 002-PROPERTY ACTIVE | $66 | $0 | $0 | $0 | $66 | $0 | $66 | $0 | $66 | $0 | 1 | 2 | $66 | $33 | |
| 002H-PROPERTY APPRAISERS ACTIVE | $5,372 | $25,389 | $10 | $46,907 | $77,678 | $0 | $77,678 | $0 | $77,678 | $98 | 50 | 123 | $1,554 | $632 | ||
| 003-BOCC ACTIVE | $256,088 | $2,842,428 | $56,381 | $1,435,558 | $4,590,455 | ($1,956) | $4,588,499 | $0 | $4,588,499 | $78,219 | 2,474 | 6,027 | $1,855 | $761 | ||
| 017H-EXPRESSWAY ACTIVE | $564 | $1,544 | $496 | $712 | $3,316 | $0 | $3,316 | $0 | $3,316 | $158 | 5 | 14 | $663 | $237 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $4,493 | $30,745 | $0 | $5,608 | $40,846 | $0 | $40,846 | $0 | $40,846 | $1,388 | 44 | 107 | $928 | $382 | ||
| 020-COURT ACTIVE | $4,564 | $85,154 | $307 | $14,892 | $104,917 | $0 | $104,917 | $0 | $104,917 | $1,199 | 38 | 87 | $2,761 | $1,206 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $2,090 | $10,118 | $322 | $4,805 | $17,334 | $0 | $17,334 | $0 | $17,334 | $789 | 25 | 47 | $693 | $369 | ||
| 022-CLERK ACTIVE | $24,689 | $291,944 | $494 | $81,971 | $399,097 | $0 | $399,097 | $0 | $399,097 | $8,106 | 254 | 546 | $1,571 | $731 | ||
| 202-PROPERTY RETIREE UNDER 65 | $251 | $4,798 | $0 | $1,244 | $6,293 | $0 | $6,293 | $0 | $6,293 | $221 | 3 | 3 | $2,098 | $2,098 | ||
| 203-BOCC RETIREE UNDER 65 | $11,599 | $310,553 | $619 | $93,400 | $416,171 | $0 | $416,171 | $0 | $416,171 | $5,866 | 171 | 252 | $2,434 | $1,651 | ||
| 218-SPORTS RETIREE UNDER 65 | $90 | $619 | $0 | $483 | $1,193 | $0 | $1,193 | $0 | $1,193 | $63 | 2 | 2 | $596 | $596 | ||
| 220-COURT RETIREE UNDER 65 | $38 | $1,221 | $0 | $700 | $1,960 | $0 | $1,960 | $0 | $1,960 | $32 | 1 | 1 | $1,960 | $1,960 | ||
| 221-C BOARD RETIREE UNDER 65 | $38 | $15 | $0 | $241 | $295 | $0 | $295 | $0 | $295 | $32 | 1 | 1 | $295 | $295 | ||
| 222-CLERK RETIREE UNDER 65 | $568 | $4,820 | $140 | $1,371 | $6,898 | $0 | $6,898 | $0 | $6,898 | $347 | 11 | 11 | $627 | $627 | ||
| 305-PROPERTY RETIREE OVER 65 SINGLE | $38 | $0 | $0 | $0 | $38 | $0 | $38 | $0 | $38 | $32 | 2 | 2 | $19 | $19 | ||
| 306-PROPERTY RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 2 | 2 | $0 | $0 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $2,084 | $19,303 | $4,107 | $32,690 | $58,184 | $0 | $58,184 | $0 | $58,184 | $1,955 | 54 | 54 | $1,077 | $1,077 | ||
| 310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $589 | $3,497 | $0 | $331 | $4,417 | $0 | $4,417 | $0 | $4,417 | $284 | 10 | 19 | $442 | $232 | ||
| 311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $772 | $12,145 | $39 | $21,257 | $34,212 | $0 | $34,212 | $0 | $34,212 | $378 | 12 | 24 | $2,851 | $1,425 | ||
| 312-BOCC RETIREE OVER 65 FAMILY | $660 | $42,585 | $0 | $4,474 | $47,719 | $0 | $47,719 | $0 | $47,719 | $126 | 4 | 13 | $11,930 | $3,671 | ||
| 367-EXPRESSWAY RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $38 | $68 | $0 | $0 | $106 | $0 | $106 | $0 | $106 | $32 | 1 | 1 | $106 | $106 | ||
| 370-SPORTS RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $43 | $157 | $0 | $25 | $225 | $0 | $225 | $0 | $225 | $32 | 1 | 1 | $225 | $225 | ||
| 377-COURT RETIREE OVER 65 SINGLE | $37 | $0 | $0 | $0 | $37 | $0 | $37 | $0 | $37 | $32 | 0 | 0 | $0 | $0 | ||
| 384-C BOARD RETIREE OVER 65 FAMILY | $93 | $612 | $0 | $6,998 | $7,703 | $0 | $7,703 | $0 | $7,703 | $32 | 1 | 2 | $7,703 | $3,851 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $389 | $3,903 | $33 | $57 | $4,382 | $0 | $4,382 | $0 | $4,382 | $347 | 8 | 8 | $548 | $548 | ||
| 387-CLERK RETIREE OVER 65 PLUS SPOUSE (BOTH MEDICARE) | ($123) | $400 | $0 | $0 | $277 | $0 | $277 | $0 | $277 | $0 | 0 | 0 | $0 | $0 | ||
| 822-CLERK COBRA | $77 | $1,350 | $0 | $16,268 | $17,695 | $0 | $17,695 | $0 | $17,695 | $32 | 1 | 1 | $17,695 | $17,695 | ||
| BENEFIT OPTION Total | $315,206 | $3,693,368 | $62,948 | $1,769,992 | $5,841,513 | ($1,956) | $5,839,557 | $0 | $5,839,557 | $99,795 | 3,176 | 7,350 | $1,839 | $794 | ||
| May-2023 Total | $464,827 | $5,003,596 | $72,811 | $2,304,558 | $7,845,792 | ($1,956) | $7,843,836 | $402,061 | $8,245,897 | $139,725 | 5,585 | 11,941 | $1,404 | $657 | ||
| Jun-23 | HDHP MODERN PLAN | 002-PROPERTY ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 3 | 5 | $0 | $0 |
| 002H-PROPERTY APPRAISERS ACTIVE | $3,048 | $13,119 | $0 | $10,605 | $26,773 | $0 | $26,773 | $8,605 | $35,377 | $1,451 | 43 | 85 | $623 | $315 | ||
| 003-BOCC ACTIVE | $131,123 | $1,153,061 | $11,948 | $503,677 | $1,799,809 | $0 | $1,799,809 | $319,231 | $2,119,040 | $64,752 | 2,036 | 3,959 | $884 | $455 | ||
| 017H-EXPRESSWAY ACTIVE | $1,414 | $3,302 | $0 | $5,384 | $10,101 | $0 | $10,101 | $5,335 | $15,436 | $536 | 17 | 39 | $594 | $259 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $423 | $1,240 | $0 | $40 | $1,702 | $0 | $1,702 | $2,128 | $3,830 | $284 | 9 | 13 | $189 | $131 | ||
| 020-COURT ACTIVE | $763 | $7,423 | $0 | $2,593 | $10,778 | $0 | $10,778 | $461 | $11,239 | $315 | 10 | 23 | $1,078 | $469 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $650 | $2,830 | $0 | $13,123 | $16,603 | $0 | $16,603 | $3,844 | $20,447 | $252 | 8 | 17 | $2,075 | $977 | ||
| 022-CLERK ACTIVE | $14,931 | $133,264 | $0 | $60,825 | $209,020 | $0 | $209,020 | $45,084 | $254,104 | $7,980 | 251 | 420 | $833 | $498 | ||
| 202-PROPERTY RETIREE UNDER 65 | $165 | $109 | $0 | $1,591 | $1,866 | $0 | $1,866 | $92 | $1,957 | $158 | 5 | 5 | $373 | $373 | ||
| 203-BOCC RETIREE UNDER 65 | $6,810 | $32,100 | $0 | $25,644 | $64,554 | $0 | $64,554 | $12,485 | $77,039 | $1,955 | 55 | 70 | $1,174 | $922 | ||
| 222-CLERK RETIREE UNDER 65 | $555 | $20,210 | $0 | $7,535 | $28,299 | $0 | $28,299 | $305 | $28,604 | $410 | 12 | 13 | $2,358 | $2,177 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $291 | $975 | $0 | $1,524 | $2,790 | $0 | $2,790 | $0 | $2,790 | $347 | 11 | 11 | $254 | $254 | ||
| 310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $21 | $0 | $0 | $0 | $21 | $0 | $21 | $0 | $21 | $0 | 1 | 2 | $21 | $11 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $146 | $2,953 | $0 | $66 | $3,165 | $0 | $3,165 | $0 | $3,165 | $158 | 5 | 5 | $633 | $633 | ||
| 803-BOCC COBRA | $34 | $460 | $0 | $0 | $494 | $0 | $494 | $0 | $494 | $0 | 0 | 0 | $0 | $0 | ||
| BENEFIT OPTION Total | $160,374 | $1,371,045 | $11,948 | $632,607 | $2,175,974 | $0 | $2,175,974 | $397,569 | $2,573,544 | $78,598 | 2,466 | 4,667 | $882 | $466 | ||
| OAP COVERAGE NOW | 003-BOCC ACTIVE | $0 | ($111) | $0 | $0 | ($111) | $0 | ($111) | $0 | ($111) | $0 | 0 | 0 | $0 | $0 | |
| 203-BOCC RETIREE UNDER 65 | $0 | ($263) | $0 | $0 | ($263) | $0 | ($263) | $0 | ($263) | $0 | 0 | 0 | $0 | $0 | ||
| 312-BOCC RETIREE OVER 65 FAMILY | $0 | ($4,766) | $0 | $0 | ($4,766) | $0 | ($4,766) | $0 | ($4,766) | $0 | 0 | 0 | $0 | $0 | ||
| BENEFIT OPTION Total | $0 | ($5,140) | $0 | $0 | ($5,140) | $0 | ($5,140) | $0 | ($5,140) | $0 | 0 | 0 | $0 | $0 | ||
| OAP TRADITIONAL PLAN | 002-PROPERTY ACTIVE | $66 | $0 | $0 | $0 | $66 | $0 | $66 | $0 | $66 | $0 | 1 | 2 | $66 | $33 | |
| 002H-PROPERTY APPRAISERS ACTIVE | $6,394 | $30,999 | $0 | $39,078 | $76,471 | $0 | $76,471 | $0 | $76,471 | $1,577 | 50 | 123 | $1,529 | $622 | ||
| 003-BOCC ACTIVE | $272,153 | $3,047,800 | $20,763 | $1,390,659 | $4,731,374 | ($17,966) | $4,713,408 | $0 | $4,713,408 | $78,976 | 2,492 | 6,068 | $1,891 | $777 | ||
| 016H-PORT AUTHORITY ACTIVE | $0 | ($10,000) | $0 | $0 | ($10,000) | $0 | ($10,000) | $0 | ($10,000) | $0 | 0 | 0 | $0 | $0 | ||
| 017H-EXPRESSWAY ACTIVE | $564 | $1,646 | $117 | $861 | $3,188 | $0 | $3,188 | $0 | $3,188 | $158 | 5 | 14 | $638 | $228 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $4,455 | $186,256 | $13,410 | $6,094 | $210,215 | $0 | $210,215 | $0 | $210,215 | $1,356 | 43 | 106 | $4,889 | $1,983 | ||
| 020-COURT ACTIVE | $3,876 | $59,459 | $0 | $20,781 | $84,117 | $0 | $84,117 | $0 | $84,117 | $1,199 | 38 | 87 | $2,214 | $967 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $2,172 | $27,238 | $161 | $3,938 | $33,509 | $0 | $33,509 | $0 | $33,509 | $789 | 25 | 47 | $1,340 | $713 | ||
| 022-CLERK ACTIVE | $23,605 | $235,306 | $83 | $101,889 | $360,883 | $0 | $360,883 | $0 | $360,883 | $7,980 | 252 | 541 | $1,432 | $667 | ||
| 202-PROPERTY RETIREE UNDER 65 | $298 | $5,719 | $0 | $2,408 | $8,425 | $0 | $8,425 | $0 | $8,425 | $221 | 3 | 3 | $2,808 | $2,808 | ||
| 203-BOCC RETIREE UNDER 65 | $15,335 | $300,823 | $5,685 | $94,637 | $416,480 | $0 | $416,480 | $0 | $416,480 | $5,835 | 171 | 254 | $2,436 | $1,640 | ||
| 218-SPORTS RETIREE UNDER 65 | $90 | $663 | $0 | $589 | $1,342 | $0 | $1,342 | $0 | $1,342 | $63 | 2 | 2 | $671 | $671 | ||
| 220-COURT RETIREE UNDER 65 | $38 | $5,202 | $0 | $1,885 | $7,126 | $0 | $7,126 | $0 | $7,126 | $32 | 1 | 1 | $7,126 | $7,126 | ||
| 221-C BOARD RETIREE UNDER 65 | $38 | $73 | $156 | $1,010 | $1,276 | $0 | $1,276 | $0 | $1,276 | $32 | 1 | 1 | $1,276 | $1,276 | ||
| 222-CLERK RETIREE UNDER 65 | $317 | $1,040 | $140 | $2,683 | $4,180 | $0 | $4,180 | $0 | $4,180 | $347 | 11 | 11 | $380 | $380 | ||
| 305-PROPERTY RETIREE OVER 65 SINGLE | $38 | $9 | $0 | $0 | $47 | $0 | $47 | $0 | $47 | $32 | 2 | 2 | $24 | $24 | ||
| 306-PROPERTY RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 2 | 2 | $0 | $0 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $7,432 | $12,846 | $4,055 | $39,529 | $63,862 | $0 | $63,862 | $0 | $63,862 | $1,955 | 54 | 54 | $1,183 | $1,183 | ||
| 310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $521 | $3,182 | $0 | $1,065 | $4,768 | $0 | $4,768 | $0 | $4,768 | $315 | 8 | 15 | $596 | $318 | ||
| 311-BOCC RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $915 | $3,831 | $177 | $25,731 | $30,654 | $0 | $30,654 | $0 | $30,654 | $378 | 12 | 24 | $2,554 | $1,277 | ||
| 312-BOCC RETIREE OVER 65 FAMILY | $69 | ($75,072) | $0 | $5,586 | ($69,417) | $0 | ($69,417) | $0 | ($69,417) | $126 | 4 | 13 | ($17,354) | ($5,340) | ||
| 367-EXPRESSWAY RETIREE OVER 65 SPOUSE (BOTH MEDICARE) | $38 | $0 | $0 | $0 | $38 | $0 | $38 | $0 | $38 | $32 | 1 | 1 | $38 | $38 | ||
| 370-SPORTS RETIREE OVER 65 SPOUSE (ONE MEDICARE) | $43 | $132 | $0 | $152 | $327 | $0 | $327 | $0 | $327 | $32 | 1 | 1 | $327 | $327 | ||
| 377-COURT RETIREE OVER 65 SINGLE | $37 | $0 | $0 | $0 | $37 | $0 | $37 | $0 | $37 | $32 | 0 | 0 | $0 | $0 | ||
| 384-C BOARD RETIREE OVER 65 FAMILY | $93 | $0 | $0 | $6,853 | $6,946 | $0 | $6,946 | $0 | $6,946 | $32 | 1 | 2 | $6,946 | $3,473 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $417 | $1,698 | ($32) | $1,397 | $3,481 | $0 | $3,481 | $0 | $3,481 | $315 | 8 | 8 | $435 | $435 | ||
| 803-BOCC COBRA | ($8) | $0 | $0 | $0 | ($8) | $0 | ($8) | $0 | ($8) | $32 | 1 | 1 | ($8) | ($8) | ||
| 822-CLERK COBRA | $77 | $874 | $0 | $32,283 | $33,234 | $0 | $33,234 | $0 | $33,234 | $32 | 1 | 1 | $33,234 | $33,234 | ||
| BENEFIT OPTION Total | $339,075 | $3,839,725 | $44,713 | $1,779,110 | $6,002,623 | ($17,966) | $5,984,657 | $0 | $5,984,657 | $101,874 | 3,190 | 7,384 | $1,876 | $810 | ||
| Jun-2023 Total | $499,449 | $5,205,630 | $56,661 | $2,411,717 | $8,173,457 | ($17,966) | $8,155,492 | $397,569 | $8,553,061 | $180,472 | 5,656 | 12,051 | $1,442 | $677 | ||
| Jul-23 | HDHP MODERN PLAN | 002-PROPERTY ACTIVE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 3 | 5 | $0 | $0 |
| 002H-PROPERTY APPRAISERS ACTIVE | $3,047 | $50,616 | $0 | $5,881 | $59,544 | $0 | $59,544 | $18,018 | $77,563 | $1,451 | 43 | 84 | $1,385 | $709 | ||
| 003-BOCC ACTIVE | $127,369 | $1,129,287 | $5,589 | $427,357 | $1,689,602 | $0 | $1,689,602 | $291,824 | $1,981,426 | $65,351 | 2,051 | 3,982 | $824 | $424 | ||
| 017H-EXPRESSWAY ACTIVE | $1,363 | $11,871 | $0 | $3,959 | $17,193 | $0 | $17,193 | $6,417 | $23,610 | $505 | 16 | 35 | $1,075 | $491 | ||
| 018H-SPORTS AUTHORITY ACTIVE | $424 | $0 | $0 | $342 | $766 | $0 | $766 | $841 | $1,607 | $284 | 9 | 14 | $85 | $55 | ||
| 020-COURT ACTIVE | $739 | $5,842 | $0 | $11,116 | $17,696 | $0 | $17,696 | $1,987 | $19,683 | $315 | 10 | 23 | $1,770 | $769 | ||
| 021H-CHILDREN 'S BOARD ACTIVE | $578 | $3,477 | $0 | $13,614 | $17,669 | $0 | $17,669 | $3,207 | $20,876 | $284 | 9 | 18 | $1,963 | $982 | ||
| 022-CLERK ACTIVE | $13,122 | $89,200 | $0 | $81,100 | $183,422 | $0 | $183,422 | $29,370 | $212,792 | $8,200 | 258 | 429 | $711 | $428 | ||
| 202-PROPERTY RETIREE UNDER 65 | $166 | $0 | $0 | $1,443 | $1,609 | $0 | $1,609 | $1,162 | $2,771 | $158 | 5 | 5 | $322 | $322 | ||
| 203-BOCC RETIREE UNDER 65 | $2,461 | $9,056 | $0 | $24,915 | $36,432 | $0 | $36,432 | $4,864 | $41,295 | $1,924 | 55 | 69 | $662 | $528 | ||
| 222-CLERK RETIREE UNDER 65 | $544 | $14,514 | $0 | $8,985 | $24,043 | $0 | $24,043 | $2,316 | $26,359 | $442 | 13 | 15 | $1,849 | $1,603 | ||
| 309-BOCC RETIREE OVER 65 SINGLE | $291 | $1,604 | $16 | $9,241 | $11,152 | $0 | $11,152 | $0 | $11,152 | $284 | 11 | 11 | $1,014 | $1,014 | ||
| 310-BOCC RETIREE OVER 65 SPOUSE (ONE MEDICARE) | ($48) | $0 | $0 | $0 | ($48) | $0 | ($48) | $0 | ($48) | $0 | 1 | 2 | ($48) | ($24) | ||
| 312-BOCC RETIREE OVER 65 FAMILY | ($144) | $0 | $0 | $0 | ($144) | $0 | ($144) | $0 | ($144) | $0 | 0 | 0 | $0 | $0 | ||
| 385-CLERK RETIREE OVER 65 SINGLE | $146 | $3,531 | $18 | $21 | $3,716 | $0 | $3,716 | $0 | $3,716 | $158 | 4 | 4 | $929 | $929 | ||
| 803-BOCC COBRA | $39 | $0 | $0 | $0 | $39 | $0 | $39 | $0 | $39 | $0 | 0 | 0 | $0 | $0 | ||
| BENEFIT OPTION Total | $150,098 | $1,318,998 | $5,623 | $587,975 | $2,062,693 | $0 | $2,062,693 | $360,006 | $2,422,699 | $79,355 | 2,488 | 4,696 | $829 | $439 | ||
| OAP COVERAGE NOW | 003-BOCC ACTIVE | $0 | ($8,291) | $0 | $0 | ($8,291) | $0 | ($8,291) | $0 | ($8,291) | $0 | 0 | 0 | $0 | $0 | |
| 203-BOCC RETIREE UNDER 65 | $0 | ($124) | $0 | $0 | ($124) | $0 | ($124) | $0 | ($124) | $0 | 0 | 0 | $0 | $0 | ||
| BENEFIT OPTION Total | $0 | ($8,415) | $0 | $0 | ($8,415) | $0 | ($8,415) | $0 | ($8,415) | $0 | 0 | 0 | $0 | $0 |
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 .