Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ALUM INSTITUTION Table


View exposing institutional reference data associated with alumni education or employment records.


Field Name

Description

Data Type

Length

ALUM_INSTITUTION_KEY

Surrogate key identifying the alum institution.

VARCHAR2

14

INSTITUTION_CODE

Code identifying institution.

VARCHAR2

10

INSTITUTION_NAME

Institution name as provided by the source.

VARCHAR2

100

SCHOOL

School as provided by the source.

VARCHAR2

40

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE