Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse STUDENT DEGREE PROGRAM Table


Student degree information including degree code, degree name, degree type, and effective academic terms.


Field Name

Description

Data Type

Length

COMMENCEMENT_BK_COURSE_ROMAN

XXX

VARCHAR2

80

COMMENCEMENT_BK_SEE_ALSO

XXX

VARCHAR2

50

COURSE

The major program (eg. "6 2", "15 M", "18 D") in which the student is enrolled in for the current term.

VARCHAR2

9

COURSE_LAST_ACTIVITY_DATE

XXX

DATE

7

COURSE_LEVEL

The level (Graduate or Undergraduate) of the course of major/degree program in which a student is enrolled.

VARCHAR2

2

DEGREE_CODE

Degree code.

VARCHAR2

5

DEGREE_DESC

The full description of the degree type

VARCHAR2

160

DEGREE_DESC_SHORT

XXX

VARCHAR2

120

DEGREE_LAST_ACTIVITY_DATE

XXX

DATE

7

DEGREE_TYPE

The type of degree, eg.: SB, SM, PHD

VARCHAR2

3

DEGREE_TYPE_DESC

Description of Degree Type (eg. SB, PHD, SM, MBA)

VARCHAR2

40

DEGREE_WEIGHT

XXX

NUMBER

22

DEPARTMENT

The department of the primary Course/major: 6, 10, HIST, etc.

VARCHAR2

4

DEPT_NAME_IN_COMMENCEMENT_BK

XXX

VARCHAR2

80

FROM_TERM

The academic term code from which the value becomes effective

VARCHAR2

6

IS_DOUBLE_MAJOR

A "Y" in this field indicates that the student is enrolled pursuing an undergraduate double major. "N" otherwise

VARCHAR2

1

SCHOOL_NAME_IN_COMMENCEMENT_BK

XXX

VARCHAR2

60

THRU_TERM

The academic term code through which the value remains effective.

VARCHAR2

6

WAREHOUSE_LOAD_DATE

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

DATE

8