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 |