EHSI HEADER NEW 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 |
60 |
EHSI_HEADER_KEY |
XXX |
NUMBER |
20 |
EHSI_ROOM_SET_KEY |
XXX |
NUMBER |
20 |
EHS_REP_EMAIL |
The email address of the primary EHS Representative for the room ser. |
VARCHAR2 |
100 |
EHS_REP_FULL_NAME |
The full name of the primary EHS Representative for the room set. |
VARCHAR2 |
100 |
EHS_REP_MIT_ID |
XXX |
VARCHAR2 |
9 |
INSPECTION_CYCLE |
XXX |
VARCHAR2 |
100 |
INSPECTION_DATE |
XXX |
DATE |
|
INSPECTION_DESCRIPTION |
XXX |
VARCHAR2 |
60 |
INSPECTION_ID |
XXX |
NUMBER |
20 |
INSPECTION_OVERALL_RATING |
XXX |
VARCHAR2 |
30 |
INSPECTION_STATUS |
XXX |
VARCHAR2 |
30 |
INSPECTION_TYPE |
XXX |
VARCHAR2 |
150 |
INSPECTION_TYPE_ID |
XXX |
NUMBER |
10 |
INSP_HEADER_CREATE_DATE |
XXX |
DATE |
|
INSP_HEADER_CREATE_USER |
XXX |
VARCHAR2 |
12 |
INSP_LAST_UPDATE_DATE |
XXX |
DATE |
|
INSP_LAST_UPDATE_USER |
XXX |
VARCHAR2 |
12 |
IS_FOLLOW_UP_REQUIRED |
XXX |
VARCHAR2 |
1 |
PI_EMAIL |
XXX |
VARCHAR2 |
100 |
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_MIT_ID |
XXX |
VARCHAR2 |
9 |
PI_TITLE |
XXX |
VARCHAR2 |
100 |
REPORT_SUBMISSION_DATE |
XXX |
DATE |
|
ROOM_SET_NAME |
XXX |
VARCHAR2 |
60 |
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 |