Fee Refund Status Report - FINR0280

Subsystem

Student Finance

Purpose

To give details of 1) refund records created for a student, and the courses in which they are, or have been enrolled 2) refund records created for a sponsor.

Normally Run By

 A fees administrator

Anticipated Frequency

As required - normally at the end of a financial year or fee period

Parameter Sample

Report Sample

Related/Dependent Jobs

The refund information contained in this report is created by the job FINJ6430, Process Student Refunds.

 

Run Details

The report can be run in immediate or batch mode.

It is possible to limit the report to refund information created in a single run of FINJ6430. For this, you need to know the refund group number assigned to records created in the particular run. This number is found in the JBS job log file (form JBSF5301, accessed via JBSF5300) for the relevant run of the job.

Depending on parameter settings, the report can be used to –

  • decide which student refunds should be approved (using the Maintain Refunds form, FINF6420)
  • obtain a printed record of students whose refunds have been automatically approved in the processing job FINJ6430
  • find out which refund records have been transferred to an external financial system, and the outcome
  • determine complete refund details.

 

Report Parameters

 

 

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

There are no mandatory parameters.

Optional parameters

Enter or select one of the following:

  • a refund group ID to limit the job to records created in a single run of FINJ6430 (see Run Details, above)
  • a person ID to report only on refunds for one student, or
  • a sponsor code (for sponsors with a status of planned, active or cancelled), to report on a refunds for a particular sponsor.

Select a refund status to report only on those refund records –

  • still to be approved (an equivalent to system PENDING)
  • approved but not yet acted upon (equivalent to system APPROVED)
  • transferred to an external financial system (equivalent to system APPLIED), or
  • that have been cancelled (equivalent to system CANCELLED).

Both open and closed statuses are available.

Limit the report to students with a course attempt matching one or more of the criteria, by entering /selecting:

  • a course code, which must be typed in
  • a course attempt status selected from the list of available system statuses
  • an open fee category
  • a location code.

Any sponsor supporting a student matching these criteria is also reported. For both selected students and sponsors, all their available credit and refund information is given.

 

Report(s)

Fee Refund Status Report

 

The report is divided into two sections: the first gives student refund information, and the second reports on sponsors.

Report information

For students, details of all courses in which they are, or have been, enrolled are given first. If a student is ENCUMBERED, this is indicated after their name.

The refund information in the report reflects data in the Maintain Refunds form, FINF6420. Each line in the report is a single refund record. A person's or organisation's available credit for refund is based on their entire association with the institution.

For applied refunds, reference details returned from an external financial system are shown. An INVOICE_AR reference indicates that a debit memo invoice has been created in 'accounts receivable'. An INVOICE_AP reference, that an invoice has been created in 'accounts payable' to prompt payment of the refund.

Sorting and totals

Within each section, students and sponsors are listed alphabetically.

For each person or organisation, refund details are organised by refund group, each group representing a refund record created at a particular time.

Totals are given after each section. For each refund status, the number of refund records and the total amounts involved are shown.

 Last Modified on 11 March 2002