STUDENT CURRENT Table
Contains biographic, enrollment, and address (home, term, and office addresses) data about current students. Current students are students who are registered or eligible to register for the current academic terms. There is one record per student.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COURSE |
The major program (eg. "6 2", "15 M", "18 D") in which the student is enrolled in for the current term. |
VARCHAR2 |
9 |
CURRENT_TERM_CODE |
Term code (eg. 2002FA, 2003SP) of the current academic term. |
VARCHAR2 |
6 |
DORM_ADDRESS |
The student's on-campus dormitory name and street address. |
VARCHAR2 |
30 |
DORM_PHONE |
The student's on-campus dormitory phone number. |
VARCHAR2 |
20 |
DORM_ROOM |
The student's on-campus dormitory room number. |
VARCHAR2 |
10 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
GRAD_ENTRANCE_TYPE |
Entrance types for graduate students: "N"=Student entered MIT for the first time as a new graduate student, "R"=Graduate student who was at MIT as an undergraduate, "O"=Student who is a cross registered graduate student or an entering special graduate student. |
VARCHAR2 |
1 |
GRAD_ENTRANCE_TYPE_DESC |
Descriptive text for GRAD_ENTRANCE_TYPE |
VARCHAR2 |
50 |
GRAD_ENTRY_TERM |
The entrance term of a graudate student |
VARCHAR2 |
6 |
HOME_ADDRESS1 |
Street number and street name. |
VARCHAR2 |
30 |
HOME_ADDRESS2 |
Additional address information. |
VARCHAR2 |
30 |
HOME_CITY |
The person's home city. |
VARCHAR2 |
30 |
HOME_COUNTRY |
The person's home country. |
VARCHAR2 |
30 |
HOME_DEPARTMENT |
The home (major) department of a person. |
VARCHAR2 |
4 |
HOME_PHONE |
The person's home telephone number. |
VARCHAR2 |
20 |
HOME_STATE |
The person's home state. |
VARCHAR2 |
2 |
HOME_ZIP_CODE |
The person's home zip code. |
VARCHAR2 |
9 |
ILG |
The Independent Living Group the student is associated with |
VARCHAR2 |
3 |
IS_ATTENDED |
"Y" indicates that the student attended at least some part of the current term. "N" indicates that the student never attended this term. In the FINAID AID APPLICANT and FINAID APPLICANT tables, "Y" indicates that the student has attended at least partially in any one of the three terms (in this order: Spring, Fall, Summer) of the aid year. "N" indicates that the student has not attended in any one of the three terms of the aid year. |
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_ELIGIBLE |
"Y" indicates that the student is currently eligible to register. "N" indicates that the student is not eligible to register. |
VARCHAR2 |
5 |
IS_E_MAIL_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her email address kept confidential. |
VARCHAR2 |
5 |
IS_HOME_ADDR_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her home address kept confidential. |
VARCHAR2 |
5 |
IS_OFFICE_ADDR_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her office address kept confidential. |
VARCHAR2 |
5 |
IS_OFFICE_PHONE_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her office phone kept confidential. |
VARCHAR2 |
5 |
IS_REGISTERED |
"Y" indicates that the student is currently registered. "N" indicates that the student is not currently registered. In the FINAID AID APPLICANT and FINAID APPLICANT tables, a "Y" in this field indicates that the student has registered for any one of the terms (in this order: Spring, Fall, Summer) of the aid year. "N" indicates that the student has not registered in any one of the three terms of the aid year. |
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_TERM_ADDR_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her term address kept confidential. |
VARCHAR2 |
5 |
IS_TERM_PHONE_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her term phone 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 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
LATEST_TERM_ELIGIBLE_TO_REG |
The last/latest academic term in which the student is eligible to register -- ie. the eligible_to_reg field in the student's enrollment profile is set to 'Y'. |
VARCHAR2 |
6 |
MIDDLE_NAME |
The person's middle name (where available). |
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 |
NAME_SUFFIX |
Contains suffixes that may be appended to the last name, examples include: Jr., Sr., II, III, IV, etc. It is not used for honorifics such as "MD, Esq, PhD" etc. |
VARCHAR2 |
15 |
OFFICE_LOCATION |
The person's primary office address at MIT. |
VARCHAR2 |
30 |
OFFICE_PHONE |
The person's primary office telephone number at MIT. |
VARCHAR2 |
20 |
ORIGINAL_CLASS |
XXX |
VARCHAR2 |
4 |
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 |
RUNDATE |
The date this data was last extracted/transported from MITSIS. |
DATE |
8 |
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_ADDR_CATEGORY |
The address category of the student's current term address. For students who live in dormitories or housing facilities of the Independent Living Groups (ILG), this field contains their dormitory codes (eg. RAN, SID, SH) and ILG codes (eg. WILG, PKT), respectively. For others, the category codes may be: OFF (for Off campus), ONC (for on-campus office/lab), etc. |
VARCHAR2 |
3 |
TERM_CITY |
The student's home city for a term. |
VARCHAR2 |
40 |
TERM_PHONE1 |
The student's home telephone number for the current term. |
VARCHAR2 |
20 |
TERM_PHONE2 |
The student's home telephone number for the current term. |
VARCHAR2 |
20 |
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 |
The student's home zip code for the current term. |
VARCHAR2 |
9 |
UGRAD_ENTRANCE_TYPE |
Entrance types for undergraduate students: "E"=Student entered the MIT undergraduate program as a freshman, "T"=Student entered the MIT undergraduate program as a transfer student, "O"=Student who is a cross registered undergraduate or an entering special undergraduate. |
VARCHAR2 |
1 |
UGRAD_ENTRANCE_TYPE_DESC |
Descriptive text for UGRAD_ENTRANCE_TYPE |
VARCHAR2 |
50 |
UGRAD_ENTRY_TERM |
The entrance term of a undergraduate student |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |