STUDENT ADVISOR Table
Contains students and their advisors for the current academic term. A student may have multiple courses of major and multiple advisors for each of the courses of major. The IS_PRIMARY_COURSE field indicates the primary course of major and the IS_PRIMARY_ADVISOR field indicates the primary advisor for each of the course(s) of major. There is one record per student per academic term per course of major and course level per advisor.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADVISOR_DEPARTMENT_NAME |
Department name of the student's advisor. |
VARCHAR2 |
100 |
ADVISOR_DEPARTMENT_NUMBER |
Department number of the student's advisor. |
VARCHAR2 |
6 |
ADVISOR_EMAIL_ADDRESS |
Email address of the student's advisor. |
VARCHAR2 |
100 |
ADVISOR_FULL_NAME |
Full name of the advisor (corresponding to ADVISOR_MIT_ID) to the student. |
VARCHAR2 |
90 |
ADVISOR_ID |
XXX |
VARCHAR2 |
9 |
ADVISOR_KRB_NAME |
Kerberos name of the student's advisor. |
VARCHAR2 |
8 |
ADVISOR_MIT_ID |
MIT ID of the advisor to the student for a specific Course that the student is enrolled in. |
VARCHAR2 |
9 |
ADVISOR_OFFICE_LOCATION |
Office location of the student's advisor. |
VARCHAR2 |
40 |
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 |
1 |
CURRENT_TERM_CODE |
Term code (eg. 2002FA, 2003SP) of the current academic term. |
VARCHAR2 |
6 |
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 |
1 |
ENROLL_STATUS |
The status of the student's registration for the term. Values include: Eligible to register, Registered, Early Thesis, Withdrew After 5th Week, etc. In the STUDENT and STUDENT_TERM_ENROLLMENT tables, only the codes (eg. EL, RE, ET, WR, WE) are shown. |
VARCHAR2 |
2 |
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_DOUBLE_MAJOR |
A "Y" in this field indicates that the student is enrolled pursuing an undergraduate double major. "N" otherwise |
VARCHAR2 |
1 |
IS_PRIMARY_ADVISOR |
Primary advisor indicator. An "Y" indicates that this is the primary advsior associated with the Course. Note that if the student does not have an advisor associated with a course (ie. the ADVISOR MIT ID field is null), this field is set to "Y". |
VARCHAR2 |
1 |
IS_PRIMARY_COURSE |
A "Y" or "N" flag indicates whether this is the primary course/degree program a student is enrolled in. |
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_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 |
STUDENT_COURSE_LEVEL |
XXX |
VARCHAR2 |
2 |
STUDENT_COURSE_MAJOR |
The student's course of major |
VARCHAR2 |
9 |
STUDENT_FULL_NAME |
The student's full name |
VARCHAR2 |
90 |
STUDENT_HOME_DEPARTMENT |
The student's home department |
VARCHAR2 |
4 |
STUDENT_MIT_ID |
The student's MIT ID |
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 |