Top of STA | Index | Table of Contents | Feedback |
STAJ0170 - Create eCAF File
Purpose | To create the eCAF file for submission to Government. | |
SubSystem | Statistics | |
Normally Run By | Statistics Specialist | |
Anticipated Frequency | As required | |
Structure | Block | Create ECAF File (PO) |
Tab | Parameters |
This job identifies STUDENT_ECAF_COMPLETION records where the initial creation date falls between the submission period start and end dates (displayed in the parameter form and defined in STAF1350). These records may be included in the Electronic Commonwealth Assistance Form (PO) file that is reported to Government and validated by HEPCAT. Where a record has been subsequently updated, the most recent update of each record is used for the extract. The Electronic Commonwealth Assistance Form (PO) file contains the information that the student has provided on the electronic Commonwealth Assistance form. Either the Request for Commonwealth Support and HECS-HELP form, or the Request for FEE-HELP Assistance form. The data reported in each record in the PO file is the minimum data requirement to enable the reconstruction of the relevant Commonwealth Assistance form if required. Each record in the file provides information for a particular student/courseattempt/student status combination. Usually there will be only one record for each student in the file. However, if a particular student is doing more than one course of study, or has more than one loan scheme within a course of study, then there may be more than one record for that student in the file. Note that students are able to update their eCAF and may do so after the the end date of the period for which it was initially created, therefore the job may correctly extract records where the creation date is greater than the submission period end date. Submission type, year and number will be the input parameters, start and end date will be derived from the govt snapshot control table. This job is accessed
via the main menu. |
The Create ECAF File (PO) block contains: Tab
|
Rules/Notes All parameters are mandatory.
|
To Create an eCAF PO File: Select the Submission Year and System Submission Number and then run the job. The file is created in a secure directory specified by the 'KEEP' environment variable. File Name: The file
name is: HHHHXXYYYY.PNNNNN
For example, 1234PO2011.100001 Note: The Submission Number used in the file name is the Submission Number defined in STAF1350 – Government Snapshot Control.
|
Rules/Notes: Output is in the format as specified by the Government (see following table). Submission Year and Number combination must exist as a Government Submission Control record with a System Submission Type of ECAF in STAF1350. There must not be a Completion Date set for this record. If the output file cannot be opened or if the specified KEEP directory cannot be found, then the job will fail and a message will be displayed in the run log. |
Element |
Element
No |
Position |
Width |
Type |
Value/Source |
Student identification code | 313 | 1-10 | 10 | Alpha-numeric | STUDENT_ECAF_COMPLETION.PERSON_ID |
Tax file number | 416 | 11-21 | 11 | Numeric | STUDENT_ECAF_COMPLETION.TAX_FILE_NUMBER * Note: this is a new field in the table |
Date of birth (not for OS-HELP) | 314 | 22-29 | 8 | Numeric | PERSON.BIRTH_DT |
Gender code (not for OS-HELP) | 315 | 30-30 | 1 | Alpha-numeric | PERSON.SEX |
Course of study code (not for OLA) | 533 | 31-40 | 10 | Alpha-numeric | STUDENT_ECAF_COMPLETION.COURSE_CD and VERSION_NUMBER |
Student surname | 402 | 41-70 | 30 | Alpha-numeric | PERSON.SURNAME record |
Student given name - first | 403 | 71-85 | 15 | Alpha-numeric | PERSON .GIVEN_NAMES(Use stap_get_person names function) |
Student given name - other | 404 | 86-115 | 30 | Alpha-numeric | PERSON .GIVEN_NAMES (Use stap_get_person names function) |
Course of study name – full (not for OLA) | 394 | 116-187 | 72 | Alpha-numeric | COURSE_VERSION.TITLE |
Campus (not for OLA) | 477 | 188-192 | 5 | Alpha-numeric | LOCATION.GOVT_LOCATION_CD |
Request for Commonwealth assistance indicator | 547 | 193-194 | 2 | Numeric | STUDENT_ECAF_COMPLETION.GOVT_ELIGIBILITY |
Signature Date | 475 | 195-202 | 8 | Numeric | STUDENT_ECAF_COMPLETION.CREATION_DT |
For OS-HELP only: | |||||
OS-HELP payment amount | 528 | 203-210 | 8 | Numeric | SPACES |
OS-HELP Study period commencement date | 521 | 211-218 | 8 | Alpha-numeric | SPACES |
For OLA only: | |||||
Postal address part 1 | 406 | 219-256 | 38 | Alpha-numeric | SPACES |
Postal address part 2 | 407 | 257-294 | 38 | Alpha-numeric | SPACES |
Postal address - state code | 467 | 295-297 | 3 | Alpha-numeric | SPACES |
Postal address - postcode | 409 | 298-301 | 4 | Numeric | SPACES |
Postal address - country name | 468 | 302-321 | 20 | Alpha-numeric | SPACES |
Unit code ** | 483 | 322-401 | 10 | Alpha-numeric | SPACES |
For Commonwealth Supported Students only: | |||||
Student contribution payment method | 548 | 402-402 | 1 | Numeric | STUDENT_ECAF_COMPLETION.GOVT_CNTRBTN_METHOD |
Filler | N.A. | 403-408 | 7 | Alpha-numeric | SPACES |
** Note For OLA students, there may be several records so this section may be repeated.
Last Modified on 23-Feb-2018 4:59 PM
History Information
Release Version | Project | Change to Document |
12.1.1.0 | 1708 - Compliance 2011 - Calipso 31933 | Updated file naming convention. |
11.0.0.2 | Calypso 24748 | Added more detail to Introductory section |
10.1 | 1340 Compliance 2007 Pt 2 | Removed redundant parts of file structure |