STUDENT ENROLLMENT WEEK5 Table
Student term enrollment information as of the fifth week (ADD Date) of the academic term. There is one record per student per term.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS_COUNTRY |
The country of the student's home address. |
VARCHAR2 |
30 |
ADDRESS_STATE |
The U.S. state code of the student's home address. |
VARCHAR2 |
2 |
BIRTH_DATE |
Date of birth. |
DATE |
8 |
CITIZENSHIP |
Citizenship status: International, US Citizen, US Permanent Resident. |
VARCHAR2 |
30 |
COUNTRY_OF_CITIZENSHIP |
The country where the person has citizenship. |
VARCHAR2 |
30 |
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_DESC |
Descriptive text for the course of the major of the student for the academic term. |
VARCHAR2 |
30 |
DEPARTMENT |
The department of the primary Course/major: 6, 10, HIST, etc. |
VARCHAR2 |
4 |
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 |
ETHNICITY |
Ethnicity |
VARCHAR2 |
40 |
GENDER |
The person's gender. |
VARCHAR2 |
30 |
GRADUATE_ENTRY_TERM |
The academic term where the student started matriculating as a graduate student. |
VARCHAR2 |
6 |
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_DESC |
This field identifies the primary graduate degree program (course of major) the student is enrolled in for the academic term. |
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_DESC |
Identifies the second, if any, graduate degree program (course of major) the student is enrolled in for the academic term. |
VARCHAR2 |
30 |
GRAD_DEPARTMENT_1 |
This field contains the student's primary graduate department for the academic term. |
VARCHAR2 |
4 |
GRAD_DEPARTMENT_2 |
The student's second, if any, graduate department of registration for the academic term. |
VARCHAR2 |
4 |
GRAD_ULTIMATE_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_ULTIMATE_DEGREE_1_DESC |
Descriptive text for the degree codes in GRAD ULTIMATE DEGREE 1. |
VARCHAR2 |
40 |
GRAD_ULTIMATE_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 (No Degree) is used for special students. |
VARCHAR2 |
3 |
GRAD_ULTIMATE_DEGREE_2_DESC |
Descriptive text for the degree codes in GRAD ULTIMATE DEGREE 2. |
VARCHAR2 |
40 |
IPEDS_ETHNICITY |
Ethnicity as defined by IPEDS |
VARCHAR2 |
50 |
IS_BIRTH_DATE_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her date of birth information kept confidential. |
VARCHAR2 |
1 |
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_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_5 |
This field contains a 'Y' if the student is a fifth year senior for the academic term, otherwise the field contains an 'N'. |
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 |
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 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
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 |
SCHOOL |
The name of the school from which the person earned the highest or most recent degree. |
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 |
STUDENT_YEAR_DESC |
Descriptive text for the student's primary year of degree for the current academic term. Eg.: Freshman, Senior, Graduate Student. |
VARCHAR2 |
30 |
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_DESC |
The primary undergraduate major or degree program in which the student is enrolled for the academic term. |
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_DESC |
The second undergraduate major or degree program in which the student is enrolled for the academic term. |
VARCHAR2 |
30 |
UGRAD_DEPARTMENT_1 |
This field contains the student's primary undergraduate department for the academic term. |
VARCHAR2 |
4 |
UGRAD_DEPARTMENT_2 |
The student's second undergraduate department for the term, if any. |
VARCHAR2 |
4 |
UGRAD_ULTIMATE_DEGREE_1 |
The 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_ULTIMATE_DEGREE_1_DESC |
Descriptive text for the degree codes in UGRAD ULTIMATE DEGREE 1. |
VARCHAR2 |
40 |
UGRAD_ULTIMATE_DEGREE_2 |
The undergraduate degree for which the student has enrolled in his/her second department, if any. Values include SB, and NDG (No Degree) for Special Students. |
VARCHAR2 |
3 |
UGRAD_ULTIMATE_DEGREE_2_DESC |
Descriptive codes for the degree codes in UGRAD ULTIMATE DEGREE 2. |
VARCHAR2 |
40 |
ULTIMATE_DEGREE |
The degree code (eg. SB, SM, MA, MBA, DOC) of the primary ultimate degree that the student is seeking. |
VARCHAR2 |
3 |
ULTIMATE_DEGREE_DESC |
Description of the degree codes in ULTIMATE DEGREE. |
VARCHAR2 |
40 |
UNDERGRAD_ENTRY_TERM |
The academic term where the student started matriculating as an undergraduate student. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |