DW_HNS_INVESTIGATION_FINDING_D (Preview)

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

Details

Module: Workforce Health and Safety Incidents

Key Columns

FINDING_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
FINDING_ID NUMBER 38 0 True Finding Identifier
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier
INVESTIGATE_ID NUMBER 38 0 Investigate Identifier
SEVERITY_LEVEL_CODE VARCHAR2 32 Severity Level Code
FINDING_ISSUE_FLAG VARCHAR2 16 Issue flag. Signifies whether there was a issue for the finding.
FINDING_SUMMARY VARCHAR2 999 User entered Summary for the finding.
FINDING_NOTES VARCHAR2 999 User entered finding notes.
FINDING_RESPONSE VARCHAR2 999 User entered finding response.
DELETED_FLAG VARCHAR2 16 Deleted flag.This column signifies whether the Investigation finding is checked for deletion.