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

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.