MIT CARD STUDENT FEED Table
XXX
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 |
11 |
CURRENT_CLASS |
XXX |
VARCHAR2 |
4 |
CURRENT_ENROLL_STATUS |
XXX |
VARCHAR2 |
50 |
CURRENT_PLUS_1_ENROLL_STATUS |
XXX |
VARCHAR2 |
50 |
CURRENT_PLUS_1_REG_TYPE |
XXX |
VARCHAR2 |
50 |
CURRENT_PLUS_2_ENROLL_STATUS |
XXX |
VARCHAR2 |
50 |
CURRENT_PLUS_2_REG_TYPE |
XXX |
VARCHAR2 |
50 |
CURRENT_TERM |
XXX |
VARCHAR2 |
6 |
CURRENT_TERM_PLUS_1 |
XXX |
VARCHAR2 |
6 |
CURRENT_TERM_PLUS_2 |
XXX |
VARCHAR2 |
6 |
DATE_OF_BIRTH |
The person's date of birth. |
DATE |
|
DEGREE_CANDIDATE_TERM |
XXX |
VARCHAR2 |
14 |
DORM_ADDRESS |
The student's on-campus dormitory name and street address. |
VARCHAR2 |
30 |
DORM_ROOM |
The student's on-campus dormitory room number. |
VARCHAR2 |
30 |
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 |
15 |
FLAGS |
XXX |
CHAR |
|
GENDER |
The person's gender. |
VARCHAR2 |
1 |
HOME_ADDRESS1 |
Street number and street name. |
VARCHAR2 |
60 |
HOME_ADDRESS2 |
Additional address information. |
VARCHAR2 |
60 |
HOME_CITY |
The person's home city. |
VARCHAR2 |
80 |
HOME_COUNTRY |
The person's home country. |
VARCHAR2 |
100 |
HOME_STATE |
The person's home state. |
VARCHAR2 |
2 |
HOME_ZIP_CODE |
The person's home zip code. |
VARCHAR2 |
9 |
IS_BIRTHDATE_CONFIDNTL |
XXX |
VARCHAR2 |
1 |
IS_COURSE_CONFIDNTL |
XXX |
VARCHAR2 |
1 |
IS_DEGREE_CANDIDATE |
A flag indicates whether the student is a degree candidate for the next degree award term. Y (Yes), N (No). |
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 |
1 |
IS_E_MAIL_CONFIDNTL |
XXX |
VARCHAR2 |
1 |
IS_HOME_ADDR_CONFIDNTL |
XXX |
VARCHAR2 |
1 |
IS_NEW_GRADUATE_STUDENT |
XXX |
CHAR |
|
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_SERIOUS_CONFIDNTL |
XXX |
VARCHAR2 |
1 |
IS_TERM_ADDR_CONFIDNTL |
XXX |
VARCHAR2 |
1 |
IS_YEAR_CONFIDNTL |
XXX |
VARCHAR2 |
1 |
KRB_NAME_UPPERCASE |
The Kerberos username of a person, in uppercase. |
VARCHAR2 |
8 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
60 |
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 |
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 |
ORIGINAL_CLASS |
XXX |
VARCHAR2 |
4 |
PIDM |
XXX |
VARCHAR2 |
8 |
RANK_IDS |
XXX |
NUMBER |
|
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 |
100 |
REGULAR_TERM_COMPLETED_GRAD |
XXX |
NUMBER |
|
REGULAR_TERM_COMPLETED_UG |
XXX |
NUMBER |
|
REG_ENDED_EARLY_DATE |
XXX |
DATE |
|
REG_ENDED_EARLY_REASON |
XXX |
VARCHAR2 |
31 |
REG_IN_3091 |
XXX |
VARCHAR2 |
1 |
STUDENT_TYPE |
XXX |
VARCHAR2 |
20 |
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 |
SUMMER_TERM_COMPLETED_GRAD |
XXX |
NUMBER |
|
SUMMER_TERM_COMPLETED_UG |
XXX |
NUMBER |
|
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 |