Load Housing contract information from Housing loaded into the temporary table NFVIEW.WTBTHSE each day.
All students are recorded in WTSLCON by term.
Load the StarRez Booking file into a temporary table in Banner using SQLLDR.
The file contains all students with a housing contract or who are living in a dorm.
Run SQLLDR to load contract file from StarRez into temporary table WTBLCON.
Load meal memberships information from a Chartwells file sent to Cheetah each evening. All those with a meal memberships are recorded in WTSLCMP by term.
In support of the “First Year Experience” program, this process monitors active FTIC students who are admitted summer 2012 and after and determine the housing and meal plan requirements based on the initial term of admission.
who begin in the summer term are required to live in campus housing in the summer, fall and spring terms. Students who begin the fall term will need to live in on-campus housing during the fall and spring terms. Students enrolling in the spring term will need to live on campus during that first spring term and during the next term the student is enrolled (summer or fall).
The status for each student and term is recorded in the housing requirement tables (WTSLHRQ and WTSLHRT) and is viewable on the Mandatory Housing page in Administrative Applications.
The process then checks against any approved exemptions in the Housing and Meal Plan Exemption system and applied them to the students’ records. Information from Housing and Chartwells about future contract and plan purchases is also checked and applied to the records. Finally, information from the Housing residence file is checked to mark the requirement as completed for the term. Once all terms have been completed for a student, the student has completed the “First Year Experience” and the student’s overall status is marked as completed.
Process data loaded from StarRez booking file. Data in the temporary table WTBLREZ are processed into the permanent table WTSLREZ.
Copyright © 2018 University of North Florida1 UNF Drive | Jacksonville, FL 32224 | Phone: (904) 620-1000
Regulations | Consumer InformationWebsite Accessibility |