Inactivating Students Annually

Owned by Former user (Deleted)
Last updated: Jul 25, 2018 by Michele Folsom
2 min read

Inactivating Student (SGASTDN) Records

 

 

A Canisius process has been written called REGR077 to create IS records for students who have not been registered for two semesters back and they are not in the graduation tables for an upcoming term and do not have an IP grade for EDA690.  There is also a business objects report (regr077) that will report who was recently inactivated so Student Records can pull the files. This report is intended to be run after you run REGR077 in Banner.

 

The process needs only one parameter now, with the intent that we will be running this process once a year, only using a summer term as the parameter. This summer term will be used to calculate back what three terms back was (prior summer) and we will then check to see if the student has any registrations records greater than or equal to this three terms back. For example if 201610 is entered, we will make sure there are no registration records greater than or equal to 201510 since it is three terms back from 201610. Additionally, the process will make sure there are no future SGASTDN records (ie, incoming GR for summer or FR/TR for fall) and do not have an IP grade for EDA690. Lastly, the process will check to ensure there are no graduation records created for one term back of the parameter date going forward. So if the parameter is 201610, we will make sure there are no graduation records >= 201540.

 

This will be NOT be in alignment with how the college Registrar inactivates students after graduation, IG records are created with an effective the term that is the same term of their graduation, ie May graduates get a Spring term code effective record with the IG status. The only difference being we can inactivate records due to graduation 3 times a year, where the regr077 process will only inactivate records once a year, creating a SGBSTDN record with the IS code for the summer term.

 

Also of special note: if the record is not changed to IG by the registrar’s office prior to running this, it WILL be set to IS regardless of the graduation status. So keep in mind you will want to IG the students in the one year MBA program prior to running regr077.