Top of STA | Index | Table of Contents | Feedback | ![]() |
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:
This function includes:
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
|
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:
|
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. |