STUDENT ARCHIVE ALUMNI Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDR_CAT |
XXX |
VARCHAR2 |
3 |
ATTENDED |
A flag indicating the student actually attended for any time during the current term. Values are Y or N. NOTE: This includes students who started the term and subsequently withdrew or completed their thesis early and are now gone. Use this field instead of the REGISTERED flag if you want to include these types of students. |
VARCHAR2 |
5 |
BIRTH_DT |
XXX |
DATE |
|
COUNTRY_ORIGIN |
Country of origin. |
VARCHAR2 |
2 |
CURRENT_ACADEMIC_TERM |
Term code (eg. 2002FA, 2004SP) of the current academic term. |
VARCHAR2 |
6 |
DATA_EXTRACT_DATE |
Date when the external test score record was extracted from MITSIS. |
DATE |
|
DEGREE1 |
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 |
DEGREE2 |
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 |
DEGREE3 |
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 |
DEGREE4 |
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 |
DEGREE5 |
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 |
DEPT |
Department |
VARCHAR2 |
4 |
DEPT1 |
Department 1 (Primary) |
VARCHAR2 |
4 |
DEPT2 |
Department 2 |
VARCHAR2 |
4 |
DEPT3 |
Department 3 |
VARCHAR2 |
4 |
DEPT4 |
Department 4 |
VARCHAR2 |
4 |
DEPT5 |
Department 5 |
VARCHAR2 |
4 |
DEPT_OPTION |
XXX |
VARCHAR2 |
4 |
ELIGIBLE_TO_REG |
A flag indicating the student is eligible to register for the term. Values include Y or N. NOTE: this flag means that the student has basic eligibility to register from the Registrar's perspective, i.e., s/he has been admitted for this term, is returning from a leave of absence or is a continuing student and has not graduated and has NOT been forced to withdraw for disciplinary or academic reasons. It does NOT MEAN that the student HAS NO HOLDS, financial, medical, or otherwise. |
VARCHAR2 |
5 |
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 |
GENDER |
The person's gender. |
VARCHAR2 |
1 |
G_ENTRY_TERM |
XXX |
VARCHAR2 |
6 |
HOME_ADDR_CHANGE_DATE |
The date when the home address was last changed. |
DATE |
|
HOME_AREA |
XXX |
VARCHAR2 |
3 |
HOME_CITY |
The person's home city. |
VARCHAR2 |
40 |
HOME_NATION |
The home nation of the person. |
VARCHAR2 |
30 |
HOME_PHONE |
The person's home telephone number. |
VARCHAR2 |
7 |
HOME_STATE |
The person's home state. |
VARCHAR2 |
2 |
HOME_STREET1 |
Home address |
VARCHAR2 |
30 |
HOME_STREET2 |
Home address |
VARCHAR2 |
30 |
HOME_STREET3 |
Home address |
VARCHAR2 |
30 |
HOME_ZIP |
Zip code in home address. |
VARCHAR2 |
5 |
HOME_ZIP_4 |
The four-digit zip code in home address. |
VARCHAR2 |
4 |
ILG |
The Independent Living Group the student is associated with |
VARCHAR2 |
3 |
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_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_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 |
LEGAL_FIRST_NAME |
XXX |
VARCHAR2 |
60 |
LEGAL_LAST_NAME |
XXX |
VARCHAR2 |
60 |
LEGAL_MIDDLE_NAME |
XXX |
VARCHAR2 |
60 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
30 |
NAME_CHANGE_DATE |
XXX |
DATE |
|
OPTION1 |
XXX |
VARCHAR2 |
4 |
OPTION2 |
XXX |
VARCHAR2 |
4 |
OPTION3 |
XXX |
VARCHAR2 |
4 |
OPTION4 |
XXX |
VARCHAR2 |
4 |
OPTION5 |
XXX |
VARCHAR2 |
4 |
REGISTERED |
A flag indicating the student is curently registered in the term. Values include Y or N. NOTE: A student who left (withdrew or finished early due to early thesis) will have an N in this field because he/she is not CURRENTLY registered-even though he/she had been registered. See ATTENDED for a better way to identify these kinds of students. |
VARCHAR2 |
5 |
REGISTRAR_ID |
MIT ID of the alum. |
VARCHAR2 |
9 |
REG_TYPE |
Registration type. Values include:N=Regular Non-Resident Student, R=Regular Resident Student, S=Special Student, X=Cross Registered or Exchange Student. |
VARCHAR2 |
1 |
SSN |
The person's social security number. |
VARCHAR2 |
9 |
TERM1 |
XXX |
VARCHAR2 |
6 |
TERM2 |
XXX |
VARCHAR2 |
6 |
TERM3 |
XXX |
VARCHAR2 |
6 |
TERM4 |
XXX |
VARCHAR2 |
6 |
TERM5 |
XXX |
VARCHAR2 |
6 |
TERM_ADDR_CHANGE_DATE |
XXX |
DATE |
|
TERM_AREA1 |
XXX |
VARCHAR2 |
3 |
TERM_AREA2 |
XXX |
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 |
7 |
TERM_PHONE2 |
The student's home telephone number for the current term. |
VARCHAR2 |
7 |
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 |
5 |
TERM_ZIP_4 |
The four digit zip code of the student's term address. |
VARCHAR2 |
4 |
U_ENTRY_TERM |
XXX |
VARCHAR2 |
6 |
YEAR |
In KRB_PERSON, YEAR is a one-character field identifying the students year of degree (or current year); eg.: 1, 2, 3, 4, G, U. In TIP_MATERIAL YEAR is a Year when a Title was published |
VARCHAR2 |
1 |