DW_HNS_ERGONOMIC_EVENT_D (Preview)

This table requires activation of Health and Safety functional area. Table stores Health and Safety Ergonomic Event information

Details

Module: Workforce Health and Safety Incidents

Key Columns

ERGONOMIC_EVT_DETAIL_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ERGONOMIC_EVT_DETAIL_ID NUMBER 38 0 True Ergonomic Event Detail Identifier
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier
INCIDENT_DETAIL_ID NUMBER 38 0 Incident Detail identifier
ERGONOMIC_TYPE_CODE VARCHAR2 32 Ergonomic Type code
ERGONOMIC_ASSESSMENT_RQST_CODE VARCHAR2 16 Request an Ergonomic Assessment
DELETED_FLAG VARCHAR2 16 Deleted flag.This column signifies whether the incident event is checked for deletion