Reminder Notice Extract - FINJ6121

This process updates the database
Subsystem	Student Finance
Purpose	To produce extract records containing the necessary information for printing of Reminder Notices. These records are stored in a table in the Callista database.
Normally Run By	A fees administrator
Anticipated Frequency	An initial run, then a planned cycle
Parameter Samples
Report	Reminder Notice Exception report
Report Sample
Topics	Extract Process, Update Process, Run Details, Job Parameters, Producing Statements of Account, Record Layouts, Processing Logic

Extract Process

A wide range of data is extracted from relevant Callista database tables. This data, plus some entered by parameter, (and data from other Callista tables if required) is the source for the creation of Reminder Notices for students with fees overdue in a given period. It is written in the form of extract records to the generic S_EXTRACT_RECORD table. A single record is written to the S_EXTRACT table to identify a particular run instance of this job for which extract records have been created. 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 allows flexibility for the institution to produce customised reminder statements. Note: For students without sponsorship and with OVERDUE fees the job only extracts a reminder notice for them once. But subsequent runs of FINJ6121 do not create the same reminder notice extract For partially sponsored students with OVERDUE fee amounts (student portion) and whose sponsorship fee amounts are NOT OVERDUE the job extracts reminder notice for these students only once. But subsequent runs of FINJ6121 do not create the same reminder notice extract. For partially sponsored students with OVERDUE fees (student portion) and whose sponsorship fee amounts are also OVERDUE the job extracts reminder notice for these students only once. But subsequent runs of FINJ6121 do not create the same reminder notice extract. For a partially sponsored student whose fees (student portion) are NOT OVERDUE and whose sponsorship fees are OVERDUE the job does not create reminder notices for these student Extraction criteria The basis of extraction is that a debt exists within the financial period for a student satisfying the parameter selection criteria. Extraction is always for a single financial period. Further selection can be made by supplying specific parameter values. Records are only extracted if the correspondence category recorded against a student's course attempt (displayed in ENRF3000) includes a correspondence type for Reminder Notice which matches the correspondence type supplied by parameter for this job. For example, if the correspondence category STANDARD includes a correspondence type of REMNDR-SOA, and if REMNDR-SOA 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.

Update Process

In a successful extract: source data for Reminder Notices is written to the S_EXTRACT_RECORD table. (Refer to Extract Creation Processes.) the last reminder date in the person payment schedule table will either be inserted or updated. 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 registered for each applicable student (shown in CORF2311) against the correspondence type selected by parameter in this job. For further information, refer to the Correspondence subsystem.

Reminder Notice extract records Up to fourteen different types of record can be held for each individual Reminder Notice. 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 Reminder Notice. For each student selected, the following are extracted where applicable: personal details (record type = PERSON) addresses (record type = ADDRESSES) 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) HECS contribution bands (record type = HECS CONTRIB BANDS) 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) a footer record, giving totals of all records processed (record type = FOOTER). See view details documentation for more detail.

Run Details

Method This job can only be run in batch mode, through the Job Control & Scheduling subsystem. Note: The report can only be generated in immediate mode using log creation date parameter which permits exception reports produced from previous runs of this job to be reproduced. The date and time of extract is stored with the extracted records. Timing considerations It is appropriate to start running this job sometime after student fees become overdue in accordance with the accepted procedure for your institution. 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 useable form in the views ACC_STMNT_EXTRACT_V and ACC_STMNT_RECORD_V, using an ad-hoc query tool.

Job Parameters

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. Select also an active financial period. Select an institution code and address type, used to retrieve the required institution address for printing on the Reminder Notice. (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.) Setting the Exclude Sponsor Debt indicator to Y will extract students where they have a personal liability. This will apply when they are not sponsored at all or when they are partially sponsored and the student's portion is overdue. Setting the Include Previously Reminded indicator to Y will report the total overdue debt status at each instance a new debt becomes overdue. Optional selection parameters These parameters have a default value of % indicating that all data values relevant to the parameter should be processed. To further limit the students whose records should be extracted and/or the relevant debts for which a Reminder Notice is to be issued, a specific value may be specified for any or all of the following: the fee assessment period - will extract only students assessed in this fee period the fee type (e.g. HECS, general service fee) - will only select students with this fee type, and produce statements only for this fee the fee category - will extract students who have been assessed under this category the course - will only select students in this course, and produce statements only for this course the Person ID to produce a statement for a single student OR the 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. the date of issue is recorded against the outgoing correspondence records. the days overdue - will only extract students where the number of days since the PPS due date is equal to or exceeds this number. If the figure is zero or NULL all overdue debt will be included. the days since last reminder - is used for managing the frequency of producing reminder notices for overdue debts. It will select students whose number of days since the last reminder exceeds or is equal to the days specified here. If there is a value of NULL and the last reminder date in the person payment schedule has a NULL value then this debt will be included. 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: Please do not include special characters in the text - these will be incorrectly interpreted by the extract process. Setting the Test Extraction indicator to Y allows for extract records to be created without registering a correspondence item or outgoing correspondence records. Checking the Include Deferred Debt checkbox causes any deferred debts to be included in the extract. These can be identified from the associated HECS Payment Option, which is also extracted.

Exception Report

This report displays any exceptions encountered during the extract process.

Run Details

This exception report is produced As part of FINJ6121 if errors with data are encountered Individually to produce a report from a previous run log At any time deemed necessary for whatever reason 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.

Report Parameters

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. This is a log created by a previous run for FINJ6121

Producing Reminder Notices

Producing Reminder Notices 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 Reminder Notices from the records stored in the extract table, S_EXTRACT_RECORD via the ACC_STMNT_RECORD_V view. These statements can thus be tailored to an individual 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 any other Callista table 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. 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 HECS fee even where the student course attempt has a DEFERRED HECS payment option (government option 10) 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.

Last Modified on 11 March 2002