RFP_5800_SLW3033_ATT_11_v1.xlsx

This is a workers' compensation claims data report as of September 30, 2024, documenting open claims for the City of Austin across multiple departments including Austin Energy, Austin Resource Recovery, Austin Water Utility, Austin Transportation, Code Compliance, Watershed Protection & Development, and Development Services Department. The file contains detailed claim information for employees injured during work activities, including claim identification numbers, dates of loss, dates claims were reported, claimant descriptions, injury types, and claim statuses. The report encompasses claims spanning from as early as 1974 through September 2024, with the majority of recent claims from fiscal year 2024 (October 1, 2023 through September 30, 2024). Claims range from minor injuries such as sprains and contusions to severe injuries including fatalities, amputations, and traumatic brain injuries. The data indicates claim statuses including accepted claims, pending claims, and denied claims, with injury descriptions and event descriptions documented for each case.

The report provides comprehensive financial data for each claim, including amounts paid and reserved for indemnity/loss, medical expenses, and case expenses, along with total incurred amounts and recovery information where applicable. Notable claims include multiple fatalities resulting from motor vehicle collisions and workplace incidents, with associated settlements and reserves ranging from thousands to over one million dollars per claim. The claims reflect workplace hazards specific to each department's operations, including electrical hazards at Austin Energy, vehicle-related injuries at Austin Resource Recovery and Austin Transportation, and water utility-specific incidents at Austin Water Utility. The file serves as a historical record supporting the City of Austin's request for proposals from qualified workers' compensation third party administrator firms with public sector experience, demonstrating the volume and complexity of claims management required for the organization.