Calculated Grid Column

The following calculated columns appear:

  • Incident Year

    This is the calendar year associated with the reported incident. It is based on the Incident Date (HSIDT) field.

  • Formatted Incident Time

    This column displays the formatted time. The Query By Example (QBE) is not enabled for this column. However, the formatted time presents the time in an easy to read format of hours, minutes, and seconds.

  • Incident Date From

    This is the incident from date entered in the header date range. This date is compared to the incident date from the incident record to determine eligibility. This date is inclusive. It is used for reporting purposes.

  • Incident Date Thru

    This is the incident thru date entered in the header date range. This date is compared to the incident date from the incident record to determine eligibility. This date is inclusive. It is used for reporting purposes.

  • Company Responsible

    This column indicates that the company is responsible for the incident and that no contractor or 3rd party is involved. 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.

  • Company or 3rd Party Description

    This column displays the description to use for reporting purposes. It will display either "3rd Party Responsible" or "Company Responsible" based on whether the Contractor / 3rd Party Involved check box (HSICR) for the incident is selected or not.

  • Environmental Event Count

    This column displays the number of environmental records. It is used for reporting purposes.

  • Incident Count

    This column displays the number of incidents. It is used for reporting purposes.