ALUM DEGREE DETAIL Table

This table contains degree information of MIT Alumni.

Field Name	Description	Data Type	Length
ALUM_BIOGRAPHIC_KEY	XXX	VARCHAR2	10
ALUM_DEGREE_TYPE_KEY	Use this field to join together the ALUM DEGREE DETAIL and the ALUM DEGREE TYPE tables.	VARCHAR2	6
ALUM_DEPARTMENT_KEY	XXX	VARCHAR2	7
ALUM_INSTITUTION_KEY	XXX	VARCHAR2	8
ALUM_MAJOR_KEY	XXX	VARCHAR2	6
DEGREE_ADDED_DATE	The date when this degree record was added to the source system.	DATE	8
DEGREE_MODIFIED_DATE	The date when the degree information was last modified.	DATE	8
DEGREE_YEAR	The academic year in which a degree is awarded.	VARCHAR2	4
SEQUENCE_NUMBER	XXX	NUMBER	22
WAREHOUSE_LOAD_DATE	The date the record was loaded into the Data Warehouse from the source system.	DATE	8