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 |