EHSS ROOM SET Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DLC_CODE |
The code for the DLC associated with this room set, e.g., D_BIOLOGY. |
VARCHAR2 |
20 |
DLC_NAME |
The name of the DLC associated with this room set. |
VARCHAR2 |
50 |
EHSS_ROOM_SET_KEY |
XXX |
NUMBER |
20 |
EHS_REP_ALT_OFFICE_LOC |
XXX |
VARCHAR2 |
30 |
EHS_REP_ALT_OFFICE_PHONE |
XXX |
VARCHAR2 |
20 |
EHS_REP_EMAIL |
The email address of the primary EHS Representative for the room ser. |
VARCHAR2 |
60 |
EHS_REP_EMERGENCY_PHONE |
XXX |
VARCHAR2 |
14 |
EHS_REP_FULL_NAME |
The full name of the primary EHS Representative for the room set. |
VARCHAR2 |
100 |
EHS_REP_HOME_PHONE |
XXX |
VARCHAR2 |
20 |
EHS_REP_MIT_ID |
XXX |
VARCHAR2 |
9 |
EHS_REP_OFFICE_LOC |
XXX |
VARCHAR2 |
30 |
EHS_REP_OFFICE_PHONE |
XXX |
VARCHAR2 |
20 |
IS_INSPECTION_REQUIRED |
XXX |
VARCHAR2 |
1 |
PI_ALT_OFFICE_LOC |
XXX |
VARCHAR2 |
30 |
PI_ALT_OFFICE_PHONE |
XXX |
VARCHAR2 |
20 |
PI_EMAIL |
XXX |
VARCHAR2 |
60 |
PI_EMERGENCY_PHONE |
XXX |
VARCHAR2 |
14 |
PI_FULL_NAME |
The full name of the PI or supervisor. This is all upper-case, in the format "LAST-NAME, FIRST-NAME OPTIONAL MIDDLE-NAME". |
VARCHAR2 |
100 |
PI_HOME_PHONE |
XXX |
VARCHAR2 |
20 |
PI_MIT_ID |
XXX |
VARCHAR2 |
9 |
PI_OFFICE_LOC |
XXX |
VARCHAR2 |
30 |
PI_OFFICE_PHONE |
XXX |
VARCHAR2 |
20 |
PI_TITLE |
XXX |
VARCHAR2 |
51 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
|
ROOM_SET_CREATE_DATE |
XXX |
DATE |
|
ROOM_SET_DESCRIPTION |
XXX |
VARCHAR2 |
132 |
ROOM_SET_ID |
XXX |
VARCHAR2 |
20 |
ROOM_SET_LAST_UPDATE_DATE |
XXX |
DATE |
|
ROOM_SET_NAME |
XXX |
VARCHAR2 |
60 |
ROOM_SET_SAP_STATUS |
XXX |
VARCHAR2 |
30 |
ROOM_SET_STATUS |
XXX |
VARCHAR2 |
30 |
SARA_REPORTER_ALT_OFFICE_LOC |
XXX |
VARCHAR2 |
30 |
SARA_REPORTER_ALT_OFFICE_PHONE |
XXX |
VARCHAR2 |
20 |
SARA_REPORTER_EMAIL |
XXX |
VARCHAR2 |
60 |
SARA_REPORTER_EMERGENCY_PHONE |
XXX |
VARCHAR2 |
14 |
SARA_REPORTER_FULL_NAME |
XXX |
VARCHAR2 |
100 |
SARA_REPORTER_HOME_PHONE |
XXX |
VARCHAR2 |
20 |
SARA_REPORTER_MIT_ID |
XXX |
VARCHAR2 |
9 |
SARA_REPORTER_OFFICE_LOC |
XXX |
VARCHAR2 |
30 |
SARA_REPORTER_OFFICE_PHONE |
XXX |
VARCHAR2 |
20 |
SCHOOL_AREA_NAME |
The name of the school or area associated with the DLC. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |