Purpose

This extract job highlights discrepancies between invoices that exist in COFI and those that have been generated in Callista in the Person Payment Schedule.

The job compares assessment data held in the core Callista table, PERSON_PAYMENT_SCHEDULE, with invoice data in the COFI tables I_INVOICE and I_INVOICE_TRANS, giving details of any inconsistencies found.

Records with inconsistencies can be investigated with INTF0116.

The context for this job is described in the overview.

Run Details

This job is likely to be run concurrently with the Payments Inconsistency Extract job INTJ0116.

INTJ0117 can only run in batch mode, through the Job Control and Scheduling subsystem. It can be run as a standalone job.

Job Conflict

There are no job conflicts for this job.

Timing

The report would normally be run after running the interface master job, INTJ0021, which creates invoices in Callista, transfers them to the external financial system and applies or re-applies payments to new or adjusted invoices.

For initial checking of system integrity, the report could be run after each run of INTJ0021. 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 the 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 Debt Inconsistency Extract Job block contains:

Parameters Tab

• Fee Assessment Period
• Fee Type
• Fee Category
• Currency Code
• Person ID
• Person ID Group Description

Rules/Notes:

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

This unique description is used when investigating discrepancies in INTF0118.

Reconciliation of Callista Debt with COFI Debt

This job lists all student liabilities where:

• Assessed debt totals held in core Callista differ from invoices in the interface tables, for the same fee liability.
• A student's fee liability may be met, in whole or in part, by a sponsor. If the debt is split between student and sponsor, invoices are created for both. This section reports on amounts against both student and sponsor.
• The Callista values reflect the total proportion of a fee assessment (excluding tax), and where applicable, the proportion of tax, for which a student or sponsor is liable. These amounts are held in the Callista core table PERSON_PAYMENT_SCHEDULE. The COFI values reflect the totals of invoice amounts for which student and sponsor customers respectively are liable, to meet the fee and tax. These invoices reflect entries in the interface view, I_INVOICE_TRANS.

The Maintain Person Payment Schedule form, FINF3800, displays the records which are the source of the total amounts shown under 'Callista Student Amount' and 'Callista Sponsor Amount' in this report.

Students with Invoices and No Fee Assessment Debt

This section lists all student liabilities where:

• Invoice records exist in the Callista interface view, I_INVOICE_TRANS_V, but not as assessments of a fee liability in the Callista core table, PERSON_PAYMENT_SCHEDULE.

Rules/Notes:

Students are grouped by fee period (Fee Assessment Calendar), with the most recent period first. Within fee period, they are sorted in ascending order of Person ID.

The output from INTJ0117 is presented in plain format and stored in the s_extract and s_extract_record table. The output can be investigated using INTF0117.

The s_extract record holds the following data:

• S_EXTRACT_TYPE
• CREATION DATE
• SEQUENCE NUMBER
• PERSON_ID
• FEE_TYPE
• FEE_CAT
• COURSE_CD
• DUE_DT
• CSS_STUDENT_FEE AMOUNT
• CSS_STUDENT_TAX AMOUNT
• CSS_SPONSOR_FEE AMOUNT
• CSS_SPONSOR_TAX AMOUNT
• CSS_LOANSCHEME_FEE AMOUNT
• CSS_LOANSCHEME_TAX AMOUNT