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	XXX	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