Configuring incident statistics
Who is this article for?Administrators and Managers who want to learn to configure incident statistics.
Administrator permissions are required to follow some of these steps.
The Statistics tab is used to generate injury frequency information (LTIFR, MTIFR etc) based on the labour hours, headcount and days lost information entered; and the injuries and their classification that has been entered into Lucidity Incident.
1. Statistics
Video: Statistics Overview
From the Statistics tab, users can:
- Add, edit and delete labour hours.
- Report on labour hours in Excel format.
Note: These options are role dependent.
2. Labour hour
Information for labour hours is entered on a monthly basis. The Labour Hours menu is used to enter:
- Hours worked.
- Number of employees and/ or subcontractors/ visitors.
- Days lost (rostered days where workers are absent from work due to workplace injuries).
2.1. Add a new labour hour entry
Video: Add New Labour Hour Entry
To add a new labour hour entry, from the Labour Hour page:
-
Click Add New.
- Complete the fields by referring to Definitions of Fields section below.
Important: The details captured for each entry may vary slightly between each system configuration. Fields marked with * are mandatory.
-
Click Save to save the labour hour entry.
2.2. Definition of fields
| Category | Field | Description |
|---|---|---|
| Administration Options | Organisation Details | Select relevant organisation details. Note: If no organisation exists for administration/overheads, leave this field blank. The statistics will then be included for whole company reporting. |
| Administration Options | Year Month | Select the year and month for the labour hour entry. |
| Employees | Number of Hours Worked | Enter the total number of hours worked by employees for the month. Note: If there is no requirement to distinguish between employee and contractor data, enter all information into the employees fields and enter '0' into the contractor fields. |
| Employees | Number of Employees | Enter the total number of employees working for the month. This is an internal business decision as to the calculation for this. Typically it is regarded as headcount not FTE. So an employee working for 2 hours in the month would count as 1 employee. |
| Employees | Days Lost | Enter the total number of rostered days for the month where employees have been absent from work due to workplace injuries, regardless of when the injury occurred. I.E. - an injury which occurred the previous month may still result in days lost for the current month. The number of days lost for the current month only need to be included. |
| Subcontractors/ Visitors | Number of Hours Worked |
Enter the total number of hours worked by contractors for the month. If there is no requirement to distinguish between employee and contractor data, enter all information into the employees fields and enter '0' into the contractor fields. |
| Subcontractors/ Visitors | Number of Contractors | Enter the total number of contractors working for the month. |
| Subcontractors/ Visitors | Days Lost | Enter the total number of rostered days for the month where contractors or visitors have been absent from work due to workplace injuries, regardless of when the injury occurred. I.E. - an injury which occurred the previous month may still result in days lost for the current month. The number of days lost for the current month only need to be included. |
| Total | Total Hours Worked | Calculated automatically = employee number of hours worked + contractor number of hours worked. |
| Total | Total Average People | Calculated automatically = number of employees working + number of contractors working. |
| Total | Days Lost Total | Calculated automatically = days lost for employees + days lost for contractors. |
2.3. Summed analysis
All entries within a given month will be aggregated for analysis based on the selected organisational parameters. The system allows flexibility in data entry to support various analytical requirements. For instance, if the Sales division comprises two active projects (Project Alpha and Project Delta) along with a general Corporate overhead group, labour hours can be entered using three distinct records:
-
Entry 1: Jan-2019 — Division: Sales, Project: Alpha — enter hours specific to Project Alpha for January 2019.
-
Entry 2: Jan-2019 — Division: Sales, Project: Delta — enter hours specific to Project Delta for January 2019.
-
Entry 3: Jan-2019 — Division: Sales, Project: [blank] — enter hours attributable to the Sales division as a whole for January 2019.
This structure enables the Statistics module to report metrics such as Lost Time Injury Frequency Rate (LTIFR) for each project individually or for the Sales division in aggregate. If detailed project-level data is not available or not required, all hours may alternatively be recorded as a single consolidated entry under the Sales division.
2.4. Edit labour hour entry
Video: Edit and Delete Labour Hour Entry
To edit a labour hour entry, from the Labour Hour page:
-
Use Filters to locate the relevant labour hour entry.
-
Click Edit on the far right-hand side of the entry.
- Enter the details as required.
- Click Save to save changes and return to the Labour Hour page.
2.5. Delete Labour Hour Entry
To delete a labour hour entry, from the Labour Hour page:
-
Use Filters to locate the relevant labour hour entry.
-
Click Actions on the far right-hand side of the entry.
-
Click Delete.
- In the pop-up window that appears, click Delete to confirm.
Important Note: The action of deleting a labour hour entry cannot be undone. Always use the delete function with caution.
2.6. Reporting from the labour hour page
Video: Reporting from the Labour Hour page
To generate a report for specific labour hour entries, from the Labour Hour page:
-
Use Filters to locate the relevant labour hour entries.
-
All results will be displayed at the bottom of the screen.
-
Click Excel Export to generate the report into Excel.
3. Labour hour report
Video: Labour Hour Report page
The Labour Hour Report page provides an overview and reporting option to view all calculations associated with labour hours and injury frequency rates.
A full injury frequency rate report is available from both the Labour Hour Report page as well as from the Dashboard tab within Lucidity Incident using either of the frequency rates widgets.
To run an Injury frequency rate report, from the Labour Hour Report page:
-
Use filters to limit results as required based on organisational structure, date range, calculation factor, date range, rolling period (e.g. 12 months).
-
All results will be displayed at the bottom of the screen.
-
Click Excel Export to generate the report into Excel.
4. Reporting on all injuries frequency rates
Video: Lucidity Incident: Reporting on All Injuries Frequency Rates (AIFR)
5. Injury frequency calculations
Lucidity Incident provides many reporting options to display a variety of calculations for Injury frequencies. The following injury frequency rate calculations and abbreviations are used throughout Lucidity Incident:
Note: Not all of these terms will appear on every page and not all are part of the Statistics Labour Hours Reporting.
| Abbreviation | Name | Calculation |
|---|---|---|
| SR | Severity Rate | (Days Lost due to LTI's * 1,000,000) / Hours |
| DR | Duration Rate | Days lost due to LTI's / Number of lost time injuries |
| LTIFR | Lost Time Injury Frequency Rate | (Number of LTI's / Hours) * 1,000,000 |
| RWIFR | Restricted Work Incident Frequency Rate | (Number of RWI's / Hours) * 1,000,000 |
| MTIFR | Medical Treated Injury Frequency Rate | (Number of MTIs / Hours) * 1,000,000 |
| TR | Total Recordable | Number of (MTI + LTI + RWI) |
| TRFR | Total Recordable Frequency Rate | (Number of TR / Hours) * 1,000,000 |
| AI | All Injury | Number of (MTI + LTI + RWI + FAI) |
| AIFR | All Injury Frequency Rate | (Number of AI / Hours) * 1,000,000 |
| FAIFR | First Aid Injury Frequency Rate | (Number of FAI / Hours) * 1,000,000 The calculation used for this is the MI - minor injury calculation. |
Rolling calculations, regardless of whether the time period is 3, 6 or 12 months, are calculated using the total hours and injuries for the selected time period. A worked example is provided below for a 3 month rolling average:
| Metric | Jan | Feb | Mar | TOTAL (3 Month rolling average) |
|---|---|---|---|---|
| Hours | 10000 | 5000 | 2000 | 17000 |
| LTI's | 1 | 1 | 0 | 2 |
| LTIFR | 100 | 200 | 0 | 117 |
Note: Simply averaging the LTIFR for each of the months in the example above will not give the correct result, as it does not recognise the effect of variations in labour hours from month to month, and how they contribute to the LTIFR.
5.1 Adjusting the injury severity list
The Injury Severity managed list can be adjusted, although it is recommended a discussion with Lucidity is held PRIOR to making any changes so the full impact on other areas of the Incident module are understood.