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.