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

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