DW_HNS_INCIDENT_RISK_ASSESSMENT_D (Preview)

This table requires activation of Health and Safety functional area. Table stores Health and Safety Incident Risk Assessment information

Details

Module: Workforce Health and Safety Incidents

Key Columns

RISK_ASSESSMENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RISK_ASSESSMENT_ID NUMBER 38 0 True Risk Assessment Identifier
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier
INCIDENT_ID NUMBER 38 0 Task Identifier Assigned to the Risk Assessment.
CONSEQUENCE_CODE VARCHAR2 32 Consequence Code
LIKELIHOOD_CODE VARCHAR2 32 Likelihood Code
RISK_ASSESSMENT_DATE TIMESTAMP Risk Assessment Date
DELETED_FLAG VARCHAR2 16 Flag to check whether is record is deleted