STUDENT ALL Table
Contains biograpic, registration, address (home, term, and office), and awarded degree data about all students (including both current and graduated students) of MIT. This table also contains records of applicants to MIT. Only users who are authorized to view records of all students have access to this table. Other users are given access to the STUDENT table.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CITIZENSHIP_INDICATOR |
Contains one of the following values: C Citizen, I International Student, or P Permanent Resident (this person holds a Green Card). |
VARCHAR2 |
1 |
COUNTRY_OF_ORIGIN |
Country of origin |
VARCHAR2 |
40 |
COURSE |
The major program (eg. "6 2", "15 M", "18 D") in which the student is enrolled in for the current term. |
VARCHAR2 |
9 |
DATE_OF_BIRTH |
The person's date of birth. |
DATE |
8 |
DEGREE_1 |
Type of degree: SB, SM, MNG, ENG, PHD, etc. A student may have up to 5 awarded degrees in the record. The degrees are listed according to the academic term when it was awarded (start from the earliest), and if more than one degrees were awarded in a term, the degree with the highest weight (eg. a PHD weighs more than a SM) will be listed first. |
VARCHAR2 |
4 |
DEGREE_2 |
Type of degree: SB, SM, MNG, ENG, PHD, etc. A student may have up to 5 awarded degrees in the record. The degrees are listed according to the academic term when it was awarded (start from the earliest), and if more than one degrees were awarded in a term, the degree with the highest weight (eg. a PHD weighs more than a SM) will be listed first. |
VARCHAR2 |
4 |
DEGREE_3 |
Type of degree: SB, SM, MNG, ENG, PHD, etc. A student may have up to 5 awarded degrees in the record. The degrees are listed according to the academic term when it was awarded (start from the earliest), and if more than one degrees were awarded in a term, the degree with the highest weight (eg. a PHD weighs more than a SM) will be listed first. |
VARCHAR2 |
4 |
DEGREE_4 |
Type of degree: SB, SM, MNG, ENG, PHD, etc. A student may have up to 5 awarded degrees in the record. The degrees are listed according to the academic term when it was awarded (start from the earliest), and if more than one degrees were awarded in a term, the degree with the highest weight (eg. a PHD weighs more than a SM) will be listed first. |
VARCHAR2 |
4 |
DEGREE_5 |
Type of degree: SB, SM, MNG, ENG, PHD, etc. A student may have up to 5 awarded degrees in the record. The degrees are listed according to the academic term when it was awarded (start from the earliest), and if more than one degrees were awarded in a term, the degree with the highest weight (eg. a PHD weighs more than a SM) will be listed first. |
VARCHAR2 |
4 |
DEGREE_AWARD_DATE_1 |
The date when the degree was awarded. |
DATE |
8 |
DEGREE_AWARD_DATE_2 |
The date when the degree was awarded. |
DATE |
8 |
DEGREE_AWARD_DATE_3 |
The date when the degree was awarded. |
DATE |
8 |
DEGREE_AWARD_DATE_4 |
The date when the degree was awarded. |
DATE |
8 |
DEGREE_AWARD_DATE_5 |
The date when the degree was awarded. |
DATE |
8 |
DEGREE_AWARD_TERM_1 |
The academic term code when the degree was awarded. |
VARCHAR2 |
6 |
DEGREE_AWARD_TERM_2 |
The academic term code when the degree was awarded. |
VARCHAR2 |
6 |
DEGREE_AWARD_TERM_3 |
The academic term code when the degree was awarded. |
VARCHAR2 |
6 |
DEGREE_AWARD_TERM_4 |
The academic term code when the degree was awarded. |
VARCHAR2 |
6 |
DEGREE_AWARD_TERM_5 |
The academic term code when the degree was awarded. |
VARCHAR2 |
6 |
DEGREE_OPTION_1 |
The major within the department of degree (primary degree). |
VARCHAR2 |
4 |
DEGREE_OPTION_2 |
The major within the department of degree (second degree). |
VARCHAR2 |
4 |
DEGREE_OPTION_3 |
The major within the department of degree (third degree). |
VARCHAR2 |
4 |
DEGREE_OPTION_4 |
The major within the department of degree (fourth degree). |
VARCHAR2 |
4 |
DEGREE_OPTION_5 |
The major within the department of degree (fifth degree). |
VARCHAR2 |
4 |
DEPARTMENT_1 |
The department where the position is held. |
VARCHAR2 |
4 |
DEPARTMENT_2 |
The department where position #2 is held, if applicable. |
VARCHAR2 |
4 |
DEPARTMENT_3 |
The department where position #3 is held, if applicable. |
VARCHAR2 |
4 |
DEPARTMENT_4 |
The department where position #4 is held, if applicable. |
VARCHAR2 |
4 |
DEPARTMENT_5 |
XXX |
VARCHAR2 |
4 |
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 |
EARLY_SOPHOMORE_TERM_CODE |
XXX |
VARCHAR2 |
6 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
ETHNICITY |
Ethnicity |
VARCHAR2 |
40 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
GENDER |
The person's gender. |
VARCHAR2 |
30 |
GRAD_COHORT |
The class of graduate students who are admitted to MIT for the first time and who enroll in the fall as full-time regular students having been admitted that fall term or in the previous summer. Graduate students who delay admission, or who have taken classes as special students in prior terms, as well as transfer students, are not included in any cohort. Cohorts are used to track graduation and retention rates for the most part. This does NOT apply to the graduate school since the programs are of varying lengths. |
VARCHAR2 |
5 |
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 |
I9_ACTIVITY_DATE |
Date when the I9 form information was last updated |
DATE |
8 |
I9_CODE |
Codes represent the status of the I9 (Employment Eligibility Verification) form. |
VARCHAR2 |
1 |
I9_DESCRIPTION |
Descriptive text for the codes represent the status of the I9 Form. |
VARCHAR2 |
50 |
ILG |
The Independent Living Group the student is associated with |
VARCHAR2 |
3 |
IPEDS_ETHNICITY |
Ethnicity as defined by IPEDS |
VARCHAR2 |
50 |
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_ATTENDED_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her attended information kept confidential. |
VARCHAR2 |
1 |
IS_BIRTHDATE_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_CURRENT_STUDENT |
A flag indicating whether this person in the STUDENT table is considered a current student for the current academic term. |
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_EARLY_SOPHOMORE |
XXX |
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_MIT_ID_OBSOLETE |
Y/N flag indicating that the MIT ID associated with this student is obsolete and should not be used. |
VARCHAR2 |
1 |
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_STUDENT |
In the STUDENT and STUDENT_ALL table, this flag indicates whether the person has ever been a student at MIT. In the WTW_INSTRUCTOR and WTW_OLD_INSTRUCTOR tables, this flag indicates whether this instructor was a current student, Y or N, for the specific term. In Payroll Person, indicates whether the person is currently a student, Y or N (i.e., the person may or may not have been a student in a past payroll period). |
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 |
IS_YEAR_CONFIDNTL |
XXX |
VARCHAR2 |
5 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
LAST_UGRAD_TERM |
The last term code when the student received his/her SB degree or before he/she entered MIT as a graduate student. |
VARCHAR2 |
6 |
LATEST_TERM_ATTENDED |
The last/latest academic term in which the student attended -- ie. the is_attended field in the student's enrollment profile is set to 'Y'. |
VARCHAR2 |
6 |
LATEST_TERM_CODE |
According to the Registrar's Office, the latest possible academic term that the student is eligible to register |
VARCHAR2 |
6 |
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 |
NEW_MIT_ID |
If the IS_MIT_ID_OBSOLETE is Y, this field may contain the MIT ID that should be used in place of the bad/obsolete MIT ID. If there is no known "good" or "new" MIT ID, then this field is blank. |
VARCHAR2 |
9 |
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_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_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_COHORT |
The class of freshmen who are admitted to MIT for the first time and who enroll in the fall as full-time regular students having been admitted that fall term or in the previous summer. Freshmen who delay admission, or who have taken classes as special students in prior terms, as well as transfer students, are not included in any cohort. Cohorts are used to track graduation and retention rates for the most part. |
VARCHAR2 |
5 |
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 |
VISA_TYPE |
A description of the type of visa a person holds. |
VARCHAR2 |
30 |
YEAR_OF_DEGREE |
In STUDENT Biograhic and Directory tables this field contains the student's current year of study at MIT: 1, 2, 3, 4, G, U. The length of the field in those tables are of one character. In GRADUATE ADMISSION tables, this field, with a length of four character, contains the year when the applicant recieved the degree from the school/program attended. |
VARCHAR2 |
1 |