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     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, 2023, Oracle and/or its affiliates.