This table requires activation of Health and Safety functional area. Health and Safety Incident Helper table
Module: Workforce Health and Safety Incidents
INCIDENT_ID
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.