Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LSO LOCATION Table


Session Locations as described in LSO module


Field Name

Description

Data Type

Length

LSO_LOCATION_CODE

XXX

VARCHAR2

8

LSO_LOCATION_KEY

XXX

VARCHAR2

10

ROOM

XXX

VARCHAR2

15

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

6

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8