Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LSO BUILDING Table


Buildings in LSO system (SAP)


Field Name

Description

Data Type

Length

BUILDING_NAME

The official MIT name given to a building. For example: Weisner Building, Horace Sayford Ford Building

VARCHAR2

64

BUILDING_NUMBER

The official MIT number given to a building. For example: N42, E19, W89

VARCHAR2

6

LSO_BUILDING_CODE

XXX

VARCHAR2

8

LSO_BUILDING_KEY

XXX

VARCHAR2

10

WAREHOUSE_LOAD_DATE

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

DATE

8