Sponsored Students Report - FINR0140

Subsystem

Student Finance

Purpose

To give personal, course attempt and sponsorship details for students sponsored during a particular academic period

Normally Run By

 Fees staff

Anticipated Frequency

At the start of each fee period and as required

Parameter Sample

Report Sample

Related/Dependent Jobs

 

 

Run Details

The report can be run in immediate or batch mode.

Timing

Sponsorships are normally assigned (in the form Direct Assignment of Sponsorships, FINF4300) at the start of a fee period, and this report might therefore be run at that time, and then as required.

 

Report Parameters

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

Report parameters

A financial period must be supplied. The current period is used by default, or another financial period may be selected from the list of values representing all open and active calendars in the FINANCE calendar category.

The remaining parameters allow for all values of the relevant data field to be selected using the % option. Alternatively, subsets of sponsored students can be reported by supplying specific values for some or all of the following:

  • a fee assessment period selected from the list of values, which displays only active fee calendars.
  • a full Person ID number (which must be typed in) to report only on one student. The ID is validated against the database.
  • a course code, which must be typed in and is validated against the database.
  • a sponsor code selected from the list of values. The LOV displays active sponsors.
  • a sponsor type from the list of values. The LOV displays all types that have been allocated to a sponsor in form FINF4100. If selected with sponsor code, the combination must be valid.
  • a course status selected from the list of values limits the reporting of sponsorships to student course attempts with the matching status.
  • an organisational unit from the list of values. Students studying a course owned by the selected organisational unit are reported. An example of use is to select all sponsored students in a particular faculty.
  • a fee category, selected from those that are open.
  • a fee type, selected from those that are open. If fee category is also selected, the fee type must be a liability of the selected category.

 

Report(s)

Sponsored Students Report

 

This report lists personal, course attempt and sponsorship details for all students for whom a sponsorship applies within a specific financial period, and where

  • the sponsorship has an active status at the date the report is run
  • the end date of the sponsorship is not prior to the report run date
  • the details match any further parameters specified at run time.

Information in the report reflects that recorded in the Direct Assignment of Sponsorships form, FINF4300.

Distinction is made between those sponsorships where a sponsor has undertaken to pay all fees for a student ('Sponsorship Applies to All Student Fees') and those where only specific fees are sponsored. These fees are listed under 'Nominated Fees'.

Scope of report

Sponsors with a cancelled status are not reported. Where a sponsor has undertaken to pay specific fee liabilities, only those that are active at the time of running the report are shown.

Sorting and totals

Students are grouped by fee period for each sponsor, and sorted in alphabetic order of surname.

Totals are given for

  • the number of students in each relevant fee period recorded for a sponsor
  • all students sponsored by a single sponsor, and
  • total number of students in the report (last page).

 Last Modified on 28 April 2000