- DATA VIEW NAME
- HOUS_MOVE_IN
- OVERVIEW
- Contains move in dates for assigned residents.
- LOAD FREQUENCY
- The data is replaced every night.
- DATA CUSTODIAN
- University Housing
Contact: Brian Ward - AUTHORIZATION
- You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to the InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 7/2010 – New view created.
02/2012 – Custodian Change c4j. - DATA FORMATS
- Key fields are identified with an asterisk(*)
- The codes following the field names in this document define the field. The different types are:
Char: Character data
Number: Numeric fields will be null if no data is available.
Date: This data type allows the date to be represented in various formats and date related functions to be used against the field. The formats (i.e. 19980203, 10-jun-98) and functions available vary based on your query tool.
| Column Name | Format | Description |
|---|---|---|
| PERSON_ID | NUMBER 10 | Unique Identifier for a person. |
| VARCHAR2 50 | Term/academic year description. | |
| CAMPUS_ID | VARCHAR2 10 | Campus ID on the Integrated Student Information System. |
| PERSON_NAME | VARCHAR2 50 | Full name in following format: last, first, middle. |
| MOVE_IN_DATE | DATE | The earliest date that this resident can move into the residence halls. |
| MOVE_IN_SOURCE | VARCHAR2 3 | The sources of the move in data. Valid values: HR – Housing Student Employment PG – Person Group (Early arrival groups). ABS – |
| MOVE_IN_DESCRIPTION | VARCHAR2 103 | This field contains the following possible values: HR – The unit and position PG – The name of the person group. ABS – “Assignment” |
| EXTRACT_DATE_TIME | DATE | The system-generated date when the data was last refreshed. |