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    

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