SYSDRNP- Drop For Non-Payment (NJ_810-812)

Description:

Runs a process to drop students for non-payment of enrollment and tuition fees in a specified term.  This process runs sequentially for all three "current registration" or "rolling" terms starting with the oldest term.  Though the SYSDNRP process will run for a term it will not process students in terms that have either ended or are NOT assessing fees.

To be considered for drop, students must meet the following criteria:

  • Have unpaid enrollment (detail code 'ENR%'), upper division course (detail code 'UDC%'), or tuition (fee category code 'TUI') transactions for the term
  • Do not have active CN, BR or PD holds on their accounts
  • Are non-HSDE students (student type not 'Y')
  • Are not receiving financial aid
  • Have not been flagged as Veteran in the past year [Vet status in ('1','5','C','D','E','I','J','K','L','M','N','O','P','Q','R','S','T','U','W')].

Given the student's outstanding balance of unpaid enrollment (including UDC% fees) and tuition fees for the term, the process will then determine which registrations in the term are considered unpaid.  The order of review is the most recent registration followed by billable unit load (largest to smallest) then the CRN number.  The process will then determine if the unpaid registration is after the start of the grace period or not.  Class registrations that fall outside of the grace period are subject to drop.

Grace Period Rules

The grace period is the number of calendar days depending on processing date (typically the current date) that students may have an unpaid balance for a class registration.  Essentially, the process will calculate a "drop date" by subtracting the number of calendar days in the grace period from the processing date.  It then determines if the registration date was prior to that date to be considered for drop. 

If it does find a registration older than the "drop date" it then checks to see if the class registration was an auto-enrollment from the waitlist (RL status code).  If so, then it uses the RL lag days (waitlist registrations) as the grace period.  If within the waitlist registration grace period then flags the class as a waitlist registration for notification purposes but does not drop.  Otherwise, the course is flagged for dropping.

The default grace period is established by the nightly job parameter (parm 03).  When the start of the term is reached the default grace period is reduced to one day.  The RL grace period is established by the nightly job parameter (parm 04).  There is no override of this period after the start of the term.

Current settings for grace periods: 

  • Default grace period = 7
  • WL grace period = 7

Note

*Note: At the start of the term, the grace period is overridden to 1 day. WL grace period does not change at the start of a term.

Student Notification

Depending on the run mode, students will be notified of any pending drops vial email messages and portal alerts.  There are three run modes:

  • No Msg - No drops and no notifications; generates report only
  • Audit - Audit only pending drops, notifies students and generates a report
  • Update - Updates students registrations and account balances after dropping classes with unpaid balances as specified above, notifies students of other classes to be dropped and generates a report.

No Msg Mode: Run in the N - No Msg mode, an audit report of students with unpaid registrations is produced but students are not notified of any unpaid balances or pending drops.  This mode is typically used when there are planned system outages preventing students from logging in to resolve the unpaid balance.

Audit Mode:  This mode produces an audit report of students with unpaid registrations and notifies the students of all unpaid registrations as determined by the criteria above and indicating the class "WILL BE DROPPED AFTER " and the planned drop date in the notification.  If the drop for non-payment process effective date is delayed and publicized, a GTVSDAX setting (DRNPEFFDT) can be set to the effective drop date for that term.  If this setting is enabled and the date has not passed, the student notification email will use the reporting date in the setting (minus one day) as the "DROPPED AFTER" date.

Update Mode:  This mode will produce an audit report of students with unpaid registrations, notifies the students of all unpaid registrations indicating the action to be taken, and drops any courses flagged for dropping.  If the course is being dropped the student notification message indicates the "CLASS WAS DROPPED" and the date of the drop.

Technical Note:

Email and portal alert notifications use the GUAPARA DRNPEML and DRNPTMS templates, respectively, and are processed the background GYSUSER notification processed.  Notifications can be found in GZREMAL with gzremal_source = 'sysdrnp.sql'.  See Examples below for a sample email notification.

Drop For Non-Payment Report

See the Example section for sample reports of the SYSDRNP process run in Audit and Update modes.  Reports are distributed to the following staff:

EMCDONALD AREED DANTER JDIAZ GGURROLA CRODRIGUEZ EDAY SROYER LCHAU KIRK_NORRIS1

Timing

The SYSRER4 nightly job evaluates when new term registration begins and rolls the terms in the three SYSDRNP nightly jobs (NJ_810 - NJ_812) to reflect this.  The jobs are set to run sequentially in term code order beginning with the oldest term.  Any term that is currently being run will retain its job parameter settings when moved to a new NJ_8xx number.  Any SYSDRNP nightly job created for a new term will default to running in Audit mode.  IT staff will need to turn the nightly job on for update mode at a pre-determined time.

Object Details
  • Object Type: sysdrnp.sql
  • Security Classes:
  • Created By: WFP
  • Last Updated Date: 4/24/2024
  • Last Updated By: Twang
  • Source:  Local
  • JIRA Tickets:

 Instructions: Click here to expand...

Instructions


Parameter Name                         

Value              
Parameter Seq No:  810-812
Term code: Current reg terms as populated by sysrer4.sql
Process Date: Blank
Lag Days for Drops: 7 (default)
Grace Days for RL: 7 (default)
Audit/Update/Aud No Msg(A/U/N): A (default)

      


 Example(s): Click here to expand...

Example

 Report examples:

 sysdrnp_811.lis - Audit

 sysdrnp_810.lis - Update


 Sample email notification to student (nightly):


Sample email notification to faculty (nightly):




 Testing Methodology: Click here to expand...

Testing Methodology