Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ALUM DEPARTMENT Table


View exposing academic department reference data associated with alumni academic programs.


Field Name

Description

Data Type

Length

ALUM_DEPARTMENT_KEY

Surrogate key identifying the alum department.

VARCHAR2

16

DEPARTMENT_CODE

Code identifying department.

VARCHAR2

16

DEPARTMENT_DESCRIPTION

Description of department.

VARCHAR2

60

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE