- DATA VIEW NAME
- HOUS_ROOM_OLD
- OVERVIEW
- Contains information about the smallest unit of housing. Includes rooms in UW Housing buildings used for assignments such as residence hall rooms and lounges. Rooms used for housing from external housing sources are included. Example: rooms in Humphrey. Apartments used for single students are also included. Example: Harvey St.
- LOAD FREQUENCY
- Replaced up to once a night depending on data changes in the housing system.
- HISTORY
- Contains the room data for the current term/academic year as well as for any future implemented term. Does not contain room data for the past term/academic year.
- 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
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 06/2001 – New view created.
02/2012 – Custodian Change c4j. - 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 |
|---|---|---|
| *ROOM_ID | Number (10) | Unique identifier for a room. |
| *ACADEMIC_YEAR | Number (10) | Identifier for term/academic year. |
| ACADEMIC_DESCRIPTION | Varchar2 (50) | Description of this term/academic year. |
| BUILDING | Varchar2 (50) | Name of physical building. Example: Holt. |
| ROOM_HOUSE_HALL | Varchar2 (50) | The room number, house and/or hall for the room. Example: 301 Noyes Adams |
| STREET_ADDRESS | Varchar2 (30) | The postal street address for the room’s building. |
| CITY | Varchar2 (30) | Name of the City. |
| STATE | Varchar2 (2) | Two-letter postal code for the state. Example: ‘WI’ = Wisconsin. Verified by the ATCOMMON.US_STATE table. |
| ZIPCODE | Varchar2 (10) | The nine-digit zip code. Note that the dash is part of the data. |
| CITY_STATE_ZIP | Varchar2 (46) | The City, State and zip formatted in one format: ‘City, ST 99999-9999’ or ‘City, ST 99999’ |
| FLOOR | Varchar2 (2) | The number or code of the floor. Valid Values are: B = Basement 1 – 15, NA = Not Applicable. For example, floor numbers are not used in Elizabeth Waters. |
| ROOM_NUMBER | Varchar2 (6) | Number associated with this room. Usually attached to the door or entrance to the room. |
| HOUSE | Varchar2 (30) | Name of house for this room. A house is a group of rooms located together. A hall may contain multiple houses. Example: Noyes. |
| HALL | Varchar2 (30) | Name of hall for this room. Example: Adams. |
| CURRENT_ROOM_TYPE | Varchar2 (50) | Description of the room type. A room’s type may change during the term/academic year.
Contains the current date for the current term/academic year. Contains the value for the first date of the term/academic year for future terms. Example: Double Regular. |
| CURRENT_GENDER | Varchar2 (1) | The gender specified for this room.
Contains the current gender for the current term/academic year. Contains the first gender of the term/academic year for future terms. |
| CURRENT_PHONE_1 | Varchar2 (8) | The room’s primary phone number.
Contains the current phone number for the current term/academic year. Contains the first phone number of the term/academic year for future terms. |
| CURRENT_PHONE_2 | Varchar2 (8) | The rooms optional secondary phone number.
Contains the current phone number for the current term/academic year Contains the first phone number of the term/academic year for future terms. |
| ROOM_RESERVE_REASON | Varchar2 ( 50) | Not being used at this time. |
| CURRENT_PROGRAM_CAPACITY | Number(2) | The number of people that may be assigned to the room. Contains the current program capacity for the current term/academic year. Contains the first program capacity of the term/academic year for future terms. |
| DESIGN_CAPACITY | Number (2) | Capacity of room at the time it was designed. |
| SQUARE_FOOTAGE | Varchar2 (4) | Square footage of room determined by length and width of outside walls. Includes closets and other non-living space within the room. |
| CARPET_LENGTH_WIDTH | Varchar2 (11) | Equivalent living spaces without closet dimensions. |
| NUMBER_OF_WINDOWS | Number (2) | The number of windows in the room. |
| EXTRACT_DATE_TIME | Date | The system-generated date when the data was last refreshed. |