EHS ROOM Table
EHS Room information
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BUILDING_ROOM_NUMBER |
A building and room number in the form building-room. |
VARCHAR2 |
16 |
CHILD_ROOM_COUNT |
For parent rooms which have been divided into subrooms, this counts the number of subrooms. |
NUMBER |
22 |
EHS_BUILDING_NAME |
The name of the building associated with the room or subroom. |
VARCHAR2 |
64 |
EHS_BUILDING_NUMBER |
The building number of the room. |
VARCHAR2 |
8 |
EHS_ROOM_AREA |
The number of square feet of the room. |
NUMBER |
22 |
EHS_ROOM_FLOOR |
The floor on which the room is found. |
VARCHAR2 |
3 |
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_USAGE |
The room usage, according to the Department of Facilities system. |
VARCHAR2 |
16 |
IS_SUBROOM |
'N' means that this is a room from the Department of Facilities system. 'Y' means this is a subroom, defined by a DLC, to subdivide a room. |
VARCHAR2 |
1 |
PARENT_ROOM |
For subrooms, this field contains the building-room number of the parent room. |
VARCHAR2 |
16 |
ROOM_STATUS |
Normally this is 'A', meaning it is active. If a room has been undefined within the Department of Facilities system, but is still isted under a room set in the EHS Labs Database, then this field will be 'I', meaning inactive. |
VARCHAR2 |
1 |
SPACE_UNIT_CODE |
The 6-digit HR unit code of the organizational unit that owns the room, according to the Department of Facilities. |
VARCHAR2 |
6 |
SUBROOM_DESCRIPTION |
For subrooms, this contains freeform text describing the subroom. |
VARCHAR2 |
1000 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |