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

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