- DATA VIEW NAME
- HOUS_RH_APPLICATION_CUST
- OVERVIEW
- The view contains supplemental custom fields attached to an application. This view is for internal Housing use only.
- 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
- The view should be used in conjunction with the HOUS_APPLICATION view. Only contains information for residence hall applications.
- 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 |
| *Entry_Application_ID | Number | Housing system identifier assigned to each unique application. |
| 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) | Student’s or resident’s legal first name. |
| Last_Name | Varchar2(40) | Student’s or resident’s legal last name. |
| Preferred_Name | Varchar2(40) | Student’s or resident’s preferred first name. |
| Term_Description | Varchar2(40) | Housing system code defining application period. Term description is equivalent to term in housing system. Values include: · Academic Year 20XX-XX · Spring 20XX · Summer 20XX · Winter Break 20XX-XX |
| Air_Cond_Need | Varchar2(100) | Student entered Y/N indicator if an air conditioner is needed in their room. |
| Notice_Of_Intent | Varchar2(100) | Continuing student selection of whether they plan to return for housing for a subsequent year. Values include: · Yes · Maybe · No |
| Continue_Option | Varchar2(100) | Continuing student selected option for picking a room. Values include: · Browse Available Rooms · Same Room Selection |
| Reason_Not_Returning | Varchar2(100) | Continuing student reason for not returning to University Housing. Values include: · ABROAD Student plans to study abroad. · GRADUATE Student is graduating. · OFFCAMPUS Student plans to live off-campus. · OTHER Other reason not listed. · WITHDRAWAL Student plans to withdraw from the University. |
| Early_Arrival_Date | Date | Student selected fall transition arrival date. |
| Fall_Transition_Override | Varchar2(1) | Staff entered Y/N indicator granting student permission to partake in fall transition housing. |
| Waiting_List_Interest | Varchar2(100) | Student selected Y/N indicator of interest of being on a waiting list for a housing contract. |
| Waiting_List_Date | Date | Date student requested to be a on a waiting list for a housing contract. |
| Winter_Break_Employee | Varchar2(100) | Student selected housing department they are working for over the winter break period. Values correspond to departments in Housing. |
| Reached_On_Wait_List | Varchar2(1) | Staff entered Y/N indicator if student on a waiting list has been reached for a housing contract offer, |
| Summer_Plans | Varchar2(100) | Student selected reason for needing summer term housing. Values include: · ENROLLED Student is enrolling for summer term courses. · EMPLOYEE Student is a summer University Housing employee. · EXTENDED Student needs to stay beyond the end of their contract term. |
| Summer_Progam_Affiliation | Varchar2(100) | Student selected summer term program with which they are affiliated. |
| Summer_Roommate_Request | Varchar2(100) | Student selected preferred roommate for summer term housing. |
| Summer_Room_Type_Request | Varchar2(100) | Student selected preferred room type. Values include: · Double · Single · Triple |
| Extract_Date_Time | Date | The date and time these data were extracted. Format: YYYYMMDD HH24:MI:SS |