STAJ0050 - Create Commonwealth Assisted Students File

Purpose

To create a Commonwealth Asssited Students File for submission to DEST

SubSystem

Statistics

Normally Run By As a batch job, by the statistics specialist, as required
Anticipated Frequency For each Government submission
Structure Block Create Commonwealth Assisted Students File
Tab Parameters

 

This job conforms with the DEST specifications for the Commonwealth Assisted Students and Revised Commonwealth Assisted Students files.

A Commonwealth Assisted Students file is provided to DEST by Higher Education Providers each time a Student Load Liability file is submitted.

A Revised Commonwealth Assisted Students file reports personal details, including names and CHESSNs, of Commonwealth assisted students who have NOT been reported on the Student Load Liability file for a reporting period.

A Revised Commonwealth Assisted Students file is provided to DEST when the following conditions are met:

  • There is a record on the Revised Student Load Liability file, and
  • The Revised Student Load Liability file record has a student / course / half year period not previously reported.

This function includes:

  • Record Inclusion
    Includes records in the HELP Due file based on a Course, Student Status and Unit of Study Census Date combination.
  • Each record in the HELP Due File is created by aggregating Student/Course records into three Student Status categories.
    HECS-HELP (Student Status Code) = 110, 111, 112, 201, 202 and 203
    FEE-HELP (Student Status Code) = 220, 230, 231, 232, and 233
    OS-HELP (Student Status Code) = 240 and 250.
  • Submission Type
    Submission Type is used to control student data that is included in the file:
    • Commonwealth Assisted students only
    • Non-Commonwealth Assisted students only.
    • Both Commonwealth Assisted and Non – Commonwealth Assisted
    • Revisions records only

The file once created will be stored in the KEEP directory.

This job is usually run in conjunction with STAJ0040, STAJ0070, STAJ0130, STAJ0140 and STAJ0150.

Related/Dependent Jobs

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

For insights into Statistics see Understanding HE Statistics (STAINTR3).

This job is accessed via the main menu.

 

The Create Commonwealth Assisted Students File block contains:

Tab

Parameters

  • Submission Year
  • System Submission Type
  • Submission Number
  • Start Date
  • End Date

Rules/Notes:

All fields are Mandatory. 

Create HELP Due File process

The job is run to create an extract file, containing details about Student Contribution 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.

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 Student Contribution due data in each record is drawn from the GOVT_STUDENT_LOAD_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.

File Naming: The file name will be HX1234YY.AXNNNT:

  • HX always present
  • 1234 representing the Institution Code
  • YY representing the file acronym. In this case HD for HELP Due file (RD if submission type is REVISION).
  • A always present
  • X is the submission period (i.e. 1 for 1/1 to 30/6 or 2 for 1/7 to 31/12)
  • NNN representing the submission number
  • T representing the System Submission Type (C – Commonwealth Supported or N – Non Commonwealth Supported).

Rules/Notes:

Output is in the DEST file specification format.

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).

Students who have a student status of 240 and are included in the OS-HELP file are also included in this file. Their Tax File Number is retrieved from the OS-HELP record in ENRF3900 in this case, rather than the student status form ENRF3110.

 

Element Element No Width Type
Student Identification Code 313 10 Alphanumeric
Tax File Number 416 11 Numeric
Date of Birth 314 8 Numeric
Gender Code 315 1 Alphanumeric
Course Code 307 10 Alphanumeric
Student Title 405 15 Alphanumeric
Student Surname 402 30 Alphanumeric
Student Given Name – First 403 15 Alphanumeric
Student Given Name – Others 404 30 Alphanumeric
Postal Address - Part 1 406 38 Alphanumeric
Postal Address - Part 2 407 38 Alphanumeric
Postal Address - Suburb/Town 466 27 Alphanumeric
Postal Address – State 467 3 Alphanumeric
Postal Address – Postcode 409 4 Alphanumeric
Postal Address – Country Name 468 20 Alphanumeric
Address of Permanent Home Residence –Part 1 410 38 Alphanumeric
Address of Permanent Home Residence – Part 2 411 38 Alphanumeric
Residential Address - Suburb/Town 469 27 Alphanumeric
Residential Address – State 470 3 Alphanumeric
Address of Permanent Home Residence – Postcode 413 4 Alphanumeric
Residential Address – Country Name  471 20 Alphanumeric
Filler N.A. 9 Alphanumeric
(CHESSN) 488 10 Alphanumeric

 



Last Modified on 24 October, 2006

History Information

Release Version Project Change to Document
10.1 1340 - DEST 2007 Pt 2 Redundant elements removed from file structure
9.1.0.0.0.0 1230 - DEST 2007 Title changed from 'Create HELP Due File' to 'Create Commonwealth Assisted Students File'. Removal of HELP debt. Rewrite introduction. Addition of Student Status Code of 250
8.0.0.0.0.0 949 - OS HELP Elements 414, 473 and 490 removed. New note about the sourcing of TFN 's for students with External Study Loans.