47411393-E3B2-7F55-0865EAB909BEF818.xlsx

This file is a Short Term Disability claims detail report for the Franklin County Cooperative Health Improvement Program, customer number 0157775, covering the period from January 1, 2022 through July 31, 2025. The document contains administrative health insurance data tracking individual disability claims processed through this cooperative health benefit arrangement. The report lists 493 total claims with associated claim statuses (Closed, Denied, Open, Pending, or Suspended), claimant demographics including gender and age, disability type classifications, disability dates, benefit start dates, claim end dates, base benefit amounts, and cumulative gross benefit payments. Claims range across various dates within the reporting period, with claimant ages spanning from newborns to individuals in their 70s, and disability classifications categorized as either Sick (S) or Accident (A), with occupational (Occ) or non-occupational (Non-Occ) designations.

The aggregate gross benefits paid for customer 0157775 totaled $2,234,179.52 across all 493 claims during the reporting period. Individual claim benefits vary significantly, ranging from minimal amounts such as $25.00 to substantial payouts exceeding $35,000, with base benefit amounts typically ranging from approximately $370 to $1,500 per claim. The claim status distribution reflects a majority of closed claims with numerous denied and open claims, along with several pending and suspended cases as of the report date of August 13, 2025. This data represents the operational claims activity for a multi-employer cooperative health insurance program providing short-term disability coverage to its participating members in Franklin County.