STUDENT TERM ENROLLMENT Table
Contains data about the student's registration status, by academic term. There is one enrollment record for a student per academic term.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADVISOR_FULL_NAME_1 |
Full name of the advisor (corresponding to ADVISOR_MIT_ID_1) to the student. |
VARCHAR2 |
90 |
ADVISOR_FULL_NAME_2 |
Full name of the advisor (corresponding to ADVISOR_MIT_ID_2) to the student. |
VARCHAR2 |
90 |
ADVISOR_FULL_NAME_3 |
Full name of the advisor (corresponding to ADVISOR_MIT_ID_3) to the student. |
VARCHAR2 |
90 |
ADVISOR_MIT_ID_1 |
MIT ID of the primary advisor to the student for a specific Course (usually the designated primary Course of the student). |
VARCHAR2 |
9 |
ADVISOR_MIT_ID_2 |
MIT ID of the primary advisor to the student for a secondary Course which the student is enrolled in. |
VARCHAR2 |
9 |
ADVISOR_MIT_ID_3 |
MIT ID of the primary advisor to the student for a secondary Course which the student is enrolled in. |
VARCHAR2 |
9 |
ALT_ADVISOR_FULL_NAME_1 |
XXX |
VARCHAR2 |
76 |
ALT_ADVISOR_FULL_NAME_2 |
XXX |
VARCHAR2 |
76 |
ALT_ADVISOR_FULL_NAME_3 |
XXX |
VARCHAR2 |
76 |
ALT_ADVISOR_MIT_ID_1 |
XXX |
VARCHAR2 |
9 |
ALT_ADVISOR_MIT_ID_2 |
XXX |
VARCHAR2 |
9 |
ALT_ADVISOR_MIT_ID_3 |
XXX |
VARCHAR2 |
9 |
ATTENDED |
A flag indicating the student actually attended for any time during the current term. Values are Y or N. NOTE: This includes students who started the term and subsequently withdrew or completed their thesis early and are now gone. Use this field instead of the REGISTERED flag if you want to include these types of students. |
VARCHAR2 |
1 |
CAN_SEE_ALL_DATA |
XXX |
CHAR |
4 |
CONTINUING_IND |
A flag indicating the student is continuing his/her enrollment from last (regular) term. Values include Y and N. |
VARCHAR2 |
1 |
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_1 |
Identifies the primary program or course of major the student is enrolled in for the term. Examples: "6 3", "18", "15 M". For students who are both at the graduate and undergraduate level, the "first" ie. "1" course is always their graduate program/major. |
VARCHAR2 |
9 |
COURSE_1_DESCRIPTION |
XXX |
VARCHAR2 |
30 |
COURSE_2 |
Identifies the secondary program or course of major the student is enrolled in for the term. Examples: "6 3", "18", "15 M". |
VARCHAR2 |
9 |
COURSE_2_DESCRIPTION |
XXX |
VARCHAR2 |
30 |
COURSE_3 |
Identifies the third program or course of major the student is enrolled in for the term. Examples: "6 3", "18", "15 M". |
VARCHAR2 |
12 |
COURSE_3_DESCRIPTION |
XXX |
VARCHAR2 |
30 |
COURSE_DESCRIPTION |
The description of the course or program (eg. "Elec. Eng & Comp Sci" for "6 2", "Management - SM" for "15 M", "Mathematics Doctoral" for "18 D") in which a student is enrolled. |
VARCHAR2 |
30 |
CO_OP_IND |
A flag indicating the student is registered as a Co-Op student during this term. Values include Y or N. |
VARCHAR2 |
1 |
CROSS_REGISTERED_IND |
A flag indicating the student is from another college and is cross-registered at MIT. Values include Y(es) and N(o). |
VARCHAR2 |
1 |
DEPT_1 |
Code identifying an academic department, eg. 18 for "Mathematics", 6 for "Electrical Eng & Computer Sci". This is the primary department of the student. For students who are both at the graduate and undergraduate level, the "first" ie. "1" department is always the department of their graduate program/major. |
VARCHAR2 |
6 |
DEPT_2 |
Code identifying an academic department, eg. 18 for "Mathematics", 6 for "Electrical Eng & Computer Sci". |
VARCHAR2 |
6 |
DEPT_3 |
Code identifying an academic department, eg. 18 for "Mathematics", 6 for "Electrical Eng & Computer Sci". |
VARCHAR2 |
6 |
DID_NOT_ATTEND_IND |
A flag indicating the student had at one point been expected to register, but either withdrew effective on Registration Day or merely never showed up. Values include Y or N. |
VARCHAR2 |
1 |
EARLIEST_SEPARATION_DATE |
The earliest time when a student is expected to graduate from his/her current program. |
VARCHAR2 |
8 |
EARLY_THESIS_IND |
A flag indicating the student finished his/her thesis before the term ended. Values include Y or N. Specific to GRADUATE AWARDS: Stipends cease once the student has completed his/her thesis, so this may prove helpful in resolving why Payroll's "Stipend Paid Amounts" may appear different for a particular student. Tuition is pro-rated manually on MITSIS when a student leaves early. |
VARCHAR2 |
1 |
ELIGIBLE_TO_REG |
A flag indicating the student is eligible to register for the term. Values include Y or N. NOTE: this flag means that the student has basic eligibility to register from the Registrar's perspective, i.e., s/he has been admitted for this term, is returning from a leave of absence or is a continuing student and has not graduated and has NOT been forced to withdraw for disciplinary or academic reasons. It does NOT MEAN that the student HAS NO HOLDS, financial, medical, or otherwise. |
VARCHAR2 |
1 |
ENROLLMENT_KEY |
Use this field to join the STUDENT TERM ENROLLMENT table with another student table which contains the same-name KEY field. This field should only be used for joining tables, not for reporting. |
VARCHAR2 |
15 |
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 |
ENROLL_STATUS_DESCRIPTION |
Descriptive text for ENROLL_STATUS |
VARCHAR2 |
50 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
GRAD_COURSE_1 |
Identifies the primary graduate degree program or track the student is enrolled in for the term. Examples: 1 M, 1 D, 1 CTP, 15 M ... |
VARCHAR2 |
12 |
GRAD_COURSE_1_DESCRIPTION |
Descriptive text for GRAD_COURSE_1 |
VARCHAR2 |
30 |
GRAD_COURSE_2 |
Identifies the second, if any, graduate degree program the student is enrolled in for the term. Examples: 1 D, 1 CTP, 15 M, ... |
VARCHAR2 |
12 |
GRAD_COURSE_2_DESCRIPTION |
Descriptive text for GRAD_COURSE_2 |
VARCHAR2 |
30 |
GRAD_COURSE_3 |
Identifies the third, if any, graduate degree program the student is enrolled in for the term. Examples: 1 D, 1 CTP, 15 M, ... |
VARCHAR2 |
12 |
GRAD_COURSE_3_DESCRIPTION |
Descriptive text for GRAD_COURSE_3 |
VARCHAR2 |
30 |
GRAD_COURSE_SELECTOR_KEY |
This field is used for GRADUATE AWARDS. It allows you to search for students who may be registered in a given degree track or program either as their first, second, or third course level. |
VARCHAR2 |
30 |
GRAD_DEPT_1 |
This field contains the student's primary graduate department for the term. It is the same as the GRAD_HOME_DEPT field. (Note: For GRADUATE AWARDS, department offices should use the GRAD_DEPT_OFC_1 field instead.) |
VARCHAR2 |
6 |
GRAD_DEPT_2 |
The student's second, if any, graduate department of registration for the term. |
VARCHAR2 |
6 |
GRAD_DEPT_3 |
The student's third, if any, graduate department of registration for the term. |
VARCHAR2 |
6 |
GRAD_DEPT_OFC_1 |
This field is used for GRADUATE AWARDS. It contains the code for the departmental office that has been connected to this student and the course he/she is enrolled in for this term. All courses have one or more departmental offices associated with them. For example: Course 6 1 has the departmental office 6U; 7 WD has the two offices connected: 7G and WHOI. The departmental office code may not be applicable if this record is for a Course that is associated with only a degree and not with a Course of registration. (This should not normally occur, but it may.) |
VARCHAR2 |
4 |
GRAD_DEPT_OFC_2 |
This field is used for GRADUATE AWARDS. It contains the code for the departmental office that has been connected to this student and course for this term. All courses have one or more departmental offices associated with them. For example: Course 6 1 has the departmental office 6U; 7 WD has the two offices connected: 7G and WHOI. The departmental office code may not be applicable if this record is for a Course that is associated with only a degree and not with a Course of registration. (This should not normally occur, but it may.) |
VARCHAR2 |
4 |
GRAD_DEPT_OFC_3 |
This field is used for GRADUATE AWARDS. It contains the code for the departmental office that has been connected to this student and course for this term. All courses have one or more departmental offices associated with them. For example: Course 6 1 has the departmental office 6U; 7 WD has the two offices connected: 7G and WHOI. The departmental office code may not be applicable if this record is for a Course that is associated with only a degree and not with a Course of registration. (This should not normally occur, but it may.) |
VARCHAR2 |
4 |
GRAD_DEPT_OFC_SELECTOR_KEY |
This field is used for GRADUATE AWARDS. It allows you to search for students who may be registred in your department office either as their first, second, or third course of registration. |
VARCHAR2 |
30 |
GRAD_DEPT_SELECTOR_KEY |
This field is used for GRADUATE AWARDS. It allows you to search for students who may be registered in your deparment as their first, second, or third course of registration. It may be used to help identify students who have no official enrollment or payroll affiliation with your department. |
VARCHAR2 |
30 |
GRAD_HOME_DEPT |
The student's primary graudate department of registration for the term. |
VARCHAR2 |
6 |
GRAD_THESIS_SUPERVISOR_MIT_ID |
XXX |
VARCHAR2 |
9 |
GRAD_THESIS_SUPERVISOR_NAME |
XXX |
VARCHAR2 |
90 |
GRAD_ULT_DEGREE_1 |
The primary ultimate graduate degree for which the student has enrolled in his/her home department. Values include: SB, MNG, SM, MA, MCP, DOC, etc. NDG (for No Degree) is used for Special STudents. |
VARCHAR2 |
3 |
GRAD_ULT_DEGREE_2 |
The ultimate graduate degree for which the student has enrolled in his/her second department (if any). Values include: SB, MNG, SM, MA, MCP, DOC, etc. NDG (for No Degree) is used for Special STudents. |
VARCHAR2 |
3 |
GRAD_ULT_DEGREE_3 |
The ultimate graduate degree for which the student has enrolled in his/her third department (if any). Values include: SB, MNG, SM, MA, MCP, DOC, etc. NDG (for No Degree) is used for Special STudents. |
VARCHAR2 |
3 |
HOME_DEPT |
The primary or home department of a student for the term |
VARCHAR2 |
4 |
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_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_DOUBLE_MAJOR |
A "Y" in this field indicates that the student is enrolled pursuing an undergraduate double major. "N" otherwise |
VARCHAR2 |
1 |
IS_MOST_CURRENT_TERM |
XXX |
VARCHAR2 |
1 |
IS_PRE_REGISTERED |
'Y' indicates the student has pre-registered for at least a subject in the term. 'N' otherwise. |
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_VISITING_STUDENT |
XXX |
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 |
LEAVE_OF_ABSENCE_END_DATE |
XXX |
DATE |
7 |
LEAVE_OF_ABSENCE_REASON_CODE |
XXX |
VARCHAR2 |
2 |
LEAVE_OF_ABSENCE_START_DATE |
XXX |
DATE |
7 |
LOAD_LEVEL_CODE |
Code indicating the level of the load the student is taking this term. Values include: 3Q=3 quarters time,FT=full time,HT=half time,LH=Less than half time. This field may be blank if student never attended this term. |
VARCHAR2 |
2 |
LOAD_LEVEL_CODE_DESCRIPTION |
Descriptive text for LOAD_LEVEL_CODE |
VARCHAR2 |
50 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
30 |
MINOR_1 |
XXX |
VARCHAR2 |
4 |
MINOR_1_DESCRIPTION |
XXX |
VARCHAR2 |
60 |
MINOR_2 |
XXX |
VARCHAR2 |
4 |
MINOR_2_DESCRIPTION |
XXX |
VARCHAR2 |
60 |
MINOR_COMPLETE_CODE_1 |
Contains the minor field (eg. "14" for Economics, "15" for Management, "21M" for Music) that the student has completed in the term. The Minor Completion Form has been submitted. |
VARCHAR2 |
4 |
MINOR_COMPLETE_CODE_2 |
Contains the second minor field (eg. "14" for Economics, "15" for Management, "21M" for Music) that the student has completed in the term. The Minor Completion Form has been submitted. |
VARCHAR2 |
4 |
MINOR_COMPLETE_DESC_1 |
Descriptive name of the minor field for MINOR_COMPLETE_CODE_1 |
VARCHAR2 |
60 |
MINOR_COMPLETE_DESC_2 |
Descriptive name of the minor field for MINOR_COMPLETE_CODE_2. |
VARCHAR2 |
60 |
MINOR_PROPOSE_CODE_1 |
Contains the minor field (eg. "14" for Economics, "15" for Management, "21M" for Music) that the student has indicated/proposed he/she would pursue starting from the term. The Minor Proposal Form has been submitted. |
VARCHAR2 |
4 |
MINOR_PROPOSE_CODE_2 |
Contains the second minor field (eg. "14" for Economics, "15" for Management, "21M" for Music) that the student has indicated/proposed he/she would pursue starting from the term. The Minor Proposal Form has been submitted. |
VARCHAR2 |
4 |
MINOR_PROPOSE_DESC_1 |
Descriptive name of the minor field for MINOR_PROPOSE_CODE_1. |
VARCHAR2 |
60 |
MINOR_PROPOSE_DESC_2 |
Descriptive name of the minor field for MINOR_PROPOSE_CODE_2. |
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 |
NEWLY_ADMITTED_IND |
A flag indicating the student was newly-admitted during this term. Valid values are Y(es) or N(o). |
VARCHAR2 |
1 |
NON_RESIDENT_IND |
A flag indicating the student is a Non-Resident Thesis student. Valid values are Y(es) and N(o). |
VARCHAR2 |
1 |
PRIMARY_ADVISOR_EMAIL_ADDRESS |
XXX |
VARCHAR2 |
100 |
PRIMARY_ADVISOR_FULL_NAME |
XXX |
VARCHAR2 |
90 |
PRIMARY_ADVISOR_MIT_ID |
XXX |
VARCHAR2 |
9 |
REGISTERED |
A flag indicating the student is curently registered in the term. Values include Y or N. NOTE: A student who left (withdrew or finished early due to early thesis) will have an N in this field because he/she is not CURRENTLY registered-even though he/she had been registered. See ATTENDED for a better way to identify these kinds of students. |
VARCHAR2 |
1 |
REGULAR_STUDENT_IND |
A flag indicating the student is a Regular student, i.e., pursuing a degree at MIT this term. This does NOT include non-resident thesis students (see Non-Resident Ind field). Values include Y(es) and N(o). |
VARCHAR2 |
1 |
REG_ENDED_EARLY_DATE |
XXX |
DATE |
7 |
REG_ENDED_EARLY_REASON |
XXX |
VARCHAR2 |
60 |
REG_GROUP |
Registration Group. Values include:C=Continuing Registration or Non-resident Student,E=Entering Freshman (Reg),F=Registered Student with Former Attendance,N=New Regular Grad Student,O=New Special/Cross-Registered Student,P=Speciall/Cross-Registered, Previously Attended, R=New Regular Grad/Former MIT undegraduate,T=Entering Transfer Student (Reg). |
VARCHAR2 |
1 |
REG_GROUP_DESCRIPTION |
Descriptive text for REG_GROUP |
VARCHAR2 |
50 |
REG_TYPE |
Registration type. Values include:N=Regular Non-Resident Student, R=Regular Resident Student, S=Special Student, X=Cross Registered or Exchange Student. |
VARCHAR2 |
1 |
REG_TYPE_DESCRIPTION |
Descriptive text for REG_TYPE |
VARCHAR2 |
50 |
RETURNING_FORMER_IND |
A flag indicating the student has attended MIT in the past and is returning to MIT this term. Values include Y and N. This flag is set to Y if the student was either a regular student with former attendance or was once a special or cross-registered student with previous attendance. |
VARCHAR2 |
1 |
SPECIAL_STUDENT_IND |
A flag indicating the student is a Special MIT student. Values include Y(es) and N(o). |
VARCHAR2 |
1 |
STUDENT_TERM_ENROLLMENT_KEY |
Use this field to join to the STUDENT TERM ENROLLMENT table |
VARCHAR2 |
15 |
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 |
STUDENT_YEAR_PROGRESS |
XXX |
VARCHAR2 |
3 |
TERM_CODE |
** For FINANCIAL DATA: the Term Code identifies the status of the cost collector. Blank - open for charges between start and end dates. Term Code = 1 - Closed. Pre-end date charges allowed. Term Code = 2 - No longer in use. Term Code = 3 - Terminated. Charges not allowed. ** For STUDENT DATA: the Term Code identifies one of the terms in an academic year; for example: 1999FA==>Fall Term of the 1998-99 academic year, and 1999SP==>Spring Term of the 1998-99 academic year. |
VARCHAR2 |
6 |
UGRAD_COURSE_1 |
The primary undergraduate major or degree program which the student is enrolled in for the term |
VARCHAR2 |
12 |
UGRAD_COURSE_1_DESCRIPTION |
Descriptive text for UGRAD_COURSE_1 |
VARCHAR2 |
30 |
UGRAD_COURSE_2 |
The second undergraduate major or degree program, if any, which the student is enrolled in for the term |
VARCHAR2 |
9 |
UGRAD_COURSE_2_DESCRIPTION |
Descriptive text for UGRAD_COURSE_2 |
VARCHAR2 |
30 |
UGRAD_COURSE_3 |
The third undergraduate major or degree program, if any, which the student is enrolled in for the term |
VARCHAR2 |
9 |
UGRAD_COURSE_3_DESCRIPTION |
Descriptive text for UGRAD_COURSE_3 |
VARCHAR2 |
30 |
UGRAD_DEPT_1 |
The student's primary undergraduate department for the term. This is the same as the HOME_DEPT field |
VARCHAR2 |
6 |
UGRAD_DEPT_2 |
The student's second undergraduate department for the term, if any |
VARCHAR2 |
6 |
UGRAD_DEPT_3 |
The student's third undergraduate department for the term, if any |
VARCHAR2 |
6 |
UGRAD_DEPT_OFC_1 |
This field is used for GRADUATE AWARDS. It contains the student's primary undergraduate department office for the term. |
VARCHAR2 |
6 |
UGRAD_DEPT_OFC_2 |
This field is specific to GRADUATE AWARDS. It contains the student's second undergraduate department office for the term |
VARCHAR2 |
4 |
UGRAD_DEPT_OFC_3 |
This field is specific to GRADUATE AWARDS. It contains the student's thirdundergraduate department offi ce for the term |
VARCHAR2 |
4 |
UGRAD_ULT_DEGREE_1 |
The primary ultimate undergraduate degree for which the student has enrolled in his/her home department. Values include: SB and NDG (No Degree) for Special Students. |
VARCHAR2 |
3 |
UGRAD_ULT_DEGREE_2 |
The third ultimate undergraduate degree, if any, for which the student has enrolled in his/her home department. |
VARCHAR2 |
3 |
UGRAD_ULT_DEGREE_3 |
The secondary ultimate undergraduate degree, if any, for which the student has enrolled in his/her home department. |
VARCHAR2 |
3 |
UG_YEAR |
The student's undergraduate year. Values include 1, 2, 3, 4 if the student is an undergraduate. Otherwise it should be null. Note: for undergraduates who are admitted directly to the graduate school, this field stays populated with "4" until s/he actually picks up his/her undergraduate degree. Since the student can wait to pick up his/her undergraduate degree until s/he picks up his/her graduate degree, many students are still coded as undergraduates in this filed long past the time the student has probably completed all of his/her undergraduate requirements. |
VARCHAR2 |
1 |
ULT_DEGREE_1 |
XXX |
VARCHAR2 |
3 |
ULT_DEGREE_2 |
XXX |
VARCHAR2 |
3 |
ULT_DEGREE_3 |
XXX |
VARCHAR2 |
3 |
UNITS_OF_LOAD |
Total of the subject units that the student is registered for this term. Includes subjects registered for as a listener. |
NUMBER |
3 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
WITHDRAWN_IND |
A flag indicating the student withdrew at some point DURING THE TERM for which the award was granted. Valid values are Y or N. |
VARCHAR2 |
1 |
WITHDRAW_DATE |
The date the student withdrew from school during the term. |
DATE |
8 |