Purpose

This extract shows the changes that have occurred in fee assessments for students who have had a student_todo record of HECS_RECAL and whose deferred details have changed since the FINJ3001 job (with the deferred indicator selected), and FINJ6231 were run.

Subsystem

Student Finance

Normally Run By

Fees staff

Anticipated Frequency

At the start of each fee period and as required

Related/Dependent Jobs

Both the FINJ3001 and FINJ6231 jobs must be run before running this extract. (Note: With the introduction of the Higher Education Loan Program (HELP) in 2005, FINJ6231 was superseded by FINJ6240.)

This extract shows the changes that have occurred in fee assessments for those students that have had a student_todo record of HECS_RECAL and whose deferred details have changed since the FINJ3001 job (with the deferred indicator selected), and FINJ6231 were run. (Note: For records created from 2005 onwards, FINJ6240 is run instead of FINJ6231.)

FINJ6232 uses the student_todo_ref records for the Person ID Group Members from the selected Person ID Group descriptions to compare the previous deferments with any subsequent deferment records that have been inserted into the fee_ass table. Students reported in the extract will be those where a change in the deferment amounts has occurred.

This process is run for the HECS_RECAL Person ID Group that was created in the FINJ3001 process. The user running FINJ6232 must be either the same person who ran FINJ3001 or have grant access to that Person ID Group.

The FINJ3001 created output Person ID Group holds the necessary reference data to select the student_todo_ref records that contain the FEE_ASS.TRANSACTION_ID to directly reference the logically deleted deferred transaction in Fee_ass.

FINJ3001 process records in its reference data the person_id and the transaction id of the logically deleted fee_ass record of s_transaction_type DEFERRED. These two items are the primary key to the FEE_ASS table. The process can therefore determine the amount of the initial deferment. The STUDENT_TODO_REF also holds the Fee period information FEE_CAL_TYPE and FEE_CI_SEQUENCE_NUM. With this it can identify the new deferred amount for the person.

Where the deferred assessments have altered, the person details are loaded into this extract.

Run Details

The extract can be run batch mode only.

Timing

This extract must be run immediately after a Process Fee Assessments from Student To Do Entries job run (FINJ3001) and HECS Deferment job (FINJ6231).

Report Parameters

For information about system (or control) parameters, see All About Standard Reports.