...
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 after of their graduation, ie May graduates get a summer 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.
...