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     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

Copyright © 2019, 2023, Oracle and/or its affiliates.