| Top of STA | Index | Table of Contents | Feedback | ![]() |
STAJ0170 - Create eCAF File
| Purpose |
Enables the creation of the eCAF (PO) File for submission to DEEWR |
|
| 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 here and defined in STAF1350). 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. Submission type, year and number will be the input parameter, 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.
|
Create a eCAF PO file: Select the Submission Year and System Submission Number and then run the job. File Naming The file name will be HX1234PO.AS1 where:
So if institution 4127 ran this job for submission 2, the file created would be called HX4127PO.A21 This file is created in a directory specified by the 'KEEP' environment variable. This is a secure directory which users cannot (and do not need to) access. |
Rules/Notes: Output is in the format as specified by DEEWR (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 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 Common-wealth 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 05-Nov-2008 3:38 PM
History Information
| Release Version | Project | Change to Document |
| 11.0.0.2 | Calypso 24748 | Added more detail to Introductory section |
| 10.1 | 1340 DEEWR 2007 Pt 2 | Removed redundant parts of file structure |