STUDENT ADVISOR Table
View exposing current student-to-advisor relationships including advisor identifiers, names, department and office attributes, advisor contact fields, student academic attributes, and confidentiality flags.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADVISOR_DEPARTMENT_NAME |
Advisor department name associated with the record. |
VARCHAR2 |
75 |
ADVISOR_DEPARTMENT_NUMBER |
Advisor department number associated with the record. |
VARCHAR2 |
0 |
ADVISOR_EMAIL_ADDRESS |
Advisor email address associated with the record. |
VARCHAR2 |
100 |
ADVISOR_FULL_NAME |
Advisor full name associated with the person or organization. |
VARCHAR2 |
100 |
ADVISOR_ID |
Business identifier for the advisor. |
VARCHAR2 |
9 |
ADVISOR_KRB_NAME |
Advisor krb name associated with the record. |
VARCHAR2 |
30 |
ADVISOR_MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
ADVISOR_OFFICE_LOCATION |
Advisor office location associated with the record. |
VARCHAR2 |
40 |
ATTENDED |
Attended associated with the record. |
VARCHAR2 |
1 |
CURRENT_TERM_CODE |
Code identifying current term. |
VARCHAR2 |
6 |
ELIGIBLE_TO_REG |
Eligible to reg associated with the record. |
VARCHAR2 |
1 |
ENROLL_STATUS |
Enroll status associated with the record. |
VARCHAR2 |
2 |
IS_COURSE_CONFIDENTIAL |
Indicator identifying whether course confidential (Y/N). |
VARCHAR2 |
1 |
IS_DOUBLE_MAJOR |
Indicator identifying whether double major (Y/N). |
VARCHAR2 |
1 |
IS_PRIMARY_ADVISOR |
Indicator identifying whether primary advisor (Y/N). |
VARCHAR2 |
1 |
IS_PRIMARY_COURSE |
Indicator identifying whether primary course (Y/N). |
VARCHAR2 |
1 |
IS_REGISTERED |
Indicator identifying whether registered (Y/N). |
VARCHAR2 |
1 |
IS_SERIOUS_CONFIDENTIAL |
Indicator identifying whether serious confidential (Y/N). |
VARCHAR2 |
1 |
IS_YEAR_CONFIDENTIAL |
Indicator identifying whether year confidential (Y/N). |
VARCHAR2 |
1 |
STUDENT_COURSE_LEVEL |
Student course level associated with the record. |
VARCHAR2 |
2 |
STUDENT_COURSE_MAJOR |
Student course major associated with the record. |
VARCHAR2 |
9 |
STUDENT_FULL_NAME |
Student full name associated with the person or organization. |
VARCHAR2 |
100 |
STUDENT_HOME_DEPARTMENT |
Student home department associated with the record. |
VARCHAR2 |
6 |
STUDENT_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 |
Student year associated with the record. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |