STUDENT DEGREE Table
This table contains information of MIT degrees that have been awarded to students and degrees that are expected to be received by students. There is one record for a degree a student was awarded or is expected. Each record contains information such as the type of degree (eg. SB, MS, PHD), the term and date as well as the department (Course of major) of the degree awarded/expected. The DEGREE STATUS DESC field (which contains values such as 'Degree awarded', 'Degree candidate', 'Degree applicant') differentiates between an awarded and an expected degree. For an awarded degree, there are also various indicators showing if the particular degree was the first undergraduate degree, the first MIT degree, or the highest MIT degree the student received.
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_CODE |
Degree code. |
VARCHAR2 |
5 |
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_OPTION |
XXX |
VARCHAR2 |
4 |
DEGREE_STATUS |
Description of degree status. |
VARCHAR2 |
2 |
DEGREE_STATUS_DESC |
Degree status codes: AW (Degree awarded), AP (Degree applicant), CN (Degree Candidate), XX (Degree awarded, but not verified). The status indicates whether the degree in the record is an awarded or expected degree from MIT. |
VARCHAR2 |
30 |
DEGREE_TERM_ORDER_NUM |
A number indicating the order the order of the degree within the term. The number is 1 if only one degree was awarded to the student in the term. |
NUMBER |
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_FIRST_DEGREE_OF_TERM |
A flag indicating whether the degree is the first degree of the term (according to the value in DEGREE_TERM_ORDER_NUM) received by the student. |
VARCHAR2 |
1 |
IS_FIRST_GRAD_DEGREE |
A flag indicating whether the degree is the first graduate degree received by the student from MIT. |
VARCHAR2 |
1 |
IS_FIRST_MIT_DEGREE |
A flag indicating whether the degree is the first MIT degree (undergraduate or graduate) received by the student. |
VARCHAR2 |
1 |
IS_FIRST_UG_DEGREE |
A flag indicating whehter the degree is the first undergraduate degree received by the student from MIT. |
VARCHAR2 |
1 |
IS_GRAD_DEGREE |
A flag indicating whether the degree is a graduate degree (Y/N). |
VARCHAR2 |
1 |
IS_HIGHEST_MIT_DEGREE |
A flag indicating whether the degree is the highest (according to DEGREE_WEIGHT, eg. PHD has a higher weight than a SM degree) MIT degree received by the student. |
VARCHAR2 |
1 |
IS_LATEST_MIT_DEGREE |
A flag indicating whether the degree is the latest MIT degree (undergraduate or graduate) received by the student. |
VARCHAR2 |
1 |
IS_PRIMARY_COURSE_OF_MAJOR |
'Y' indicates that this is the student's primary course of major. 'N' otherwise |
VARCHAR2 |
1 |
IS_UG_DEGREE |
A flag indicating whether the degree is an undergraduate degree (Y/N). |
VARCHAR2 |
1 |
MINOR_CODE_1 |
Code for a minor program |
VARCHAR2 |
4 |
MINOR_CODE_2 |
Code for a second minor program |
VARCHAR2 |
4 |
MINOR_DESC_1 |
Description for Minor Code |
VARCHAR2 |
60 |
MINOR_DESC_2 |
Description for Minor Code |
VARCHAR2 |
60 |
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 |
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 |