FINJ6120 - Statement of Account Extract

Purpose

To produce extract records containing the necessary information for inclusion on printed Statement of Account notices.

SubSystem

Finance

Normally Run By Fee Specialist
Anticipated Frequency An initial run, then a planned cycle
Structure  Block Statement Of Account Extract
Tabs Parameters
More
Buttons Find Person (ADMF1211)
Find Course (ADMF1220)
Calendar Lookup (overlay)

  

Introduction

This function is used to create an extract containing all of the relevant information that Higher Education Providers (HEPs) require to include on a hardcopy Statement Of Account (SOA) Notice. This process extracts a range of data (pertaining to the student) from Callista database tables and includes all of this data in the extract. This provides HEPs with the opportunity to use all or a subset of the data on the SOA that they issue to students.

Extract Process

When this function is run (successfully) it creates a record in the s_extract table. The data in this table identifies the type of extract that was run (s_extract_type), the creation date of the extract, the Callista job run ID and the key for the extract. The key contains details of the parameters that were defined when the process was run. The s_extract table is a generic table, which contains records for a number of different Callista extract jobs. Each extract is uniquely identified by a System Extract Type (s_extract_type) and Creation Date; the s_extract_type for the SOA is ‘ACC-STMNT’. In addition to creating a record in the s_extract table this process also creates records in the s_extract_record table. The records in the s_extract_record table are uniquely identified by the s_extract_type, Creation Date and Sequence Number of the Extract records.

The extract relates only to student debtors. A different statement (FINJ6130) is provided for sponsors undertaking payment of student's fees.

The Extract Table Methodology enables flexibility for the institution to produce customised statements of account.

Extraction Criteria

The primary Extraction Criteria is that a debt exists within the Financial Period for a student satisfying the parameter selection criteria. Records are extracted even if the debt is fully paid.

Extraction is always for a single Financial Period. Further selection can be made by supplying specific parameter values.

A Statement of Account extract will be produced if a Person Payment Schedule exists for the student with:

  • Date of issue = Notification Date.
  • Date of issue is blank, then Notification Date on or after the Current Date.
  • If the Start Date is blank and the End Date is set, records with a Notification Date from the System Date to the End Date may be extracted.
  • If the Start Date is set and the End Date is blank, records with a Notification Date from and including the Start Date may be extracted.
  • If both values are blank, records with a Notification Date equal to the System Date may be extracted.

A Statement of Account extract that includes an Opening Balance, will be produced if a Person Payment Schedule exists for the student with the criteria described above, plus a Fee Assessment Period is specified on the parameter tab.

The Start and End Range Dates are used to determine which records may be extracted. Records may be extracted if the Notification Date is within the specified date range (including the Start and End Dates).

If one entry in the schedule has a Notification Date matching the date of issue, records are extracted for all instalment entries of all the student's fees in the Fee Period.

The Correspondence Category recorded against a Student's Course Attempt (displayed in ENRF3000) includes a Correspondence Type for Statement of Account which matched the Correspondence Type supplied by parameter for this job.

For example, if the Correspondence Category STANDARD includes a Correspondence Type of STMNT-ACCT, and if STMNT-ACCT is the chosen parameter for this job run, Student Course Attempts with the STANDARD Correspondence Category are extracted.

The relationships between Correspondence Types and Categories are recorded in CORF2200.

Source tables and views of the extracted data are documented in view details. A summary of the processing logic used to extract data and write it to the extract table is also provided.

Interpretation

It should be noted that if the Maintain Person Payment Schedule form (FINF3800) shows an expected payment for a student Fee Assessment of say $685, the Statement of Account Extract records an expected payment of $685 regardless of any sponsored amounts. This is because ultimately the debt belongs to the student. Institutions can, if they wish, deduct the sponsored amount when they build their statement of account production program.

Update Process

