Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse TEM BUILDING Table


View exposing TEM building reference data including building code, building number, building name, and warehouse load date.


Field Name

Description

Data Type

Length

BUILDING_NAME

Building name associated with the record.

VARCHAR2

100

BUILDING_NUMBER

Building number associated with the record.

VARCHAR2

30

TEM_BUILDING_CODE

Code identifying tem building.

VARCHAR2

8

TEM_BUILDING_KEY

Surrogate key identifying the tem building.

VARCHAR2

10

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE