STUDENT DEGREE THESIS Table
Student Thesis
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTUAL_OR_PROPOSED |
XXX |
VARCHAR2 |
8 |
COMMENCEMENT_BK_THESIS_INFIELD |
XXX |
VARCHAR2 |
250 |
COURSE |
The major program (eg. "6 2", "15 M", "18 D") in which the student is enrolled in for the current term. |
VARCHAR2 |
9 |
COURSE_LEVEL |
The level (Graduate or Undergraduate) of the course of major/degree program in which a student is enrolled. |
VARCHAR2 |
2 |
DEGREE_APPLY_DATE |
XXX |
DATE |
7 |
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_DESC |
The full description of the degree type |
VARCHAR2 |
160 |
DEGREE_STATUS |
Description of degree status. |
VARCHAR2 |
2 |
DEGREE_STATUS_DATE |
XXX |
DATE |
7 |
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_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 |
DEPARTMENT |
The department of the primary Course/major: 6, 10, HIST, etc. |
VARCHAR2 |
4 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
FUNKY_THESIS_IND |
XXX |
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 |
OTHER_THESIS_FIELD |
XXX |
VARCHAR2 |
100 |
THESIS_COAUTHOR |
XXX |
VARCHAR2 |
60 |
THESIS_FIELD_ID |
XXX |
NUMBER |
22 |
THESIS_LAST_ACTIVITY_DATE |
XXX |
DATE |
7 |
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 |