2024 MEDICAL CLAIMS Query.xlsx

This is a 2024 Medical Claims Query spreadsheet documenting inmate medical expense claims processed across multiple Indiana county jails, including facilities in Fountain, Delaware, Dearborn, Steuben, Noble, Sullivan, Lake, Brown, Greene, Jay, DeKalb, Bartholomew, Johnson, Boone, Franklin, Hancock, Allen, Fayette, and numerous other counties. The spreadsheet tracks medical claim submissions for healthcare (HEA), correctional facility (CF), and pharmacy (PAR) services rendered to offenders during 2023 and 2024, with claims processed throughout the calendar year 2024 from January through December.

The document records 587 individual medical claims with submitted amounts totaling $375,222.41 and approved amounts totaling $299,019.26, representing a cumulative difference of $76,203.15 in claim adjustments. Claims encompass medications, dental services, laboratory work, x-rays, emergency room visits, surgical procedures, physical therapy, imaging services, and other medical treatments. Claim types are categorized by service provider (HEA for healthcare, CF for correctional facility services, and PAR for pharmacy), with service dates spanning from September 2022 through September 2024. Notable claim denials and reductions appear throughout the dataset, with some claims fully approved and others partially denied or reduced by varying amounts, indicating review and adjustment processes were applied during claim adjudication.