ALUM DEGREE DETAIL Table
This table contains degree information of MIT Alumni.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALUM_BIOGRAPHIC_KEY |
Use this field to join together the ALUM_BIOGRAPHIC table to another Alumni fact table with this field to get specific information about a person. |
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 |
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 |
ALUM_INSTITUTION_KEY |
XXX |
VARCHAR2 |
8 |
ALUM_MAJOR_KEY |
Use this field to join together the ALUM_MAJOR table with another Alumni fact table that contains this field to get more information about the courses of major of a person. |
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 |
Numerical value identifying the position of this record for the person. |
NUMBER |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |