Calculated Columns

The following calculated columns appear:

  • People Count

    This column displays the number of people involved in an incident. This number is important for reporting because one person with multiple injuries has multiple grid rows.

  • Incident Count

    This column displays the number of incidents that involve people. This number is important for reporting because a single incident may involve multiple people.

  • Injury Count

    This column displays the number of injuries for incidents that involve people. It is based on the Injured Y/N check box on the person record and takes into consideration additional injuries or illnesses in a complex injury.

  • Total Days Lost

    This column displays the total number of days lost for each employee due to injury or illness that resulted in days away from work or days restricted.

  • Case Number Count

    This column displays the number of reported cases (OSHA Y/N=Y).

  • People Level of Detail

    This column specifies the information that each grid row represents. "1" represents that the person has only an F54HS02 record and does not have any additional injuries. "2" represents that the person has both an F54HS02 and F54HS021 record. "3" represents that the information in the grid row is a subsequent additional injury or illness record (F54HS021) beyond the initial additional injury record. The various reports that come with this application report at different levels of people information and this field is integral to control which records are taken into consideration for each report.

  • Company Responsible

    This column indicates that the company is responsible for the incident. This column has a value of 1 if the Contractor / 3rd Party Involved check box is not selected. The system uses this value to count the number of incidents where the company is responsible.

  • Incident Date From and Incident Date Thru

    These columns are the incident date from and the incident date thru entered in the header date range. These dates are compared to the incident date from the incident record to determine eligibility. These dates are inclusive.

  • Formatted Time Work Began

    This column displays the time that the person began work on the day of the incident shown. It is formatted as hours:minutes:seconds. Although you cannot filter or query on this field (you would use the accompanying Time Work Began column for that), it is easier to read formatted date fields and is provided for reporting purposes.