HR Incidents - Safety and Health

The HR Incidents - Safety and Health report shows safety and health incident details by employee. You can add fields to show additional incident details.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Employee Number
Employee
Employment Status
Incident Date
Case No
Incident Area
Incident State
Privacy Case
Emergency Room Visit
Is Days Lost
Days Lost
Safety Health Type Name
HR Incident Group Name
HR Incident Injury Name
HR Incident Type Name
Location Name

Custom Fields

Manager On Date of Incident

The Manager on Date of Incident custom field uses the following expression:

(select string_agg(e.DisplayName, ' / ') from employeemanager em join employee e on em.ManagerId = e.EmployeeId where em.employeeid = employee.employeeid and effectivestart <= employeehrincident.hrincidentdate and coalesce(effectiveend, '2050-01-01') >= employeehrincident.hrincidentdate)

Filters

The template includes the following filters: