STUDENT DEGREE CANDIDATE Table
View exposing student degree candidate 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_COURSE |
Degree course associated with the record. |
VARCHAR2 |
240 |
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_STATUS |
Degree status associated with the record. |
VARCHAR2 |
30 |
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_PRIMARY_COURSE_OF_MAJOR |
Indicator identifying whether primary course of major (Y/N). |
VARCHAR2 |
1 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
|
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 |