- DATA VIEW NAME
- HOUS_CONTRACT
- OVERVIEW
- A legal document that defines the terms and conditions of occupancy for a specific time period between UW Housing and a person
- 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
- 03/2001 – New view created
01/2002 – Added Session_Descr
03/2009 – Added Contract_method, Online_checklist, Online_terms and conditions, Online_signature, Online_timestamp c4j
05/2010 – Added Requested_deposit_amount, Offered_room_type, Deficit_deposit_ind c4j
02/2012 – Custodian Change c4j.
01/2013 – Removed ‘Rooms_online_access_time and Length of Stay’ fields and added ‘Published_date_due’ field c4j.
06/2014 – Removed Offered_room_type’ field s8w
01/2015 – Updated preferred name description s8w. - 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 |
|---|---|---|
| *CONTRACT_ID | NUMBER 10 | Unique system-generated identifier for a housing contract. |
| APPLICATION_ID | NUMBER 10 | Identifier for an application. |
| ACADEMIC_YEAR | VARCHAR2 50 | Term/academic year description. Example: Academic Year 2002-2003 |
| SESSION_DESCR | VARCHAR2 50 | An “Academic Year” or Housing term may contain multiple “sessions”. For example, Academic Year 2002-03 contains two sessions: “Academic Year” and “Spring Only”. Summer has motile housing sessions that generally correspond with the various summer class sessions (i.e. “Eight Week Summer Session’). |
| 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 following format: last, first middle |
| RESIDENCY | VARCHAR2 2 | Residency code. Values are: R = Wisconsin Resident, N = Non-Wisconsin Resident, I = International Resident |
| 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 |
| DIRECTORY_WITHHOLD_IND | VARCHAR2 1 | Indicates person requested not to be included in Housing directory. Values are: Y=Yes, N=No. |
| CONTRACT_TYPE | VARCHAR2 1 | Contract type code. Values are: U = Undergraduate, G = Graduate. |
| CURRENT_CONTRACT_STATUS | VARCHAR2 50 | Description for this current Contract Status. Values are: Sent, Duplicate, Binding, Pending, Cancelled |
| DATE_FIRST_SENT | DATE | Date UW Housing sent the contract. |
| DATE_DUE | DATE | Most recent due date for the contract. |
| PUBLISHED_DATE_DUE | DATE | |
| DATE_RETURNED | DATE | Date UW Housing received the contract. |
| DATE_CANCELLED | DATE | Date the Contract Cancelled. Populated only if cancelled. |
| CANCEL_REASON | VARCHAR2 50 | Description of this cancellation. |
| NEW_OR_RETURNING_RESIDENT | VARCHAR2 1 | New or returning resident code. Values are: N = New, R = Returning. |
| DEFICIT_DEPOSIT_IND | VARCHAR2 1 | Value is ‘Y’ if the student has a binding contract and does not have the full deposit required. Value is ‘N’ otherwise. |
| CONTRACT_METHOD | VARCHAR2 6 | Indicates the method used to contract with University Housing Residence Halls. Valid values: Paper On-line |
| ONLINE_CHECKLIST | VARCHAR2 1 | Indicates if student checked the checkbox during the online contracting process. Valid values: Y-Yes N-No null |
| ONLINE_TERMS_AND_CONDITIONS | VARCHAR2 8 | Indicates if student agreed or disagreed to the terms and conditions of the contract during the online contracting process.. Valid values: Agree Disagree null |
| ONLINE_SIGNATURE | VARCHAR2 1 | Indicates if a student entered a correct birthdate and campus id during the online contracting process. Valid values: Y-Yes N-No null |
| ONLINE_TIMESTAMP | DATE | Date and time during online contracting process when the student (1) disagrees to the terms or (2) enters an invalid birthdate and campus id or (3) enters a correct birthdate and campus id. |
| REQUESTED_DEPOSIT_AMOUNT | NUMBER 8 | The deposit amount requested for online contracting. |
| EXTRACT_DATE_TIME | DATE | The system-generated date when the data was last refreshed. |