DW_HNS_INVESTIGATION_RECOMMEND_D (Preview)

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

Details

Module: Workforce Health and Safety Incidents

Key Columns

RECOMMEND_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RECOMMEND_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 RECOMMEND_ID    
FINDING_ID NUMBER 38 0   Investigation Finding Identifier. DW_HNS_INVESTIGATION_FINDING_D FINDING_ID
ACTION_FLAG VARCHAR2 16     This flag signifies whether there is an action associated with the recommendation.    
RECOMMENDATION_SUMMARY VARCHAR2 999     Recommendation summary.    
RECOMMENDATION_SUGGESTION_FLAG VARCHAR2 16     Recommendation suggestion flag for improvement.    
DELETED_FLAG VARCHAR2 16     This column signifies whether the investigation recommendation is checked for deletion.    

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