EHS ROOM Table
View exposing room records used in Environment, Health, and Safety compliance tracking, including rooms associated with hazards, training requirements, and oversight responsibilities.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BUILDING_ROOM_NUMBER |
Building room number associated with the record. |
VARCHAR2 |
16 |
CHILD_ROOM_COUNT |
Child room count associated with the record. |
NUMBER |
5 |
EHS_BUILDING_NAME |
Ehs building name associated with the record. |
VARCHAR2 |
64 |
EHS_BUILDING_NUMBER |
Ehs building number associated with the record. |
VARCHAR2 |
8 |
EHS_ROOM_AREA |
Ehs room area associated with the record. |
NUMBER |
13,2 |
EHS_ROOM_FLOOR |
Ehs room floor associated with the record. |
VARCHAR2 |
4 |
EHS_ROOM_KEY |
Surrogate key identifying the ehs room. |
VARCHAR2 |
16 |
EHS_ROOM_USAGE |
Ehs room usage associated with the record. |
VARCHAR2 |
16 |
IS_SUBROOM |
Indicator identifying whether subroom (Y/N). |
VARCHAR2 |
1 |
PARENT_ROOM |
Parent room associated with the record. |
VARCHAR2 |
16 |
ROOM_STATUS |
Room status associated with the record. |
VARCHAR2 |
1 |
SPACE_UNIT_CODE |
Code identifying space unit. |
VARCHAR2 |
6 |
SUBROOM_DESCRIPTION |
Description of subroom. |
VARCHAR2 |
1000 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |