Purpose

To assign Sponsors and record Sponsorship details where students are sponsored for fees within a Course Attempt

SubSystem

Finance

A Sponsor agrees to make payment of all or some of a student's fee costs for a particular course. This form is used to assign a Sponsor or Sponsors to individual Student Course Attempts and to maintain the Sponsorship records. Sponsorships can be cancelled in this form.

Sponsors can undertake to pay (in part or in full) all fees pertaining to a Course Attempt within specified Fee Periods. Student Sponsorship can be defined at many levels (see below). These include Fee Period, Fee Type and Unit Attempt levels. Percentage limits and Percentage Contributions can be defined at each of these levels. For example, a Sponsor may agree to pay 75% of a student's Tuition Fee, but not contribute to their General Service Fee.

Before they can be assigned in this form, Sponsors must be recorded in the form FINF4100. Where a student is Sponsored by more than one individual, corporation or other body, each Sponsor must take responsibility for different Fee Liabilities relevant to the Course Attempt. It is not possible within the System to split the cost of the Course Attempt as a whole between two or more Sponsors.

Timing

Sponsorships must be linked to Fee Periods in this form. Once active, the Sponsorship applies to relevant fees for which a Sponsored student is liable throughout the Fee Period. This includes debt that has already been notified; if Sponsorship details are added after an assessment cycle for the period has begun. In this situation, the Sponsor's liability is calculated when a relevant student is next reassessed (by running FINJ3500 or FINJ3001) and their person payment schedule amended (by running FINJ6111). The student's liability is adjusted accordingly.

It is also possible, where exceptional circumstances dictate, to apply Sponsorship retrospectively to a student's records for a previous Fee Period. This can be done as long as the relevant student/s can be reassessed and new schedules created for that period - that is, the Retro Date has not passed and the period has not been finalised.

Ending Sponsorship

Sponsorships can expire or be cancelled.

The job Expire Fee Sponsorship (FINJ4430) is run to automatically change the status to one equivalent to the System value EXPIRED for those Sponsorships for which the End Date has passed. Related Fee Periods and Fee Liabilities will also be set to expired, but Sponsorship will still be in effect for any Fee Period in which there has already been Sponsorship activity.

Sponsorships may be end-dated automatically by the job ADMJ3850 (Clean Up Unconfirmed Student Course Attempt Process) if applicants through Admissions do not confirm enrolment in the relevant courses.

Unlike expiry, cancelling either a Sponsorship or specific commitments ends the Sponsor's responsibility for any debt (both paid and unpaid) at the time of cancellation. Setting a CANCELLED status is done in this form.

Fee Sponsorship Status

This status operates at three levels in this form. Normally only statuses equivalent to PLANNED, ACTIVE or CANCELLED will be set in the form. The EXPIRED status is set by the system. The INFRINGED status currently (September 1999) has no system functionality.

An ACTIVE status can only ever be changed to CANCELLED, and vice versa.

Only PLANNED records can be deleted, and only if they do not have dependent records. For example, a planned Course Attempt Sponsorship can be deleted as long as it has no dependent Fee Period or fee liability records.

See Navigation Diagram at end of the file for a simple diagram of how to get around FINF4300.

Special Note:

It should be noted that if the Sponsorship Limit and/or Percentage Contribution are modified after a Person Payment Schedule has been created, the Person Payment Schedule (FINJ6111) will need to be rescheduled to run again for the students affected by the change.

In this documentation:

Recording a Sponsor or Sponsors
A Single Sponsor Can Undertake to Pay
To Assign a Single Sponsor
To Record Fee Period/s
To Assign Specific Fees to a Single Sponsor
To Assign Multiple Sponsors
To Activate a Planned Sponsorship
To Change Sponsorship Details
To Cancel Sponsorships or a Sponsor's Commitment for Fee Periods or Fee Liabilities
Validations
Navigation Diagram
Sponsorship Dilemma - An Example
Sponsorship Limit Hierarchy

This form is accessed from the main menu.

The Student Course Attempt block contains:

• Person ID
• Sex
• Date Of Birth
• Course Version
• Short Title
• Calendar Type
• Commencement Date
• Student Course Attempt Status
• Fee Category

• Button

• Find Person

The Student Course Attempt Fee Sponsorship block contains:

• Sponsor Code (LOV)
• Name
• Fee Sponsorship Status (LOV)
• Total Sponsorship Limit
• Start Date
• End Date
• Sponsorship Limit
• Percentage Contribution
• Comments

  Button

  • Sponsorship Calendars (overlay to Fee Category Calendar Instance Sponsorship block)

The Fee Category Calendar Instance Sponsorship block contains:

• Fee Calendar Type (LOV)
• Start Date
• End Date
• Fee Sponsorship Status (LOV)
• Sponsorship Limit
• Percentage Contribution
• Fee Category
• Fee Calendar Status

  Buttons

• Comments (overlay to Comments block)
• Fee Liability Sponsorship (overlay to Fee Liability Sponsorship block)
• Back

The Fee Liability Sponsorship block contains:

• Fee Type (LOV)
• Fee Calendar Type
• Start Date
• End Date
• Fee Category
• Fee Sponsorship Status (LOV)
• Sponsorship Limit
• Percentage Contribution
• Description

  Button

  • Comments (overlay to Comments block)
  • Unit Sponsorship (overlay to Unit sponsorship block)
  • Back

The Comments block contains:

• Comments

Button

• Back

The Unit Sponsorship block contains:

• Unit Code (LOV)
• Version (LOV)
• Title
• Fee Sponsorship Status (LOV)
• Sponsorship Limit
• Percentage Contribution

Button

• Comments (overlay to Comments block)
• Back

Rule/Notes:

For Validations, see table at end of the file.

The Student Course Attempt Block

To the right of the block title, a lamp will appear to indicate if multiple Student Course Attempts exist for a student. If there are multiple Student Course Attempts, they are displayed in order of status, and in alphabetical order within a status. They are:

• Enrolled
• Inactive
• Unconfirmed
• Lapsed
• Intermitted
• Discontinued
• Completed

The Student Course Attempt Fee Sponsorship block

This block enables users to assign sponsors and record sponsorship details for sponsored students. A Percentage Contribution, which defaults to 100%, is recorded against each sponsor and a Sponsorship Limit can optionally be entered. This limit is the highest amount that will be contributed by the sponsor for each Fee Period. The amount assessed for the sponsor in a Fee Period can never be higher than the Sponsorship Limit, even if the calculated percentage is higher.

The user can navigate to the Sponsorship Calendars using the button. The button label is enhanced. If calendar level data exists for a sponsor the button label includes a ‘+’. There is a ‘-‘ sign on the button if no calendar level data exists.

The Fee Category Calendar Instance Sponsorship block

This block enables the user to set up Sponsorship Calendars showing the Fee Periods over which the sponsorship applies. A Percentage Contribution and Sponsorship Limit can be recorded for each individual fee period.

If Fee Type level data exists for a fee calendar this is indicated by a FEE LIABILITIES SPECIFIED lamp that is displayed when the fee calendar is in context. This lamp alerts the user to the fact that there is a lower-level Fee Liability Sponsorship level data. The lamp SCAFS LIMIT/PERCENTAGE OVERRIDES is displayed if the sponsorship limit at the SCAFS level is not null or the percentage contribution at the SCAFS level is not 100%. This lamp alerts the user to the fact that any Sponsorship Limit or Percentage Contribution set at the Fee Calendar level will not be used by the Person Payment Schedule. There is also a ‘+’ sign on the button if Fee Type level data exists, and a ‘–‘ sign if no Fee Type level data exists.

If the Fee Category for the SCA has been changed since the Fee Calendar was linked to the sponsorship, this is indicated to the user using a CHANGED FEE CATEGORY lamp displayed when the calendar is in context.

The Fee Liability Sponsorship Block

This block enables the user to link fee types to a sponsorship in the context of a fee period. If no fee types are linked, the sponsorship is considered to apply to all fee types in that period.

A Percentage and Sponsorship Limit can be recorded for each individual Fee Type. The Sponsorship Limit applies for the context Fee Period in which the Fee Type was selected.

If the Fee Category of the SCA has been changed since the FTCI was linked to the Sponsorship, this is indicated to the user using a CHANGED FEE CATEGORY lamp displayed when the Fee Type is in context.

If unit level data exists for a Fee Type, this is indicated by a UNITS SPECIFIED EXCEPTIONS EXIST lamp that is displayed when the Fee Type is in context. This lamp alerts the user to the fact that there is lower-level Student Unit Fee Sponsorship level data. The lamp SCAFS LIMIT/PERCENTAGE EXISTS is displayed if the sponsorship limit at the SCAFS level is not null or the Percentage Contribution at the SCAFS level is not 100%. The lamp alerts the user to the fact that any Sponsorship Limit or Percentage Contribution set at the Unit Sponsorship level, there is lower-level or SCAFS level data, so any Sponsorship Limit or Percentage Contribution set at the Fee Type level will not be used by the Person Payment Schedule. There is also a ‘+’ sign on the button if unit level data exists, and a ‘– ‘ sign if no unit level data exists.

The Unit Sponsorship Block

This block enables the user to define units that the sponsor has agreed to pay for. Units are defined in the context of a Fee Type. Due to the hierarchical nature of the function, this means that the Units are also in the context of a Fee Period.

If Sponsorship is set up for a unit that has already been sponsored in a previous Fee Period, a warning will be displayed, but the system will not prevent a repeat sponsorship.

The lamp SCAFS LIMIT/PERCENTAGE EXISTS is displayed if the Sponsorship Limit at the SCAFS level is not null or the Percentage Contribution at the SCAFS level is not 100%. This indicates to the user that any Sponsorship Limit or Percentage Contribution set at the unit level will not be used by the Person Payment Schedule.

Recording a Sponsor or Sponsors:

The Student Course Attempt block operates in query mode only.

Select the student to whom a Sponsorship applies or will apply, either by entering a known Person ID or by selecting the button to use the Find Person facility (ADMF1211).

Select the student's relevant Course Attempt by scrolling through the retrieved records (on the keyboard, use the down arrows or Page Down).

Rule/Notes:

A Single Sponsor Can Undertake to Pay:

• All or a proportion of every fee for which a student is liable in specified periods of a Course Attempt. This is achieved by entering details in the Student Course Attempt Fee Sponsorship and Fee Category Calendar Instance Sponsorship blocks only

or

• Only a specific fee or fees – in part or in full – for the Course Attempt and specified period. This is achieved by additionally entering details in the Fee Liability Sponsorship block

If a student has more than one Sponsor for a Course Attempt, each Sponsor must take responsibility for a different fee or fees. Details must be entered in both the Student Course Attempt Fee Sponsorship block, the Fee Category Calendar Instance Sponsorship block and the Fee Liability Sponsorship block, for each Sponsor.

Because slightly different methods apply, single and multiple Sponsors are dealt with separately in this documentation.

Rule/Notes:

Use the Student Course Attempt Fee Sponsorship block to:

• Select the Sponsor code from those Sponsors shown as active in the list of values
• Set the Sponsorship Status to an equivalent of PLANNED (defaults to a planned status – this can be altered if more than one user defined status corresponds to the System Status of PLANNED)
• Enter a Start Date for the Sponsorship, or accept the default of the current Date
• Optionally, enter a End Date
• Optionally, record a Currency Amount as a Sponsorship limit. The total of all fee amounts which the Sponsor has undertaken to pay in the Course Attempt cannot exceed this limit
• Record a Percentage Contribution representing the proportion the Sponsor is prepared to pay of each fee for which they have undertaken responsibility (the default is 100%)
• Save the record
• Add the required Fee Period/s (see below)
• If a single Sponsor intends to pay only specific fees, add these as liabilities (see below)
• Activate the Sponsorship, if required at this time (see below)
• Save the record

A reminder warning is given on exiting the form if no Fee Period has been assigned to the Sponsorship, or if the Sponsorship has not been set to ACTIVE.

Rules/Notes:

The Start and End Dates in part determine the Fee Periods available for Sponsorship. Fee Periods must fall wholly or partially within these dates (see below).

It is possible to apply Sponsorship retrospectively to a student's records for a previous Fee Period. This can only be done if the relevant student/s can be reassessed and new schedules created for that period - that is, the Retro Date has not passed and the period has not been finalised.

The End Date may be left open. If given, it is used by the job FINJ4430(Expire Fee Sponsorship).

A new Sponsorship record for the same Sponsor can be added if:

• A an existing Sponsorship record has been cancelled and has an End Date, and the Start and End Dates of the two Sponsorships do not overlap
• The sponsorship record is linked to a different Fee Period.

Where a Sponsorship limit applies, this is in the currency of the Fee Category shown in the Student Course Attempt block. (Currencies are recorded for Fee Categories in Maintain Fee Categories, FINF2800).

A lamp is displayed if a Contract Rate will be effective at any time within the Sponsorship period for any Fee Sponsored.

Where a Sponsorship limit has been set, the Sponsor undertakes to pay whichever is the lesser of

• The amount given as a Sponsorship limit across all relevant Fee Liabilities during the fee period, or
• The total when the agreed Percentage of each Sponsored Fee is calculated

Sponsors are only liable for Sponsorships which, when the job to Maintain Person Payment Schedules (FINJ6111) is run, have a status equivalent to the System value ACTIVE, or which have been ACTIVE in the Fee Period but are now set to EXPIRED.

Once saved the Start Date is protected.

Access the Fee Period overlay block (Fee Category Calendar Instance Sponsorship) via the Sponsorship Calendars button, and record:

• The Fee Period/s for which Sponsorship of this student is to apply
• The status of the Sponsorship in this period (equivalent to PLANNED - given as default)
• Save the record, and use the Back button to return

Rules/Notes:

A student must have a Fee Category (assigned during admission or enrolment) before a Fee Period can be selected.

The list of values (LOV) displays ACTIVE or PLANNED Fee Periods, which are recorded (in FINF2800) for the Fee Category or Categories matching the student's Fee Category or Categories, and which fall wholly or partially within the Start and End Dates recorded in the previous block.

An advisory warning is given if a PLANNED rather than ACTIVE Fee Period (Fee Category Calendar Instance) is selected, but this does not prevent its selection.

For a long-running Sponsorship, new Fee Periods may need to be added when Fee Calendars are rolled over.

Access the Fee Liability overlay block via the Fee Liability Sponsorship button, only available once a Fee Period has been entered.

Use the Fee Liability Sponsorship block to:

• Select the Fee Liabilities (fee type in a Fee Period) for each fee the Sponsor is prepared to pay either in full or in part, as indicated by the percentage value recorded in the previous block
• Set the Sponsorship status to an equivalent of PLANNED (the default)
• Save the record

Rules/Notes:

A warning is given if Inactive Fee Types are selected, but these can still be recorded against a Sponsorship.

Sponsors are liable for fees which, when the job to Maintain Person Payment Schedules (FINJ6111) is run,

• Have a Fee Sponsorship Status equivalent to the System value ACTIVE,
• Or fees where the Sponsorship has been ACTIVE in the Fee Period but is now EXPIRED

The list of values for Fee Type displays those Fee Liabilities recorded against the Fee Category shown for the student and available in the Fee Periods associated with the Sponsorship.

