SPACE ROOM Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CLASSIFICATION_CODE |
XXX |
VARCHAR2 |
50 |
DLC_KEY |
a unigue key to enable joining information stored with other forms of Department Key |
VARCHAR2 |
50 |
LAST_UPDATE_BY |
XXX |
VARCHAR2 |
8 |
LAST_UPDATE_TIME |
XXX |
DATE |
|
ROOM_NUMBER |
The identification/location number of a room on a floor of a building. For example: room E19-332B is on the third floor of building E19. Explanation: The characters before the hyphen always indicate the MIT building number; the room number follows the hyphen, and the initial digit(s) indicate the floor of the building. |
VARCHAR2 |
25 |
USER_FIELD_1 |
XXX |
VARCHAR2 |
50 |
USER_FIELD_2 |
XXX |
VARCHAR2 |
50 |
USER_FIELD_3 |
XXX |
VARCHAR2 |
50 |
USER_FIELD_4 |
XXX |
VARCHAR2 |
50 |
USER_FIELD_5 |
XXX |
VARCHAR2 |
350 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |