This table requires activation of Health and Safety functional area. Table stores Health and Safety Injured Person Treatment information
Module: Workforce Health and Safety Incidents
INJURED_PERSON_TREATMENT_ID
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, 2024, Oracle and/or its affiliates.