STUDENT DIRECTORY FULL Table
Contains directory information for current students, including term address, year of degree, and department.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DEPARTMENT |
The department of the primary Course/major: 6, 10, HIST, etc. |
VARCHAR2 |
4 |
DEPARTMENT_NAME |
The name of the department, school, center, or lab. |
VARCHAR2 |
50 |
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 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
FULL_NAME_UPPERCASE |
The full name of the person. This is all uppercase, in the format "LAST-NAME, FIRST-NAME OPTIONAL-MIDDLE-NAME |
VARCHAR2 |
100 |
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_EMAIL_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her email address kept confidential. |
VARCHAR2 |
1 |
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_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_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 |
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 |
OFFICE_LOCATION |
The person's primary office address at MIT. |
VARCHAR2 |
30 |
OFFICE_PHONE |
The person's primary office telephone number at MIT. |
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 |
TERM_ADDRESS_CATEGORY |
The address categories of the student's current term address. For the students who live in dormitories or housing facilities of Independent Living Groups (ILG), this field contains their dormitory names (e.g., Random Hall, Senior House, Sidney and Pacific) and ILG names (e.g., Fenway House, WILG), respectively. For others, the categories may be: Off Campus, On Campus (office/lab), etc.. |
VARCHAR2 |
30 |
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 |
20 |
TERM_PHONE2 |
The student's home telephone number for the current term. |
VARCHAR2 |
20 |
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 |
9 |
TITLE_DEGREE |
The students year of degree (or current year), eg.: 1,2,3,4,G,U. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |