STUDENT ALL ENROLLMENT Table
This table contains registration status information and awarded degree data for all students, including current and graduated students There is one record per student.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COURSE |
The major program (eg. "6 2", "15 M", "18 D") in which the student is enrolled in for the current term. |
VARCHAR2 |
9 |
CURRENT_TERM_CODE |
Term code (eg. 2002FA, 2003SP) of the current academic term. |
VARCHAR2 |
6 |
DEGREE_1 |
Type of degree: SB, SM, MNG, ENG, PHD, etc. A student may have up to 5 awarded degrees in the record. The degrees are listed according to the academic term when it was awarded (start from the earliest), and if more than one degrees were awarded in a term, the degree with the highest weight (eg. a PHD weighs more than a SM) will be listed first. |
VARCHAR2 |
4 |
DEGREE_2 |
Type of degree: SB, SM, MNG, ENG, PHD, etc. A student may have up to 5 awarded degrees in the record. The degrees are listed according to the academic term when it was awarded (start from the earliest), and if more than one degrees were awarded in a term, the degree with the highest weight (eg. a PHD weighs more than a SM) will be listed first. |
VARCHAR2 |
4 |
DEGREE_3 |
Type of degree: SB, SM, MNG, ENG, PHD, etc. A student may have up to 5 awarded degrees in the record. The degrees are listed according to the academic term when it was awarded (start from the earliest), and if more than one degrees were awarded in a term, the degree with the highest weight (eg. a PHD weighs more than a SM) will be listed first. |
VARCHAR2 |
4 |
DEGREE_4 |
Type of degree: SB, SM, MNG, ENG, PHD, etc. A student may have up to 5 awarded degrees in the record. The degrees are listed according to the academic term when it was awarded (start from the earliest), and if more than one degrees were awarded in a term, the degree with the highest weight (eg. a PHD weighs more than a SM) will be listed first. |
VARCHAR2 |
4 |
DEGREE_5 |
Type of degree: SB, SM, MNG, ENG, PHD, etc. A student may have up to 5 awarded degrees in the record. The degrees are listed according to the academic term when it was awarded (start from the earliest), and if more than one degrees were awarded in a term, the degree with the highest weight (eg. a PHD weighs more than a SM) will be listed first. |
VARCHAR2 |
4 |
DEGREE_AWARD_DATE_1 |
The date when the degree was awarded. |
DATE |
8 |
DEGREE_AWARD_DATE_2 |
The date when the degree was awarded. |
DATE |
8 |
DEGREE_AWARD_DATE_3 |
The date when the degree was awarded. |
DATE |
8 |
DEGREE_AWARD_DATE_4 |
The date when the degree was awarded. |
DATE |
8 |
DEGREE_AWARD_DATE_5 |
The date when the degree was awarded. |
DATE |
8 |
DEGREE_AWARD_TERM_1 |
The academic term code when the degree was awarded. |
VARCHAR2 |
6 |
DEGREE_AWARD_TERM_2 |
The academic term code when the degree was awarded. |
VARCHAR2 |
6 |
DEGREE_AWARD_TERM_3 |
The academic term code when the degree was awarded. |
VARCHAR2 |
6 |
DEGREE_AWARD_TERM_4 |
The academic term code when the degree was awarded. |
VARCHAR2 |
6 |
DEGREE_AWARD_TERM_5 |
The academic term code when the degree was awarded. |
VARCHAR2 |
6 |
DEGREE_DEPARTMENT_1 |
Department of degree: 6, 10, HIST, etc. |
VARCHAR2 |
4 |
DEGREE_DEPARTMENT_2 |
Department of degree: 6, 10, HIST, etc. |
VARCHAR2 |
4 |
DEGREE_DEPARTMENT_3 |
Department of degree: 6, 10, HIST, etc. |
VARCHAR2 |
4 |
DEGREE_DEPARTMENT_4 |
Department of degree: 6, 10, HIST, etc. |
VARCHAR2 |
4 |
DEGREE_DEPARTMENT_5 |
Department of degree: 6, 10, HIST, etc. |
VARCHAR2 |
4 |
DEGREE_OPTION_1 |
The major within the department of degree (primary degree). |
VARCHAR2 |
4 |
DEGREE_OPTION_2 |
The major within the department of degree (second degree). |
VARCHAR2 |
4 |
DEGREE_OPTION_3 |
The major within the department of degree (third degree). |
VARCHAR2 |
4 |
DEGREE_OPTION_4 |
The major within the department of degree (fourth degree). |
VARCHAR2 |
4 |
DEGREE_OPTION_5 |
The major within the department of degree (fifth degree). |
VARCHAR2 |
4 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
GRAD_COHORT |
The class of graduate students who are admitted to MIT for the first time and who enroll in the fall as full-time regular students having been admitted that fall term or in the previous summer. Graduate students who delay admission, or who have taken classes as special students in prior terms, as well as transfer students, are not included in any cohort. Cohorts are used to track graduation and retention rates for the most part. This does NOT apply to the graduate school since the programs are of varying lengths. |
VARCHAR2 |
5 |
GRAD_ENTRANCE_TYPE |
Entrance types for graduate students: "N"=Student entered MIT for the first time as a new graduate student, "R"=Graduate student who was at MIT as an undergraduate, "O"=Student who is a cross registered graduate student or an entering special graduate student. |
VARCHAR2 |
1 |
GRAD_ENTRANCE_TYPE_DESC |
Descriptive text for GRAD_ENTRANCE_TYPE |
VARCHAR2 |
50 |
GRAD_ENTRY_TERM |
The entrance term of a graudate student |
VARCHAR2 |
6 |
HOME_DEPARTMENT |
The home (major) department of a person. |
VARCHAR2 |
4 |
IS_ATTENDED |
"Y" indicates that the student attended at least some part of the current term. "N" indicates that the student never attended this term. In the FINAID AID APPLICANT and FINAID APPLICANT tables, "Y" indicates that the student has attended at least partially in any one of the three terms (in this order: Spring, Fall, Summer) of the aid year. "N" indicates that the student has not attended in any one of the three terms of the aid year. |
VARCHAR2 |
1 |
IS_COURSE_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her course of major kept confidential. |
VARCHAR2 |
5 |
IS_CURRENT_STUDENT |
A flag indicating whether this person in the STUDENT table is considered a current student for the current academic term. |
VARCHAR2 |
1 |
IS_DATES_ATTND_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her attended dates information kept confidential. |
VARCHAR2 |
1 |
IS_DEGREES_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her degree information kept confidential. |
VARCHAR2 |
1 |
IS_ELIGIBLE |
"Y" indicates that the student is currently eligible to register. "N" indicates that the student is not eligible to register. |
VARCHAR2 |
5 |
IS_E_MAIL_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her email address kept confidential. |
VARCHAR2 |
5 |
IS_REGISTERED |
"Y" indicates that the student is currently registered. "N" indicates that the student is not currently registered. In the FINAID AID APPLICANT and FINAID APPLICANT tables, a "Y" in this field indicates that the student has registered for any one of the terms (in this order: Spring, Fall, Summer) of the aid year. "N" indicates that the student has not registered in any one of the three terms of the aid year. |
VARCHAR2 |
1 |
IS_REG_TYPE_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her registration type information kept confidential. |
VARCHAR2 |
5 |
IS_SERIOUS_CONFIDENTIAL |
A "Y" in this field indicates that the student wants his/her record kept confidential |
VARCHAR2 |
1 |
IS_YEAR_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her year information kept confidential. |
VARCHAR2 |
5 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
LAST_UGRAD_TERM |
The last term code when the student received his/her SB degree or before he/she entered MIT as a graduate student. |
VARCHAR2 |
6 |
LATEST_TERM_CODE |
According to the Registrar's Office, the latest possible academic term that the student is eligible to register |
VARCHAR2 |
6 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
30 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
NAME_SUFFIX |
Contains suffixes that may be appended to the last name, examples include: Jr., Sr., II, III, IV, etc. It is not used for honorifics such as "MD, Esq, PhD" etc. |
VARCHAR2 |
15 |
REGISTRATION_TYPE |
Describes how the student has registered. Cross Registered - a student that is taking courses at MIT but whose primary affiliation is with another university. Special - A student who has registered for one or more courses but is not enrolled in a degree program. Regular - A student who is enrolled in a degree program. Non-resident - A doctoral student who is not living or working on campus. This type of student has complete all requirements other than the thesis. |
VARCHAR2 |
18 |
STUDENT_YEAR |
The student's primary year of degree for the current term. Values include 1,2,3,4 (for freshman through senior), G for Graduate, and U for Special Undergraduate. If the student is in the graduate school and also is still an undergraduate student, then this field should always contain a "G". The undergraduate year is then stored in the Undergraduate Year (UG YEAR) field, if applicable. |
VARCHAR2 |
1 |
UGRAD_COHORT |
The class of freshmen who are admitted to MIT for the first time and who enroll in the fall as full-time regular students having been admitted that fall term or in the previous summer. Freshmen who delay admission, or who have taken classes as special students in prior terms, as well as transfer students, are not included in any cohort. Cohorts are used to track graduation and retention rates for the most part. |
VARCHAR2 |
5 |
UGRAD_ENTRANCE_TYPE |
Entrance types for undergraduate students: "E"=Student entered the MIT undergraduate program as a freshman, "T"=Student entered the MIT undergraduate program as a transfer student, "O"=Student who is a cross registered undergraduate or an entering special undergraduate. |
VARCHAR2 |
1 |
UGRAD_ENTRANCE_TYPE_DESC |
Descriptive text for UGRAD_ENTRANCE_TYPE |
VARCHAR2 |
50 |
UGRAD_ENTRY_TERM |
The entrance term of a undergraduate student |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |