Purpose

An extract job to identify students who do not have a valid Fee Category and/or Correspondence Category

SubSystem

Finance

Record Selection

Records can be selected for multiple Course Attempt Statuses and Fee Periods. Defining at least one Fee Period is mandatory, while defining multiple Fee Periods or Course Attempt Statuses are optional. Primary record selection is dependent on which of certain parameters are used. Records are extracted only for students with invalid fee or correspondence categories, according to the parameters entered.

The process finds details of students with invalid fee or correspondence categories within the specified Fee Period(s) and Course Attempt Status(s) (where where this is specified), including:

• Person ID
• Course Code and Version Number
• Course Attempt Status
• Fee Calendar (if the problem is fee category related)
• Fee Sequence Number (if the problem is fee category related)
• Fee Category
• Correspondence Category
• Message Number

Processing

If the Invalid Fee Categories parameter is selected then the report will only include Student Course Attempts with invalid Fee Categories. If the Invalid Correspondence Categories parameter is selected then the report will only include Student Course Attempts with invalid Correspondence Categories. If both options are selected (Invalid Fee Categories and Invalid Correspondence Categories parameters are checked) then the report will include Student Course Attempts with invalid Fee Categories or invalid Correspondence categories. In the case that more than one of the following apply the message number included in the report will specify the first Fee Category error that was identified and the first Correspondence Category error that was identified.

Extract Details

The extract process creates a record in the S_EXTRACT table which identifies the particular extract job run. It creates corresponding student detail records in the S_EXTRACT_RECORD table.

Run Details

FINJ6140 can be run in batch mode, through the Job Control & Scheduling Subsystem.

The Student With Invalid Fee/Correspondence Extract block contains:

• Course Attempt Status
• Fee Period
• Include Students with Invalid Fee Categories check box
• Include Students with Invalid Correspondence Categories check box

Rule/Notes:

To run the job, select the parameters which reflect the purpose for which it is being run. Up to four Course Attempt Statuses can be specified for this extract job (at least one must be defined). Additionally, up to four Fee Periods can be specified for this extract job (at least one must be defined). This job is normally run after the enrolments period. If both the Invalid Fee Categories and Invalid Correspondence check boxes are checked, the message number included in the report will specify the first error that was identified.

Rule/Notes:

Invalid Fee Categories in this process are defined as Fee Categories that are:

• Student Course Attempt does not have a Fee Category specified.
• The Fee Category that is defined for the Student Course Attempt is Closed.
• If Fee Period parameters are specified and the Fee Category Calendar Instance is not ACTIVE for the student’s Fee Category.
• The Fee Category has no ACTIVE Fee Category Calendar Instances.
• The Fee Category Calendar Instance has no ACTIVE Fee Category Fee Liabilities
• The Fee Category Calendar Instance has no ACTIVE Fee Category Fee Liabilities for the specified period

Invalid Correspondence Categories in this process are defined as Correspondence Categories that are:

• Student Course Attempt does not have a Correspondence Category specified.
• The Correspondence Category that is defined for the Student Course Attempt is Closed.
• The Correspondence Category does not have any correspondence category items
• There are no active Correspondence Category Items (i.e. all of them are Logically Deleted).
• An active Correspondence Category Item has a Correspondence Type that is Closed.