Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ALUM DEPARTMENT Table


This table contains information about MIT academic departments as used in the Alumni's system.


Field Name

Description

Data Type

Length

ALUM_DEPARTMENT_KEY

Use this field to join together the ALUM_DEPARTMENT table with another Alumni fact table that contains this field to get more information about the department.

VARCHAR2

7

DEPARTMENT_CODE

Code identifying an academic department, eg. 18 for "Mathematics", 6 for "Electrical Eng & Computer Sci". In the Alumni's tables, the department codes used are different from those used in MITSIS.

VARCHAR2

4

DEPARTMENT_DESCRIPTION

Descriptive text for DEPARTMENT_CODE.

VARCHAR2

50

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8