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

File Type Posted
ESBD_521004_1780595757286_RFP 2605-004Amendment 1 - Updated Exhibits A-10 & A-11.pdf PDF
ESBD_521004_1780596005194_UPDATED Exhibit A-11 Vision Provider Report.xlsx XLSX spreadsheet
ESBD_521004_1780955159340_RFP 2605-004 Addendum 1 - Q&A Document.pdf PDF
ESBD_521004_1780955124892_Updated Exhibit A-4 -RX Claim, Medical Memborship, Monthly Claims History De-ID 1.1.23 thru present.xlsx XLSX spreadsheet
ESBD_521004_1780955049911_RFP 2605-004 Amendment 2 - Updated Exhibits A--4.pdf PDF
ESBD_521004_1780595977238_UPDATED Exhibit A-10 DPPO Provider Report.xls XLS spreadsheet
ESBD_521004_1780003738276_Exhibit A-1. 2026_Seton ACO_SBC.pdf PDF
ESBD_521004_1780004996397_Exhibit A-17 YOY Rates.xlsx XLSX spreadsheet
ESBD_521004_1780004177857_Exhibit A-7. Prescription Drug NDC 11.xlsx XLSX spreadsheet
ESBD_521004_1780004433000_Exhibit A-12 Census.xlsx XLSX spreadsheet
ESBD_521004_1780003632493_RFP 2605-004 HR Benefits - Medical, Dental & Vision.pdf PDF
ESBD_521004_1780004399033_Exhibit A-11 Vision Provider Report.xlsx XLSX spreadsheet
ESBD_521004_1780004464564_Exhibit A-13 Medical ASO, Dental, Vision Questionnaire 3.31.26kle.xlsx XLSX spreadsheet
ESBD_521004_1780003821808_Exhibit A-2 (PREMIUM PPO PLAN ) Summary .pdf PDF
ESBD_521004_1780004939189_Exhibit A-15 Data Requirements.pdf PDF
ESBD_521004_1780005665914_Exhibit A-7 Large Claim Jan 26.xls XLS spreadsheet
ESBD_521004_1780005824658_Exhibit A-9 Provider Report Most Recent 12month w-o lag 3_31_26 (1).xls XLS spreadsheet
ESBD_521004_1780003853623_Exhibit A-2. -Comprehensive Dental Basic Plan - Multi Plans.PDF PDF
ESBD_521004_1780004199247_Exhibit A-8 - Top 50 Drugs Report.xlsx XLSX spreadsheet
ESBD_521004_1780003765862_Exhibit A-1. 2026_TMN_SBC.pdf PDF
ESBD_521004_1780004043386_Exhibit A-5 Dental PvC through 1-26.xlsx XLSX spreadsheet
ESBD_521004_1780004979249_Exhibit A-16 Plan Summaries.pdf PDF
ESBD_521004_1780004498571_Exhibit B-1 - Medical ASO Pricing Sheet.pdf PDF
ESBD_521004_1780004547468_Exhibit B-3 - Fully-insured Vision Pricing Sheet.pdf PDF
ESBD_521004_1780004312250_Exhibit A-10 DPPO Provider Report - most recent.xls XLS spreadsheet
ESBD_521004_1780004282954_Exhibit A-3. 2026 Vision Member Summary.pdf PDF
ESBD_521004_1780005447955_Exhibit A-10 DPPO Provider Report.xls XLS spreadsheet
ESBD_521004_1780003789859_Exhibit A-2 ( BASIC PPO PLAN) Summary .pdf PDF
ESBD_521004_1780003703946_Exhibit A-1. 2026_HDHP_SBC.pdf PDF
ESBD_521004_1780004525370_Exhibit B-2 - Fully-insured Dental Pricing Sheet.pdf PDF
ESBD_521004_1780007087656_Exhibit A-11 Vision Provider Report - most recent.xlsx XLSX spreadsheet
ESBD_521004_1780004889095_Exhibit A-14 PBM Questionnaire.xlsx XLSX spreadsheet
ESBD_521004_1780005131284_Exhibit A-4 -RX Claim History De-ID 1.1.23 thru present.xlsx XLSX spreadsheet
ESBD_521004_1780004074805_Exhibit A-6. Vision PvC through 11-25.xlsx XLSX spreadsheet
ESBD_521004_1780004246154_Exhibit A-9 Provider Report 12month w-o lag 3_31_26 - most recent.xls XLS spreadsheet
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 InsuredALL
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
ClaimantTotal Medical/RX
Paid AmountPharmacy
Paid AmountMedical
Paid AmountInpatient
Paid AmountAmbulatory
Paid AmountDiagnosis
CodeDescriptionService Rendered in Last Quarter
1$568,034$567,573$460$0$460D66HEREDITARY FACTOR VIII DEFICIENCYYes
2$544,010$81,619$462,391$303,859$158,532M48.02SPINAL STENOSIS, CERVICAL REGIONYes
3$417,022$356,896$60,126$0$60,126B20HUMAN IMMUNODEFICIENCY VIRUS (HIV) DISEASEYes
4$410,324$24,300$386,025$0$386,025E75.22GAUCHER DISEASEYes
5$287,804$77,385$210,419$0$210,419D47.2MONOCLONAL GAMMOPATHYYes
6$282,601$18,110$264,491$195,731$68,760I63.9CEREBRAL INFARCTION, UNSPECIFIEDYes
7$270,558$252,407$18,151$0$18,151R55SYNCOPE AND COLLAPSEYes
8$201,004$545$200,459$0$200,459F84.0AUTISTIC DISORDERYes
9$195,091$192,852$2,239$320$1,919K52.9NONINFECTIVE GASTROENTERITIS AND COLITIS, UNSPECIFIEDYes
10$194,815$182,800$12,014$0$12,014C50.411MALIG NEOPLM OF UPPER-OUTER QUADRANT OF RIGHT FEMALE BREASTYes
11$188,839$178,840$9,998$0$9,998C50.411MALIG NEOPLM OF UPPER-OUTER QUADRANT OF RIGHT FEMALE BREASTYes
12$166,616$145,288$21,329$96$21,232R07.9CHEST PAIN, UNSPECIFIEDYes
13$164,702$161,888$2,814$0$2,814K52.89OTHER SPECIFIED NONINFECTIVE GASTROENTERITIS AND COLITISYes
14$162,736$0$162,736$0$162,736F84.0AUTISTIC DISORDERYes
15$162,371$0$162,371$0$162,371F84.0AUTISTIC DISORDERYes
16$161,653$158,239$3,414$0$3,414G35MULTIPLE SCLEROSISYes
17$154,720$4$154,716$149,829$4,887G82.20PARAPLEGIA, UNSPECIFIEDYes
18$151,055$150,376$679$0$679R09.89OTH SYMPTOMS AND SIGNS INVOLVING THE CIRC AND RESP SYSTEMSYes
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 .