Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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