STUDENT CURRENT ENROLLMENT Table
This table contains the current academic term enrollment/registration information. It is a simplified version of STUDENT_TERM_ENROLLMENT.
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 |
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_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 |
CURRENT_TERM_CODE |
Term code (eg. 2002FA, 2003SP) of the current academic term. |
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 |
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 |
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_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_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_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 |
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 |
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 |
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_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_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_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_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 |
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 |