STUDENT GRAD ENROLLMENT Table
This table contains the enrollment information of all current as well as incoming (for the upcoming academic term) graduate students. Enrollment status (including registration, degree course, load level) for the current academic term is included as well as the entry term, entrance type, home department, email address, office address, and whether the student is eligible to register for the upcoming term. New incoming students are marked with a "Y" in the "Is New Incoming Student" field.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CURRENT_ACADEMIC_TERM |
Term code (eg. 2002FA, 2004SP) of the current academic term. |
VARCHAR2 |
6 |
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_1 |
The primary degree program the student is enrolled in for the current academic term. |
VARCHAR2 |
30 |
DEGREE_COURSE_2 |
The second, if any, degree program the student is enrolled in for the current academic term. |
VARCHAR2 |
30 |
ELIGIBLE_TO_REG_NEXT_TERM |
"Y"=the student is eligible to register for the upcoming term. "N"=the student is not eligible to register for the upcoming term. |
VARCHAR2 |
1 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
ENROLL_STATUS |
The status of the student's registration for the term. Values include: Eligible to register, Registered, Early Thesis, Withdrew After 5th Week, etc. In the STUDENT and STUDENT_TERM_ENROLLMENT tables, only the codes (eg. EL, RE, ET, WR, WE) are shown. |
VARCHAR2 |
2 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
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_ENTRY_TERM |
The entrance term of a graudate student |
VARCHAR2 |
6 |
HOME_DEPARTMENT_CODE |
The primary home department (eg. 7, 8, 18, SDM) of a student for the term. |
VARCHAR2 |
6 |
HOME_DEPARTMENT_DESC |
The descriptive text of the primary home department of a student for the term. |
VARCHAR2 |
30 |
IS_COURSE_CONFIDNTL |
XXX |
VARCHAR2 |
1 |
IS_DEGREE_CANDIDATE |
A flag indicates whether the student is a degree candidate for the next degree award term. Y (Yes), N (No). |
VARCHAR2 |
1 |
IS_EMAIL_CONFIDNTL |
XXX |
VARCHAR2 |
1 |
IS_INCOMING_NEW_STUDENT |
"Y" indicates the student is a new incoming gradudate student for the upcoming academic term. |
VARCHAR2 |
1 |
IS_OFFICE_ADDR_CONFIDNTL |
XXX |
VARCHAR2 |
1 |
IS_OFFICE_PHONE_CONFIDNTL |
XXX |
VARCHAR2 |
1 |
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 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
LAST_UGRAD_TERM_AT_MIT |
The academic term code when the student was last registered as a undergraduate student at MIT. |
VARCHAR2 |
6 |
LOAD_LEVEL |
The course load of the student in the registered term. Values: Full Time, Half Time, 3/4 Time, Early Thesis, No Load, Cross-registered, Less Than Half Time, Full Time Senior. |
VARCHAR2 |
30 |
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 |
OFFICE_LOCATION |
The person's primary office address at MIT. |
VARCHAR2 |
30 |
OFFICE_PHONE |
The person's primary office telephone number at MIT. |
VARCHAR2 |
20 |
REGISTRATION_GROUP |
The registration group in which the student is categorized for the academic term. Some possible values include: Entering Freshman, Entering Transfer Student, New Regular Grad Student, Continuing Registration or Non-Resident Student. |
VARCHAR2 |
50 |
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 |
UPCOMING_ACADEMIC_TERM |
The next academic term. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |