DW_HNS_INJURED_PERSON_SUMMARY_D (Preview)

This table requires activation of Health and Safety functional area. Table stores Health and Safety Injured Person Summary information

Details

Module: Workforce Health and Safety Incidents

Key Columns

INJURED_PERSON_SUMMARY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INJURED_PERSON_SUMMARY_ID NUMBER 38 0 True Injured Person Summary 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
HR_NOTIFIED_FLAG VARCHAR2 16 Human resources notified flag
DATE_TIME_NOTIFIED TIMESTAMP Date and Time the HR or Payroll team was notified
DELETED_FLAG VARCHAR2 16 Flag to check whether is record is deleted