In a successful extract, the source data for Statements of Account is written to the S_EXTRACT_RECORD table. (Refer to Extract Creation Processes.) and, unless the run is a test extraction (set by parameter):

  • A Correspondence Item is created for each extract (displayed in CORF2310) and;
  • Outgoing Correspondence is registered for each applicable student (shown in CORF2311) for the Correspondence Type selected by parameter in this job.

For further information, refer to the Correspondence subsystem.

Statement of Account Extract Records

Different types of record can be held for each individual statement of account. These records are:

  • A header record with the Financial Period and institution details including an address (Record Type = HEADER)
  • Records for each student due to receive a Statement of Account. For each student selected, the following are extracted where applicable:
    • Personal details (Record Type = PERSON)
    • Addresses (Record Type = ADDRESS)
    • Opening Balance (Record Type = OPENING-BALANCE)
    • Fee Credits (Record Type = SYSTEM-CREDIT)
    • Details of Assessed Courses (Record Type = ASSESSED-COURSES)
    • Unit Set details (Record Type = UNIT SETS)
    • Assessed Liabilities (Record Type = ASSESSED-LIABILITIES)
    • Assessed Units (Record Type = ASSESSED-UNITS)
    • Discipline Bands (Record Type = DISCIPLINE-BANDS (Previously HECS))
    • Assessment Transactions (Record Type = TRANSACTION-DETAILS)
    • External references (Record Type = EXTERNAL-REFERENCES)
    • Fee Encumbrance details (Record Type = FEE-ENCUMBRANCES)
    • Encumbrance effect details (Record Type = ENCUMBRANCE-EFFECTS)
    • Non assessed course details (Record Type = NON-ASSESSED-COURSES)
    • Non assessed unit set details (Record Type = NON ASSESS UNIT SETS)
    • Non assessed unit details (Record Type = NON-ASSESSED-UNITS)
    • Advanced Standing details (Record Type = ADVANCED STANDING)
    • Fee Capping Details (Record Type = FEE-CAP-DETAILS) - [VET-only]
  • A footer record, giving totals of all records processed (Record Type = FOOTER)

See view details documentation for more detailon each Record Type.

Run Details

Method

This job can only be run in Job Scheduler Mode, through the Job Control and Scheduling Subsystem.

Note: Only the Exception Report for this job can be run in immediate mode. The Exception Report is generated using the Log Creation Date from a previous run of this job.

In most circumstances, the job will be run shortly after the Process Person Payments job (FINJ6111).

The date and time of extract is stored with the extracted records.

Timing Considerations

The job FINJ6111 (Process Person Payment Schedules) creates records with actual dates when Fee Payments are due. Since these dates appear on statements, it is important to time the running of this extract job and the production of statements with due regard to when FINJ6111 has/will run.

If there is a delay in producing Statements of Account, a further job, Add Grace Period to Person Payment Schedules (FINJ6112) enables Payment Dates to be extended by a set number of days.

Viewing the Extracted Data

Data is usually processed by the institution's custom built statement creation/printing job. Data can be viewed in the S_EXTRACT and S_EXTRACT_RECORD tables, or in a more usable form in the views ACC_STMNT_EXTRACT_V and ACC_STMNT_RECORD_V, using an ad-hoc query tool.

This job can be accessed via the main menu.

 

The Statement Of Account Extract block contains:

Parameters Tab

  • Request Person ID

Select either:

  • Log Creation Date

Or a combination of the following parameters:

  • Correspondence Type
  • Financial Period
  • Fee Assessment Period
  • Fee Type
  • Fee Category
  • Course Code
  • Person ID

    Buttons

More Tab

  • Person ID Group
  • Institution
  • Institution Address Type
  • Date of Issue
  • Comment
  • Test Extraction check box
  • Start Range Date
  • End Range Date
  • Include Non Assessed Courses and Units check box

    Button

    • Calendar Lookup

Rule/Notes:

