STUDENT DEGREE CANDIDATE Table
This table contains MIT degree candidates and applicants for the upcoming degree-award term.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DEGREE_AWARD_DATE |
Date the degree was awarded (date of the Corporation vote). |
DATE |
8 |
DEGREE_AWARD_TERM |
The term code (eg. 2002SP, 2003SP) represents the academic term when the student was awarded a degree or is expected to receive a degree (for STUDENT DEGREE CANDIDATE). |
VARCHAR2 |
6 |
DEGREE_COURSE |
The full description of the department (Course of major) under which the degree was awarded or is expected (for STUDENT DEGREE CANDIDATE). |
VARCHAR2 |
100 |
DEGREE_DEPARTMENT |
The department (Course of major) under which the degree was awarded or is expected (for STUDENT DEGREE CANDIDATE). |
VARCHAR2 |
4 |
DEGREE_DEPARTMENT_DESC |
The full description of the department (including both courses of major and minor) under which the degree was awarded. |
VARCHAR2 |
100 |
DEGREE_DESC |
The full description of the degree type |
VARCHAR2 |
160 |
DEGREE_STATUS |
Description of degree status. |
VARCHAR2 |
2 |
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 |
DEPT_NAME_IN_COMMENCEMENT_BK |
XXX |
VARCHAR2 |
80 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
IS_DEGREES_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her degree information kept confidential. |
VARCHAR2 |
1 |
IS_DOUBLE_MAJOR |
A "Y" in this field indicates that the student is enrolled pursuing an undergraduate double major. "N" otherwise |
VARCHAR2 |
1 |
IS_PRIMARY_COURSE_OF_MAJOR |
'Y' indicates that this is the student's primary course of major. 'N' otherwise |
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 |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
SCHOOL_NAME_IN_COMMENCEMENT_BK |
XXX |
VARCHAR2 |
60 |
THESIS_FIELD |
Doctoral dissertation field/title |
VARCHAR2 |
300 |
THESIS_TITLE |
Title of a PhD thesis. |
VARCHAR2 |
300 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |