- DATA VIEW NAME
- HOUS_ENTRY
- OVERVIEW
- The view contains demographic and address information for all entries in the housing system.
- 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
- “Privacy_Flag” is a FERPA indicator and it is the users responsibility to check this indicator if the information is being considered for release.
- 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_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. |
| Photo_ID | Varchar2(10) | Number printed on the official UW-Madison identification card (Wiscard). |
| Priavacy_Flag | Varchar2(1) | Restricted information indicator for student. Values include: · Y = information restricted · N = information not restricted |
| 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. |
| Date_Of_Birth | Date | Student’s or resident’s date of birth. |
| Age | Number | Student’s or resident’s age as of today’s date. |
| Gender | Varchar2(10) | Student’s or resident’s sex classification; field can be altered in Housing system. Values include: · Female · Male · Neutral · Other · Unknown |
| Birth_Gender | Varchar2(10) | Student’s or resident’s sex classification. Values include: · Female · Male · Other · Unknown |
| Classification | Varchar2(50) | Resident’s classification based on admission/enrollment or housing derived status. Values include: · Continuing · First Year · Other Undergrad · Special · Transfer · University Apartments |
| Entry_Status | Varchar2(20) | The computed status of an entry based on last application and/or booking status. Values include: · Application · 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. |
| Home_Street | Varchar2(80) | First line of home address |
| Home_Street_2 | Varchar2(80) | Second line of home address |
| Home_City | Varchar2(60) | City of home address |
| Home_State | Varchar2(60) | State of home address |
| Home_Zip_Code | Varchar2(15) | Zip code of home address |
| Home_Country | Varchar2(50) | Name of home country |
| Home_Phone | Varchar2(25) | Telephone number for home address |
| Home_Phone_Mobile_Cell | Varchar2(25) | Mobile/cell phone number for home address |
| Varchar2(100) | Primarily email address for resident, usually wisc.edu for students; manual entry for other apartment residents. | |
| Alt_Email | Varchar2(100) | Email address given by applicant to the University; undergraduates only. |
| Mail_Street | Varchar2(80) | First line of mailing address |
| Mail_Street_2 | Varchar2(80) | Second line of mailing address |
| Mail_City | Varchar2(60) | City of mailing address |
| Mail_State | Varchar2(60) | State of mailing address |
| Mail_Zip_Code | Varchar2(15) | Zip code of mailing address |
| Emergency_Name | Varchar2(80) | Name of resident’s emergency contact. For students, it is the primary emergency contact from SIS; manually entered for other apartment residents. |
| Emergency_Relationship | Varchar2(50) | Relationship of emergency contact to resident. Values include: · Child · Friend · Grandparent · Other · Other Relative · Parent · Sibling · Spouse · Step Parent |
| Emergency_Phone | Varchar2(25) | Phone number of resident’s emergency contact. |
| Contact1_Name | Varchar2(80) | Student identified first individual to receive relevant housing information; not required. |
| Contact1_Email | Varchar2(100) | Email of student identified first contact. |
| Contact1_Relationship | Varchar2(50) | Relationship to student of first contact. |
| Contact2_Name | Varchar2(80) | Student identified second individual to receive relevant housing information; not required. |
| Contact2_Email | Varchar2(100) | Email of student identified second contact. |
| Contact2_Relationship | Varchar2(50) | Relationship to student of second contact. |
| Extract_Date_Time | Date | The date and time these data were extracted. Format: YYYYMMDD HH24:MI:SS |