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

100

BUILDING_NUMBER

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

VARCHAR2

30

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