EHS HAZARD Table
EHS information about hazards
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EHS_HAZARD_GROUP_NAME |
The name of the group of hazards of which this hazard type is a member. |
VARCHAR2 |
50 |
EHS_HAZARD_GROUP_SORT |
Sort order of the hazard groups within groups. |
NUMBER |
22 |
EHS_HAZARD_KEY |
The internal key of a hazard type. A hazard type is a material, type of equipment, or activity, that has regulatory or training requirements. Use this field for joining with ehs_hazard, ehs_room_set_detail and ehs_room_set_contact_detail tables. |
NUMBER |
12 |
EHS_HAZARD_NAME |
The name of a hazard type. |
VARCHAR2 |
50 |
EHS_HAZARD_SORT |
The sort order of a hazard type within a hazard group. |
NUMBER |
22 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |