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

Parameters

  • Submission Year
  • Submission Number
  • Start Date
  • End Date

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
where
:

  • HHHH = Higher Education Provider Code - (Institution code)
  • XX = File Type abbreviation code - (file type code is not case sensitive), i.e. PO
  • YYYY = Reporting Year - (must be >=2011)
  • P = Reporting Period - (1 or 2)
  • NNNNN = Submission Number - (00001 – 99999)

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