These records are stored in a table in the Callista database.  Note: Reminder Notices are extracted using the front-end job Reminder Notice Extract (FINJ6121).

This job also allows users to produce invoice/statement of Accounts/Enrolment Advices through the following fields:

  • Fee Contract Type
  • Contract Start Date
  • Contract End Date
  • Variable Rate Indicator
  • Contract Creation Type
  • Manual Override Indicator
  • Charge Rate
  • Percentage Variation

Note: If the Fee Type is managed at the UNIT level, then the various units contributing to the Fee may have different Notification Dates. In such cases, if the Notification Date of one of the Units falls within the Start Date Range and End Date Range parameters, then all Units for that Fee Type will be included in the extract.

Fee Cap details are not shown on the Statement of Account. (Currently, Fee capping occurs for VET and VET-TUIT Fee Types only. For more information, see FINJ35000.)

Special Consideration:
Previously in the existing documentation for Statement Of Account Extract View, the ‘ASSESSED UNITS’ Record Type was incomplete. It did not contain the existing field ‘Contact Hours’. This was due to the fact that 'Contact Hours' is a VET-related field and was the last field in previous extract versions before Version 7.0.2. However, it is now included in the documentation. See the 'Contact Hours' link above for the correct listing of fields.

Deferred Debt is always included in the extract.

Required Parameters

Select a value for Correspondence Type (see Extraction Criteria and Update Process) from the list of values (LOV) displaying the types mapped to this job. For reminder statements of account, a specific Correspondence Type should be selected. Select also an active Financial Period.

Under the More tab, select an Institution Code and Address Type, used to retrieve the required institution address for printing on the Statement of Account. (Note that the LOV shows only Closed Address Types. This is in line with the recommendation that once established, institution addresses should be closed to prevent their display in general LOVs.)

Optional Selection Parameters

To further limit the students whose records are extracted and/or the debts for which a Statement of Account is to be issued, a specific value can be nominated for any or all of the following:

  • Fee Assessment Period - will extract only students assessed in this Fee Period and causes the opening balance for the student to be extracted.
  • Fee Type (for example, Student Contribution Amount, general service fee) - will only select students with this Fee Type, and produce statements only for this fee.
  • Fee Category - will extract students who have been assessed under this category.
  • Course Code - will only select students in this course, and produce statements only for this course.
  • Person ID - to produce a statement for a single student
    OR
    Person ID Group - to target only students identified as within the group. Note that users who create Person ID groups Control ID Group security, and the list of values (LOV) will only present groups to which you have been granted access.
  • Date of Issue - is used to determine the 'current' address for each student, the current Institution Address and the current student Payment Advice number and is recorded against the Outgoing Correspondence records in the Correspondence Subsystem. If left blank, the System date is used instead, and the student Address, Institution Address and Payment Advice number current at the System Date are used.
Other Parameters

The comment is included in the extract header record (record 1) for printing on statements, if required. It is also recorded against the correspondence item.

Note: Do not include special characters in the text - these will be incorrectly interpreted by the extract process.

  • Setting the Test Extraction check box to Y (checked) enables extract records to be created without registering a Correspondence Item or Outgoing Correspondence records.
  • Start Range Date is used to set the beginning of the period to be extracted.
  • End Range Date is used to set the end of the period to be extracted.

Rules/Notes:

Exception Report

This report displays any exceptions encountered during the extract process.

This exception report is produced:

  • As a part of FINJ6120 if errors with data are encountered.
  • Individually to produce a report from a previous run log.
  • At any time deemed necessary.

Refer to the Job Control and Scheduling Subsystem for details of scheduling and running batch and online jobs.

Note: If exceptions are recorded for more than one person then the System creates a new Person ID Group containing Student ID's of records with data errors. This Person ID Group is recorded against the Correspondence Item instead.

Where appropriate, the Unit Code is appended to the end of an error message. This only occurs when an error message is in the context of a unit. For example, when processing Record Type TRANSACTION DETAILS, where the Fee Type is managed at the unit level.

