Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ALUM DEGREE TYPE Table


This table contains information about the different degree types available in the ALUM DEGREE DETAIL table.


Field Name

Description

Data Type

Length

ALUM_DEGREE_TYPE_KEY

Use this field to join together the ALUM DEGREE DETAIL and the ALUM DEGREE TYPE tables.

VARCHAR2

6

DEGREE_CODE

Degree code.

VARCHAR2

5

DEGREE_DESCRIPTION

The full description of the degree.

VARCHAR2

40

DEGREE_LEVEL

In SUBJECT_AUDIT_DETAIL: 'U'=Undergraduate, 'G'=Graduate

VARCHAR2

40

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8