Middlebury

StarRez

Overview

StarRez provides the ability to manage and assign housing stock.

Data feeds are provided from Banner for door access codes, demographic information and enrollment (housing eligibility) information.

A data download from StarRez to Banner is available as a job submission process in Banner. This process will push StarRez room assignments into Banner for use by the Active Directory feed, Facility Commander feed and Banner Room Key management forms.

When will demographic data be loaded?

Right now, demographic data will be loaded once a day at 1:30 am ET.

How is the student demographic data population determined?

We use the SYBISTU table as the basis for the demographic data population.  The data is gathered from the baseline Banner student table, but incorporates other datapoints from other Banner tables that are useful for this load.

SYBISTU/SGBSTDN is term-based. What terms are you using to pull records from SYBISTU?

Housing business processes require future term data to assign housing. We use the following calculation to pick up students in future terms.

Current Term Terms used in student demographic pull
Fall (90) Fall (90), Winter (10), Spring (20)
Winter (10) Winter (10), Spring (20), Summer+ (50, 60, 65)
Spring (20) Spring (20), Summer+ (50, 60, 65), Fall (90)
Summer (60) Summer+ (50, 60, 65), Fall (90), Winter (10)

Demographic data push from Banner to StarRez

Persons are inserted or updated by an API (application programming interface) push process using Banner data.

We do not delete persons from StarRez. The Housing office must purge person records as needed.

The concept of a population is to pull in everyone who could be housed.

Population Group Name Business Rules Notes
Students (Undergraduate, Language Schools, School of Environment, Summer Study)

Active Student record in Sybistu and

  • Term is Fall (90), Winter (10) or Spring (20) and Student Type is one of C, E, N, O, R, S, T
  • Term is Summer (60), School of Environment (50) or Summer Study (65) and Student Type is one of B, V or Y.
Non-enrolled DMLs (Doctorate of Modern Languages) Sybistu record exists for a summer term (ends in 60) with Student Type code = V (Visiting) and Student Status code = NE (Not Enrolled)
Long-term Housing Guests Spriden name type = HGST (Housing Guest) Spouses or dependents of language school faculty/staff, but may be other guests as well.
TAs (Teaching Assistants) Employee class = 28
CRDs (Commons Resident Directors) Job Titles starting with the characters "Common Res" or "CRA" Example
Summer Student Employees N/A Summer Student Employees will already be loaded into StarRez as students.
Language School Faculty Faculty member actively employed by Language Schools and working on the Middlebury Campus
Language School Staff Staff member actively employed by Language Schools and working on the Middlebury Campus

Housing Eligibility data PUSH from Banner to StarRez

Housing Eligibility data (also know as enrollment data) is inserted or updated by an API (application programming interface) push process using Banner data from Banner records.

This process sends all valid eligibility (enrollment) data for the terms of interest (see above). If a person does not exist in Star-Rez that is related to a new eligibility (enrollment) record, that person will be created in Star-Rez using only their ID and first/last names. As the demographic data in Banner is then set up for this new person, it will be updated in Star-Rez via the demographic data push process.

Room PIN codes PUSH from Banner to StarRez

PIN codes for rooms are maintained in Banner on an ellucian Self-Service Banner (SSB) web page. When a PIN code is changed on this page a process is triggered to send that updated PIN to Star-Rez via another API (application programming interface) push process.

Room Assignments PULL from Star-Rez to Banner

Room assignments are maintained in Star-Rez. Updates are sent back to Banner via a data extraction process invoked in Star-Rez. That process creates a file that is then imported into Banner through a manual (job submission) process that pulls the data into Banner and updates the appropriate Banner room assignment tables.

A rough step-by-step process is below: A functional description of the Standard Bookings Export Interface (from Star-Rez, updated by Joe) is here:

https://drive.google.com/drive/u/0/folders/0B0pdLD-rtpX1SzhNdThBWjZYZ3M?ths=true 

It outlines what you need to do in Star-Rez to get a file downloaded to your machine. You’ll need to talk with Erin about this and using the ‘star-rez file transfer tool”.

The user guide for the Starrez File Transfer Tool can be found at:

https://starrez.zendesk.com/hc/en-us/articles/206448546-User-Guide-StarRez-Cloud-File-Transfer-Tool

Once you get the file downloaded from star-rez to your local machine.

You’ll then have to move that file to the following folder:

“middfiles/orgs/Dean of the College/Residential Systems Coordinator/BANNER DATA/StarRez Data”

Then you’ll need to log into PPRD (pre-production) INB to test this out. ( https://ssb-dev.ec.middlebury.edu:9002/PPRD/twbkwbis.P_WWWLogin )

The job submission process is called SYPSRBD.

It has two parameters: 1) The full name of the file that you just downloaded from Star-Rez and moved to the middfiles folder above. 2) Audit or update. Audit mode will give you an idea of what’s going to be loaded without changing any data. Update mode will do the actual load.

After this process completes without error, you should be able to see the booking data in Banner.

F A Q

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Q: From: Hall-Kolts, Karin A. Sent: Monday, June 5, 2017 12:05 PM

Erin, Can you remind me of the outcomes of previous conversations we’ve had about the Class and Year fields in the Enrollment Details section of the Enrollment page? I was hoping the Class could be set to pull in the Expected Graduation Term and the Year would pull their Expected GradYear (my notes indicate that both of those fields were on our list of fields to be mapped to StarRez). Also, can you confirm that the Enrollment Term is the Matriculation Term as found on BANNER SGASTN screens and not the Admission Term. (2nd screen shot below) Could we then also change the heading on that field in SRWeb to “Matriculation Term” instead of “Enrollment Term”?

Are these questions for Rob or for StarRez?


A: From: Pekor, Robert J. Sent: Tuesday, June 6, 2017 2:04:11 PM

Karin,

field Push Process Where it comes from
Class Biographic Relates back to the SAGASTDN term-code-matric field in Banner
Expected-Graduation-Term Enrollment relates back to the SAGASTDN term-code-grad field
Enrollment term Enrollment nothing specifically called “enrollment term” in either push, but the entry term relates back to the relates SAGASTDN term-code-entry field.
Admission Term Enrollment relates SAGASTDN term-code-matric field. If the term-code-matric field is blank, it sends the SAGASTDN term-code-admit.


Are you saying we need to change some of these?


xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Q: From: Stokes, John D. Sent: Thursday, June 01, 2017 1:42 PM Subject: LS dependents not pulling into StarRez

Hello Rob/Cindy,

I created faculty lists in StarRez and it appears our faculty dependents are not being imported into StarRez. Sandy Bonomo told me that we identify faculty by the “religion” code “LE” and dependents by the “religion” code “DP” in PPAIDEN.

Please look into this for me. I need to run faculty/dependent lists for 8-week programs, at least, by next week.

A:

Cindy mentioned that dependents are found in – the BANINST1.PDVBENE view . This view has been incorporated into the starrez_demographic_view. the dependents themselves are gather using the starrez_ls_fac_depnd_demo_data view.


xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Powered by MediaWiki