Validations/Error Messages:

  • A Fee Type Group Calendar Instance could not be found for the Unit start date.

Log Creation Date

Permits Exception Reports produced from previous runs of this job to be reproduced. No further report parameters are required when this parameter is specified.

Producing Statements of Account

The extract data supplied is envisaged as sufficiently comprehensive to meet the varied needs of different institutions. Licensees will be responsible for the programming tasks involved in extracting data and producing Statements of Account from the records stored in the extract table, S_EXTRACT_RECORD via the ACC_STMNT_RECORD_V view. Statements can be tailored to the institution's formatting and content requirements.

Some matters for consideration are:

  • Whether to use a subset of the data, or to extract additional information from other Callista tables for use in a statement.
  • The totalling of assessment transactions (where a fee is paid in instalments).
  • The calculation of totals and balances across Fee Types.
  • The sort sequence that will be most useful for totalling purposes and printing layouts.

Fee Cap details extracted by this job are not shown on the Statement of Account. (Currently, Fee capping occurs for VET and VET-TUIT Fee Types only. For more information, see FINJ35000.)

Information contained in the Statement of Account extract can be viewed by students online, via Callista Connect. However, Fee Cap Details extracted by this job are not available for viewing online.

About Assessment Transactions (TRANSACTION DETAILS records)
  • The transaction category in the Assessment Transactions record has a value of either DEBT or PAYMENT.
  • For DEBT records, the Transaction Type is always ASSESSMENT, and the Transaction Amount field holds the proportion of the aggregate assessed amount due at the Transaction Date (an individual record in the Person Payment Schedule - displayed in FINF3800). The tax amount is held in a separate field, and is not included in the transaction amount.
  • For PAYMENT records, the Transaction Type is either PAYMENT or DISCOUNT. For a payment record, the transaction amount shows individual payment. transactions (not an aggregate, and not including the tax paid on the transaction). For a discount record, the transaction amount represents the discount (other than tax discount) earned on the actual amount paid.
  • Where a student is studying more than one course concurrently, an institution fee (for example, a general service fee) for the student will have ASSESSMENT transaction records with an identical amount shown against each course. This represents a single liability, to be charged only once.
  • An assessed transaction amount is shown for a Student Contribution Amount even where the Student Course Attempt has a DEFERRED Student Status (Government option 110) as at the Census Date.
  • For records with an ASSESSMENT Transaction Type, the data in the Discount Percentage, Discount Amount, Discount Minimum Payment and Tax Discount available fields represents the conditions under which a discount applies, as given in the Person Payment Schedule. These fields are blank for other than ASSESSMENT records.
  • Currency and exchange rate information for PAYMENT records is as at the time of receipt of the payment.

(For VET and VET-TUIT Fee Types only): Fee Cap details are also extracted. Note:

  • Cap minimum and maximum - These are the Fee Type Group fee cap minimum and maximum charges if a record is found that matches the student course and unit attributes. Otherwise the Fee Type Group Calendar Instance minimum/maximum charges (see below) are extracted.
  • Overall Minimum and Maximum Assessments - These are the Fee Type Group Calendar Instance minimum and maximum charges.
    Note: The Overall Minimum and Maximum Assessment Amounts are derived at the time of creating the extract, using the same derivation process that the Fee Assessment uses.

 

Last Modified on 15-Nov-2010 4:21 PM

History Information

Release Version Project Change to Document
13.0.0.2 1323 - Online Help Consolidation Identified Vet-only Help text. Edited the Special Consideration note.
12.1.0.1 1400 - Calipso 28759 Updated link to Callista logo in Header
12.0.0.2 1617 - VU - SV Fee-Help Added Validation/error message and notes about extracted fee cap charges and details.
12.0.0.2 1540 - VU Development Fees Added FEE-CAP-DETAILS Record Type