This table requires activation of Health and Safety functional area. Table stores Health and Safety Injured Person Body Part information
Module: Workforce Health and Safety Incidents
INJURED_PERSON_PART_ID
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 | 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. |
Copyright © 2019, 2023, Oracle and/or its affiliates.