A lamp is displayed if a contract rate will be effective at any time within the Sponsorship period for a Sponsored fee. The dates of the contract are shown.

Where fee structures have been 'rolled over' several years in advance, future Fee Liabilities can be selected from the LOV. Alternatively, for a long-running Sponsorship, the relevant Fee Liabilities for the upcoming year will need to be selected in this form after each yearly rollover. (Refer to the rollover job, FINJ2A00.)

Because two or more Sponsors of a Course Attempt must each take responsibility for different Fee Liabilities, existing active Sponsors must have fees assigned in the Fee Liability Sponsorship block before subsequent Sponsors can be made active in the Student Course Attempt Fee Sponsorship block.

The method of entry would be to:

• Assign a fee liability or liabilities to an existing active Sponsor as indicated in 'To assign specific fees to a single Sponsor' . If required, a liability status equivalent to the system value PLANNED can be recorded for Sponsorships
• Create each subsequent Sponsor following the method given in 'To assign a single Sponsor'
• In the Fee Liability Sponsorship block assign different Fee Liabilities for each subsequent Sponsor, with statuses equivalent to PLANNED
• Activate the new Sponsorships, as described below

Rules/Notes:

For multiple Sponsors of a student, liabilities must be assigned for each Fee Period specified for each Sponsor.

Either:

• Set the Sponsorship in the Student Course Attempt Fee Sponsorship block to ACTIVE. When saving, the user is asked to confirm that related Fee Period and Fee Liability records should also be set to ACTIVE by the System

or

• Set the required Fee Period to ACTIVE. The Course Attempt Sponsorship to which it relates will be set to ACTIVE by the System

Rules/Notes:

A Fee Liability can only be set to ACTIVE if the associated course Sponsorship and Fee Period are active.

Related Fee Liabilities will not be activated if using the second method (activate a Fee Period).

• New Fee Periods and liabilities may need to be added to long-running Sponsorships after Calendar and Fee Period rollovers
• If an End Date is not recorded initially, but added later, expiry after the End Date (by running FINJ4430) will preclude Sponsorship of any associated Fee Periods which start on or after the new End Date. Current Fee Periods in which activity has already occurred will continue to operate with Sponsorship, even when expired
• A Sponsorship limit can be changed during the Sponsorship. Note that this limit will also be applied to past Fee Periods if Person Payment Schedules are retrospectively rerun for those periods
• A Percentage contribution cannot be decreased once any payment has been received from the Sponsor, but can be increased at any time

Rules/Notes:

Changes to Sponsorship details are reflected in the Person's Payment Schedule (FINF3800) and in the Manual Fee Assessment (FINF3610) and inquiry forms, once the Process Person Payment Schedules job (FINJ6111) has been rerun.

To Cancel Sponsorships or a Sponsor's Commitment for Fee Periods or Fee Liabilities:

• Student Course Attempt Fee Sponsorship block.
  A Sponsorship can be cancelled by changing an ACTIVE status shown against a Sponsor Code to the equivalent of the System value CANCELLED
  A message invites you to authorise cancellation of related Fee Periods, Fee Liabilities and any Sponsored amounts for this Sponsorship. Select OK to authorise.
• Fee Category Calendar Instance Sponsorship block.
  The Sponsorship for a particular Fee Period can be cancelled by changing an ACTIVE status shown against the Calendar to the equivalent of the System value CANCELLED
  A message invites you to authorise cancellation of related Fee Liabilities and any Sponsored amounts for this Sponsorship. Select OK to authorise.
• Fee Liability Sponsorship block.
  A Sponsor's responsibility for a specific fee can be cancelled by changing an ACTIVE status shown against a Fee Type to the equivalent of the System value CANCELLED
  A message invites you to authorise the cancellation of any Sponsored amounts for this fee. Select OK to authorise.

Rules/Notes:

All debt in the current period, both paid and unpaid, is reassigned to the student if a Sponsorship is cancelled. Amounts already paid by the Sponsor are available for refund.

