- DATA VIEW NAME
- HOUS_RATES
- OVERVIEW
- The view contains details on rates for the residence halls including room charges, dining meal plan tiers, and learning community fees.
- 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 in conjunction with desired rate or rate combinations in the rate type field is critical. The ‘Rate_Type’ field produces the same results as the ‘Room’, ‘Dining’, and ‘LC’ fields selected individually. Use of the ‘Room’, ‘Dining’, or ‘LC’ fields requires a (Y/N) value to be selected in the remaining two fields to work properly.
- 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_Rate_ID | Number | Housing system identifier assigned to a top-level category of room rates. |
| Room_Location | Varchar2(200) | Specific residence hall name. |
| Room_Type | Varchar2(200) | Type of room based on designated capacity. Values include: · Single · Double · Triple · Quad · Staff Qualifiers can exist on these rooms due to size (Type A/B) or having an in-room bathroom. |
| Tier_Type | Varchar2(50) | Dining tiers level 1,2, and 3. |
| Lc_Type | Varchar2(50) | List of learning communities in the residence halls. |
| Fall_Semester | Number | Fall semester charges for a selected academic year term. |
| Spring_Semester | Number | Spring semester charges for a selected academic year term. |
| Academic_Year | Number | Academic year charges for a selected term. |
| Num_Spaces | Number | Number of spaces associated with a room type and rate. |
| Term | Varchar2(50) | Housing system code defining application period. Term description is equivalent to term in housing system. Values include: · Academic Year 20XX-XX · Summer 20XX |
| Rate_Type | Varchar2(31) | Singular or combined rates for room charges, dining tier plans, or learning community fees. |
| Room | Char (1) | Y/N indicator whether to include room charges. |
| Dining | Char (1) | Y/N indicator whether to include dining charges. |
| Lc | Char (1) | Y/N indicator whether to include learning community charges. |
| Extract_Date_Time | Date | The date and time these data were extracted. Format: YYYYMMDD HH24:MI:SS |