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
| 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 |