ESBD_379720_1729031192350_Attachment D - UHC Life paid claim report.xlsx
XLSX spreadsheet 68 KB Posted
- Solicitation number
- 2510-006
- Issued by
- Travis County, Austin City, Texas
About this file
The provided document is a Request for Proposals (RFP) issued by the Travis County Healthcare District d/b/a Central Health for basic life & AD&D, voluntary life & AD&D, employer paid short-term disability, voluntary short-term disability, and employer paid long-term disability insurance coverage. The RFP seeks qualified vendors to provide these benefits to approximately 1,900 Central Health employees, with the goal of offering high-quality and valuable benefits at affordable pricing. The RFP has a proposal due date of November 14, 2024 and allows for a one-time open enrollment for all employees with no underwriting up to the guarantee issue amount. The initial contract term is two years, with optional four one-year renewal periods.
The RFP does not mention any set-aside designations or restrictions on the types of organizations that can respond. There are no listed incumbent vendors or current contractors, and no specific details on existing infrastructure or technology that requires integration. The RFP does not provide any information on possible award values or budget ranges, though the historical claims data and premium information suggests this is a significant employee benefits contract for the Travis County Healthcare District.
View the file
Other files
Show 40 more
Latest 50 of 68 listed here. See the rest on GovTribe.
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
Sheet1
| Selection Parameters |
| 305532 |
| ALL |
| 09/01/2023 to 09/01/2024 |
Accident,Critical Illness,FMLA,HIPP,Life,LTD,PFML,STD
FACETS
| TRAVIS COUNTY HEALTHCARE DISTRICT | Group Effective Date: 03/01/2018 | ||||||
| Subgroup: 1002 - L6Z COMMUNITY CARE | |||||||
| Claim | Benefit | Gender | Age at Incurred Date | Status * | Incurred Date | Payment Date | Net Benefit Amount |
| 203020776 | Life - Basic | F | 63 | Closed | 01/22/2024 | 02/22/2024 | $58,111.24 |
| 203020776 | Life - Supplemental | F | 63 | Closed | 01/22/2024 | 02/22/2024 | $58,111.24 |
| January 2024 Incurred Total: | $116,222.47 | ||||||
| 203415168 | Life - Basic | F | 60 | Closed | 07/07/2024 | 08/15/2024 | $69,075.62 |
| July 2024 Incurred Total: | $69,075.62 | ||||||
| Subgroup 00001002 Total: | $185,298.09 | ||||||
| Group Total: | $185,298.09 |
&"times new roman,Regular"&7 Run Date: 9/9/2024 3:46:12 PM &"Times New Roman,Regular"&8 * Claim Status Descriptions:
Appealed: Claim has been disputed | Closed: Claim is closed | In Process: Claim is in adjudication process | Incomplete: C
Sheet2
Paid Claim Detail by Incurred Date
| Selection Parameters | Values on Report | |
| Group/Customer: | 305532 | 00305532 - TRAVIS COUNTY HEALTHCARE DISTRICT |
| Subgroup/Policy: | ALL | 1002 |
| Incurred Date Range: | 09/01/2023 to 09/01/2024 | 01/22/2024 to 07/07/2024 |
Business Segment: Accident,Critical Illness,FMLA,HIPP,Life,LTD,PFML,STD Life
Source System: FACETS
TRAVIS COUNTY HEALTHCARE DISTRICT
| All Subgroups by Product | Net Benefit Amount | |
| Life - Basic | $127,186.86 | |
| Life - Supplemental | $58,111.24 | |
| All Subgroups by Product Total | $185,298.09 |
&"times new roman,Regular"&7 Run Date: 9/9/2024 3:46:12 PM &"Times New Roman,Regular"&8 * Claim Status Descriptions:
Appealed: Claim has been disputed | Closed: Claim is closed | In Process: Claim is in adjudication process | Incomplete: C image1.png image2.jpg
File details come from the government source that posted it. Updated .