EHS ROOM SET Table
List of EHS ROOMS (LABS)
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DLC_CODE |
The code for the DLC associated with this room set, e.g., D_BIOLOGY. |
VARCHAR2 |
15 |
DLC_NAME |
The name of the DLC associated with this room set. |
VARCHAR2 |
50 |
EHS_REP_EMAIL |
The email address of the primary EHS Representative for the room ser. |
VARCHAR2 |
60 |
EHS_REP_FULL_NAME |
The full name of the primary EHS Representative for the room set. |
VARCHAR2 |
100 |
EHS_REP_KERBNAME |
The Kerberos username of the primary EHS Representative for the room set. |
VARCHAR2 |
8 |
EHS_REP_PRIM_OFFICE_LOC |
The building-room number of the primary office location of the primary EHS Representative for the room set. |
VARCHAR2 |
30 |
EHS_REP_PRIM_OFFICE_PHONE |
The primary office phone number of the primary EHS Representative for the room set. |
VARCHAR2 |
20 |
EHS_REP_SECND_OFFICE_LOC |
The building-room number of the secondary office location of the primary EHS Representative for the room set. |
VARCHAR2 |
30 |
EHS_REP_SECND_OFFICE_PHONE |
The secondary office phone number of the primary EHS Representative for the room set. |
VARCHAR2 |
20 |
EHS_ROOM_SET_CODE |
The short code number used to identify a room set. |
VARCHAR2 |
15 |
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 |
EHS_ROOM_SET_MODIFIED_BY |
The Kerberos username of the person who last modified date for this room set. |
VARCHAR2 |
8 |
EHS_ROOM_SET_MODIFIED_DATE |
The date on which data for this room set was last modified. |
DATE |
8 |
EHS_ROOM_SET_NAME |
The name of a room set, set by the DLC to help them identify the room set. |
VARCHAR2 |
50 |
EHS_ROOM_SET_NOTES |
Optional notes about this room set. |
VARCHAR2 |
1000 |
EHS_ROOM_SET_TYPE |
A code for a type of room set. |
NUMBER |
22 |
EHS_ROOM_SET_TYPE_NAME |
A short description of the type of room set. |
VARCHAR2 |
100 |
GROUP_WITHIN_DEPT |
The group within a DLC in which the room set is included. DLCs choose how to organize room sets into groups. |
VARCHAR2 |
15 |
SCHOOL_AREA_CODE |
The school or area code associated with the DLC, e.g., D_SCHOOL_SCI. |
VARCHAR2 |
15 |
SCHOOL_AREA_NAME |
The name of the school or area associated with the DLC. |
VARCHAR2 |
50 |
SHOW_HOME_PHONES_GREENCARD |
IF 'Y', then home phone numbers for contact people within this room set are shown on the green card. If 'N', the home phone numbers are not shown on the green card. |
VARCHAR2 |
1 |
SUPERVISOR_EMAIL |
The email address of the primary supervisor of the roomset. |
VARCHAR2 |
60 |
SUPERVISOR_FULL_NAME |
The full name of the primary supervisor for the room set. |
VARCHAR2 |
100 |
SUPERVISOR_KERBNAME |
The Kerberos username of the primary supervisor for the room set. |
VARCHAR2 |
8 |
SUPERVISOR_PRIM_OFFICE_LOC |
The primary office building-room number of the supervisor for the room set. |
VARCHAR2 |
30 |
SUPERVISOR_PRIM_OFFICE_PHONE |
The primary office phone number of the supervisor for the room set. |
VARCHAR2 |
20 |
SUPERVISOR_SECND_OFFICE_LOC |
The secondary office building-room number of the supervisor for the room set. |
VARCHAR2 |
30 |
SUPERVISOR_SECND_OFFICE_PHONE |
The secondary office phone number of the supervisor for the room set. |
VARCHAR2 |
20 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |