XFINITY INFORMATION Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DW_ADDRESS_CATEGORY |
XXX |
VARCHAR2 |
3 |
DW_ADDRESS_CATEGORY_DESC |
XXX |
VARCHAR2 |
100 |
DW_XFINITY_FLAG |
XXX |
VARCHAR2 |
2 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
102 |
IS_ELIGIBLE_FOR_CAMPUS_XF |
XXX |
VARCHAR2 |
1 |
KRB_NAME_UPPERCASE |
The Kerberos username of a person, in uppercase. |
VARCHAR2 |
93 |
MITSIS_PIDM |
XXX |
VARCHAR2 |
8 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
REG_TERM |
XXX |
VARCHAR2 |
6 |
REG_TYPE |
Registration type. Values include:N=Regular Non-Resident Student, R=Regular Resident Student, S=Special Student, X=Cross Registered or Exchange Student. |
VARCHAR2 |
50 |
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 |
80 |
TERM_STATE |
The student's home state for the current term. |
VARCHAR2 |
4 |
TERM_STREET1 |
The student's home street address for the current term. Line 1. |
VARCHAR2 |
60 |
XFINITY_REASON |
XXX |
VARCHAR2 |
283 |