25-Manor ISD Large Claim Reporting - 9.2025-3.2026.xlsx
XLSX spreadsheet 28 KB Posted
- Attached to
- Manor ISD - 2026 Medical RFP
- Solicitation number
- 26-010RFP – RE-ISSUED
- Issued by
- Travis County, Texas
About this file
This is a Large Claim Reporting document for Manor Independent School District's self-funded medical plan covering the period from September 2025 through March 2026. The report details high-cost claims exceeding the $25,000 threshold across multiple service categories including facility inpatient, facility outpatient, professional services, and pharmacy. The document identifies 35 claimants with their encrypted member IDs, relationship descriptions (subscriber, spouse, or dependent child), medical paid amounts, pharmacy paid amounts, and primary diagnoses. The claims encompass a wide range of medical conditions including malignant neoplasms, chronic renal failure, developmental disorders, respiratory failure, and various musculoskeletal and systemic conditions.
The aggregate medical paid claims total $2,342,561.41, with pharmacy paid claims totaling $1,217,656.18, representing combined high-cost claims of approximately $3.56 million for the six-month period. Individual claim amounts vary significantly, ranging from approximately $531.81 to $466,227.13 in medical costs, with pharmacy costs ranging from $0.00 to $336,971.00. This claims data directly supports Manor Independent School District's 2026 Medical RFP, which is soliciting proposals for self-funded medical and prescription drug plans, fully insured medical and prescription drug plans, and stop loss products. The district previously rejected all prior proposals and is re-soliciting to ensure adequate competition and best value.
View the file
Other files
Show all 27
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
Dynamic Claimant Dynamic Claimant
Run Date: 4/13/2026
| Metrics: | (Paid) | |||
| High Cost Threshold: | ($25,000) | |||
| Paid Month: | (Sep 2025 - Mar 2026) | |||
| Service Category: | (FACILITY INPATIENT, FACILITY OUTPATIENT, PROFESSIONAL, PHARMACY) | |||
| Encrypted Member ID | Member Relationship Description | Medical Paid | Pharmacy Paid | Primary Diagnosis |
| 6956989340538076877 | Subscriber | 62,292.17 | 1,149.50 | D05 - Carcinoma in situ of breast |
| 7229027485593804546 | Subscriber | 6,927.41 | 24,902.37 | R10 - Abdominal and pelvic pain |
| 2318108370334176448 | Spouse | 50,349.62 | 5,109.20 | C22 - Malignant neoplasm of liver and intrahepatic bile ducts |
| 4657789646815587468 | Subscriber | 50,206.48 | 6,890.25 | I16 - Hypertensive crisis |
| 1183455891590386660 | Dependent Child | 74,516.68 | 64.42 | F84 - Pervasive developmental disorders |
| 2288214574400101860 | Subscriber | 175,001.35 | 2,027.74 | C50 - Malignant neoplasm of breast |
| 2329613266373177380 | Subscriber | 41,315.68 | 3,421.94 | G35 - Multiple sclerosis |
| 4101167685775033217 | Subscriber | 34,682.82 | 9,305.31 | M17 - Gonarthrosis [arthrosis of knee] |
| 4255850521043393881 | Dependent Child | 118,076.11 | 0.00 | Z38 - Liveborn infants according to place of birth |
| 3630014050385380095 | Subscriber | 23,851.60 | 4,156.89 | G43 - Migraine |
| 6849153654071089498 | Dependent Child | 60,221.75 | 0.00 | J96 - Respiratory failure, not elsewhere classified |
| 6341165288982509909 | Subscriber | 30,193.27 | 1,026.35 | O42 - Premature rupture of membranes |
| 8024443307166921423 | Subscriber | 531.81 | 90,393.37 | L03 - Cellulitis |
| 8840898306007723149 | Subscriber | 33,954.44 | 393.55 | M48 - Other spondylopathies |
| 532965161068767555 | Subscriber | 108,541.76 | 376.50 | M50 - Cervical disc disorders |
| 4730270440619251948 | Dependent Child | 466,227.13 | 18,197.45 | S37 - Injury of pelvic organs |
| 8962028849723391775 | Spouse | 67,296.46 | 4,831.86 | N18 - Chronic renal failure |
| 6202999279817841740 | Dependent Child | 17,022.94 | 82,935.08 | E43 - Unspecified severe protein-energy malnutrition |
| 6672715074505954875 | Subscriber | 921.00 | 47,770.85 | Z23 - Need for immunization against single bacterial diseases |
| 6019531012974920390 | Subscriber | 37,672.39 | 336,971.00 | M19 - Other arthrosis |
| 4212468029815085983 | Subscriber | 106,613.47 | 0.00 | I67 - Other cerebrovascular diseases |
| 283690822150018453 | Subscriber | 35,931.61 | 873.98 | A41 - Other septicaemia |
| 7842575415443208980 | Subscriber | 2,215.92 | 40,722.37 | M45 - Ankylosing spondylitis |
| 8651063155326295056 | Subscriber | 38,631.34 | 4,365.76 | M16 - Coxarthrosis [arthrosis of hip] |
| 8338872174721189843 | Subscriber | 54,574.68 | 139.13 | N18 - Chronic renal failure |
| 4813801640415999501 | Subscriber | 31,692.77 | 54,030.58 | M34 - Systemic sclerosis |
| 6694979315554783862 | Subscriber | 4,379.82 | 61,282.17 | K31 - Other diseases of stomach and duodenum |
| 1703898883421554585 | Dependent Child | 28,708.73 | 151.94 | Q89 - Other congenital malformations, not elsewhere classified |
| 8121977297585047996 | Subscriber | 2,249.48 | 64,853.11 | N20 - Calculus of kidney and ureter |
| 6104682396989871739 | Subscriber | 36,005.70 | 0.00 | T81 - Complications of procedures, not elsewhere classified |
| 2199262265185908194 | Subscriber | 381.07 | 25,017.73 | J45 - Asthma |
| 2084185188054031654 | Dependent Child | 66,133.60 | 279,208.39 | Z99 - Dependence on enabling machines and devices, not elsewhere classified |
| 687746626053470590 | Subscriber | 167,562.83 | 85.11 | C50 - Malignant neoplasm of breast |
| 8050512952950000800 | Subscriber | 306,287.82 | 15.52 | A41 - Other septicaemia |
| 4941942740942695051 | Subscriber | 1,389.70 | 46,986.76 | Z00 - General examination and investigation of persons without complaint and reported diagnosis |
| Query Totals: 35 | 2,342,561.41 | 1,217,656.18 | ||
| Report Totals: 35 | 2,342,561.41 | 1,217,656.18 |
&G
Page &P of &N image1.jpeg
File details come from the government source that posted it. Updated .