STUDENT DEGREE Table
View exposing student degree data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DEGREE_AWARD_DATE |
Date associated with degree award. |
DATE |
|
DEGREE_AWARD_TERM |
Degree award term associated with the record. |
VARCHAR2 |
6 |
DEGREE_CODE |
Code identifying degree. |
VARCHAR2 |
8 |
DEGREE_DEPARTMENT |
Degree department associated with the record. |
VARCHAR2 |
4 |
DEGREE_DEPARTMENT_DESC |
Description of degree department. |
VARCHAR2 |
240 |
DEGREE_DESC |
Description of degree. |
VARCHAR2 |
240 |
DEGREE_OPTION |
Degree option associated with the record. |
VARCHAR2 |
4 |
DEGREE_STATUS |
Degree status associated with the record. |
VARCHAR2 |
2 |
DEGREE_STATUS_DESC |
Description of degree status. |
VARCHAR2 |
30 |
DEGREE_TERM_ORDER_NUM |
Degree term order num associated with the record. |
NUMBER |
|
DEGREE_TYPE |
Degree type associated with the record. |
VARCHAR2 |
3 |
DEGREE_TYPE_DESC |
Description of degree type. |
VARCHAR2 |
100 |
DEPT_NAME_IN_COMMENCEMENT_BK |
Dept name in commencement bk associated with the record. |
VARCHAR2 |
80 |
FULL_NAME |
Full name associated with the person or organization. |
VARCHAR2 |
80 |
IS_DEGREES_CONFIDENTIAL |
Indicator identifying whether degrees confidential (Y/N). |
VARCHAR2 |
1 |
IS_DOUBLE_MAJOR |
Indicator identifying whether double major (Y/N). |
VARCHAR2 |
1 |
IS_FIRST_DEGREE_OF_TERM |
Indicator identifying whether first degree of term (Y/N). |
VARCHAR2 |
1 |
IS_FIRST_GRAD_DEGREE |
Indicator identifying whether first grad degree (Y/N). |
VARCHAR2 |
1 |
IS_FIRST_MIT_DEGREE |
Indicator identifying whether first mit degree (Y/N). |
VARCHAR2 |
1 |
IS_FIRST_UG_DEGREE |
Indicator identifying whether first ug degree (Y/N). |
VARCHAR2 |
1 |
IS_GRAD_DEGREE |
Indicator identifying whether grad degree (Y/N). |
VARCHAR2 |
1 |
IS_HIGHEST_MIT_DEGREE |
Indicator identifying whether highest mit degree (Y/N). |
VARCHAR2 |
1 |
IS_LATEST_MIT_DEGREE |
Indicator identifying whether latest mit degree (Y/N). |
VARCHAR2 |
1 |
IS_PRIMARY_COURSE_OF_MAJOR |
Indicator identifying whether primary course of major (Y/N). |
VARCHAR2 |
1 |
IS_UG_DEGREE |
Indicator identifying whether ug degree (Y/N). |
VARCHAR2 |
1 |
MINOR_CODE_1 |
Minor code 1 associated with the record. |
VARCHAR2 |
4 |
MINOR_CODE_2 |
Minor code 2 associated with the record. |
VARCHAR2 |
4 |
MINOR_DESC_1 |
Minor desc 1 associated with the record. |
VARCHAR2 |
100 |
MINOR_DESC_2 |
Minor desc 2 associated with the record. |
VARCHAR2 |
100 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
SCHOOL_NAME_IN_COMMENCEMENT_BK |
School name in commencement bk associated with the record. |
VARCHAR2 |
60 |
THESIS_FIELD |
Thesis field associated with the record. |
VARCHAR2 |
300 |
THESIS_TITLE |
Thesis title associated with the record. |
VARCHAR2 |
500 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |