ESBD_360338_1717797768324_Attachment I - Updated - Additional Supporting Claims and Enrollment Information.xlsx
XLSX spreadsheet 12 KB Posted
- Solicitation number
- RFp2024-P11
- Issued by
- Hays County, Texas
About this file
This document is a spreadsheet detailing monthly payments for various benefits plans for a specific policy number in Hays County, Texas. The payments are broken down by benefit type category, including medical, pharmacy, dental, and others, from May 2021 through April 2024.
The related state and local contract opportunity is an RFP issued by Hays County, Texas for Employee Group Health, Dental, and Employee Assistance Plans. The county is seeking a comprehensive package that includes medical, pharmacy, dental, and employee wellness/assistance plan coverage, with the intent to award a contract effective January 1, 2025 and open enrollment starting October 1, 2024. The county is looking to partner with insurance companies that can provide competitive long-term and stable financial plans while offering a robust benefits package.
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
Payments By Month - Paid
| 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 ({Book Year/Month} = 2024-04, 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) And ({Funding Arrangement Category} = Administrative Services Only) | ||||
| Benefit Payment | Medical | Managed Pharmacy | Dental | Total |
| Book Year/Month | Payments | Payments | Payments | Payments |
| 2021-05 | $480,827 | $239,668 | $48,262 | $768,758 |
| 2021-06 | $1,318,989 | $326,696 | $39,381 | $1,685,066 |
| 2021-07 | ($92,506) | $276,316 | $41,309 | $225,120 |
| 2021-08 | $702,932 | $249,630 | $43,698 | $996,260 |
| 2021-09 | $998,880 | $308,373 | $44,631 | $1,351,884 |
| 2021-10 | $702,119 | $274,611 | $36,245 | $1,012,975 |
| 2021-11 | $998,321 | $335,718 | $42,959 | $1,376,999 |
| 2021-12 | $909,724 | $326,401 | $42,100 | $1,278,224 |
| 2022-01 | $501,737 | $259,187 | $31,370 | $792,294 |
| 2022-02 | $621,204 | $235,360 | $36,575 | $893,138 |
| 2022-03 | $593,992 | $237,151 | $41,494 | $872,637 |
| 2022-04 | $600,725 | $303,329 | $40,445 | $944,499 |
| 2022-05 | $648,513 | $249,412 | $40,491 | $938,415 |
| 2022-06 | $679,940 | $310,187 | $42,896 | $1,033,023 |
| 2022-07 | $431,728 | $322,947 | $36,132 | $790,807 |
| 2022-08 | $548,023 | $301,018 | $48,053 | $897,095 |
| 2022-09 | $386,315 | $303,770 | $38,471 | $728,556 |
| 2022-10 | $218,999 | $296,019 | $37,136 | $552,154 |
| 2022-11 | $1,193,281 | $347,535 | $37,026 | $1,577,842 |
| 2022-12 | $724,372 | $319,953 | $42,108 | $1,086,433 |
| 2023-01 | $826,255 | $265,161 | $43,028 | $1,134,444 |
| 2023-02 | $506,098 | $336,285 | $35,699 | $878,082 |
| 2023-03 | $667,873 | $322,372 | $47,098 | $1,037,343 |
| 2023-04 | $697,231 | $337,487 | $42,832 | $1,077,550 |
| 2023-05 | $971,622 | $333,753 | $50,187 | $1,355,562 |
| 2023-06 | $823,979 | $375,021 | $48,387 | $1,247,387 |
| 2023-07 | $703,264 | $343,423 | $39,503 | $1,086,190 |
| 2023-08 | $818,098 | $396,489 | $53,796 | $1,268,383 |
| 2023-09 | $666,083 | $339,777 | $42,967 | $1,048,827 |
| 2023-10 | $963,261 | $352,313 | $48,226 | $1,363,800 |
| 2023-11 | $669,776 | $339,435 | $45,115 | $1,054,325 |
| 2023-12 | $722,626 | $362,678 | $40,119 | $1,125,423 |
| 2024-01 | $865,145 | $366,958 | $52,837 | $1,284,940 |
| 2024-02 | $720,888 | $400,669 | $42,370 | $1,163,927 |
| 2024-03 | $681,212 | $358,903 | $56,984 | $1,097,099 |
| 2024-04 | $874,901 | $365,561 | $55,297 | $1,295,760 |
| Total | $25,346,427 | $11,419,564 | $1,555,227 | $38,321,218 |
| 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.
File details come from the government source that posted it. Updated .