Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ALUM MAJOR Table


View exposing academic major reference data associated with alumni academic records.


Field Name

Description

Data Type

Length

ALUM_MAJOR_KEY

Surrogate key identifying the alum major.

VARCHAR2

6

MAJOR_CODE

Code identifying major.

VARCHAR2

6

MAJOR_DESCRIPTION

Description of major.

VARCHAR2

40

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE