STUDENT COURSE ENROLLMENT Table
This table contains the student course/degree program enrollment information, including advisor(s), by academic term. There is one record for each course of major (or degree) program (ie. course department, course option, and course level) and the student's advisor(s) for each student in each academic term.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADVISOR_FULL_NAME |
Full name of the advisor (corresponding to ADVISOR_MIT_ID) to the student. |
VARCHAR2 |
90 |
ADVISOR_MIT_ID |
MIT ID of the advisor to the student for a specific Course that the student is enrolled in. |
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 |
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_DEPARTMENT |
The primary degree program (course of major) in which the student is enrolled for the academic year. |
VARCHAR2 |
4 |
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 |
COURSE_LEVEL |
The level (Graduate or Undergraduate) of the course of major/degree program in which a student is enrolled. |
VARCHAR2 |
2 |
COURSE_OPTION |
The major within the department/course/degree program, Eg. "3" in the Course "6 3", "C" in the Course "18 C". |
VARCHAR2 |
4 |
DEPT_OFFICE_CODE |
This field contains the code for the departmental office that has been connected to this student and the course he/she is enrolled in for the term. |
VARCHAR2 |
4 |
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_DESCRIPTION |
Descriptive text for ENROLL_STATUS |
VARCHAR2 |
50 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
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_PRIMARY_ADVISOR |
Primary advisor indicator. An "Y" indicates that this is the primary advsior associated with the Course. Note that if the student does not have an advisor associated with a course (ie. the ADVISOR MIT ID field is null), this field is set to "Y". |
VARCHAR2 |
1 |
IS_PRIMARY_COURSE |
A "Y" or "N" flag indicates whether this is the primary course/degree program a student is enrolled in. |
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_ACTIVITY_DATE |
Date when information in the record was last updated. |
DATE |
8 |
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_TYPE_DESCRIPTION |
Descriptive text for REG_TYPE |
VARCHAR2 |
50 |
SCE_KEY |
XXX |
VARCHAR2 |
36 |
STUDENT_COURSE_ENROLLMENT_KEY |
XXX |
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 |
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 |
ULTIMATE_DEGREE |
The degree code (eg. SB, SM, MA, MBA, DOC) of the primary ultimate degree that the student is seeking. |
VARCHAR2 |
3 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |