ESBD_521004_1780004140477_Exhibit A-7 Large Claims 3.1.25-12.31.25.xls
XLS spreadsheet 201 KB Posted
- Attached to
- HR Benefits - Medical, Dental, and Vision
- Solicitation number
- 2605-004
- Issued by
- Travis County, Austin City, Texas
About this file
This is a catastrophic claimant detail report prepared by Aetna Integrated Informatics for the Travis County Healthcare District's CENT health plan (Plan Sponsor ID 0000000097013764). The report analyzes large claims data for the self-insured plan covering the period of March 1, 2025 through December 31, 2025, with a two-month claims processing lag, and was generated on February 24, 2026. The report identifies 18 catastrophic claimants who exceeded the $150,000 claims threshold, detailing medical, pharmacy, inpatient, and ambulatory service claims by diagnosis code.
The total claims identified across all catastrophic claimants amounted to $4,683,955, consisting of $2,549,123 in pharmacy paid amounts and $2,134,832 in medical paid amounts, with $649,835 in inpatient services and $1,484,997 in ambulatory services. The highest individual claim was $568,034 for a claimant with Hereditary Factor VIII Deficiency (hemophilia), followed by $544,010 for spinal stenosis and $417,022 for HIV disease. Other significant claims involved rare diseases and conditions including Gaucher disease, monoclonal gammopathy, cerebral infarction, autism spectrum disorder, and multiple sclerosis. All identified claimants had service rendered in the final quarter of the reporting period, indicating active ongoing claims management for the district's self-insured health plan.
View the file
Other files
Show all 35
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
Cover Page
| TRAVIS COUNTY HEALTHCARE DISTRICT - CENT |
| Plan Sponsor ID 0000000097013764 |
| Catastrophic Claimant Detail by Medical and Pharmacy by Diagnosis Code |
| Current Data For Claims Incurred March 01, 2025 - December 31, 2025 with 2 months lag |
&C&G&L&8© Aetna Integrated Informatics® 2026&R&8Page &P of &N Run Date: 2/24/2026
Criteria Page
| TRAVIS COUNTY HEALTHCARE DISTRICT - CENT - 0000000097013764 | |
| Current Data For Claims Incurred March 01, 2025 - December 31, 2025 with 2 months lag | |
| Catastrophic Claimant Detail by Medical and Pharmacy by Diagnosis Code | |
| Funding Category: | Account Structure: |
| Self Insured | ALL |
| Product: | Large Claimant Threshold: |
| ALL | $150,000 |
| MDC Exclusion: | |
| None | |
| Member Network Service Area: | |
| ALL | |
| Par Indicator: | |
| ALL | |
| Primary Payer: | |
| ALL | |
| Relationship: | |
| ALL | |
| Run By: | |
| Medical-Pharmacy by Diagnosis Code |
&C&G&L&8© Aetna Integrated Informatics® 2026&R&8Page &P of &N Run Date: 2/24/2026
Report
| TRAVIS COUNTY HEALTHCARE DISTRICT - CENT - 0000000097013764 | |||||||||
| Current Data For Claims Incurred March 01, 2025 - December 31, 2025 with 2 months lag | |||||||||
| Catastrophic Claimant Detail by Medical and Pharmacy by Diagnosis Code | |||||||||
| Claimant | Total Medical/RX | ||||||||
| Paid Amount | Pharmacy | ||||||||
| Paid Amount | Medical | ||||||||
| Paid Amount | Inpatient | ||||||||
| Paid Amount | Ambulatory | ||||||||
| Paid Amount | Diagnosis | ||||||||
| Code | Description | Service Rendered in Last Quarter | |||||||
| 1 | $568,034 | $567,573 | $460 | $0 | $460 | D66 | HEREDITARY FACTOR VIII DEFICIENCY | Yes | |
| 2 | $544,010 | $81,619 | $462,391 | $303,859 | $158,532 | M48.02 | SPINAL STENOSIS, CERVICAL REGION | Yes | |
| 3 | $417,022 | $356,896 | $60,126 | $0 | $60,126 | B20 | HUMAN IMMUNODEFICIENCY VIRUS (HIV) DISEASE | Yes | |
| 4 | $410,324 | $24,300 | $386,025 | $0 | $386,025 | E75.22 | GAUCHER DISEASE | Yes | |
| 5 | $287,804 | $77,385 | $210,419 | $0 | $210,419 | D47.2 | MONOCLONAL GAMMOPATHY | Yes | |
| 6 | $282,601 | $18,110 | $264,491 | $195,731 | $68,760 | I63.9 | CEREBRAL INFARCTION, UNSPECIFIED | Yes | |
| 7 | $270,558 | $252,407 | $18,151 | $0 | $18,151 | R55 | SYNCOPE AND COLLAPSE | Yes | |
| 8 | $201,004 | $545 | $200,459 | $0 | $200,459 | F84.0 | AUTISTIC DISORDER | Yes | |
| 9 | $195,091 | $192,852 | $2,239 | $320 | $1,919 | K52.9 | NONINFECTIVE GASTROENTERITIS AND COLITIS, UNSPECIFIED | Yes | |
| 10 | $194,815 | $182,800 | $12,014 | $0 | $12,014 | C50.411 | MALIG NEOPLM OF UPPER-OUTER QUADRANT OF RIGHT FEMALE BREAST | Yes | |
| 11 | $188,839 | $178,840 | $9,998 | $0 | $9,998 | C50.411 | MALIG NEOPLM OF UPPER-OUTER QUADRANT OF RIGHT FEMALE BREAST | Yes | |
| 12 | $166,616 | $145,288 | $21,329 | $96 | $21,232 | R07.9 | CHEST PAIN, UNSPECIFIED | Yes | |
| 13 | $164,702 | $161,888 | $2,814 | $0 | $2,814 | K52.89 | OTHER SPECIFIED NONINFECTIVE GASTROENTERITIS AND COLITIS | Yes | |
| 14 | $162,736 | $0 | $162,736 | $0 | $162,736 | F84.0 | AUTISTIC DISORDER | Yes | |
| 15 | $162,371 | $0 | $162,371 | $0 | $162,371 | F84.0 | AUTISTIC DISORDER | Yes | |
| 16 | $161,653 | $158,239 | $3,414 | $0 | $3,414 | G35 | MULTIPLE SCLEROSIS | Yes | |
| 17 | $154,720 | $4 | $154,716 | $149,829 | $4,887 | G82.20 | PARAPLEGIA, UNSPECIFIED | Yes | |
| 18 | $151,055 | $150,376 | $679 | $0 | $679 | R09.89 | OTH SYMPTOMS AND SIGNS INVOLVING THE CIRC AND RESP SYSTEMS | Yes | |
| Total | $4,683,955 | $2,549,123 | $2,134,832 | $649,835 | $1,484,997 |
&C&G&L&8© Aetna Integrated Informatics® 2026&R&8Page &P of &N Run Date: 2/24/2026
File details come from the government source that posted it. Updated .