STUDENT BIOGRAPHIC Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CITIZENSHIP_IND |
Status of US Citizenship. Values are: US Citizen, US Permanent Resident, International, and Unknown. |
VARCHAR2 |
18 |
COUNTRY_OF_ORIGIN |
Country of origin |
VARCHAR2 |
100 |
COURSE |
The major program (eg. "6 2", "15 M", "18 D") in which the student is enrolled in for the current term. |
VARCHAR2 |
11 |
CURRENT_TERM_CODE |
Term code (eg. 2002FA, 2003SP) of the current academic term. |
VARCHAR2 |
6 |
DATE_OF_BIRTH |
The person's date of birth. |
DATE |
|
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 |
100 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
15 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
93 |
GENDER |
The person's gender. |
VARCHAR2 |
100 |
GRAD_ENTRANCE_TYPE_DESC |
Descriptive text for GRAD_ENTRANCE_TYPE |
VARCHAR2 |
100 |
GRAD_ENTRY_TERM |
The entrance term of a graudate student |
VARCHAR2 |
6 |
HOME_DEPARTMENT |
The home (major) department of a person. |
VARCHAR2 |
6 |
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 |
100 |
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_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 |
1 |
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_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_TO_REG |
A flag indicates whether the student is eligible to register for the current academic year: Y (Yes), N (No) |
VARCHAR2 |
1 |
IS_E_MAIL_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her email address kept confidential. |
VARCHAR2 |
1 |
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 |
1 |
IS_SERIOUS_CONFIDENTIAL |
A "Y" in this field indicates that the student wants his/her record kept confidential |
VARCHAR2 |
1 |
KRB_NAME |
Kerberos Name |
VARCHAR2 |
8 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
60 |
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_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 |
15 |
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 |
20 |
PRONOUNS |
XXX |
VARCHAR2 |
100 |
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 |
100 |
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 |
UGRAD_ENTRANCE_TYPE_DESC |
Descriptive text for UGRAD_ENTRANCE_TYPE |
VARCHAR2 |
100 |
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 |
2 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |