SIS TERM ADDRESS CATEGORY Table
Descriptions of student term address category. Categories of term address include on-campus dormitories, living groups, and off-campus housing.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LAST_ACTIVITY_DATE |
Date when information in the record was last updated. |
DATE |
8 |
LIVING_GROUP_TYPE |
XXX |
VARCHAR2 |
1 |
LIVING_GROUP_TYPE_DESC |
XXX |
VARCHAR2 |
10 |
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_ADDRESS_CATEGORY_CODE |
XXX |
VARCHAR2 |
3 |
VALID_FROM_DATE |
XXX |
DATE |
8 |
VALID_THRU_DATE |
XXX |
DATE |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |