Calculated Columns Used by the Safety Statistics for Recordable Cases Report

Death Cases

This is the total number of cases where an employee died. An incident may have more than one case. This is determined using the Injury Classification field (HSIIC has a value of Death) on the Incident People record (F54HS02).

Restricted Work Cases

This is the total number of cases where an employee was listed as Restricted Work. An incident may have more than one case. This is determined using the Injury Classification field (HSIIC has a value of Restricted Work) on the Incident People record (F54HS02).

Days Away from Work Cases

This is the total number of cases where an employee was listed as Days Away From Work. An incident may have more than one case. This is determined using the Injury Classification field (HSIIC has a value of Days Away From Work) on the Incident People record (F54HS02).

Other Recordable Cases

This is the total number of cases where an employee was listed as Other Recordable Injury. An incident may have more than one case. This is determined using the Injury Classification field (HSIIC has a value of Other Recordable Injury) on the Incident People record (F54HS02).

First Aid Cases

This is the total number of cases where an employee was listed as First Aid. An incident may have more than one case. This is determined using the Injury Classification field (HSIIC has a value of First Aid) on the Incident People record (F54HS02).

Illness Cases

This is the total number of cases where an employee was listed as having an illness rather than an injury. An incident may have more than one case. This is determined using the Occupational Injury/Illness field (HSIOI has a value of Skin Disorder, Respiratory Condition, Poisoning, Hearing Loss, or All Other Illnesses. It excludes any marked as Injury) on the Incident People record (F54HS02).

Illness Case Rate

This is the illness cases frequency rate for each safety hours group. It is calculated as the (Total Number of Illness Cases X the Frequency Rate Constant from the processing option) / (Total Safety Metric). It is based on the Illness Cases calculated column.

Injury Cases

This is the total number of cases where an employee was listed as having an injury rather than an illness. An incident may have more than one case. This is determined using the Occupational Injury/Illness field (HSIOI has a value of Injury. It excludes any marked as Skin Disorder, Respiratory Condition, Poisoning, Hearing Loss, or All Other Illnesses) on the Incident People record (F54HS02).

Injury Case Rate

This is the injury cases frequency rate for each safety hours group. It is calculated as the (Total Number of Injury Cases X the Frequency Rate Constant from the processing option) / (Total Safety Metric). It is based on the Injury Cases calculated column.

Recordable Cases

This is the total number of recordable cases. An incident may have more than one case. This is determined using the OSHA Y/N check box equal to Y on the Incident People table (F54HS02).

Recordable Cases Rate

This is the recordable cases frequency rate for each safety hours group. It is calculated as the (Total Number of Recordable Cases X the Frequency Rate Constant from the processing option) / (Total Safety Metric). It is based on the Recordable Cases calculated column.

Lost Time Cases

This is the total number of cases where the employee lost time. An incident may have more than one case. This is determined using the Injury Classification field (HSIIC has a value of either Restricted Work or Days Away From Work) on the Incident People record (F54HS02).

Lost Time Cases Rate

This is the lost time cases frequency rate for each safety hours group. It is calculated as the (Total Number of Lost Time Cases X the Frequency Rate Constant from the processing option) / (Total Safety Metric). It is based on the Lost Time Cases calculated column

Skin Disorder Cases

This is the total number of cases where an employee was listed as having a skin disorder illness rather than an injury. An incident may have more than one case. This is determined using the Occupational Injury/Illness field (HSIOI has a value of Skin Disorder) on the Incident People record (F54HS02).

Respiratory Condition Cases

This is the total number of cases where an employee was listed as having a respiratory condition illness rather than an injury. An incident may have more than one case. This is determined using the Occupational Injury/Illness field (HSIOI has a value of Respiratory Condition) on the Incident People record (F54HS02).

Poisoning Cases

This is the total number of cases where an employee was listed as having a poisoning illness rather than an injury. An incident may have more than one case. This is determined using the Occupational Injury/Illness field (HSIOI has a value of Poisoning) on the Incident People record (F54HS02).

Hearing Loss Cases

This is the total number of cases where an employee was listed as having hearing loss rather than an injury. An incident may have more than one case. This is determined using the Occupational Injury/Illness field (HSIOI has a value of Hearing Loss) on the Incident People record (F54HS02).

All Other Illness Cases

This is the total number of cases where an employee was listed as having an 'other' illness rather than an injury. An incident may have more than one case. This is determined using the Occupational Injury/Illness field (HSIOI has a value of All Other Illnesses) on the Incident People record (F54HS02).

Recordable Injury Cases

This is the total number of cases where an employee was listed as having a 'recordable' injury. An incident may have more than one case. This is determined using the Injury Classification field (HSIIC has a value of Death, Restricted Work, Days Away From Work, or Other Recordable Cases) on the Incident People record (F54HS02).

Recordable Injury Rate

This is the recordable injury cases frequency rate for each safety hours group. It is calculated as the (Total Number of Recordable Injury Cases X the Frequency Rate Constant from the processing option) / (Total Safety Metric). It is based on the Recordable Injury Cases calculated column.