STUDENT BASIC Table
Basic student information with MIT ID, name; and registration information such as whether the student is eligible to register, registered, and the student year, home department and course of major for the current academic term.
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 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
HOME_DEPARTMENT |
The home (major) department of a person. |
VARCHAR2 |
4 |
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_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 |
"Y" indicates that the student is currently eligible to register. "N" indicates that the student is not eligible to register. |
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_SERIOUS_CONFIDENTIAL |
A "Y" in this field indicates that the student wants his/her record kept confidential |
VARCHAR2 |
1 |
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 |
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 |
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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |