SYSCMPE Comprehensive Ed Plan Notification

Owned by Michael Rose
Last updated: Mar 13, 2018
2 min read

Description

This script will send an email and personal alert to students who are (a) currently registered in the term, (b) have earned a cumulative of 15 units or greater as of the term, and (c) have not completed a comprehensive ed plan in the last 3 years.  A report of students is also provided.

The process is run by term code, college code (primary college code for the student as of that term), and there is an audit/update option.  If the process is run in audit mode, it will produce the report only.  If the process is run in update mode, it will produce the report and send the email/personal alert.

The text for the email in GUAPARA is code CMPEDPE, and for the personal alert, it is CMPEDPT.

Object Details
  • Object Type:
  • Security Classes:
  • Created By:
  • Last Updated Date:
  • Last Updated By:
  • Source:  (Baseline, Modified Baseline, VCCCD Local)
  • JIRA Tickets:

Instructions

The process should be run after final grades are processed for the term, and should only be run once per term per college.  It should be run in audit mode first, reviewed, and then run in update mode.

Example

Sample email:

Sample Personal Alert:

Sample Report:


 

Testing Methodology

 Click here to expand...

 

  • Created text in GUAPARA and sent sample emails using test script to Registrars for review:
    begin

    pw_gysuser.p_insert_gzremal
        ('CMPEDPE',
         null,
         null,
         'E',
         'H',
         'bpearce@vcccd.edu',
         null,
         null,
         null,
         null,
         'test procedure',
         'Hieronymus',
         null,
         null,
         null,
         null,
         null,
         null,
         null,
         null);

    end;
    /

    commit;

  • Created text in GUAPARA and tested personal alert in lp5upgr:

    begin

    pw_gysuser.p_insert_gzremal

        ('CMPEDPT',

         null,

         null,

         'T',

         null,

         '900484202',

         null,

         null,

         null,

         null,

         'test procedure',

         'Hieronymus',

         null,

         null,

         null,

         null,

         null,

         null,

         null,

         null);

         

    end;

    /

     

    commit;

  • Wrote sql select script, and pulled a spreadsheet for Registrars to review.
  • Imbedded sql select in script and desk-tested in audit mode.
  • Desk-tested email and personal alert portion of the script - ran interactively with rownum <=5.  Tested personal alert in lp5upgr.
  • Had Registrars test script in audit mode in TEST to review report.

 

Â