EHSS ROOM SET Table
View exposing ehss room set data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DLC_CODE |
Code identifying dlc. |
VARCHAR2 |
20 |
DLC_NAME |
Dlc name associated with the record. |
VARCHAR2 |
50 |
EHSS_ROOM_SET_KEY |
Surrogate key identifying the ehss room set. |
NUMBER |
20 |
EHS_REP_ALT_OFFICE_LOC |
Ehs rep alt office loc associated with the record. |
VARCHAR2 |
30 |
EHS_REP_ALT_OFFICE_PHONE |
Ehs rep alt office phone associated with the record. |
VARCHAR2 |
20 |
EHS_REP_EMAIL |
Ehs rep email associated with the record. |
VARCHAR2 |
60 |
EHS_REP_EMERGENCY_PHONE |
Ehs rep emergency phone associated with the record. |
VARCHAR2 |
14 |
EHS_REP_FULL_NAME |
Ehs rep full name associated with the record. |
VARCHAR2 |
100 |
EHS_REP_HOME_PHONE |
Ehs rep home phone associated with the record. |
VARCHAR2 |
20 |
EHS_REP_MIT_ID |
Business identifier for the ehs rep mit. |
VARCHAR2 |
9 |
EHS_REP_OFFICE_LOC |
Ehs rep office loc associated with the record. |
VARCHAR2 |
30 |
EHS_REP_OFFICE_PHONE |
Ehs rep office phone associated with the record. |
VARCHAR2 |
20 |
IS_INSPECTION_REQUIRED |
Indicator identifying whether inspection required (Y/N). |
VARCHAR2 |
1 |
PI_ALT_OFFICE_LOC |
Pi alt office loc associated with the record. |
VARCHAR2 |
30 |
PI_ALT_OFFICE_PHONE |
Pi alt office phone associated with the record. |
VARCHAR2 |
20 |
PI_EMAIL |
Pi email associated with the record. |
VARCHAR2 |
60 |
PI_EMERGENCY_PHONE |
Pi emergency phone associated with the record. |
VARCHAR2 |
14 |
PI_FULL_NAME |
Pi full name associated with the record. |
VARCHAR2 |
100 |
PI_HOME_PHONE |
Pi home phone associated with the record. |
VARCHAR2 |
20 |
PI_MIT_ID |
Business identifier for the pi mit. |
VARCHAR2 |
9 |
PI_OFFICE_LOC |
Pi office loc associated with the record. |
VARCHAR2 |
30 |
PI_OFFICE_PHONE |
Pi office phone associated with the record. |
VARCHAR2 |
20 |
PI_TITLE |
Pi title associated with the record. |
VARCHAR2 |
51 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
|
ROOM_SET_CREATE_DATE |
Date associated with room set create. |
DATE |
|
ROOM_SET_DESCRIPTION |
Description of room set. |
VARCHAR2 |
132 |
ROOM_SET_ID |
Business identifier for the room set. |
VARCHAR2 |
20 |
ROOM_SET_LAST_UPDATE_DATE |
Date associated with room set last update. |
DATE |
|
ROOM_SET_NAME |
Room set name associated with the record. |
VARCHAR2 |
60 |
ROOM_SET_SAP_STATUS |
Room set sap status associated with the record. |
VARCHAR2 |
30 |
ROOM_SET_STATUS |
Room set status associated with the record. |
VARCHAR2 |
30 |
SARA_REPORTER_ALT_OFFICE_LOC |
Sara reporter alt office loc associated with the record. |
VARCHAR2 |
30 |
SARA_REPORTER_ALT_OFFICE_PHONE |
Sara reporter alt office phone associated with the record. |
VARCHAR2 |
20 |
SARA_REPORTER_EMAIL |
Sara reporter email associated with the record. |
VARCHAR2 |
60 |
SARA_REPORTER_EMERGENCY_PHONE |
Sara reporter emergency phone associated with the record. |
VARCHAR2 |
14 |
SARA_REPORTER_FULL_NAME |
Sara reporter full name associated with the record. |
VARCHAR2 |
100 |
SARA_REPORTER_HOME_PHONE |
Sara reporter home phone associated with the record. |
VARCHAR2 |
20 |
SARA_REPORTER_MIT_ID |
Business identifier for the sara reporter mit. |
VARCHAR2 |
9 |
SARA_REPORTER_OFFICE_LOC |
Sara reporter office loc associated with the record. |
VARCHAR2 |
30 |
SARA_REPORTER_OFFICE_PHONE |
Sara reporter office phone associated with the record. |
VARCHAR2 |
20 |
SCHOOL_AREA_NAME |
School area name associated with the record. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |