Calculated Columns Used by the Incident Impact Rates Report

These are based on incidents by key impact measures such as costs and lost time.

  • Total Days Away From Work

    This is the total number of days away from work as indicated on all the people records related to the incidents for the safety hours group. This is based on the No. Days Away From Work field (NDAW) on the Incident People record (F54HS02).

  • Total Days Restricted Work

    This is the total number of days on restricted work or job transfer as indicated on all the people records related to the incidents for the safety hours group. This is based on the No. Days Restricted Work Activity field (NDWA) on the Incident People record (F54HS02).

  • Total Days Lost

    This is the total number of days lost as indicated on all of the people records related to the incidents for the safety hours group. This is the sum of the Total Days Away From Work and Total Days On Restricted Work or Job Transfer calculated columns.

  • Total Days Lost Rate

    This is the total days lost impact rate for each safety hours group. It is calculated as the (Incident Total Days Lost X the Frequency Rate Constant from the processing option) / (Total Safety Metric). This is based on the Total Days Lost calculated column.

  • Estimated Cost of Incidents

    This is the total estimated cost for all incidents for the safety hours group. This information is reported on from the incident master (HSITEC, F54HS01) but it represents the sum of all estimated costs as recorded in the individual cost records for each incident.

  • Actual Cost of Incidents

    This is the total actual cost for all incidents for the safety hours group. This information is reported on from the incident master (HSITAC, F54HS01) but it represents the sum of all actual costs as recorded in the individual cost records for each incident.

  • Actual Cost Rate

    This is the total actual cost impact rate for each safety hours group. It is calculated as the (Incident Total Actual Cost) / (Total Safety Metric). This is based on the Actual Cost of Incidents calculated column.

  • As If Estimated Cost of Incidents

    This is the total estimated cost for all incidents stated in a common currency. This is the sum of Total Estimated Cost (HSITEC) converted to the As If Currency Code and the As of Date.

  • As If Actual Cost of Incidents

    This is the total actual cost for all incidents stated in a common currency. This is the sum of Total Actual Cost (HSITAC) converted to the As If Currency Code and the As of Date.

  • As If Actual Cost Rate

    This is the total actual cost impact rate for each safety hours group stated in a common currency converted to the As If Currency Code and the As of Date. It is calculated as the (As If Actual Cost of Incidents)/ (Total Safety Metric). This is based on the As If Actual Cost of Incidents calculated column.