DW_HNS_INJURED_PERSON_PART_D (Preview)
This table requires activation of Health and Safety functional area. Table stores Health and Safety Injured Person Body Part information
Details
Module: Workforce Health and Safety Incidents
Key Columns
INJURED_PERSON_PART_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| INJURED_PERSON_PART_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 INJURED_PERSON_PART_ID | ||||
| INJURED_PERSON_ID | NUMBER | 38 | 0 | Injured person identifier. | |||
| INJURED_PART_CODE | VARCHAR2 | 32 | Injured person part identifer. | ||||
| INJURY_NATURE_CODE | VARCHAR2 | 999 | The nature of injury. | ||||
| INJURY_NATURE_CODE1 | VARCHAR2 | 999 | The nature of injury 1. | ||||
| INJURY_NATURE_CODE2 | VARCHAR2 | 999 | The nature of injury 2. | ||||
| INJURY_NATURE_CODE3 | VARCHAR2 | 999 | The nature of injury 3. | ||||
| DELETED_FLAG | VARCHAR2 | 16 | Flag to check whether is record is deleted. |