DW_HNS_INCIDENT_EVENT_EF (Preview)

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

Details

Module: Workforce Health and Safety Incidents

Key Columns

INCIDENT_DETAIL_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INCIDENT_DETAIL_ID NUMBER 38 0 True Incident Detail Identifier    
SOURCE_RECORD_ID VARCHAR2 256     Unique Source Record Identifier which in this case is nothing but Incident Detail Identifier    
INCIDENT_ID NUMBER 38 0   Incident identifier    
PERSON_ID NUMBER 38 0   Person Identifier of the Employee. DW_PERSON_D PERSON_ID
ASSIGNMENT_ID NUMBER 38 0   Assignment ID of the Employee.    
INCIDENT_EVENT_NUMBER VARCHAR2 64     Incident Event Number    
INCIDENT_EVENT_SUMMARY VARCHAR2 999     The Summary information entered by the reporter for each incident event.    
INCIDENT_EVENT_DATE DATE       Date incident event was reported.    
INCIDENT_EVENT_DATE_TIME TIMESTAMP       Date time incident event was reported.    
INCIDENT_EVENT_STATUS_CODE VARCHAR2 32     Current Incident Event Status.    
TARGET_COMPLETION_DATE TIMESTAMP       Target completion date set for each incident event.    
ACTUAL_COMPLETION_DATE TIMESTAMP       Actual Completion date set per incident event.    
INCIDENT_EVNT_OWNR_PERSON_ID NUMBER 38 0   Owner Person Identifier for an Incident Event. Owner is an employee. DW_PERSON_D PERSON_ID
INCIDENT_EVNT_OWNR_ASSIGNMENT_ID NUMBER 38 0   Assignment Id of the incident event owner.    
COMPLETED_FLAG VARCHAR2 16     Incident event completed flag. This signifies if the incident event is completed.    
SEVERITY_LEVEL_CODE VARCHAR2 32     Severity level set per incident event.    
EVENT_CREATION_DATE TIMESTAMP       The date incident event was created in the system.    
LESSONS_LEARNED VARCHAR2 999     Lessons Learned.    
ACTION_REQUIRED_FLAG VARCHAR2 16     Check box to confirm whether an action is required.    
DATE_DISCLOSED TIMESTAMP       Date employee notified the organization about the event.    
INCIDENT_EVENT_CODE VARCHAR2 32     Incident Event Code    
ERGONOMIC_EVT_DETAIL_ID NUMBER 38 0   Ergonomic Event Detail Identifier    
FIRE_INC_EVT_DETAIL_ID NUMBER 38 0   Fire Incident Event Detail Identifier    
AIR_QUALITY_EVT_DETAIL_ID NUMBER 38 0   Air Quality Event Detail Identifier    
ISSUE_EVT_DETAIL_ID NUMBER 38 0   Issue Event Detail Identifier    
NEAR_MISS_EVT_DETAIL_ID NUMBER 38 0   Near Miss Event Detail Identifier    
NOTICE_VIO_EVT_DETAIL_ID NUMBER 38 0   Notice Violation Event Detail Identifier    
PROP_DAMAGE_EVT_DETAIL_ID NUMBER 38 0   Property Damage Event Detail Identifier    
SPILL_REL_EVT_DETAIL_ID NUMBER 38 0   Spill Release Event Detail Identifier    
SUGG_IMPROV_EVT_DETAIL_ID NUMBER 38 0   Suggestion Improvement Event Detail Identifier    
UNSAFE_ACT_EVT_DETAIL_ID NUMBER 38 0   Unsafe Act Event Detail Identifier    
UNSAFE_COND_EVT_DETAIL_ID NUMBER 38 0   Unsafe Condition Event Detail Identifier    
INJURED_PERSON_SUMMARY_ID NUMBER 38 0   Injured Person Summary Identifier    
DELETED_FLAG VARCHAR2 16     This column signifies whether the incident event is checked for deletion.    

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