- DATA VIEW NAME
- HOUS_ROOM_APARTMENT
- OVERVIEW
- Facility based residence hall and apartment information for University Housing.
- LOAD FREQUENCY
- Data is refreshed nightly.
- 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
- Be sure to identify residence hall or university apartment information individually as data fields can have significant differences between the two areas.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 05/2020 – New view created
- 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_Space_ID | Number | Housing system identifier assigned to a top-level category of room rates. |
| Room_Location | Varchar2(25) | Specific residence hall name or neighborhood/unit for apartments. |
| House | Varchar2(50) | Residence hall naming convention which can consist of a floor, wing, multiple floors, or building based on size of a residence hall. |
| Room_Number | Varchar2(50) | Residence hall room numbering. |
| Floor | Varchar2(30) | Floor designation for a room or apartment. Residence hall values: B (Basement), then 1, 2, 3, etc. Buildings 10 or more stories will have a 01, 02, 03, etc. University apartments values: · 1st floor, 2nd floor, etc. · Townhouse (denotes a unit that may have multiple floors within a singular unit) |
| Room_House_Hall | Varchar2(50) | Residence halls concatenation of room location, house, and room number. |
| Bed_Space | Varchar2(30) | Specific space in a residence hall room or university apartment bedroom. Carries an a,b,c, or d designation based on capacity. |
| Room_Type | Varchar2(25) | Type of room or apartment based on designated capacity. Residence halls values: · Single · Double · Triple · Quad · Staff Qualifiers can exist on these rooms due to size (Type A/B) or having an in-room bathroom. Bathroom, kitchen, laundry, study, and trash/recycle would all have a zero capacity. University apartments values: · 1 Bedroom · 2 Bedroom · 3 Bedroom Qualifiers can exist on these apartments including whether it is furnished, contains laundry, type of unit, or designation for staff. |
| Room_Type_Capacity | Number | Capacity for a given room type. Used for residence halls only. Values include 0,1,2,3,4. |
| Room_Space_Street | Varchar2(60) | 1st line of address for university apartment spaces. Room_House_Hall field serves as first address line for residence halls spaces. |
| Room_Space_Street_2 | Varchar2(60) | Concatenation of city, state, and zip code for all university housing spaces addresses. |
| Floor_Suite | Varchar2(25) | Residence halls floor, wing, or cluster designation. University apartments individual apartment unit designation. |
| Section | Varchar2(25) | Designated section of a residence hall or apartment unit. For the residence halls, this will be a concatenated list of hall house. Singular hall names are buildings without house designations or public/basement areas of buildings. For university apartments, this is a concatenation of neighborhood and apartment building unit. |
| Room_Space_Type | Varchar2(12) | Housing system designation of use for a particular space in a room, apartment, or common area. Values include: · Admin Space used or held for administrative purposes. · Bed Bed space available for assigning. · BedClosed Bed space not available for assigning. · Public Spaces designated as open to public. · Shared Space shared among residents in a room or apartment. |
| Bed_Capacity | Number | Available assignment capacity for a bed space. Values are 0 and 1. |
| Gender_Type | Varchar2(25) | Housing system gender designation for a room or apartment. Values include: · Coed Room or apartment has no gender restrictions. · DynamicGender First person to select or assigned to a room sets the gender designation. · Female · Male |
| Apt_Min_Occupancy | Varchar2(50) | Minimum possible occupancy of an apartment. Values are 1 and 3. |
| Apt_Max_Occupancy | Varchar2(50) | Maximum possible occupancy of an apartment. Values are 2, 3, 4, 5, 6, 7, & 8. |
| Room_Location_Area | Varchar2(50) | Highest level in room hierarchy that represents a geographic area within campus. Values include: · Eagle Heights · Harvey Street · Residence Hals · University Apartments · University House |
| Extract_Date_Time | Date | The date and time these data were extracted. Format: YYYYMMDD HH24:MI:SS |