STUDENT ADDRESS Y REPORT Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DORM_ADDRESS |
The student's on-campus dormitory name and street address. |
VARCHAR2 |
30 |
DORM_PHONE |
The student's on-campus dormitory phone number. |
VARCHAR2 |
20 |
DORM_ROOM |
The student's on-campus dormitory room number. |
VARCHAR2 |
10 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
HOME_ADDRESS1 |
Street number and street name. |
VARCHAR2 |
30 |
HOME_ADDRESS2 |
Additional address information. |
VARCHAR2 |
30 |
HOME_CITY |
The person's home city. |
VARCHAR2 |
40 |
HOME_COUNTRY |
The person's home country. |
VARCHAR2 |
30 |
HOME_PHONE |
The person's home telephone number. |
VARCHAR2 |
20 |
HOME_STATE |
The person's home state. |
VARCHAR2 |
2 |
HOME_ZIP_CODE |
The person's home zip code. |
VARCHAR2 |
9 |
ILG |
The Independent Living Group the student is associated with |
VARCHAR2 |
3 |
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_TERM_ENROLLMENT_KEY |
Use this field to join to the STUDENT TERM ENROLLMENT table |
VARCHAR2 |
15 |
TERM_ADDR_CATEGORY |
The address category of the student's current term address. For students who live in dormitories or housing facilities of the Independent Living Groups (ILG), this field contains their dormitory codes (eg. RAN, SID, SH) and ILG codes (eg. WILG, PKT), respectively. For others, the category codes may be: OFF (for Off campus), ONC (for on-campus office/lab), etc. |
VARCHAR2 |
3 |
TERM_CITY |
The student's home city for a term. |
VARCHAR2 |
40 |
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 |
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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |