PARK ELIGIBLE RESIDENT Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVITY_DATE |
The date of the last major change in the employment status. The date records only hires, leaves, terminations, retirements, and deaths. |
DATE |
|
ASSIGNMENT_STATUS_DATE |
XXX |
DATE |
|
BUILDING_CODE |
XXX |
VARCHAR2 |
15 |
FACILITY_ASSET_TYPE |
XXX |
VARCHAR2 |
15 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PARK_STU_RES_CONTR_ST_KEY |
XXX |
VARCHAR2 |
1 |
ROOM_CODE |
XXX |
VARCHAR2 |
15 |
STU_RESIDENT_FSILG_INDICATOR |
XXX |
VARCHAR2 |
1 |
STU_RES_CONTR_END_DATE |
XXX |
DATE |
|
STU_RES_CONTR_START_DATE |
XXX |
DATE |
|
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 |
15 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |