- DATA VIEW NAME
- HOUS_DINING
- OVERVIEW
- The view details information on applicant/resident selected dining tier plans.
- 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 and meal plan status is critical.
- 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_Meal_ID | Number | Housing system identifier assigned to each type of dining plan option offered. |
| 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. Values include: · Fall Semester 20XX · Spring Semester 20XX · Spring Semester Only 20XX Used only for students entering the University for the spring. · Winter Break 20XX-XX (N/A for Dining) |
| Meal_Plan | Varchar2(200) | Applicant selected plan for a given term session. Values include: · No Dining Plan Students granted an exemption or continuing students who choose not to have a plan. · Tier 1 · Tier 2 · Tier 3 |
| Meal_Status | Varchar2(50) | The status of a resident’s meal plan for a given term. Values include: · Cancelled Change in meal plan tier or cancelled contract. · History Meal plan from a previous term. · Upcoming Meal plan for the current term. |
| Allowance | Number | Meal plan dollars allocated depending on plan selection. |
| Food_Allergies | Varchar2(1000) | Applicant selected Y/N indicator regarding food allergies. |
| Religious_Preferences | Varchar2(1000) | Applicant selected Y/N indicator regarding religious dietary preferences. |
| Meal_Plan_Balance | Number | Running balance of resident’s WiscCard Dining Account (accurate as of the night before). |
| Extract_Date_Time | Date | The date and time these data were extracted. Format: YYYYMMDD HH24:MI:SS |