- DATA VIEW NAME
- HOUS_BOOKING
- OVERVIEW
- The view contains details on assignment information for residence halls and university apartments.
- 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
- Selection of a term session is critical since assignment information for both the residence halls and university apartments are contained in this view. If looking at specific room information for residence halls, selection of House is critical due to certain halls having multiple rooms with the same number.
- 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 |
| *Booking_ID | Number | Housing system identifier assigned to each unique room or apartment assignment. |
| Room_Space_ID | Number | Housing system identifier assigned to each unique space om room or apartment. |
| Entry_ID | Number | Housing system identifier assigned to each unique individual in the system. |
| Campus_ID | Varchar2(11) | ID number assigned to SIS to be used by student. |
| Emplid | Varchar2(11) | SIS personal identifier. The ID can never be changed throughout the individual’s relationship with the University. |
| First_Name | Varchar2(40) | Applicant’s or resident’s legal first name. |
| Last_Name | Varchar2(40) | Applicant’s or resident’s legal last name. |
| Preferred_Name | Varchar2(40) | Applicant’s or resident’s preferred first name. |
| Term_Session | Varchar2(50) | Term to which a room or apartment is assigned. Residence hall terms correspond to either the University’s academic calendar or a Housing defined period. University apartment terms are for a lease year. Residence hall values: · Fall Semester 20XX · Spring Semester 20XX · Spring Semester Only 20XX Used only for students entering the University for the spring. · Summer Term 20XX · Winter Break 20XX-XX University apartments values: · Eagle Heights/University Houses Lease 20XX-XX · Harvey Street Lease 20XX-XX |
| Contract_Date_Start | Date | Date which a booking begins for charging/billing purposes. |
| Contract_Date_End | Date | Date which a booking ends for charging/billing purposes. |
| Room_Rate_ID | Number | Housing system identifier assigned to each unique room rate. |
| 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_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. |
| Room_House_Hall | Varchar2(100) | Residence halls concatenation of room location, house, and room number. |
| Room_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. Housing system identifies this as “bed space” in the booking fields. |
| Booking_Status | Varchar2(20) | Status of a room or apartment assignment. Values include: · Cancelled Booking cancelled prior to resident moving in. · History Booking for a resident that involves a checkout due to a cancellation or full completion of a given session as defined in the housing system. · In Room Currently resides in room or apartment. · Reserved Booking held for a resident who has not checked in. · Tentative Internal status used for assignment planning. |
| 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 |
| Check_In_Date | Date | Anticipated check-in date for a booking in reserved status; actual date is recorded once a student moves to in-room status. |
| Check_Out_Date | Date | Anticipated check-out date for a booking status of in room; actual date is recorded once a student moves out and status changes to history. |
| Start_Booking_Reason | Varchar2(25) | Reason for starting a new booking status occurring within a given term session. Residence hall reasons typically reflect room changes or cancellations. University apartment reasons are connected to terminations, transfers, or changes in roommate status. Residence halls values: · Cancellation · Reinstate · Room Change · Room Change (EOS) · Room Swap (Start) · Session Change · Spring-Only Assignment · STS Placement University apartments values: · UA-Cancelled termination · UA-Extension · UA-Renewal · UA-Roommate Add · UA-Roommate Release · UA-Termination · UA-Transfer · UA-Transfer Termination |
| End_Booking_Reason | Varchar2(25) | Reason for ending a booking status occurring within a given term session. Residence hall reasons typically reflect room changes or cancellations. University apartment reasons are connected to terminations, transfers, or changes in roommate status. Residence halls values: · Cancellation · Cancellation (Btwn Sem) · Cancellation (EOS) · Reinstate · Room Change · Room Change (EOS) · Room Change (Inactivated) · Room Swap (End) · STS Checkout University apartments values: · UA-Cancelled termination · UA-Renewal · UA-Roommate Add · UA-Roommate Release · UA-Termination · UA-Transfer · UA-Transfer Termination |
| 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 Houses |
| Extract_Date_Time | Date | The date and time these data were extracted. Format: YYYYMMDD HH24:MI:SS |