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 |