2025 Medical Claims Query Summary

This is a medical claims tracking spreadsheet documenting healthcare services provided to incarcerated individuals across multiple Indiana county jail facilities during 2025. The document tracks claims submitted by various county jails including Wabash, Johnson, Posey, Delaware, Fountain, Sullivan, Allen, Lake, Hancock, Boone, and numerous others throughout the state. The spreadsheet records medical services encompassing medications, dental procedures, surgical interventions, laboratory work, X-rays, ultrasounds, emergency room visits, and various specialist consultations. The data spans from January 2025 through November 2025, with claims organized by submission date, service month, and facility. Each entry documents the offender information, claim type (HEA for individual health evaluations or CF for facility-level claims), and service dates ranging from June 2024 through September 2025.

The spreadsheet details claim submission amounts and approved reimbursement amounts for 491 individual medical claims totaling $219,064.34 in submitted amounts, with $168,455.92 in approved amounts, resulting in a total difference of $50,608.42 in denied or reduced claims. Claims are classified by type—including HEA (individual), CF (facility), and PAR (partner) designations—with approval rates varying significantly by county facility and service category. Approved claims show full reimbursement in numerous instances, while other claims experience substantial reductions, with some claims denied entirely. The data indicates ongoing healthcare service provision to detained populations with a systematic review and approval process for medical claim reimbursement across the Indiana county jail system.