Special Processing in the Calculated Grid Columns

The system records information in the grid columns that is related to the special processing considerations in the header. These columns facilitate reporting over data that is not available in the database in a form easy to report on. The reports delivered with the application are possible because of these columns. You can also use them when defining custom reports.

The One View Incident Summary Inquiry application uses the following special processing in these calculated columns in the grid:

• 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 provided in a column to use on a report.

• 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 provided in a column to use on a report.

• Incident Year

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

• As If Currency Code

  This is the currency code entered in the header field of the application. This column is needed so that the code is available to use on a report.

• As of Currency Date

  This is the As of Date entered in the header field of the application. This column is needed so that the As of Currency Date is available to use on a report. If a currency code was filled in but this date is left blank, the system will use the system date.

• As If Exchange Rate

  This is the exchange rate used to convert the currency amounts. It is retrieved based on the As If Currency Code and the As of Currency Date fields.

• Estimated Cost Injury / Illness

  This is the total of all estimated costs associated with an incident that has the Injury / Illness check box selected. This is based on the Total Incident Estimated Cost (HSITEC). If the Injury / Illness check box is not selected, this column has a value of 0.

• Actual Cost Injury / Illness

  This is the total of all actual costs associated with an incident that has the Injury / Illness check box selected. This is based on the Total Incident Actual Cost (HSITAC). If the Injury / Illness check box is not selected, this column has a value of 0.

• As If Estimated Cost Injury / Illness

  This is the total of all estimated costs in another currency associated with an incident that has the Injury / Illness check box selected. When the incident has the Injury / Illness check box selected, this field is populated with the Total Incident Estimated Cost (HSITEC) converted to the As If Currency. If the Injury / Illness check box is not selected, this column has a value of 0.

• As If Actual Cost Injury / Illness

  This is the total of all actual costs in another currency associated with an incident that has the Injury / Illness check box selected. When the incident has the Injury / Illness check box selected, this field is populated with the Total Incident Actual Cost (HSITAC) converted to the As If Currency. If the Injury / Illness check box is not selected, this column has a value of 0.

• Estimated Cost Security

  This is the total of all estimated costs associated with an incident that has the Security check box selected. This is based on the Total Incident Estimated Cost (HSITEC). If the Security check box is not selected, this column has a value of 0.

• Actual Cost Security

  This is the total of all actual costs associated with an incident that has the Security check box selected. This is based on the Total Incident Actual Cost (HSITAC). If the Security check box is not selected, this column has a value of 0.

• As If Estimated Cost Security

  This is the total of all estimated costs in another currency associated with an incident that has the Security check box selected. When the incident has the Security check box selected, this field is populated with the Total Incident Estimated Cost (HSITEC) converted to the As If Currency. If the Security check box is not selected, this column has a value of 0.

• As If Actual Cost Security

  This is the total of all actual costs in another currency associated with an incident that has the Security check box selected. When the incident has the Security check box selected, this field is populated with the Total Incident Actual Cost (HSITAC) converted to the As If Currency. If the Security check box is not selected this has a value of 0.

• Estimated Cost Equipment

  This is the total of all estimated costs associated with an incident that has the Property / Equipment Damage check box selected. This is based on the Total Incident Estimated Cost (HSITEC). If the Property / Equipment Damage check box is not selected, this column has a value of 0.

• Actual Cost Equipment

  This is the total of all actual costs associated with an incident that has the Property / Equipment Damage check box selected. This is based on the Total Incident Actual Cost (HSITAC). If the Property / Equipment Damage check box is not selected, this column has a value of 0.

• As If Estimated Cost Equipment

  This is the total of all estimated costs in another currency associated with an incident that has the Property / Equipment Damage check box selected. When the incident has the Property / Equipment Damage check box selected, this field is populated with the Total Incident Estimated Cost (HSITEC) converted to the As If Currency. If the Property / Equipment Damage check box is not selected, this column has a value of 0.

