STUDENT ENROLLMENT Y REPORT Table
Student term enrollment information as reported in the Yearly Enrollment Report generated by the Registrar's Office.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BIRTH_DATE |
Date of birth. |
DATE |
8 |
CITIZENSHIP |
Citizenship status: International, US Citizen, US Permanent Resident. |
VARCHAR2 |
30 |
COUNTER |
Numeric field used to count entries in a table. Can be summed on a report. Example - if this field appeared on a table of Person information, it could be used on reports to show headcounts. |
NUMBER |
1 |
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_DEFINITION |
The definition of the degree programs (courses of major) in which the student is enrolled. The values are: Graduate Primary Course, Graduate Non Primary Course, Undergraduate Primary Course, Undergraduate Primary Course with Graduate Course. |
VARCHAR2 |
50 |
COURSE_DEPARTMENT |
The primary degree program (course of major) in which the student is enrolled for the academic year. |
VARCHAR2 |
4 |
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 |
DEPARTMENT_BUDGET_CODE |
The budget code assigned to the department. |
VARCHAR2 |
6 |
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 |
ETHNICITY |
Ethnicity |
VARCHAR2 |
40 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
GENDER |
The person's gender. |
VARCHAR2 |
30 |
GRADUATE_ENTRY_TERM |
The academic term where the student started matriculating as a graduate student. |
VARCHAR2 |
6 |
GRADUATE_LEVEL |
Graduate degree levels: DOC (Doctoral degree) and SM (Master's degree). |
VARCHAR2 |
3 |
HOME_ADDR_COUNTRY |
The country of the person's home address. |
VARCHAR2 |
30 |
HOME_ADDR_STATE |
The U.S. state code of the student's home address. |
VARCHAR2 |
2 |
IPEDS_ETHNICITY |
Ethnicity as defined by IPEDS |
VARCHAR2 |
50 |
IPEDS_GENDER |
XXX |
VARCHAR2 |
1 |
IS_AMERICAN_INDIAN_ALASKA_NATV |
If the employee has identified herself as American Indian or Alaska Native, this field is set to "Y", otherwise it contains "N" |
VARCHAR2 |
1 |
IS_AMER_INDIAN_ALASKA_NATV_IR |
XXX |
VARCHAR2 |
1 |
IS_ASIAN |
If the employee has identified herself as Asian, this field is set to "Y", otherwise it contains "N" |
VARCHAR2 |
1 |
IS_ASIAN_IR |
XXX |
VARCHAR2 |
1 |
IS_BLACK_OR_AFRICAN_AMERICAN |
If the employee has identified herself as Black or African American, this field is set to "Y", otherwise it contains "N" |
VARCHAR2 |
1 |
IS_BLACK_OR_AFRICAN_AMER_IR |
XXX |
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_HISPANIC_OR_LATINO |
If the employee has identified herself as Hispanic or Latino on the Employee Self Service web page, this field is set to "Y", otherwise it contains "N" |
VARCHAR2 |
1 |
IS_HISPANIC_OR_LATINO_IR |
XXX |
VARCHAR2 |
1 |
IS_INTERNATIONAL_NOT_CITZ_PR |
XXX |
VARCHAR2 |
1 |
IS_INTERNTL_NOT_CITZ_PR_IR |
XXX |
VARCHAR2 |
1 |
IS_MORE_THAN_ONE_RACE_REPORTED |
If the employee has identified herself as having more than one Race, this field is set to "Y", otherwise it contains "N" |
VARCHAR2 |
1 |
IS_MORE_THAN_ONE_RACE_REP_IR |
XXX |
VARCHAR2 |
1 |
IS_NATIVE_HAWAIIAN_PACIFIC_ISL |
If the employee has identified herself as a Native Hawaiian or Other Pacific Islander, this field is set to "Y", otherwise it contains "N" |
VARCHAR2 |
1 |
IS_NATIVE_HAWAIIAN_PAC_ISL_IR |
XXX |
VARCHAR2 |
1 |
IS_NO_ETHNICITY_ON_RECORD |
If the employee has not specified any ethnicity on the Employee Self Service web page, this field is set to "Y", otherwise it contains "N" |
VARCHAR2 |
1 |
IS_NO_ETHNICITY_ON_RECORD_IR |
XXX |
VARCHAR2 |
1 |
IS_RACE_ETHNICITY_UNKNOWN |
XXX |
VARCHAR2 |
1 |
IS_RACE_ETHNICITY_UNKN_IR |
XXX |
VARCHAR2 |
1 |
IS_WHITE |
If the employee has identified herself as White, this field is set to "Y", otherwise it contains "N" |
VARCHAR2 |
1 |
IS_WHITE_IR |
XXX |
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 |
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 |
OFFICE_BUILDING |
Building number where the office of the ASA student group is located. |
VARCHAR2 |
20 |
OFFICE_LOCATION |
The person's primary office address at MIT. |
VARCHAR2 |
30 |
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 |
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 |
SUPER_COURSE |
The primary degree program (course of major) in which the student is enrolled for the academic year. |
VARCHAR2 |
9 |
SUPER_COURSE_ROMAN |
Same as SUPER COURSE except the Course Number (e.g. Course 6) is in Roman numeric (Course VI). |
VARCHAR2 |
20 |
TERM_ADDRESS_CATEGORY |
The address categories of the student's current term address. For the students who live in dormitories or housing facilities of Independent Living Groups (ILG), this field contains their dormitory names (e.g., Random Hall, Senior House, Sidney and Pacific) and ILG names (e.g., Fenway House, WILG), respectively. For others, the categories may be: Off Campus, On Campus (office/lab), etc.. |
VARCHAR2 |
30 |
TERM_CITY |
The student's home city for a term. |
VARCHAR2 |
40 |
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 |
TERM_COUNTRY |
XXX |
VARCHAR2 |
100 |
TERM_STATE |
The student's home state for the current term. |
VARCHAR2 |
2 |
TERM_STREET1 |
The student's home street address for the current term. Line 1. |
VARCHAR2 |
30 |
TERM_STREET2 |
The student's home street address for the current term. Line 2. |
VARCHAR2 |
30 |
TERM_STREET3 |
The student's home street address for the current term. Line 3. |
VARCHAR2 |
30 |
TERM_ZIP_CODE5 |
The five digit zip code of the student's term address. |
VARCHAR2 |
5 |
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 |