Where cancellation is not authorised in response to the displayed message, the status reverts to an ACTIVE state.

A cancelled Sponsorship can be reactivated by first recording as ACTIVE at the Sponsorship level, and then at Fee Period and liability levels.

A new Sponsorship record for the same Sponsor can be added if:

• An existing Sponsorship record has been cancelled and has an End Date, and the Start and End Dates of the two Sponsorships do not overlap
• The sponsorship record is linked to a different Fee Period.

Cancelling a Sponsor's record in the form FINF4100 (without cancelling their Sponsorship/s in this form) prevents the selection of that Sponsor for any future Sponsorship, but does not affect existing Sponsorship.

Validations include:

• Determine if multiple course attempts exist for the student. This will assist on when to display the ‘MULTIPLE COURSE ATTEMPTS EXIST’ lamp in the SCA block
• Determine if the Fee Category for the SCA has been changed since the Fee Calendar was linked to the sponsorship. This will assist on when to display the ‘CHANGED FEE CATEGORY’ lamp in the FCCIS or FLS blocks
• Determine if child Fee Liability Sponsorship data exists for the Fee Category Calendar Instance Sponsorship. This will assist on when to display the ‘FEE LIABILITIES SPECIFIED’ lamp in the FCCIS block
• Determine if child Unit Sponsorship data exists for the Fee Liability Sponsorship. This will assist on when to display the ‘UNITS SPECIFIED’ lamp in the FLS block and will also assist with the ‘(+)’ or ‘(-)’ logic on the Unit Sponsorship button
• Determine if the Student Course Attempt Fee Sponsorship has a Sponsorship Limit that is not null or a Percentage Contribution that is not 100%. This will assist on when to display the ‘SCAFS LIMIT/PERCENTAGE OVERRIDES’ lamp in the FCCIS, FLS and SUFS blocks
• If a Sponsorship Limit that is not null or a Percentage Contribution that is not 100% is entered in a FCCIS, FLS or SUFS record and a Sponsorship Limit that is not null or a Percentage Contribution that is not 100% exists at the SCAFS level then display a warning
• If a sponsorship is set up for a unit that has already been sponsored in another fee period a warning will be displayed but the system will not prevent a repeat sponsorship
• Units can only be specified for Fee Types managed at unit level
• Only Unit Versions that are active and either have no expiry date or have a future expiry date can be selected
• Only Units with a Unit Offering Option can be selected
• Different versions of the same unit cannot be selected
• Cannot delete a Fee Liability Sponsorship if there are dependent Student Unit Fee Sponsorship records
• The Fee Sponsorship Status of the Student Unit Fee Sponsorship cannot be closed
• The Fee Category Fee Liability must exist
• The current date cannot be past the Retrospective Date
• The Fee Category Calendar Instance must exist
• The Unit Sponsorship cannot be created if the Fee Period is FINALISED
• The Fee Sponsorship Status for the Unit Sponsorship can only be set to ACTIVE if the Fee Category Calendar Instance Sponsorship is ACTIVE
• The Fee Sponsorship Status for the Unit Sponsorship can only be set to ACTIVE if the Fee Liability Sponsorship is ACTIVE
• The Unit Sponsorship cannot be deleted if it has a Fee Sponsorship Status of ACTIVE
• The Unit Sponsorship cannot be deleted if it has a Fee Sponsorship Status of EXPIRED
• Produce a warning if the Fee Type is an INSTITUTN defined Fee Type and it has already been defined as a sponsorship that is active or expired for the Student and Fee Period
• A sponsor code cannot be linked to a Fee Calendar if an identical Sponor/Fee Calendar relationship exists for this SCA.

What happens when an institution has a situation where sponsorship is split over two or more courses and a student remains financially disadvantaged following normal procedures?

For example:

A sponsor decides to sponsor a student attending two courses. The sponsor is sponsoring the first course 50% of the fee up to $500. The sponsor is sponsoring the second course 100% of the fee.

As the example shows, the present order of sponsorship is applied:

Sponsor_cd
-> Keep sponsorship for fees which have a write off transaction
Course_cd
System Fee Type (in order of TUITION, COMSUPPORT, OTHER, VET, GRADUATION, ADVSTND)
Loan scheme attached to the fee, then no loan scheme attached
fee_type
unit_cd
payment_due_date
person_payment_schedule sequence_number

The student is out of pocket $600 for Course A. Course B has no debt to the student as the sponsorship pays the full amount.

What if the sponsorship order was changed, couldn't the student get a better deal?

The simple answer is yes. Unfortunately, as with sponsorship, there are hundreds of different scenarios that can be applied to sponsorship. It is left to the institution to not so much as change the order, but consider other ways to configure sponsorship differently.

For example, the institution could exclude INSTITUTION from Course A and apply it to Course B. The student is now out of pocket only $350, not $600 as in the example.

Another alternative is for the institution to exclude TUITION and INSTITUTION and change sponsorship for COMSUPPORT to be 100% of Fee (they know the sponsor is only paying up to $500 - and COMSUPPORT is $500). The student is now out of pocket $200 for the TUITION, not the $600 as in the original example.

Considering other alternatives means an institution could also configure sponsorship differently by excluding sponsorship of a particular fee types or setting limits at fee type level. The possibilities are endless. How an institution applies sponsorship, other than in system order, depends on an institution's individual needs. As circumstances change, sponsorship can be modified to meet the new requirements.

Sponsorship Limit Hierarchy

Sponsorship Limits can be specified at the Student Course Attempt Fee Sponsorship (SCAFS) level, the Fee Category Calendar Instance Sponsorship (FCCIS) level, the Fee Liability Sponsorship (FLS) level and/or the Unit Sponsorship (US) level (where the Fee Type Management Level recorded in FINF2100 = UNIT). These levels, in that order, form a hierarchy, with 'SCAFS' the highest level and 'US' the lowest.

Where data is to be recorded at one of the lower levels, the context of that data is established by the data that is recorded at higher levels. For instance, if data is recorded at the 'US' level, it applies to the specific Sponsor, Fee Period and Fee Type recorded at the higher levels, and the data at the higher levels should have its Sponsorship Limits and Percentage Contributions left as the default values.

When recording Sponsorship data;
If a Sponsorship Limit and/or a Percentage Contribution less than the default value (100%) is specified at the SCAFS level, then any data recorded at lower levels will be ignored.
Else, if a Sponsorship Limit and/or a Percentage Contribution is specified at the US level then any data recorded at other levels is ignored.
Else, if a Sponsorship Limit and/or a Percentage Contribution is specified at the FLS level then any data recorded at other levels is ignored.
Else, if a Sponsorship Limit and/or a Percentage Contribution is specified at the FCCIS level, then this is used.
Else, no Sponsorship exists.

For example;
If a Student Course Attempt has a sponsor recorded in FINF4300 with:
1. Sponsorship Limit = NULL and Percentage Contribution = 100 at the SCAFS level,
2. Sponsorship Limit = 1000 and Percentage Contribution = 50 at the FCCIS level for the Semester 1 Fee Calendar and
3. Sponsorship Limit = NULL and Percentage Contribution = 75 at the FLS level for a Fee Type of 'TUITION',
then the values at '3' apply as 'FLS' is the lowest level and therefore is applied first. The student will be sponsored for 75% of their TUITION fees in Semester 1, 2007 (i.e. no other Fee Types will be sponsored within the context Fee Calendar), but there will be no limit to the maximum amount of Sponsorship.

In the case of our example at '2', recording a Percentage Contribution of '50' at the FCCIS level has no effect, so the value should have been left as 'NULL' (the default).

The Sponsorship will only apply to a 'TUITION' Fee in Semester 1, 2007.