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.