# DW_HNS_INJURED_PERSON_TREATMENT_D (Preview)

This table requires activation of Health and Safety functional area. Table stores Health and Safety Injured Person Treatment information

## Details

Module: Workforce Health and Safety Incidents

## Key Columns

INJURED_PERSON_TREATMENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
INJURED_PERSON_TREATMENT_ID | NUMBER | 38 | 0 | True | Injured person treatment identifer. |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Unique Source Record Identifier with NEAR_MISS_EVT_DETAIL_ID |  |
INJURED_PERSON_ID | NUMBER | 38 | 0 |  | Injured person identifier. |  |
TREATMENT_TYPE_CODE | VARCHAR2 | 999 |  |  | Injured person treatment identifer. |  |
TREATMENT_TYPE_CODE1 | VARCHAR2 | 999 |  |  | Injured person treatment identifer 1. |  |
TREATMENT_TYPE_CODE2 | VARCHAR2 | 999 |  |  | Injured person treatment identifer 2. |  |
TREATMENT_TYPE_CODE3 | VARCHAR2 | 999 |  |  | Injured person treatment identifer 3. |  |
MEDICAL_PROFESSIONAL_NAME | VARCHAR2 | 256 |  |  | Name of the physician or medical professional treating the injury |  |
DESCRIPTION_OF_TREATMENT | VARCHAR2 | 999 |  |  | Description of the treatment of the injury |  |
FACILITY_NAME | VARCHAR2 | 256 |  |  | Name of the facility where injury is treated |  |
FACILITY_ADDRESS_LINE1 | VARCHAR2 | 256 |  |  | Address line 1 of the facility where injury is treated |  |
FACILITY_ADDRESS_LINE2 | VARCHAR2 | 256 |  |  | Address line 2 of the facility where injury is treated |  |
FACILITY_CITY | VARCHAR2 | 128 |  |  | City of the facility where injury is treated |  |
FACILITY_STATE | VARCHAR2 | 128 |  |  | State of the facility where injury is treated |  |
FACILITY_COUNTRY | VARCHAR2 | 128 |  |  | Country of the facility where injury is treated |  |
FACILITY_ZIP_CODE | VARCHAR2 | 128 |  |  | Zip Code of the facility where injury is treated |  |
DELETED_FLAG | VARCHAR2 | 16 |  |  | Flag to check whether is record is deleted. |  |

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