PARK ELIGIBLE RESIDENT Table
View exposing resident parking eligibility records including residential contract dates, building and room attributes, facility indicators, and status dates.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVITY_DATE |
Date associated with activity. |
DATE |
|
ASSIGNMENT_STATUS_DATE |
Date associated with assignment status. |
DATE |
|
BUILDING_CODE |
Code identifying building. |
VARCHAR2 |
15 |
FACILITY_ASSET_TYPE |
Facility asset type associated with the record. |
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 |
Surrogate key identifying the park stu res contr st. |
VARCHAR2 |
1 |
ROOM_CODE |
Code identifying room. |
VARCHAR2 |
15 |
STU_RESIDENT_FSILG_INDICATOR |
Indicator identifying whether stu resident fsilg (Y/N). |
VARCHAR2 |
1 |
STU_RES_CONTR_END_DATE |
Date associated with stu res contr end. |
DATE |
|
STU_RES_CONTR_START_DATE |
Date associated with stu res contr start. |
DATE |
|
TERM_CODE |
Term code associated with the record. |
VARCHAR2 |
15 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |