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 This column is for Oracle Internal use only. 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.
CREATION_DATE TIMESTAMP Indicates the date and time of the creation of the row.