- DATA VIEW NAME
- HOUS_ASSIGNMENT_HISTORY_OLD
- OVERVIEW
- Housing assignment data. There is one record per assignment. A student may have only one assignment for a given date. Always query this data using date parameters.
- 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
- 01/2004 – New view created.
02/2012 – Custodian Change
01/2013 – Added fields Added_Source, Added_Logonid, Added_Datetime
09/2013 – Added field Assignment_Action
01/2015 – Updated preferred name description s8w
03/2015 – Added fields Expire_Datetime, Reserve_Space_Ind s8w . - DATA FORMATS
- Primary Key Columns are identified with an asterisk(*)
- Alphanumeric Data
- VARCHAR2( N) (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or ‘ABC’ or ‘A’ - Numeric Data
- NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) = format for numbers with decimal positions.
X = total number of digits
Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12 - Date
- DATE – Date can be in various formats. Date functions available with your query tool can be used to format the date.
Examples: DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)
| Column Name | Format | Description |
|---|---|---|
| *ASSIGNMENT_ID | NUMBER(10) | Identifier for an assignment. |
| ACADEMIC_YEAR | VARCHAR2(50) | Identifier for Term/Academic Year. |
| ROOM_ID | NUMBER(10) | Identifier for a room. |
| PERSON_ID | NUMBER(10) | Identifier for a person. |
| CAMPUS_ID | VARCHAR2(10) | Campus ID on the Integrated Student Information System. |
| PERSON_NAME | VARCHAR2(50) | Full preferred name in the following format: last, first middle. |
| ACTIVE_INDICATOR | VARCHAR2(1) | Active indicator of an assignment. A value of ‘N’ indicates the resident never lived in the room. A value of ‘Y’ indicates that the resident lived in the room for the duration of the assignment. |
| ROOM_HOUSE_HALL | VARCHAR2(50) | The room number, house and/or hall for the room. Example: 301 Noyes Adams |
| ASSIGNMENT_BEGIN_DATE | DATE | Date assignment begins. |
| ASSIGNMENT_END_DATE | DATE | Date assignment ends. |
| ASSIGNMENT_ACTION | VARCHAR2(14) | |
| EXPIRE_DATETIME | DATE | The date and time that the assignment will expire if contracting is not completed. |
| RESERVE_SPACE_IND | VARCHAR2(1) | Indicates if that this assignment is reserving a space in the room. Typically used for returning residents requesting to live with new residents. |
| ADDED_SOURCE | VARCHAR2(30) | |
| ADDED_LOGONID | VARCHAR2(20) | |
| ADDED_DATETIME | DATE | |
| LAST_MODIFIED_LOGONID | VARCHAR2(20) | The logonid of the person who last modified the assignment. |
| LAST_MODIFIED_DATETIME | DATE | The date and time of the person who last modified the assignment. |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted.
Format : YYYYMMDD HH24:MI:SS |