| # of Actual Workers Compensation Claims Filed (Monthly)HR-Human Resources |
Measure Definition & Importance |
Accurately reflecting the actual claims reported from the Third Party Administrator (TPA). This data is imported from the TPA's claim system and allows Risk Management to track claim reporting trends and to compare the trends with claim cost. An increasing claim count presents an opportunity for Risk Management to implement cost saving measures and/or safety prevention.
Analysis | |
There was a 2.78% increase in actual number of workers compensation claims filed in September. Risk staff continues to evaluate the data of the actual claims filed to determine if any additional training or prevention measures can be increased.
# of Actual Workers Compensation Claims Filed (Monthly) |
Service Areas |
-
HR.6.1 Workers' Compensation
HR-Human Resources
Attachments |
Measure Data | Last Calculated 7 days ago |
| Period |  | Status | Actual | Overall Target | High Variance (FY Target) | Low Variance |
|---|---|---|---|---|---|---|
| Oct-18 |  | Lagging | 182.00 | 150.00 | 85.00 | |
| Nov-18 | | On Target | 122.00 | 150.00 | 85.00 | |
| Dec-18 | | On Target | 103.00 | 150.00 | 85.00 | |
| Jan-19 | | On Target | 143.00 | 150.00 | 85.00 | |
| Feb-19 | | On Target | 127.00 | 150.00 | 85.00 | |
| Mar-19 | | Lagging | 154.00 | 150.00 | 85.00 | |
| Apr-19 | | On Target | 119.00 | 150.00 | 85.00 | |
| May-19 | | On Target | 140.00 | 150.00 | 85.00 | |
| Jun-19 | | On Target | 142.00 | 150.00 | 85.00 | |
| Jul-19 | | On Target | 127.00 | 150.00 | 85.00 | |
| Aug-19 | | On Target | 128.00 | 150.00 | 85.00 | |
| Sep-19 | | On Target | 135.00 | 150.00 | 85.00 | |
| Oct-19 | | On Target | 120.00 | 150.00 | 85.00 | |
| Nov-19 | | On Target | 132.00 | 150.00 | 85.00 | |
| Dec-19 | | On Target | 92.00 | 150.00 | 85.00 | |
| Jan-20 | | On Target | 119.00 | 150.00 | 85.00 | |
| Feb-20 | | On Target | 121.00 | 150.00 | 85.00 | |
| Mar-20 | | Lagging | 212.00 | 150.00 | 85.00 | |
| Apr-20 | | On Target | 147.00 | 150.00 | 85.00 | |
| May-20 | | On Target | 118.00 | 150.00 | 85.00 | |
| Jun-20 | | Lagging | 170.00 | 150.00 | 85.00 | |
| Jul-20 | | Lagging | 199.00 | 150.00 | 85.00 | |
| Aug-20 | | On Target | 132.00 | 150.00 | 85.00 | |
| Sep-20 | | On Target | 146.00 | 150.00 | 85.00 | |
| Oct-20 | | Lagging | 163.00 | 150.00 | 85.00 | |
| Nov-20 | | Lagging | 190.00 | 150.00 | 85.00 | |
| Dec-20 | | Lagging | 246.00 | 150.00 | 85.00 | |
| Jan-21 | | Lagging | 261.00 | 150.00 | 85.00 | |
| Feb-21 | | On Target | 142.00 | 150.00 | 85.00 | |
| Mar-21 | | On Target | 88.00 | 150.00 | 85.00 | |
| Apr-21 | | On Target | 104.00 | 150.00 | 85.00 | |
| May-21 | | On Target | 89.00 | 150.00 | 85.00 | |
| Jun-21 | | On Target | 83.00 | 150.00 | 85.00 | |
| Jul-21 | | On Target | 67.00 | 150.00 | 85.00 | |
| Aug-21 | | On Target | 108.00 | 150.00 | 85.00 | |
| Sep-21 | | On Target | 111.00 | 150.00 | 85.00 | |
| Oct-21 | | On Target | 137.00 | 150.00 | 85.00 | |
| Nov-21 |  | Monitoring/No Info | ||||
| Dec-21 | | Monitoring/No Info | ||||
| Jan-22 | | Monitoring/No Info | ||||
| Feb-22 | | Monitoring/No Info | ||||
| Mar-22 | | Monitoring/No Info | ||||
| Apr-22 | | Monitoring/No Info | ||||
| May-22 | | Monitoring/No Info | ||||
| Jun-22 | | Monitoring/No Info | ||||
| Jul-22 | | Monitoring/No Info | ||||
| Aug-22 | | Monitoring/No Info | ||||
| Sep-22 | | Monitoring/No Info |
Data Source Details & Calculation Information |
Run a generalized claim export from YCEa (TPA's Claim System) for the desired date range.
The claims system will produce an excel spreadsheet.
Open the spreadsheet; Sort for date range.
Insert a column
Add a count and total the lines for the number of actual workers compensation claims filed (for the date range).
Performance Liaison |
| CA | Courtney August (HR- Human Resources) |
Measure Type |
Data Owner |
Measure ID |
Performance Liaison Notes |
Administrator Notes |