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.    

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