DW_HNS_INCIDENT_H (Preview)

This table requires activation of Health and Safety functional area. Health and Safety Incident Helper table

Details

Module: Workforce Health and Safety Incidents

Key Columns

INCIDENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INCIDENT_ID NUMBER 38 0 True Incident Identifier
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier
ERGONOMIC_EVT_DETAIL_ID NUMBER 38 0 Ergonomic Event Detail Identifier DW_HNS_ERGONOMIC_EVENT_D ERGONOMIC_EVT_DETAIL_ID
FIRE_INC_EVT_DETAIL_ID NUMBER 38 0 Fire Incident Event Detail Identifier DW_HNS_FIRE_INCIDENT_EVENT_D FIRE_INC_EVT_DETAIL_ID
AIR_QUALITY_EVT_DETAIL_ID NUMBER 38 0 Air Quality Event Detail Identifier DW_HNS_AIR_QUALITY_EVENT_D AIR_QUALITY_EVT_DETAIL_ID
ISSUE_EVT_DETAIL_ID NUMBER 38 0 Issue Event Detail Identifier DW_HNS_ISSUE_EVENT_DETAIL_D ISSUE_EVT_DETAIL_ID
NEAR_MISS_EVT_DETAIL_ID NUMBER 38 0 Near Miss Event Detail Identifier DW_HNS_NEAR_MISS_EVENT_D NEAR_MISS_EVT_DETAIL_ID
NOTICE_VIO_EVT_DETAIL_ID NUMBER 38 0 Notice Violation Event Detail Identifier DW_HNS_NOTICE_VIOLATION_EVENT_D NOTICE_VIO_EVT_DETAIL_ID
PROP_DAMAGE_EVT_DETAIL_ID NUMBER 38 0 Property Damage Event Detail Identifier DW_HNS_PROPERTY_DAMAGE_EVENT_D PROP_DAMAGE_EVT_DETAIL_ID
SPILL_REL_EVT_DETAIL_ID NUMBER 38 0 Spill Release Event Detail Identifier DW_HNS_SPILL_RELEASE_EVENT_D SPILL_REL_EVT_DETAIL_ID
SUGG_IMPROV_EVT_DETAIL_ID NUMBER 38 0 Suggestion Improvement Event Detail Identifier DW_HNS_SUGGESTION_IMPROV_EVENT_D SUGG_IMPROV_EVT_DETAIL_ID
UNSAFE_ACT_EVT_DETAIL_ID NUMBER 38 0 Unsafe Act Event Detail Identifier DW_HNS_UNSAFE_ACT_EVENT_D UNSAFE_ACT_EVT_DETAIL_ID
UNSAFE_COND_EVT_DETAIL_ID NUMBER 38 0 Unsafe Condition Event Detail Identifier DW_HNS_UNSAFE_CONDITION_EVENT_D UNSAFE_COND_EVT_DETAIL_ID
INJURED_PERSON_SUMMARY_ID NUMBER 38 0 Injured Person Summary Identifier DW_HNS_INJURED_PERSON_SUMMARY_D INJURED_PERSON_SUMMARY_ID