Model: Incident Analysis - Specifications for Dimension Table: INCIDENT ANALYSIS
Attributes
| Attribute |
Description (where applicable) |
| Incident Case No | The ID of the incident. This is a reference number for the incident. |
| Incident Case Reference No | A reference name to identify the Incident. |
| Incident Class | The classification of the incident. Possible values are predefined. |
| Incident Date | The date at which the incident occurred. |
| Incident Severity Level | The severity of the incident. E.g. Fatal, major or minor. |
| Incident Type | The value indicates the type of incident. Possible values are predefined |
| Injury/ Illness Reference No | Reference No for the Injury/ Illness |
| Injury/ Illness Status | The status which identifies whether the injury and illness details registered for the employee have been confirmed. |
| Loss of Consciousness | Indicator whether the person has lost consciousness because of the incident. |
| Medical Treatment | Obtained medical treatment for the injury or illness. |
| Personnel Incident Type | The type of personnel incident. |
| Personnel Injury/ Illness Status Description | The status which identifies whether the injury and illness details registered for the employee have been confirmed. |
| Project ID | The ID of the delivery project relevant to this incident. |
| Reportable to External Body | If Yes, the incident should be reported to an external regulatory body. |
| Severity Level | The severity of the injury/illness |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| INCIDENT ANALYSIS | FACT_INCIDENT_CASE_TM | FACT_INCIDENT_CASE_BI | FACT_INCIDENT_CASE | On Line |