STUDENT DEGREE PROGRAM Table
View exposing student degree program data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMMENCEMENT_BK_COURSE_ROMAN |
Commencement bk course roman associated with the record. |
VARCHAR2 |
80 |
COMMENCEMENT_BK_SEE_ALSO |
Commencement bk see also associated with the record. |
VARCHAR2 |
50 |
COURSE |
Course associated with the record. |
VARCHAR2 |
9 |
COURSE_LAST_ACTIVITY_DATE |
Date associated with course last activity. |
DATE |
|
COURSE_LEVEL |
Course level associated with the record. |
VARCHAR2 |
2 |
DEGREE_CODE |
Code identifying degree. |
VARCHAR2 |
8 |
DEGREE_DESC |
Description of degree. |
VARCHAR2 |
240 |
DEGREE_DESC_SHORT |
Degree desc short associated with the record. |
VARCHAR2 |
120 |
DEGREE_LAST_ACTIVITY_DATE |
Date associated with degree last activity. |
DATE |
|
DEGREE_TYPE |
Degree type associated with the record. |
VARCHAR2 |
3 |
DEGREE_TYPE_DESC |
Description of degree type. |
VARCHAR2 |
100 |
DEGREE_WEIGHT |
Degree weight associated with the record. |
NUMBER |
1 |
DEPARTMENT |
Department associated with the record. |
VARCHAR2 |
4 |
DEPT_NAME_IN_COMMENCEMENT_BK |
Dept name in commencement bk associated with the record. |
VARCHAR2 |
80 |
FROM_TERM |
From term associated with the record. |
VARCHAR2 |
6 |
IS_DOUBLE_MAJOR |
Indicator identifying whether double major (Y/N). |
VARCHAR2 |
1 |
SCHOOL_NAME_IN_COMMENCEMENT_BK |
School name in commencement bk associated with the record. |
VARCHAR2 |
60 |
THRU_TERM |
Thru term associated with the record. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |