Create the HECS Due File - STAJ0050

Subsystem

Statistics

Purpose

To create the HECS Due file for use in DESTPAC

Normally Run By

 As a batch job, by the statistics specialist, as required

Anticipated Frequency

 For each government submission

Parameter Sample

Related/Dependent Jobs

This job is dependent on the Create Government Submission Snapshot process (STAJ0110) being performed, for the particular submission, first

 

Run Details

This job is usually run in conjunction with STAJ0020, STAJ0040, STAJ0060, STAJ0070, STAJ0080 and STAJ0090.

The job is run to create an extract file, containing details about HECS debts which are to be recovered through the taxation system and personal details for the students who have the debt. The file is created in accordance with the DEST file specification, for loading into DESTPAC, and is only created for submissions 1 and 2.

Creation of this file assumes that address details are set up correctly, in accordance with the requirements specified in Statistics Subsystem Data Pre-requisites. The Job Scheduler Run Log should be checked for entries resulting from running this job. These entries identify missing or errant address and Tax File Number details.

The file's header record contains contact details for the 'local' institution, drawn from Institution Addresses (ORGF0122). Course attempt and HECS due data in each record is drawn from the GOVT_STUDENT_LIABILITY table, with student name and address details and tax file number details extracted from the database via special routines which manipulate this data into the required format.

 These records are stored in the institution specific DU file (with which statistics specialists will be familiar), in a directory specified by the 'KEEP' environment variable. This is a secure directory which users cannot (and do not need to) access.

The process 'Copy Extract Files From Secure Area' (STAJ0120) allows the DU file to be copied from the 'KEEP' directory to an accessible directory, specified by the 'USER' environment variable (refer to your system administrator).

 

Job Parameters

The single parameter is used to specify the submission for which the job is being run. By specifying a previous submission, an earlier DU file can be reproduced.

Output

 Output is in the DEST file specification format.

Updated 31 January 2002