DW_HNS_INVESTIGATION_F (Preview)

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

Details

Module: Workforce Health and Safety Incidents

Key Columns

INVESTIGATE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INVESTIGATE_ID NUMBER 38 0 True System generated primary key column.
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. Unique Source Record Identifier with investigate_id
INVESTIGATE_NUMBER VARCHAR2 64 Unique user generated Investigation Identifier.
INVESTIGATE_DATE DATE The date the investigation was initiated by the investigation owner.
INVESTIGATE_DATE_TIME TIMESTAMP The date time the investigation was initiated by the investigation owner.
INCIDENT_ID NUMBER 38 0 Incident Summary Identifier
INCIDENT_DETAIL_ID NUMBER 38 0 Incident Event Identifier
INVESTIGATE_SUMMARY VARCHAR2 999 The user entered summary on the investigation.
INVESTIGATE_TYPE_CODE VARCHAR2 32 Type of investigation. This signifies the level of investigation. Low level, high level.
INVESTIGATE_OWNER_PERSON_ID NUMBER The employee Identifier of ther person who owns the investigation. DW_PERSON_D PERSON_ID
INVESTIGATE_OWNER_ASSIGNMENT_ID NUMBER The Assignment Identifier of ther person who owns the investigation.
ACTION_REQUIRED_FLAG VARCHAR2 16 Check box to confirm whether an action is required.
COMPLETED_FLAG VARCHAR2 16 Signifies whether Investigation is completed
INVESTIGATE_STATUS_CODE VARCHAR2 32 Current Investigation Status
TARGET_COMPLETION_DATE DATE Target Completion date for an investigation.
ACTUAL_COMPLETION_DATE DATE Actual completion date for an investigation
LESSONS_LEARNED VARCHAR2 999 Lessons Learned.
FINDING_COMMENT VARCHAR2 999 User entered finding comments.
FINDING_FINAL_RESPONSE VARCHAR2 999 User entered finding final response.
CASUAL_FACTORS_CODE VARCHAR2 999 Casual Factors Code
CASUAL_FACTORS_CODE1 VARCHAR2 999 Casual Factors Code1
CASUAL_FACTORS_CODE2 VARCHAR2 999 Casual Factors Code2
CASUAL_FACTORS_CODE3 VARCHAR2 999 Casual Factors Code3
CONTRIBUTING_FACTORS_CODE VARCHAR2 999 Contributions Factors Code
CONTRIBUTING_FACTORS_CODE1 VARCHAR2 999 Contributions Factors Code1
CONTRIBUTING_FACTORS_CODE2 VARCHAR2 999 Contributions Factors Code2
CONTRIBUTING_FACTORS_CODE3 VARCHAR2 999 Contributions Factors Code3
UNDERLYING_FACTORS_CODE VARCHAR2 999 Underlying Factors Code
UNDERLYING_FACTORS_CODE1 VARCHAR2 999 Underlying Factors Code1
UNDERLYING_FACTORS_CODE2 VARCHAR2 999 Underlying Factors Code2
UNDERLYING_FACTORS_CODE3 VARCHAR2 999 Underlying Factors Code3
IMMEDIATE_CAUSE_CODE VARCHAR2 999 Immediate Cause Code
IMMEDIATE_CAUSE_CODE1 VARCHAR2 999 Immediate Cause Code1
IMMEDIATE_CAUSE_CODE2 VARCHAR2 999 Immediate Cause Code2
IMMEDIATE_CAUSE_CODE3 VARCHAR2 999 Immediate Cause Code3
ROOT_CAUSE_CODE VARCHAR2 999 Root Cause Code
ROOT_CAUSE_CODE1 VARCHAR2 999 Root Cause Code1
ROOT_CAUSE_CODE2 VARCHAR2 999 Root Cause Code2
ROOT_CAUSE_CODE3 VARCHAR2 999 Root Cause Code3
DELETED_FLAG VARCHAR2 16 Signifies whether investigation is deleted.
CREATION_DATE TIMESTAMP Indicates the date and time of the creation of the row.