• As If Actual Cost Equipment

  This is the total of all actual costs in another currency associated with an incident that has the Property / Equipment Damage check box selected. When the incident has the Property / Equipment Damage check box selected, this field is populated with the Total Incident Actual Cost (HSITAC) converted to the As If Currency. If the Property / Equipment Damage check box is not selected, this column has a value of 0.

• Estimated Cost Motor Vehicle

  This is the total of all estimated costs associated with an incident that has the Motor Vehicle Involved check box selected. This is based on the Total Incident Estimated Cost (HSITEC). If the Motor Vehicle Involved check box is not selected, this column has a value of 0.

• Actual Cost Motor Vehicle

  This is the total of all actual costs associated with an incident that has the Motor Vehicle Involved check box selected. This is based on the Total Incident Actual Cost (HSITAC). If the Motor Vehicle Involved check box is not selected, this column has a value of 0.

• As If Estimated Cost Motor Vehicle

  This is the total of all estimated costs in another currency associated with an incident that has the Motor Vehicle Involved check box selected. When the incident has the Motor Vehicle Involved check box selected, this field is populated with the Total Incident Estimated Cost (HSITEC) converted to the As If Currency If the Motor Vehicle Involved check box is not selected, this column has a value of 0.

• As If Actual Cost Motor Vehicle

  This is the total of all actual costs in another currency associated with an incident that has the Motor Vehicle Involved check box selected. When the incident has the Motor Vehicle Involved check box selected, this field is populated with the Total Incident Actual Cost (HSITAC) converted to the As If Currency. If the Motor Vehicle Involved check box is not selected, this column has a value of 0.

• Estimated Cost Environment

  This is the total of all estimated costs associated with an incident that has the Environmental Impact check box selected. This is based on the Total Incident Estimated Cost (HSITEC). If the Environmental Impact check box is not selected, this column has a value of 0.

• Actual Cost Environment

  This is the total of all actual costs associated with an incident that has the Environmental Impact check box selected. This is based on the Total Incident Actual Cost (HSITAC). If the Environmental Impact check box is not selected, this column has a value of 0.

• As If Estimated Cost Environmental

  This is the total of all estimated costs in another currency associated with an incident that has the Environmental Impact check box selected. When the incident has the Environmental Impact check box selected, this field is populated with the Total Incident Estimated Cost (HSITEC) converted to the As If Currency. If the Environmental Impact check box is not selected, this column has a value of 0.

• As If Actual Cost Environmental

  This is the total of all actual costs in another currency associated with an incident that has the Environmental Impact check box selected. When the incident has the Environmental Impact check box selected, this field is populated with the Total Incident Actual Cost (HSITAC) converted to the As If Currency. If the Environmental Impact check box is not selected, this column has a value of 0.

• Estimated Cost Other

  This is the total of all estimated costs associated with an incident that has the Other check box selected. This is based on the Total Incident Estimated Cost (HSITEC). If the Other check box is not selected, this column has a value of 0.

• Actual Cost Other

  This is the total of all actual costs associated with an incident that has the Other check box selected. This is based on the Total Incident Actual Cost (HSITAC). If the Other check box is not selected, this column has a value of 0.

• As If Estimated Cost Other

  This is the total of all estimated costs in another currency associated with an incident that has the Other check box selected. When the incident has the Other check box selected, this field is populated with the Total Incident Estimated Cost (HSITEC) converted to the As If Currency. If the Other check box is not selected, this column has a value of 0.

• As If Actual Cost Other

  This is the total of all actual costs in another currency associated with an incident that has the Other check box selected. When the incident has the Other check box selected, this field is populated with the Total Incident Actual Cost (HSITAC) converted to the As If Currency. If the Other check box is not selected, this has a value of 0.

• Estimated Cost Potential

  This is the total of all estimated costs associated with an incident that has the Potential Incident check box selected. This is based on the Total Incident Estimated Cost (HSITEC). If the Potential Incident check box is not selected, this column has a value of 0.

• Actual Cost Potential

  This is the total of all actual costs associated with an incident that has the Potential Incident check box selected. This is based on the Total Incident Actual Cost (HSITAC). If the Potential Incident check box is not selected, this column has a value of 0.

