Skip to Main Content

Housing

Extract StarRez Demographic File


Create Demographic File extract for StarRez (Housing System). All active students, plus members of the groups ELP students and Housing Affiliates are sent.

  

 
Students cannot apply for Housing or access the StarRez system until they have been sent in this file.
 
Technical Notes:   

 Automic Chain 

 NSTU_HOUSING 

 Job 

 WSL5045

 Package 

 wkslrez

 Procedure 

 p_starrez_feed

 


Housing Contract Information Load


Load Housing contract information from Housing loaded into the temporary table NFVIEW.WTBTHSE each day. 


All students are recorded in WTSLCON by term. 

 

 

 Technical Notes:  

Automic Chain

NSTU_HOUSING

Job

WSL5010

Package

wksgsts

Procedure

p_housing_contracts

 



Load StarRez Booking File


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.

 

   

Technical Notes:    

  AppWorx Chain  

  NSTU_HOUSING  

  Job  

  WSL5030

  Package  

 

  Procedure  

 



Load StarRez Contract File


Run SQLLDR to load contract file from StarRez into temporary table WTBLCON.

 
Technical Notes:   

 Automic Chain 

 NSTU_HOUSING 

 Job 

 WSL5050

 Package 

 

 Procedure 

 



Meal Memberships Information Load


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.

 

 Technical Notes:  

AppWorx Chain

NSTU_OVERALLL_STUDENT

Job

WSL5020

Package

wksgsts

Procedure

p_mealplans



Maintain FTIC Housing Requirements


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.

UNF students 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.

 

 Technical Notes:  

AppWorx Chain

NSTU_HOUSING

Job

WSL5100

Package

wksgsts

Procedure

p_housing_requirements



Process StarRez Data


Process data loaded from StarRez booking file. Data in the temporary table WTBLREZ are processed into the permanent table WTSLREZ.

 

 

 Technical Notes:  

Automic Chain

NSTU_HOUSING

Job

WSL5025

Package

wksgsts

Procedure

p_process_starrrez



Retrieve StarRez Booking File


Retrieves the latest StarRez Booking file from the StarRez server and places it on Hood.
 
The process uses SFTP via Owl.
 
Only the file for the current date is retrieved. The file name at StarRez is StarRezBookingExport_YYYYMMDD.txt. This is changed to starrez_booking.txt on Hood.

 

   

Technical Notes:    

  Automic Chain  

  NSTU_HOUSING

  Job  

  WSL5035

  Package  

 

  Procedure  

 



Retrieve StarRez Contract File


Retrieves the latest StarRez Contract file from the StarRez server and places it on Hood.
 
The process uses SFTP via Owl.
 
The file name at StarRez is loStarRezContractExport_YYYYMMDD.txt. This is changed to starrez_contract.txt on Hood.
 
Technical Notes:   

 Automic Chain 

 NSTU_HOUSING 

 Job 

 WSL5055

 Package 

 

 Procedure 

 



Send StarRez Demographic File


The StarRez Demographic Export file is sent from Hood to the StarRez server via SFTP using OWL.

The file is named: DemographicImportBanner.txt

Technical Notes:   

 Automic Chain 

 NSTU_HOUSING 

 Job 

 WSL5040

 Package 

 

 Procedure