Purpose

This Extract job highlights discrepancies between the information in PERSON_PAYMENT_SCHEDULE and the assessments in FEE_ASS.

The expected revenue stream for the HEP external finance system begins in Fee Assessments for load incurred debts in Callista. This expected revenue is recorded as assessments in the Callista table, Fee_Ass. The expected revenue is further processed into payment schedules that may reflect when expected revenue is to be received and from whom that revenue is expected. INTJ0118 discrepancy extract is seeking to identify abnormalities that are present in the expected revenue stream between Fee Assessments and Person Payment Schedules.

This extract job compares records between the tables FEE_ASS (FAS) and PERSON_PAYMENT_SCHEDULE (PPS). Records that have discrepancies in the Schedule information when compared against the Fee Assessments information are made available for investigation via INTF0118.

The context for this job is described in the overview.

Run Details

INTJ0118 can only run in batch mode, through the Job Control & 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 Person Payment Schedule job, FINJ6111, which creates PERSON_PAYMENT_SCHEDULES.

For initial checking of system integrity, the report could be run after each run of FINJ6111. 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 Fee Assessment - Payment Schedule Inconsistency Extract block contains:

Parameters Tab

• Fee Assessment Period:
• Currency:
• 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.

Compare Records in FEE_ASS and PERSON_PAYMENT_SCHEDULE

This module compares the records in FEE_ASS and PPS for a given fee period and currency. Identified inconsistencies are logged into and extract table.

This process identifies occurrences where a student's Fee Assessment debt is not equal to the debt schedule in the Person Payment Schedule. A PIG is created to group the students that have inconsistencies between the details of the debt in the FEE_ASS table and the PERSON_PAYMENT_SCHEDULE record. Record sequence numbers are recorded in the system extract tables. The total number of inconsistent records is also recorded in the extract tables.

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 INTJ0118 is presented in plain format and stored in the S_EXTRACT and S_EXTRACT_RECORD table. The output can be investigated through four different views using INTF0118. The four different views are:

• Master
• Summary
• FAS
• PPS