- DATA VIEW NAME
- HOUS_CANCELLATION_OLD
- OVERVIEW
- End of contractual obligation with Housing prior to normal end of contract date. Contracts can be cancelled because of a release, a termination, or a buy-out.
- LOAD FREQUENCY
- The data is replaced every night.
- 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
- 02/2003 – New view created.
02/2012 – Custodian Change c4j
01/2015 – Updated preferred name description 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 |
|---|---|---|
| *CANCELLATION_ID | NUMBER(10) | Unique system-generated identifier for a housing contract cancellation. |
| CONTRACT_ID | NUMBER(10) | Identifier for a contract. |
| CANCELLATION_SEQ | NUMBER(10) | Sequence number for this cancellation data. Increased by one each time a cancellation is adjusted. Cancellation data is stored historically. The cancellation record with the highest sequence for a cancellation is the data that is current. |
| LATEST_ROOM_ID | NUMBER(10) | Identifier for the room that this person was last assigned to. May be joined to Hous_Room view. |
| ACADEMIC_YEAR | VARCHAR(50) | Term/academic year description. Example: Academic Year 2002-2003 |
| SESSION_DESCR | VARCHAR2(50) | Description of the Housing session. 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 multiple 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 |
| CONTRACT_TYPE | VARCHAR2(1) | Contract type code. Values are: U = Undergraduate, G = Graduate. |
| DATE_RECEIVED | DATE | Date that the contract cancellation was requested by the student or initiated by Housing. |
| DESIRED_END_DATE | DATE | The date that the party requesting the cancellation wants as the contract end date. |
| DECISION_DATE | DATE | Date that the cancellation was approved or denied by UW Housing. |
| DECIDED_BY | VARCHAR2(3) | Initials of the Housing staff who approved or denied the contract cancellation. |
| CONTRACT_END_DATE | DATE | The date that the contract ends. This becomes the final assignment/occupancy date when the cancellation is approved, if the contract_end_date is after the assignment begin date. |
| CHECK_OUT_DATE | DATE | Check out completed date. |
| ACCOUNTING_CLOSE_DATE | DATE | The date that this cancellation was processed by UW Housing accounting. |
| CANCELLATION_STATUS | VARCHAR2(1) | Valid values are: P – Pending A – Approved D – Denied R – Reinstated |
| CANCEL_REASON_DESCR | VARCHAR2(50) | Description of the Cancellation Reason |
| CANCEL_TYPE_DESCR | VARCHAR2(50) | Description of the Cancellation Type. Examples: Release, Termination, Buyout, End of Semester |
| ROW_ENTRY_DTG | DATE | Date/Time that this record was last modified. |
| ROW_ENTRY_LOGONID | VARCHAR2(20) | Logon ID of the person who last modified this record. |
| EXTRACT_DATE_TIME | DATE | The system-generated date when the data was last refreshed. |