EHS ROOM SET DETAIL Table
EHS room_set ->room->hazard->function->role-person detail information
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EHS_FUNCTION_KEY |
The internal key for a function within a Room Set. Use this for joining with ehs_function and detail tables. |
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_PERSON_KEY |
The internal key for a person who performs a given function within a Room Set. Use this for joining with person-related fields in the ehs_room_set_detail and ehs_room_set_contact_detail tables. |
VARCHAR2 |
8 |
EHS_ROOM_KEY |
The internal key for a room within a building. Use this key for joining ehs_room, ehs_room_set, ehs_room_set_detail and ehs_room_set_contact_detail tables. |
VARCHAR2 |
16 |
EHS_ROOM_SET_KEY |
Internal key for a room set. Join to ehs_room, ehs_room_set_detail and ehs_room_set_contact_detail tables. A room is a set of rooms with a supervisor, an EHS representative, some contact people, and some hazard types. |
NUMBER |
12 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |