Purpose

This Extract job highlights discrepancies between what has been recorded as successfully transferred in the I_payment_load table and the destination I_payment table in CALLISTA.

This Extract Job highlights discrepancies between what has been recorded as successfully transferred in the I_payment_load table and the destination I_payment table in CALLISTA. COFI Student Customers with payment inconsistencies are placed into a Person ID group (PIG). Each PIG will have a unique identification defined by the user before the job is run.

The results of this job can be can be investigated with Loaded Payments Inconsistency Extract Inquiry Form INTF0115

The context for this job is described in the overview.

Run Details

INTJ0115 can only run in batch mode, through the Job Control & Scheduling subsystem. It can be run as a stand alone job.

Job Conflict

There are no job conflicts for this job.

Timing

The report would normally be run after running the finance interface master job, INTJ0022, which transfers payments from the external finance system to Callista and applies or re-applies payments to invoices.

For initial checking of system integrity, the report could be run after each run of INTJ0022. As long as errors are not encountered, institutions may then decide to schedule the report to run less frequently.

It would normally be run before end of financial year processing.

Checking on the Job Run

Always check the run log in form JBSF5301, to see that the job ran successfully. Custom built messages in the log indicate the outcomes for each component of the job.

The COFI Loaded Payments Inconsistency Extract block contains:

Parameters Tab

• IP Sequence Number From:
• Person ID Group Description:

Compare I_PAYMENT_LOAD table with I_PAYMENT

This procedure compares successful records in the I_Payment_Load table with those in the I_Payment Table. Those successful I_Payment_Load records that don't exist in the I_Payment table will be added to the INTJ0115 Person ID Group.

Rules/Notes:

The Person ID Group (PIG) description must be unique.

Note: The output from this job can be investigated through INTF0115.