STUDENT DEGREE AWARDED Table
This table contains one record for a degree a student was awarded by MIT. A record contains information such as the the type of the degree (eg. SB, MS, PHD), the term and date as well as the department from which the degree was awarded.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CIP_PROGRAM_CODE |
The 6-digit CIP program code. CIP is the NCES (National Center for Education Statistics) publication that classifies instructional programs by standard terminology for curriculum and instruction in local and state school systems and post-secondary institutions. |
VARCHAR2 |
6 |
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_CATEGORY |
XXX |
VARCHAR2 |
50 |
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_GROUPING |
The academic department under which the degree was awarded. DEGREE_GROUPING may be different from DEGREE_DEPARTMENT. It is created, in addition to DEGREE_DEPARTMENT, to identify the department under which the degree was awarded according to the Registrar's Office's annual report of "NUMBER OF DEGREES AWARDED". |
VARCHAR2 |
80 |
DEGREE_OPTION |
XXX |
VARCHAR2 |
4 |
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 |
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 |
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 |