SCHJ0600 - Bulk Update Person Scholarship Payment Activity

Purpose Performs bulk update of Scholarship Scheduled Payment Details
SubSystem Scholarships
Normally Run By Scholarship Specialist
Anticipated Frequency At least for each Scholarship Management Period
Structure  Block Bulk Update Scholarship Scheduled Payments
Tab Include
Exclude

  

This job allows users to bulk update scheduled payment details in the PERSON_SCH_PAYMENT_ACTVTY table for multiple Person Scholarships

The job will update the following for Person Scholarship Payment Activity records in SCHF1280 if specified in the parameters for the job:

  • Scheduled Payment ($) – This is the dollar amount to be paid to the student for the specified management period.
  • Payment Processed Date – This is the date the payment will be processed by the institution’s external payment system. After running the job, it is anticipated that institutions will utilise the Payment Processed Date to trigger a payment to students via their external payment system.
  • Intended Payment Date – This is the date on which the scheduled payment is expected to be paid to the student via the institution’s external finance system.

This job is accessed via the main menu.

 

The Bulk Scholarship Verification block contains:

Include Tab:

Select

  • Scholarship Code
  • Management Period
  • Intended Payment Date (optional)

Update Options

  • Scheduled Payment
  • Payment Processed Date
  • Intended Payment Date

Exclude Tab:

  • Scholarship Codes
  • Scholarship Categories

Rules/Notes:

Users must select a Scholarship Code and Management Period (mandatory), and (if required) an Intended Payment Date from the job’s parameters to define the Person Scholarship Payment Activity records to be updated. At least one Update Option must be specified.

This job can only run for current or future management periods.

Intended Payment Date must be equal to or after the current date and must not be the same date as an Intended Payment Date specified as an Update Option parameter.

At least one Update Option must be specified.

The Scheduled Payment must be a decimal value between 0.01 and 999999.99 and up to two decimal places e.g. $25.00.

If the Exclude Scholarship Code parameters are used then the Include Scholarship Code should be set to %.

 

To bulk update Scholarship Scheduled Payment Details:

  • Go to SCHJ0600
  • Select a Scholarship Code and Management Period, and (if required) an Intended Payment Date.
  • Select one or more values from the Update Options, which are to be updated by the job: Scheduled Payment, Payment Processed Date, Intended Payment Date.
  • Run the job ASAP or schedule a time to run.

Rules/Notes:

Errors such as those below are written to the S_LOG_ENTRY table with an S_LOG_TYPE of SCH-PYMNT.

  • The Total Scheduled Payments and Actual Payments cannot exceed the Total Scholarship Value.
  • The Payment Method , Intended Payment Date and Intended Payment Amount cannot be changed for Processed or Completed payments.
  • Only Processed or Completed dates can be updated when the Person Scholarship Status is TERMINATED.
  • Payment Completed Date cannot be earlier than the Payment Processed Date.
  • Payments can only be processed for a Commonwealth Scholarship of Type 7 if the system Scholarship Status is ACTIVE.
  • Payment Processed Date can only be updated if Verification for the Management Period is SUCCESSFUL or Skip Verification is checked.
  • Cannot update the Payment Processed Date to the specified value if the Scholarship Management Period Activity Status is INTERMIT.

 

Last modified on 8 June, 2023 4:01 PM

History Information

Release Version Project Change to Document
25.0, 25.1 & 26.0 2606 - Scholarships Enhancements New Help Page