ALUM DEGREE DETAIL Table
View exposing alumni degree records including degree attributes associated with MIT academic programs.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALUM_BIOGRAPHIC_KEY |
Surrogate key identifying the alum biographic. |
VARCHAR2 |
10 |
ALUM_DEGREE_TYPE_KEY |
Surrogate key identifying the alum degree type. |
VARCHAR2 |
6 |
ALUM_DEPARTMENT_KEY |
Surrogate key identifying the alum department. |
VARCHAR2 |
7 |
ALUM_INSTITUTION_KEY |
Surrogate key identifying the alum institution. |
VARCHAR2 |
14 |
ALUM_MAJOR_KEY |
Surrogate key identifying the alum major. |
VARCHAR2 |
12 |
DEGREE_ADDED_DATE |
Date associated with degree added. |
DATE |
|
DEGREE_MODIFIED_DATE |
Date associated with degree modified. |
DATE |
|
DEGREE_YEAR |
Degree year as provided by the source. |
VARCHAR2 |
4 |
SEQUENCE_NUMBER |
Sequence number as provided by the source. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |