ESBD_360338_1716477843084_Attachment I - Additional Supporting Claims and Enrollment Information.xlsx
XLSX spreadsheet 127 KB Posted
- Solicitation number
- RFp2024-P11
- Issued by
- Hays County, Texas
About this file
This document is an attachment to a Request for Proposal (RFP) issued by Hays County, Texas for Employee Health, Dental, and Employee Assistance Plans. The County is seeking a comprehensive package to include Medical, Pharmacy, Dental, and Employee Wellness/Assistance Plan, and is looking to implement the chosen plans effective January 1, 2025, with open enrollment starting October 1, 2024. The County is evaluating any combination of plan designs, networks, and services, as well as value added services, and is seeking to partner with insurance companies who can help achieve competitive long term and stable financial success while offering a robust benefits package.
The RFP does not include banking for the Health Savings Account. Pricing terms, set asides, incumbents, funding requirements and sources are not specified in the provided information. The County is fully committed to implementing the chosen plans and is looking for insurance companies that can help them achieve their goals of competitive long-term and stable financial success while offering a very robust benefits package to their employees.
View the file
Other files
Show all 23
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
Membership By Month
| Membership By Month | ||||||||
| Report Filter: | ||||||||
| ({Type of Coverage} = Medical) And ({-Policy Number} = 000912772) And ({Membership Year/Month} = 2024-03, 2024-02, 2024-01, 2023-12, 2023-11, 2023-10, 2023-09, 2023-08, 2023-07, 2023-06, 2023-05, 2023-04, 2023-03, 2023-02, 2023-01, 2022-12, 2022-11, 2022-10, 2022-09, 2022-08, 2022-07, 2022-06, 2022-05, 2022-04, 2022-03, 2022-02, 2022-01, 2021-12, 2021-11, 2021-10, 2021-09, 2021-08, 2021-07, 2021-06, 2021-05, 2021-04) | ||||||||
| Employment Status | Membership Year/Month | Single Subscribers | Subscribers plus Spouse | Subscribers plus Child/Children | Subscribers plus Family | Total Subscribers | Enrolled Dependents | Total Members |
| Active | 2021-04 | 467 | 92 | 195 | 158 | 912 | 962 | 1,874 |
| 2021-05 | 466 | 94 | 193 | 157 | 910 | 964 | 1,874 | |
| 2021-06 | 468 | 95 | 193 | 158 | 914 | 966 | 1,880 | |
| 2021-07 | 461 | 95 | 194 | 156 | 906 | 961 | 1,867 | |
| 2021-08 | 465 | 93 | 192 | 158 | 908 | 965 | 1,873 | |
| 2021-09 | 461 | 92 | 193 | 155 | 901 | 956 | 1,857 | |
| 2021-10 | 459 | 89 | 191 | 155 | 894 | 951 | 1,845 | |
| 2021-11 | 458 | 87 | 190 | 155 | 890 | 942 | 1,832 | |
| 2021-12 | 456 | 86 | 188 | 155 | 885 | 934 | 1,819 | |
| 2022-01 | 458 | 79 | 188 | 154 | 879 | 929 | 1,808 | |
| 2022-02 | 452 | 78 | 188 | 152 | 870 | 921 | 1,791 | |
| 2022-03 | 455 | 77 | 188 | 152 | 872 | 923 | 1,795 | |
| 2022-04 | 461 | 76 | 184 | 151 | 872 | 915 | 1,787 | |
| 2022-05 | 462 | 76 | 182 | 154 | 874 | 914 | 1,788 | |
| 2022-06 | 458 | 78 | 180 | 155 | 871 | 913 | 1,784 | |
| 2022-07 | 454 | 80 | 181 | 154 | 869 | 915 | 1,784 | |
| 2022-08 | 455 | 81 | 180 | 151 | 867 | 906 | 1,773 | |
| 2022-09 | 458 | 81 | 178 | 157 | 874 | 920 | 1,794 | |
| 2022-10 | 460 | 81 | 174 | 162 | 877 | 930 | 1,807 | |
| 2022-11 | 464 | 81 | 175 | 163 | 883 | 934 | 1,817 | |
| 2022-12 | 461 | 84 | 176 | 161 | 882 | 935 | 1,817 | |
| 2023-01 | 456 | 82 | 177 | 159 | 874 | 929 | 1,803 | |
| 2023-02 | 461 | 83 | 177 | 160 | 881 | 932 | 1,813 | |
| 2023-03 | 466 | 85 | 180 | 165 | 896 | 961 | 1,857 | |
| 2023-04 | 468 | 85 | 182 | 164 | 899 | 962 | 1,861 | |
| 2023-05 | 481 | 85 | 181 | 164 | 911 | 966 | 1,877 | |
| 2023-06 | 489 | 86 | 180 | 168 | 923 | 976 | 1,899 | |
| 2023-07 | 480 | 88 | 181 | 164 | 913 | 962 | 1,875 | |
| 2023-08 | 488 | 86 | 182 | 161 | 917 | 949 | 1,866 | |
| 2023-09 | 496 | 85 | 185 | 162 | 928 | 956 | 1,884 | |
| 2023-10 | 518 | 85 | 187 | 161 | 951 | 958 | 1,909 | |
| 2023-11 | 530 | 82 | 190 | 162 | 964 | 968 | 1,932 | |
| 2023-12 | 537 | 84 | 188 | 161 | 970 | 959 | 1,929 | |
| 2024-01 | 543 | 89 | 197 | 161 | 990 | 977 | 1,967 | |
| 2024-02 | 546 | 89 | 200 | 159 | 994 | 983 | 1,977 | |
| 2024-03 | 549 | 88 | 203 | 159 | 999 | 987 | 1,986 | |
| Total | 17,167 | 3,057 | 6,693 | 5,703 | 32,620 | 34,081 | 66,701 | |
| Retired | 2021-04 | 64 | 18 | 2 | 3 | 87 | 27 | 114 |
| 2021-05 | 64 | 18 | 2 | 3 | 87 | 27 | 114 | |
| 2021-06 | 64 | 18 | 2 | 3 | 87 | 27 | 114 | |
| 2021-07 | 63 | 18 | 2 | 3 | 86 | 28 | 114 | |
| 2021-08 | 63 | 18 | 2 | 3 | 86 | 27 | 113 | |
| 2021-09 | 64 | 17 | 2 | 3 | 86 | 26 | 112 | |
| 2021-10 | 65 | 16 | 2 | 3 | 86 | 25 | 111 | |
| 2021-11 | 65 | 16 | 2 | 3 | 86 | 25 | 111 | |
| 2021-12 | 65 | 16 | 2 | 3 | 86 | 25 | 111 | |
| 2022-01 | 65 | 16 | 2 | 3 | 86 | 25 | 111 | |
| 2022-02 | 65 | 16 | 2 | 3 | 86 | 25 | 111 | |
| 2022-03 | 65 | 15 | 2 | 3 | 85 | 24 | 109 | |
| 2022-04 | 65 | 15 | 2 | 3 | 85 | 24 | 109 | |
| 2022-05 | 65 | 15 | 2 | 3 | 85 | 24 | 109 | |
| 2022-06 | 65 | 15 | 2 | 3 | 85 | 24 | 109 | |
| 2022-07 | 65 | 15 | 2 | 3 | 85 | 24 | 109 | |
| 2022-08 | 65 | 15 | 2 | 3 | 85 | 24 | 109 | |
| 2022-09 | 64 | 15 | 2 | 3 | 84 | 24 | 108 | |
| 2022-10 | 64 | 15 | 2 | 3 | 84 | 24 | 108 | |
| 2022-11 | 64 | 15 | 2 | 3 | 84 | 24 | 108 | |
| 2022-12 | 64 | 15 | 2 | 3 | 84 | 24 | 108 | |
| 2023-01 | 65 | 14 | 2 | 3 | 84 | 23 | 107 | |
| 2023-02 | 64 | 14 | 2 | 3 | 83 | 23 | 106 | |
| 2023-03 | 64 | 14 | 2 | 3 | 83 | 23 | 106 | |
| 2023-04 | 64 | 14 | 2 | 3 | 83 | 23 | 106 | |
| 2023-05 | 64 | 13 | 2 | 3 | 82 | 22 | 104 | |
| 2023-06 | 64 | 13 | 2 | 3 | 82 | 22 | 104 | |
| 2023-07 | 64 | 13 | 2 | 3 | 82 | 22 | 104 | |
| 2023-08 | 65 | 13 | 2 | 3 | 83 | 22 | 105 | |
| 2023-09 | 66 | 11 | 2 | 3 | 82 | 20 | 102 | |
| 2023-10 | 66 | 10 | 2 | 3 | 81 | 19 | 100 | |
| 2023-11 | 65 | 10 | 2 | 3 | 80 | 19 | 99 | |
| 2023-12 | 65 | 10 | 2 | 3 | 80 | 19 | 99 | |
| 2024-01 | 66 | 9 | 2 | 3 | 80 | 18 | 98 | |
| 2024-02 | 65 | 9 | 2 | 3 | 79 | 18 | 97 | |
| 2024-03 | 65 | 8 | 2 | 3 | 78 | 17 | 95 | |
| Total | 2,325 | 512 | 72 | 108 | 3,017 | 837 | 3,854 | |
| This document contains UnitedHealthcare’s confidential and/or proprietary business information (PBI). PBI may only be used by |
the recipient person/entity to which it is addressed. Recipient is liable for using and protecting UnitedHealthcare’s PBI from further disclosure or misuse, consistent with recipient’s contractual obligations under any applicable administrative services agreement, group policy contract, non-disclosure agreement or other applicable contract or law, including but not limited to the U.S. Freedom of Information Act and state freedom of information law exemptions for “trade secrets”. The document may also contain protected health information (PHI) and must be handled according to applicable state and federal law, including, but not limited to HIPAA. Recipients who misuse information may be subject to both civil and criminal penalties.
Payments By Month
| Payments By Month | |||||
| Report Filter: | |||||
| ({Benefit Type Category} = Dental Benefit, FSA Benefit, Managed Pharmacy Benefit, Medical Benefit, Vision Benefit, HRA Benefit - Medical, HRA Benefit - Pharmacy) And ({-Policy Number} = 000912772) And ({Service Year/Month} = 2024-01, 2023-12, 2023-11, 2023-10, 2023-09, 2023-08, 2023-07, 2023-06, 2023-05, 2023-04, 2023-03, 2023-02, 2023-01, 2022-12, 2022-11, 2022-10, 2022-09, 2022-08, 2022-07, 2022-06, 2022-05, 2022-04, 2022-03, 2022-02, 2022-01, 2021-12, 2021-11, 2021-10, 2021-09, 2021-08, 2021-07, 2021-06, 2021-05, 2021-04) And ({Book Year/Month} = 2024-03, 2024-02, 2024-01, 2023-12, 2023-11, 2023-10, 2023-09, 2023-08, 2023-07, 2023-06, 2023-05, 2023-04, 2023-03, 2023-02, 2023-01, 2022-12, 2022-11, 2022-10, 2022-09, 2022-08, 2022-07, 2022-06, 2022-05, 2022-04, 2022-03, 2022-02, 2022-01, 2021-12, 2021-11, 2021-10, 2021-09, 2021-08, 2021-07, 2021-06, 2021-05, 2021-04) | |||||
| Employment Status | Benefit Payment | Medical | Managed Pharmacy | Dental | Total |
| Book Year/Month | Payments | Payments | Payments | Payments | |
| Active | 2021-04 | $182,715 | $93,399 | $31,018 | $307,131 |
| 2021-05 | $436,976 | $183,577 | $45,702 | $666,255 | |
| 2021-06 | $401,519 | $252,288 | $37,698 | $691,505 | |
| 2021-07 | $1,197,093 | $180,203 | $41,254 | $1,418,550 | |
| 2021-08 | $641,281 | $183,000 | $43,803 | $868,084 | |
| 2021-09 | $918,175 | $236,805 | $44,467 | $1,199,446 | |
| 2021-10 | $721,287 | $220,005 | $35,088 | $976,381 | |
| 2021-11 | $1,931,468 | $259,071 | $42,464 | $2,233,004 | |
| 2021-12 | $935,543 | $234,477 | $41,898 | $1,211,919 | |
| 2022-01 | $824,821 | $200,351 | $31,370 | $1,056,542 | |
| 2022-02 | $445,269 | $165,306 | $36,521 | $647,095 | |
| 2022-03 | $546,601 | $180,604 | $41,494 | $768,699 | |
| 2022-04 | $538,939 | $207,047 | $40,445 | $786,431 | |
| 2022-05 | $572,235 | $188,251 | $40,423 | $800,909 | |
| 2022-06 | $640,182 | $215,311 | $42,896 | $898,389 | |
| 2022-07 | $470,490 | $247,926 | $34,967 | $753,383 | |
| 2022-08 | $519,080 | $215,966 | $48,053 | $783,099 | |
| 2022-09 | $369,248 | $220,349 | $38,471 | $628,068 | |
| 2022-10 | $465,111 | $236,479 | $37,136 | $738,726 | |
| 2022-11 | $1,110,805 | $275,457 | $37,026 | $1,423,287 | |
| 2022-12 | $676,302 | $251,428 | $42,342 | $970,072 | |
| 2023-01 | $746,039 | $190,950 | $43,028 | $980,017 | |
| 2023-02 | $477,672 | $269,915 | $35,699 | $783,287 | |
| 2023-03 | $599,303 | $253,933 | $47,180 | $900,416 | |
| 2023-04 | $657,423 | $283,967 | $42,832 | $984,222 | |
| 2023-05 | $882,940 | $270,746 | $50,187 | $1,203,874 | |
| 2023-06 | $720,394 | $300,089 | $48,387 | $1,068,871 | |
| 2023-07 | $555,638 | $266,833 | $39,503 | $861,974 | |
| 2023-08 | $633,307 | $314,100 | $53,796 | $1,001,202 | |
| 2023-09 | $607,769 | $265,937 | $43,301 | $917,007 | |
| 2023-10 | $743,003 | $288,733 | $48,226 | $1,079,962 | |
| 2023-11 | $678,372 | $251,961 | $45,115 | $975,448 | |
| 2023-12 | $762,318 | $254,254 | $40,119 | $1,056,691 | |
| 2024-01 | $1,128,406 | $287,804 | $52,837 | $1,469,047 | |
| 2024-02 | $492,673 | $163,406 | $10,703 | $666,783 | |
| 2024-03 | $92,576 | ($8,155) | $3,425 | $87,846 | |
| Total | $24,322,974 | $8,101,774 | $1,438,872 | $33,863,621 | |
| Retired | 2021-04 | $3,139 | $41,312 | $0 | $44,451 |
| 2021-05 | $15,985 | $58,206 | $0 | $74,191 | |
| 2021-06 | $27,723 | $74,285 | $0 | $102,008 | |
| 2021-07 | $48,125 | $96,114 | $0 | $144,239 | |
| 2021-08 | $33,380 | $66,630 | $0 | $100,009 | |
| 2021-09 | $28,928 | $71,481 | $0 | $100,410 | |
| 2021-10 | $39,785 | $53,454 | $0 | $93,239 | |
| 2021-11 | $42,538 | $75,099 | $0 | $117,637 | |
| 2021-12 | $34,993 | $91,923 | $0 | $126,916 | |
| 2022-01 | $34,114 | $58,771 | $0 | $92,886 | |
| 2022-02 | $36,162 | $70,054 | $0 | $106,215 | |
| 2022-03 | $37,537 | $56,547 | $0 | $94,085 | |
| 2022-04 | $48,695 | $96,282 | $0 | $144,976 | |
| 2022-05 | $73,418 | $61,161 | $0 | $134,579 | |
| 2022-06 | $41,497 | $94,876 | $0 | $136,373 | |
| 2022-07 | $51,964 | $75,021 | $0 | $126,984 | |
| 2022-08 | $42,542 | $85,053 | $0 | $127,594 | |
| 2022-09 | $28,742 | $83,421 | $0 | $112,163 | |
| 2022-10 | $6,169 | $59,540 | $0 | $65,709 | |
| 2022-11 | $105,080 | $72,077 | $0 | $177,157 | |
| 2022-12 | $83,423 | $68,525 | $0 | $151,948 | |
| 2023-01 | $56,862 | $74,212 | $0 | $131,074 | |
| 2023-02 | $25,401 | $66,369 | $0 | $91,770 | |
| 2023-03 | $65,960 | $68,439 | $0 | $134,399 | |
| 2023-04 | $39,808 | $53,519 | $0 | $93,328 | |
| 2023-05 | $103,525 | $63,007 | $0 | $166,532 | |
| 2023-06 | $106,272 | $74,932 | $0 | $181,204 | |
| 2023-07 | $148,975 | $76,590 | $0 | $225,564 | |
| 2023-08 | $99,477 | $82,389 | $0 | $181,866 | |
| 2023-09 | $76,888 | $73,840 | $0 | $150,728 | |
| 2023-10 | $188,784 | $63,523 | $0 | $252,306 | |
| 2023-11 | $32,149 | $87,474 | $0 | $119,623 | |
| 2023-12 | $59,867 | $108,424 | $0 | $168,292 | |
| 2024-01 | $18,498 | $79,153 | $0 | $97,651 | |
| 2024-02 | $28,522 | $52,726 | $0 | $81,248 | |
| 2024-03 | $10,949 | ($134) | $0 | $10,814 | |
| Total | $1,925,872 | $2,534,295 | $0 | $4,460,167 | |
| This document contains UnitedHealthcare’s confidential and/or proprietary business information (PBI). PBI may only be used by |
the recipient person/entity to which it is addressed. Recipient is liable for using and protecting UnitedHealthcare’s PBI from further disclosure or misuse, consistent with recipient’s contractual obligations under any applicable administrative services agreement, group policy contract, non-disclosure agreement or other applicable contract or law, including but not limited to the U.S. Freedom of Information Act and state freedom of information law exemptions for “trade secrets”. The document may also contain protected health information (PHI) and must be handled according to applicable state and federal law, including, but not limited to HIPAA. Recipients who misuse information may be subject to both civil and criminal penalties.
12 Month Claim Expenses
| Claim Expenses by Size of Payment | ||||||
| Report Filter: | ||||||
| ({Service Year/Month} = 2024-01, 2023-12, 2023-11, 2023-10, 2023-09, 2023-08, 2023-07, 2023-06, 2023-05, 2023-04, 2023-03, 2023-02) And ({Book Year/Month} = 2024-03, 2024-02, 2024-01, 2023-12, 2023-11, 2023-10, 2023-09, 2023-08, 2023-07, 2023-06, 2023-05, 2023-04, 2023-03, 2023-02) And ({-Policy Number} = 000912772) And ({Benefit Type Category} = Medical Benefit , Managed Pharmacy Benefit ) And ({Claimant ID} (ID) <> "9999999999999999") | ||||||
| Employment Status | Payment Category | Number of Claimants | % Claimants | Payments | % Payments | |
| Active | Total | 1,860 | 100.0% | $11,621,212.82 | 100.0% | |
| <$.01 | 6 | 0.3% | $0.00 | 0.0% | ||
| $.01-$49 | 45 | 2.4% | $1,323.34 | 0.0% | ||
| $50-$99 | 67 | 3.6% | $5,064.21 | 0.0% | ||
| $100-$249 | 196 | 10.5% | $33,741.23 | 0.3% | ||
| $250-$499 | 239 | 12.8% | $87,746.28 | 0.8% | ||
| $500-$999 | 268 | 14.4% | $195,914.61 | 1.7% | ||
| $1,000-$2,499 | 361 | 19.4% | $572,820.47 | 4.9% | ||
| $2,500-$4,999 | 253 | 13.6% | $905,533.51 | 7.8% | ||
| $5,000-$9,999 | 176 | 9.5% | $1,231,467.16 | 10.6% | ||
| $10,000-$14,999 | 88 | 4.7% | $1,070,956.62 | 9.2% | ||
| $15,000-$19,999 | 45 | 2.4% | $777,621.87 | 6.7% | ||
| $20,000-$24,999 | 26 | 1.4% | $576,017.83 | 5.0% | ||
| $25,000-$29,999 | 17 | 0.9% | $463,252.31 | 4.0% | ||
| $30,000-$39,999 | 23 | 1.2% | $804,345.72 | 6.9% | ||
| $40,000-$49,999 | 15 | 0.8% | $649,567.01 | 5.6% | ||
| $50,000-$74,999 | 15 | 0.8% | $949,367.15 | 8.2% | ||
| $75,000-$99,999 | 3 | 0.2% | $255,507.70 | 2.2% | ||
| $100,000-$124,999 | 6 | 0.3% | $690,614.49 | 5.9% | ||
| $125,000-$149,999 | 2 | 0.1% | $280,375.20 | 2.4% | ||
| $150,000-$174,999 | 1 | 0.1% | $151,856.60 | 1.3% | ||
| $175,000-$199,999 | 5 | 0.3% | $928,100.26 | 8.0% | ||
| $200,000-$249,999 | 1 | 0.1% | $201,396.20 | 1.7% | ||
| $250,000-$299,999 | 1 | 0.1% | $282,688.56 | 2.4% | ||
| $500,000+ | 1 | 0.1% | $505,934.49 | 4.4% | ||
| Retired | Total | 188 | 100.0% | $1,865,006.18 | 100.0% | |
| <$.01 | 1 | 0.5% | $0.00 | 0.0% | ||
| $.01-$49 | 22 | 11.7% | $565.05 | 0.0% | ||
| $50-$99 | 4 | 2.1% | $342.12 | 0.0% | ||
| $100-$249 | 22 | 11.7% | $3,803.47 | 0.2% | ||
| $250-$499 | 8 | 4.3% | $2,652.74 | 0.1% | ||
| $500-$999 | 20 | 10.6% | $13,810.76 | 0.7% | ||
| $1,000-$2,499 | 33 | 17.6% | $52,637.72 | 2.8% | ||
| $2,500-$4,999 | 14 | 7.4% | $50,663.90 | 2.7% | ||
| $5,000-$9,999 | 19 | 10.1% | $130,840.80 | 7.0% | ||
| $10,000-$14,999 | 15 | 8.0% | $184,185.13 | 9.9% | ||
| $15,000-$19,999 | 5 | 2.7% | $87,578.27 | 4.7% | ||
| $20,000-$24,999 | 8 | 4.3% | $176,231.53 | 9.4% | ||
| $25,000-$29,999 | 3 | 1.6% | $84,289.14 | 4.5% | ||
| $30,000-$39,999 | 6 | 3.2% | $200,385.47 | 10.7% | ||
| $50,000-$74,999 | 2 | 1.1% | $143,704.17 | 7.7% | ||
| $75,000-$99,999 | 2 | 1.1% | $158,219.85 | 8.5% | ||
| $100,000-$124,999 | 2 | 1.1% | $216,204.42 | 11.6% | ||
| $150,000-$174,999 | 1 | 0.5% | $163,099.95 | 8.7% | ||
| $175,000-$199,999 | 1 | 0.5% | $195,791.69 | 10.5% | ||
| This document contains UnitedHealthcare’s confidential and/or proprietary business information (PBI). PBI may only be used by |
the recipient person/entity to which it is addressed. Recipient is liable for using and protecting UnitedHealthcare’s PBI from further disclosure or misuse, consistent with recipient’s contractual obligations under any applicable administrative services agreement, group policy contract, non-disclosure agreement or other applicable contract or law, including but not limited to the U.S. Freedom of Information Act and state freedom of information law exemptions for “trade secrets”. The document may also contain protected health information (PHI) and must be handled according to applicable state and federal law, including, but not limited to HIPAA. Recipients who misuse information may be subject to both civil and criminal penalties.
24 Month Claim Expenses
| Claim Expenses by Size of Payment | ||||||
| Report Filter: | ||||||
| ({Service Year/Month} = 2024-01, 2023-12, 2023-11, 2023-10, 2023-09, 2023-08, 2023-07, 2023-06, 2023-05, 2023-04, 2023-03, 2023-02, 2023-01, 2022-12, 2022-11, 2022-10, 2022-09, 2022-08, 2022-07, 2022-06, 2022-05, 2022-04, 2022-03, 2022-02) And ({Book Year/Month} = 2024-03, 2024-02, 2024-01, 2023-12, 2023-11, 2023-10, 2023-09, 2023-08, 2023-07, 2023-06, 2023-05, 2023-04, 2023-03, 2023-02, 2023-01, 2022-12, 2022-11, 2022-10, 2022-09, 2022-08, 2022-07, 2022-06, 2022-05, 2022-04, 2022-03, 2022-02) And ({-Policy Number} = 000912772) And ({Benefit Type Category} = Medical Benefit , Managed Pharmacy Benefit ) And ({Claimant ID} (ID) <> "9999999999999999") | ||||||
| Employment Status | Payment Category | Number of Claimants | % Claimants | Payments | % Payments | |
| Active | Total | 2,221 | 100.0% | $21,325,557.23 | 100.0% | |
| <$.01 | 9 | 0.4% | ($421.32) | (0.0%) | ||
| $.01-$49 | 49 | 2.2% | $1,455.29 | 0.0% | ||
| $50-$99 | 67 | 3.0% | $5,250.36 | 0.0% | ||
| $100-$249 | 158 | 7.1% | $27,641.36 | 0.1% | ||
| $250-$499 | 183 | 8.2% | $67,972.40 | 0.3% | ||
| $500-$999 | 238 | 10.7% | $174,915.63 | 0.8% | ||
| $1,000-$2,499 | 484 | 21.8% | $782,801.81 | 3.7% | ||
| $2,500-$4,999 | 319 | 14.4% | $1,152,404.59 | 5.4% | ||
| $5,000-$9,999 | 271 | 12.2% | $1,910,781.50 | 9.0% | ||
| $10,000-$14,999 | 134 | 6.0% | $1,635,359.82 | 7.7% | ||
| $15,000-$19,999 | 94 | 4.2% | $1,607,120.44 | 7.5% | ||
| $20,000-$24,999 | 35 | 1.6% | $783,783.13 | 3.7% | ||
| $25,000-$29,999 | 35 | 1.6% | $964,712.66 | 4.5% | ||
| $30,000-$39,999 | 47 | 2.1% | $1,615,432.17 | 7.6% | ||
| $40,000-$49,999 | 27 | 1.2% | $1,215,417.08 | 5.7% | ||
| $50,000-$74,999 | 28 | 1.3% | $1,694,021.46 | 7.9% | ||
| $75,000-$99,999 | 9 | 0.4% | $775,103.06 | 3.6% | ||
| $100,000-$124,999 | 10 | 0.5% | $1,145,256.82 | 5.4% | ||
| $125,000-$149,999 | 6 | 0.3% | $805,615.87 | 3.8% | ||
| $150,000-$174,999 | 3 | 0.1% | $493,447.93 | 2.3% | ||
| $175,000-$199,999 | 3 | 0.1% | $553,548.48 | 2.6% | ||
| $200,000-$249,999 | 2 | 0.1% | $433,678.74 | 2.0% | ||
| $250,000-$299,999 | 4 | 0.2% | $1,085,622.40 | 5.1% | ||
| $300,000-$349,999 | 2 | 0.1% | $671,430.64 | 3.1% | ||
| $350,000-$399,999 | 2 | 0.1% | $766,087.38 | 3.6% | ||
| $450,000-$499,999 | 1 | 0.0% | $451,183.04 | 2.1% | ||
| $500,000+ | 1 | 0.0% | $505,934.49 | 2.4% | ||
| Retired | Total | 200 | 100.0% | $3,370,209.95 | 100.0% | |
| <$.01 | 1 | 0.5% | $0.00 | 0.0% | ||
| $.01-$49 | 18 | 9.0% | $494.81 | 0.0% | ||
| $50-$99 | 5 | 2.5% | $343.25 | 0.0% | ||
| $100-$249 | 17 | 8.5% | $2,999.39 | 0.1% | ||
| $250-$499 | 13 | 6.5% | $4,369.93 | 0.1% | ||
| $500-$999 | 15 | 7.5% | $11,540.96 | 0.3% | ||
| $1,000-$2,499 | 23 | 11.5% | $33,400.41 | 1.0% | ||
| $2,500-$4,999 | 24 | 12.0% | $89,724.26 | 2.7% | ||
| $5,000-$9,999 | 18 | 9.0% | $130,196.54 | 3.9% | ||
| $10,000-$14,999 | 12 | 6.0% | $151,616.53 | 4.5% | ||
| $15,000-$19,999 | 7 | 3.5% | $123,242.84 | 3.7% | ||
| $20,000-$24,999 | 8 | 4.0% | $176,408.98 | 5.2% | ||
| $25,000-$29,999 | 7 | 3.5% | $188,305.37 | 5.6% | ||
| $30,000-$39,999 | 12 | 6.0% | $408,646.26 | 12.1% | ||
| $40,000-$49,999 | 6 | 3.0% | $271,642.36 | 8.1% | ||
| $50,000-$74,999 | 2 | 1.0% | $136,772.90 | 4.1% | ||
| $75,000-$99,999 | 6 | 3.0% | $506,845.31 | 15.0% | ||
| $100,000-$124,999 | 1 | 0.5% | $117,177.16 | 3.5% | ||
| $150,000-$174,999 | 1 | 0.5% | $167,721.17 | 5.0% | ||
| $175,000-$199,999 | 1 | 0.5% | $187,945.84 | 5.6% | ||
| $200,000-$249,999 | 2 | 1.0% | $408,213.19 | 12.1% | ||
| $250,000-$299,999 | 1 | 0.5% | $252,602.49 | 7.5% | ||
| This document contains UnitedHealthcare’s confidential and/or proprietary business information (PBI). PBI may only be used by |
the recipient person/entity to which it is addressed. Recipient is liable for using and protecting UnitedHealthcare’s PBI from further disclosure or misuse, consistent with recipient’s contractual obligations under any applicable administrative services agreement, group policy contract, non-disclosure agreement or other applicable contract or law, including but not limited to the U.S. Freedom of Information Act and state freedom of information law exemptions for “trade secrets”. The document may also contain protected health information (PHI) and must be handled according to applicable state and federal law, including, but not limited to HIPAA. Recipients who misuse information may be subject to both civil and criminal penalties.
36 Month Claim Expenses
| Claim Expenses by Size of Payment | ||||||
| Report Filter: | ||||||
| ({Service Year/Month} = 2024-03, 2024-02, 2024-01, 2023-12, 2023-11, 2023-10, 2023-09, 2023-08, 2023-07, 2023-06, 2023-05, 2023-04, 2023-03, 2023-02, 2023-01, 2022-12, 2022-11, 2022-10, 2022-09, 2022-08, 2022-07, 2022-06, 2022-05, 2022-04, 2022-03, 2022-02, 2022-01, 2021-12, 2021-11, 2021-10, 2021-09, 2021-08, 2021-07, 2021-06, 2021-05, 2021-04) And ({Book Year/Month} = 2024-03, 2024-02, 2024-01, 2023-12, 2023-11, 2023-10, 2023-09, 2023-08, 2023-07, 2023-06, 2023-05, 2023-04, 2023-03, 2023-02, 2023-01, 2022-12, 2022-11, 2022-10, 2022-09, 2022-08, 2022-07, 2022-06, 2022-05, 2022-04, 2022-03, 2022-02, 2022-01, 2021-12, 2021-11, 2021-10, 2021-09, 2021-08, 2021-07, 2021-06, 2021-05, 2021-04) And ({-Policy Number} = 000912772) And ({Benefit Type Category} = Medical Benefit , Managed Pharmacy Benefit ) And ({Claimant ID} (ID) <> "9999999999999999") | ||||||
| Employment Status | Payment Category | Number of Claimants | % Claimants | Payments | % Payments | |
| Active | Total | 2,603 | 100.0% | $33,466,642.67 | 100.0% | |
| <$.01 | 11 | 0.4% | ($1,887.68) | (0.0%) | ||
| $.01-$49 | 55 | 2.1% | $1,778.07 | 0.0% | ||
| $50-$99 | 61 | 2.3% | $4,745.16 | 0.0% | ||
| $100-$249 | 172 | 6.6% | $28,665.89 | 0.1% | ||
| $250-$499 | 182 | 7.0% | $65,434.28 | 0.2% | ||
| $500-$999 | 258 | 9.9% | $190,816.72 | 0.6% | ||
| $1,000-$2,499 | 504 | 19.4% | $851,060.37 | 2.5% | ||
| $2,500-$4,999 | 388 | 14.9% | $1,406,662.43 | 4.2% | ||
| $5,000-$9,999 | 353 | 13.6% | $2,486,140.57 | 7.4% | ||
| $10,000-$14,999 | 174 | 6.7% | $2,139,346.01 | 6.4% | ||
| $15,000-$19,999 | 130 | 5.0% | $2,279,014.64 | 6.8% | ||
| $20,000-$24,999 | 54 | 2.1% | $1,192,306.61 | 3.6% | ||
| $25,000-$29,999 | 36 | 1.4% | $990,280.33 | 3.0% | ||
| $30,000-$39,999 | 62 | 2.4% | $2,128,974.26 | 6.4% | ||
| $40,000-$49,999 | 37 | 1.4% | $1,621,105.47 | 4.8% | ||
| $50,000-$74,999 | 51 | 2.0% | $3,048,044.61 | 9.1% | ||
| $75,000-$99,999 | 18 | 0.7% | $1,516,536.66 | 4.5% | ||
| $100,000-$124,999 | 12 | 0.5% | $1,386,167.96 | 4.1% | ||
| $125,000-$149,999 | 11 | 0.4% | $1,516,492.18 | 4.5% | ||
| $150,000-$174,999 | 7 | 0.3% | $1,125,250.55 | 3.4% | ||
| $175,000-$199,999 | 4 | 0.2% | $757,141.93 | 2.3% | ||
| $200,000-$249,999 | 7 | 0.3% | $1,558,014.42 | 4.7% | ||
| $250,000-$299,999 | 4 | 0.2% | $1,092,533.45 | 3.3% | ||
| $300,000-$349,999 | 3 | 0.1% | $980,037.44 | 2.9% | ||
| $350,000-$399,999 | 2 | 0.1% | $727,749.56 | 2.2% | ||
| $450,000-$499,999 | 1 | 0.0% | $451,640.57 | 1.3% | ||
| $500,000+ | 6 | 0.2% | $3,922,590.21 | 11.7% | ||
| Retired | Total | 218 | 100.0% | $4,621,975.40 | 100.0% | |
| <$.01 | 1 | 0.5% | $0.00 | 0.0% | ||
| $.01-$49 | 10 | 4.6% | $302.92 | 0.0% | ||
| $50-$99 | 8 | 3.7% | $595.48 | 0.0% | ||
| $100-$249 | 18 | 8.3% | $2,866.97 | 0.1% | ||
| $250-$499 | 15 | 6.9% | $4,627.46 | 0.1% | ||
| $500-$999 | 14 | 6.4% | $9,748.61 | 0.2% | ||
| $1,000-$2,499 | 30 | 13.8% | $52,638.44 | 1.1% | ||
| $2,500-$4,999 | 20 | 9.2% | $77,210.97 | 1.7% | ||
| $5,000-$9,999 | 23 | 10.6% | $161,189.38 | 3.5% | ||
| $10,000-$14,999 | 12 | 5.5% | $152,410.41 | 3.3% | ||
| $15,000-$19,999 | 8 | 3.7% | $138,793.07 | 3.0% | ||
| $20,000-$24,999 | 11 | 5.0% | $246,221.29 | 5.3% | ||
| $25,000-$29,999 | 7 | 3.2% | $192,106.42 | 4.2% | ||
| $30,000-$39,999 | 12 | 5.5% | $422,473.10 | 9.1% | ||
| $40,000-$49,999 | 5 | 2.3% | $218,486.97 | 4.7% | ||
| $50,000-$74,999 | 9 | 4.1% | $513,618.79 | 11.1% | ||
| $75,000-$99,999 | 6 | 2.8% | $539,690.17 | 11.7% | ||
| $100,000-$124,999 | 2 | 0.9% | $221,959.92 | 4.8% | ||
| $125,000-$149,999 | 1 | 0.5% | $139,174.09 | 3.0% | ||
| $200,000-$249,999 | 4 | 1.8% | $889,163.16 | 19.2% | ||
| $250,000-$299,999 | 1 | 0.5% | $282,223.97 | 6.1% | ||
| $350,000-$399,999 | 1 | 0.5% | $356,473.81 | 7.7% | ||
| This document contains UnitedHealthcare’s confidential and/or proprietary business information (PBI). PBI may only be used by |
the recipient person/entity to which it is addressed. Recipient is liable for using and protecting UnitedHealthcare’s PBI from further disclosure or misuse, consistent with recipient’s contractual obligations under any applicable administrative services agreement, group policy contract, non-disclosure agreement or other applicable contract or law, including but not limited to the U.S. Freedom of Information Act and state freedom of information law exemptions for “trade secrets”. The document may also contain protected health information (PHI) and must be handled according to applicable state and federal law, including, but not limited to HIPAA. Recipients who misuse information may be subject to both civil and criminal penalties.
Dental Membership
Membership by Group, Product and Tier
| Selection Parameters | ||
| Values on Report | ||
| Group Effective Date: 1/1/2018 |
| Incurred Date Range: 4/1/2021 to 3/31/2024 | 4/1/2021 to 3/1/2024 | |
| Group Renewal Month Day: 01/01 |
| Group ID: 1186163 | 1186163 | |
| Group Policy Number: 0912772 | ||
| Business Category: -1 | PPO |
Product: -1 Product: -1
| Incurred Date | Subscribers Count by Tier | Total | Total | Total | ||||||
| Subscriber Only | with Spouse | with Child | with Children | with Family | Subscribers | Dependents | Members | |||
| 1186163 COUNTY OF HAYS | D0012129UHC TX DHMO Plan130C (D094C) | April 2021 | 7 | 11 | 3 | 4 | 8 | 33 | 47 | 80 |
| May 2021 | 7 | 10 | 3 | 4 | 8 | 32 | 46 | 78 | ||
| June 2021 | 7 | 9 | 3 | 4 | 9 | 32 | 47 | 79 | ||
| July 2021 | 7 | 9 | 3 | 4 | 9 | 32 | 48 | 80 | ||
| August 2021 | 7 | 9 | 2 | 4 | 9 | 31 | 47 | 78 | ||
| September 2021 | 7 | 9 | 3 | 4 | 9 | 32 | 48 | 80 | ||
| October 2021 | 7 | 9 | 4 | 4 | 8 | 32 | 47 | 79 | ||
| November 2021 | 7 | 9 | 3 | 4 | 8 | 31 | 46 | 77 | ||
| December 2021 | 7 | 8 | 3 | 4 | 8 | 30 | 45 | 75 | ||
| January 2022 | 5 | 8 | 2 | 2 | 8 | 25 | 42 | 67 | ||
| February 2022 | 6 | 7 | 2 | 2 | 8 | 25 | 41 | 66 | ||
| March 2022 | 6 | 7 | 2 | 2 | 8 | 25 | 41 | 66 | ||
| April 2022 | 6 | 7 | 2 | 2 | 8 | 25 | 41 | 66 | ||
| May 2022 | 6 | 6 | 2 | 2 | 8 | 24 | 40 | 64 | ||
| June 2022 | 6 | 6 | 2 | 2 | 9 | 25 | 47 | 72 | ||
| July 2022 | 6 | 7 | 2 | 2 | 9 | 26 | 48 | 74 | ||
| August 2022 | 5 | 7 | 3 | 1 | 9 | 25 | 47 | 72 | ||
| September 2022 | 5 | 7 | 3 | 1 | 9 | 25 | 47 | 72 | ||
| October 2022 | 5 | 7 | 3 | 1 | 9 | 25 | 47 | 72 | ||
| November 2022 | 5 | 6 | 3 | 1 | 9 | 24 | 46 | 70 | ||
| December 2022 | 5 | 7 | 3 | 1 | 9 | 25 | 48 | 73 | ||
| January 2023 | 5 | 8 | 5 | 1 | 7 | 26 | 47 | 73 | ||
| February 2023 | 4 | 9 | 5 | 1 | 7 | 26 | 48 | 74 | ||
| March 2023 | 5 | 8 | 5 | 1 | 8 | 27 | 49 | 76 | ||
| April 2023 | 5 | 8 | 5 | 1 | 8 | 27 | 49 | 76 | ||
| May 2023 | 6 | 8 | 5 | 1 | 7 | 27 | 45 | 72 | ||
| June 2023 | 6 | 8 | 5 | 1 | 7 | 27 | 45 | 72 | ||
| July 2023 | 6 | 8 | 5 | 1 | 6 | 26 | 39 | 65 | ||
| August 2023 | 6 | 7 | 5 | 1 | 6 | 25 | 38 | 63 | ||
| September 2023 | 6 | 7 | 5 | 1 | 6 | 25 | 38 | 63 | ||
| October 2023 | 6 | 7 | 5 | 1 | 7 | 26 | 42 | 68 | ||
| November 2023 | 9 | 6 | 4 | 1 | 8 | 28 | 42 | 70 | ||
| December 2023 | 9 | 6 | 4 | 2 | 7 | 28 | 39 | 67 | ||
| January 2024 | 11 | 4 | 4 | 3 | 6 | 28 | 36 | 64 | ||
| February 2024 | 11 | 4 | 5 | 5 | 6 | 31 | 41 | 72 | ||
| March 2024 | 11 | 5 | 5 | 6 | 6 | 33 | 46 | 79 | ||
| 235 | 268 | 128 | 82 | 281 | 994 | 1,600 | 2,594 | |||
| D0019980UHC ASO Custom Plan 4P648 | April 2021 | 497 | 141 | 82 | 100 | 166 | 986 | 995 | 1,981 | |
| May 2021 | 499 | 141 | 82 | 100 | 165 | 987 | 999 | 1,986 | ||
| June 2021 | 502 | 142 | 82 | 100 | 166 | 992 | 1,001 | 1,993 | ||
| July 2021 | 495 | 141 | 82 | 101 | 164 | 983 | 998 | 1,981 | ||
| August 2021 | 498 | 139 | 82 | 100 | 167 | 986 | 1,002 | 1,988 | ||
| September 2021 | 498 | 136 | 79 | 97 | 167 | 977 | 991 | 1,968 | ||
| October 2021 | 497 | 135 | 77 | 95 | 167 | 971 | 985 | 1,956 | ||
| November 2021 | 493 | 135 | 78 | 95 | 165 | 966 | 974 | 1,940 | ||
| December 2021 | 495 | 135 | 78 | 94 | 164 | 966 | 967 | 1,933 | ||
| January 2022 | 487 | 128 | 83 | 95 | 171 | 964 | 992 | 1,956 | ||
| February 2022 | 484 | 126 | 83 | 94 | 169 | 956 | 981 | 1,937 | ||
| March 2022 | 487 | 124 | 82 | 92 | 172 | 957 | 985 | 1,942 | ||
| April 2022 | 489 | 123 | 81 | 92 | 171 | 956 | 980 | 1,936 | ||
| May 2022 | 490 | 125 | 80 | 92 | 171 | 958 | 976 | 1,934 | ||
| June 2022 | 486 | 127 | 80 | 90 | 172 | 955 | 976 | 1,931 | ||
| July 2022 | 486 | 126 | 79 | 92 | 172 | 955 | 978 | 1,933 | ||
| August 2022 | 486 | 127 | 78 | 91 | 171 | 953 | 973 | 1,926 | ||
| September 2022 | 490 | 126 | 77 | 91 | 175 | 959 | 982 | 1,941 | ||
| October 2022 | 489 | 129 | 75 | 89 | 179 | 961 | 994 | 1,955 | ||
| November 2022 | 496 | 130 | 75 | 89 | 180 | 970 | 999 | 1,969 | ||
| December 2022 | 492 | 133 | 76 | 88 | 178 | 967 | 996 | 1,963 | ||
| January 2023 | 488 | 130 | 76 | 89 | 173 | 956 | 978 | 1,934 | ||
| February 2023 | 495 | 131 | 75 | 88 | 175 | 964 | 981 | 1,945 | ||
| March 2023 | 498 | 136 | 73 | 91 | 180 | 978 | 1,010 | 1,988 | ||
| April 2023 | 501 | 136 | 74 | 92 | 179 | 982 | 1,013 | 1,995 | ||
| May 2023 | 511 | 135 | 75 | 92 | 179 | 992 | 1,016 | 2,008 | ||
| June 2023 | 519 | 139 | 75 | 91 | 182 | 1,006 | 1,029 | 2,035 | ||
| July 2023 | 512 | 140 | 77 | 89 | 180 | 998 | 1,021 | 2,019 | ||
| August 2023 | 521 | 139 | 76 | 90 | 179 | 1,005 | 1,012 | 2,017 | ||
| September 2023 | 531 | 137 | 78 | 91 | 179 | 1,016 | 1,016 | 2,032 | ||
| October 2023 | 550 | 140 | 78 | 92 | 178 | 1,038 | 1,018 | 2,056 | ||
| November 2023 | 559 | 139 | 78 | 96 | 179 | 1,051 | 1,032 | 2,083 | ||
| December 2023 | 565 | 139 | 79 | 95 | 178 | 1,056 | 1,026 | 2,082 | ||
| January 2024 | 573 | 143 | 84 | 94 | 180 | 1,074 | 1,035 | 2,109 | ||
| February 2024 | 576 | 144 | 81 | 98 | 177 | 1,076 | 1,035 | 2,111 | ||
| March 2024 | 577 | 142 | 80 | 97 | 178 | 1,074 | 1,033 | 2,107 | ||
| 18,312 | 4,839 | 2,830 | 3,362 | 6,248 | 35,591 | 35,979 | 71,570 | |||
| Product Total | 18,547 | 5,107 | 2,958 | 3,444 | 6,529 | 36,585 | 37,579 | 74,164 |
&"Arial,Regular"&10 ODSCR-08B &"Arial,Regular"&10 Run Date Time: 4/16/2024
Dental Claims and Utilization
Dental Client Experience and Utilization for Fully Insured
Business Category: ALL
Service Date Range: 4/1/2021 to 3/1/2024
| COUNTY OF HAYS | Client Effective Date: | 01/01/2018 | Group ID: 1186163 | Group Renewal Month Day: 01/01 | |||||||
| Business Category | Incurred Month | Subscribers | Insured Dependents | Members | Collected Revenue | Incurred Claim | |||||
| (Including IBNR) | Capitation | BCR | |||||||||
| DHMO | 04/01/2021 | 33 | 47 | 80 | $697 | $85 | $61 | 20.9% | |||
| DHMO | 05/01/2021 | 32 | 46 | 78 | $697 | $339 | $57 | 56.8% | |||
| DHMO | 06/01/2021 | 32 | 47 | 79 | $676 | $32 | $57 | 13.2% | |||
| DHMO | 07/01/2021 | 32 | 48 | 80 | $683 | $3 | $57 | 8.9% | |||
| DHMO | 08/01/2021 | 31 | 47 | 78 | $683 | $33 | $57 | 13.2% | |||
| DHMO | 09/01/2021 | 32 | 48 | 80 | $683 | $110 | $68 | 26.0% | |||
| DHMO | 10/01/2021 | 32 | 47 | 79 | $727 | $115 | $64 | 24.7% | |||
| DHMO | 11/01/2021 | 31 | 46 | 77 | $655 | $268 | $64 | 50.7% | |||
| DHMO | 12/01/2021 | 30 | 45 | 75 | $655 | $30 | $68 | 14.9% | |||
| DHMO | 01/01/2022 | 25 | 42 | 67 | $570 | $3 | $135 | 24.2% | |||
| DHMO | 02/01/2022 | 25 | 41 | 66 | $582 | $0 | $61 | 10.4% | |||
| DHMO | 03/01/2022 | 25 | 41 | 66 | $560 | $45 | $61 | 18.9% | |||
| DHMO | 04/01/2022 | 25 | 41 | 66 | $560 | $15 | $61 | 13.5% | |||
| DHMO | 05/01/2022 | 24 | 40 | 64 | $538 | $15 | $61 | 14.1% | |||
| DHMO | 06/01/2022 | 25 | 47 | 72 | $567 | $15 | $61 | 13.4% | |||
| DHMO | 07/01/2022 | 26 | 48 | 74 | $590 | $15 | $61 | 12.9% | |||
| DHMO | 08/01/2022 | 25 | 47 | 72 | $590 | $28 | $57 | 14.5% | |||
| DHMO | 09/01/2022 | 25 | 47 | 72 | $578 | $30 | $162 | 33.3% | |||
| DHMO | 10/01/2022 | 25 | 47 | 72 | $578 | $15 | $162 | 30.7% | |||
| DHMO | 11/01/2022 | 24 | 46 | 70 | $578 | $0 | $155 | 26.9% | |||
| DHMO | 12/01/2022 | 25 | 48 | 73 | $578 | $0 | $162 | 28.1% | |||
| DHMO | 01/01/2023 | 26 | 47 | 73 | $595 | $0 | $176 | 29.5% | |||
| DHMO | 02/01/2023 | 26 | 48 | 74 | $606 | $60 | $162 | 36.7% | |||
| DHMO | 03/01/2023 | 27 | 49 | 76 | $625 | $3 | $172 | 28.1% | |||
| DHMO | 04/01/2023 | 27 | 49 | 76 | $625 | $0 | $172 | 27.6% | |||
| DHMO | 05/01/2023 | 27 | 45 | 72 | $637 | $0 | $159 | 24.9% | |||
| DHMO | 06/01/2023 | 27 | 45 | 72 | $607 | $16 | $159 | 28.8% | |||
| DHMO | 07/01/2023 | 26 | 39 | 65 | $578 | $395 | $108 | 87.1% | |||
| DHMO | 08/01/2023 | 25 | 38 | 63 | $555 | $38 | $108 | 26.3% | |||
| DHMO | 09/01/2023 | 25 | 38 | 63 | $555 | $264 | $108 | 67.1% | |||
| DHMO | 10/01/2023 | 26 | 42 | 68 | $585 | $100 | $145 | 41.9% | |||
| DHMO | 11/01/2023 | 28 | 42 | 70 | $621 | $268 | $152 | 67.7% | |||
| DHMO | 12/01/2023 | 28 | 39 | 67 | $597 | $0 | $155 | 26.1% | |||
| DHMO | 01/01/2024 | 28 | 36 | 64 | $545 | $0 | $142 | 26.1% | |||
| DHMO | 02/01/2024 | 31 | 41 | 72 | $612 | $0 | $159 | 25.9% | |||
| DHMO | 03/01/2024 | 33 | 46 | 79 | $656 | $0 | $183 | 27.8% | |||
| PPO | 12/01/2021 | 0 | 0 | 0 | $0 | $0 | $0 | 0.0% | |||
| Client Total | 994 | 1,600 | 2,594 | $22,024 | $2,340 | $4,015 | 28.9% |
&"Arial,Regular"&5&F &"-,Regular"4/16/2024 2:56:52 PM image1.jpg image2.jpg image3.png
File details come from the government source that posted it. Updated .