• As If Estimated Cost Potential

  This is the total of all estimated costs in another currency associated with an incident that has the Potential Incident check box selected. When the incident has the Potential Incident check box selected, this field is populated with the Total Incident Estimated Cost (HSITEC) converted to the As If Currency. If the Potential Incident check box is not selected, this column has a value of 0.

• As If Actual Cost Potential

  This is the total of all actual costs in another currency associated with an incident that has the Potential Incident check box selected. When the incident has the Potential Incident check box selected, this field is populated with the Total Incident Actual Cost (HSITAC) converted to the As If Currency. If the Potential Incident check box is not selected, this column has a value of 0.

• Estimated Cost 3rd Party

  This is the total of all estimated costs associated with an incident that has the Contractor / 3rd Party Involved check box selected. This is based on the Total Incident Estimated Cost (HSITEC). If the Contractor / 3rd Party Involved check box is not selected, this column has a value of 0.

• Actual Cost 3rd Party

  This is the total of all actual costs associated with an incident that has the Contractor / 3rd Party Involved check box selected. This is based on the Total Incident Actual Cost (HSITAC). If the Contractor / 3rd Party Involved check box is not selected, this column has a value of 0.

• As If Estimated Cost 3rd Party

  This is the total of all estimated costs in another currency associated with an incident that has the Contractor / 3rd Party Involved check box selected. When the incident has the Contractor / 3rd Party check box selected, this field is populated with the Total Incident Estimated Cost (HSITEC) converted to the As If Currency. If the Contractor / 3rd Party Involved check box is not selected, this column has a value of 0.

• As If Actual Cost 3rd Party

  This is the total of all actual costs in another currency associated with an incident that has the Contractor / 3rd Party Involved check box selected. When the incident has the Contractor / 3rd Party Involved check box selected, this field is populated with the Total Incident Actual Cost (HSITAC) converted to the As If Currency. If the Contractor / 3rd Party Involved check box is not selected, this column has a value of 0.

• Estimated Cost Company

  This is the total of all estimated costs associated with an incident that has the Contractor / 3rd Party Involved check box not selected. This is based on the Total Incident Estimated Cost (HSITEC). If the Contractor / 3rd Party Involved check box is selected, this column has a value of 0.

• Actual Cost Company

  This is the total of all actual costs associated with an incident that has the Contractor / 3rd Party Involved check box not selected. This is based on the Total Incident Actual Cost (HSITAC). If the Contractor / 3rd Party Involved check box is selected, this column has a value of 0.

• As If Estimated Cost Company

  This is the total of all estimated costs in another currency associated with an incident that has the Contractor / 3rd Party check box not selected. When the incident has the Contractor / 3rd Party check box not selected, this field is populated with the Total Incident Estimated Cost (HSITEC) converted to the As If Currency. If the Contractor / 3rd Party check box is selected, this column has a value of 0.

• As If Actual Cost Company

  This is the total of all actual costs in another currency associated with an incident that has the Contractor / 3rd Party Involved check box not selected. When the incident has the Contractor / 3rd Party Involved check box not selected, this field is populated with the Total Incident Actual Cost (HSITAC) converted to the As If Currency. If the Contractor / 3rd Party Involved check box is selected, this column has a value of 0.

• As If Total Incident Estimated Cost

  This is the total estimated incident cost in another currency. This is the total of estimated cost based on the Total Estimated Incident Cost (HSITEC) converted to the As If Currency.

• As If Total Incident Actual Cost

  This is the total actual incident cost in another currency. This is the total of actual cost based on the Total Actual Incident Cost (HSITAC) converted to the As If Currency.

• Company Responsible

  This indicates 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.

• Contractor / 3rd Party Description

  This indicates 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.

• Formatted Incident Time and Formatted Incident Time Reported

  These two columns display the time formatted. The Query By Example (QBE) is not enabled in these columns. However, to facilitate searching and filtering these formatted time columns present the time in an easy to read format of hours, minutes and seconds.