47411393-E3B2-7F55-0865EAB909BEF818.xlsx

This is a Short Term Disability claims data report for the Franklin County Cooperative Health Improvement Program (Customer 0157775), documenting disability claims processed between January 1, 2022, and July 31, 2025. The report provides a comprehensive claim status detail for 493 total disability claims managed under this cooperative health program. The claims data includes individual claimant information, disability classifications (sick or accident-related), occurrence/non-occurrence status, disability dates, benefit start dates, claim end dates, base benefit amounts, and cumulative gross benefits paid. Claims are categorized by status as either Closed, Denied, Open, Pending, or Suspended, reflecting various stages of the disability claim process. The report captures claim lifecycles ranging from immediate denial through multi-month benefit periods, with disability dates spanning from 2020 through August 2025.

The aggregate data shows a total cumulative gross benefit payout of $2,234,179.52 across all 493 claims for the reporting period. Individual base benefits range from $25.00 to $1,500.00 per claim, with cumulative gross benefits varying significantly based on claim duration and approval status. The vast majority of claims are classified as non-occupational sick leave (marked as "S N" in the data), with a small number designated as accident-related. Base benefit amounts appear to correlate with claimant age and employment classification. The report reflects the operational status of the cooperative health program's short-term disability insurance coverage, providing detailed metrics for claims management, benefit administration, and financial performance across the covered population.