EECS TERM ENROLLMENT Table
Student term enrollment data specific to EECS students. Included in this table are terms from the current and prior academic years. For use by EECS users only.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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 |
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_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_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_DESCRIPTION_1 |
Descriptions for the primary program or course of major. For students who are both at the graduate and undergraduate level, the "first" ie. "1" course is always their graduate program/major. |
VARCHAR2 |
30 |
COURSE_DESCRIPTION_2 |
Descriptions for the second program or course of major. |
VARCHAR2 |
30 |
COURSE_DESCRIPTION_3 |
Descriptions for the third program or course of major. |
VARCHAR2 |
30 |
COURSE_LEVEL_1 |
The level (Graduate or Undergraduate) of the course of major. This is for the primary course of major of the student. For students who are both at the graduate and undergraduate level, the "first" ie. "1" course is always their graduate program/major. |
VARCHAR2 |
2 |
COURSE_LEVEL_2 |
The level (Graduate or Undergraduate) of the course of major. |
VARCHAR2 |
2 |
COURSE_LEVEL_3 |
The level (Graduate or Undergraduate) of the course of major. |
VARCHAR2 |
2 |
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 |
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 |
HOME_DEPARTMENT |
The home (major) department of a person. |
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_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 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
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 |
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 |
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 |
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 |
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 |
WITHDRAW_DATE |
The date the student withdrew from school during the term. |
DATE |
8 |