- DATA VIEW NAME
- HOUS_RESIDENT
- 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.
- HISTORY
- The data will contain resident data for current housing terms, future terms and past terms that ended less than one year ago. The data will not contain historical resident data for past terms that ended more than one year ago.
- DATA CUSTODIAN
- University Housing: 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 - There are no special considerations.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- C4j – Added Limited_Visitation_Ind. 1/09
C4j – Added Directory_Withhold_Ind 10/10
C4j – Custodian Change 02/12
C4j – Added fields – ‘Roommate_campus_ID, Roommate_name, Added_source, Added_logonid, Added_datetime’ and removed fields ‘Limited_visitation_ind’ 01/2013
S8w – Updated preferred name description 01/2015. - 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. |
| PERSON_ID | NUMBER(10) | Identifier for a person.. |
| ACADEMIC_YEAR | NUMBER(10) | Identifier for Term/academic year. |
| ACADEMIC_YEAR_DESCRIPTION | VARCHAR2 (50) | Term/academic year description. Example: Academic Year 2002-2003 |
| ROOM_ID | NUMBER (10) | Identifier for a room. |
| CAMPUS_ID | VARCHAR2 (10) | Campus ID on the Integrated Student Information System. |
| PERSON_NAME | VARCHAR2 (50) | Full preferred name in following format: last, first middle |
| FERPA | VARCHAR2 (1) | Do not release information about this person “Y” = Do not release Information |
| ACADEMIC_LEVEL | VARCHAR2 (3) | The student’s academic level. Values are: 05 = Spcl, Guest 10 = Freshman 20 = Sophomore 30 = Junior 40 = Senior GR = Graduate P1 = Professional Year 1 P2 = Professional Year 2 P3 = Professional Year 3 P4 = Professional Year 4 |
| ACADEMIC_LEVEL_DESCR | VARCHAR2 (20) | The academic level description. |
| RESIDENCY_CODE | VARCHAR2 (2) | Residency code. Values are: R = Wisconsin Resident, N = Non-Wisconsin Resident, I = International Resident |
| RESIDENCY_DESCR | VARCHAR2 (20) | Description of the Residency code. |
| NEW_OR_RETURNING_RESIDENT | VARCHAR2 (1) | New or returning resident code. Values are: N = New, R = Returning. |
| CONTRACT_TYPE | VARCHAR2 (1) | Contract type code. Values are: U = Undergraduate, G = Graduate. |
| ASSIGNMENT_BEGIN_DATE | Date | Date assignment begins. |
| ASSIGNMENT_END_DATE | Date | Date assignment ends. |
| ROOM_HOUSE_HALL | VARCHAR2 (50) | The room number, house and/or hall for the room. Example: 301 Noyes Adams |
| HALL_HOUSE_ROOM | VARCHAR2 (50) | The hall and/or house, room number for the room. Example: Adams Noyes 301 Useful for sorting residents by hall. |
| DIRECTORY_WITHHOLD_IND | VARCHAR2 (1) | Indicates what the resident selected for directory withhold on their preferences form. Values are: Y N |
| ROOMMATE_CAMPUS_ID | VARCHAR2 (10) | |
| ROOMMATE_NAME | VARCHAR2 (50) | |
| ADDED_SOURCE | VARCHAR2 (30) | |
| ADDED_LOGONID | VARCHAR2 (20) | |
| ADDED_DATETIME | Date | |
| EXTRACT_DATE_TIME | Date | The system-generated date when the data was last refreshed. |