Purpose

A return file is updated for UAC to enable the finalisation of UAC processes

After the census date, Enrolment data is extracted from Callista to update the UAC Return File. This file, originally provide by UAC and then updated by the institute, is then returned to UAC to enable the finalisation of the UAC processes.

Each record in the outgoing return file will have the following fields:

• UAC Reference Number
• UAC Course Code (Callista Course Entry Point Reference Code)
• Student Number
• Enrolment Code
• Attendance Type
• Attendance Mode

Each field will have a value, otherwise a single blank space will be written to the output file.

The processing needed to provide this data includes the following features:

• Parameter Validation - Checks all Mandatory input parameters are not NULL, otherwise raises an application error, 'One or more mandatory parameters are NULL'
• File Directory Validation - Queries the tables to find where the Output/Input files will go. If none exist, it will raise an error
• File Validation - Needs to open input files to create output file. If input files cannot be opened an error is raised
• For S-LOG-ENTRY - This enables entries to be made when errors occur in the processing

See TAC Process for further details on Tertiary Admission Centre information.

This job is accessed via the main menu.

The Process UAC Return Files block contains:

Parameters Tab

• Academic Period (LOV)
• Admission Period (LOV)
• Alternate Person ID Type (LOV)
• Offer Round
• Input File Name
• Output File Name

Rules/Notes:

The current Academic Period is displayed by default.

The earliest Admission Period is displayed by default in context of the Academic Period.

Students within a different Admission Period to the one selected within the parameter form but are however within the same Academic Period are not reported to the Return Output file.

Selecting a different Academic period that does not have a mapping to the selected Admission Period result in Admission Period field being invalidated and displaying in red.

Students within the Return Input file who have Alternate Person ID’s that have Alternate Person ID Types that match the value defined to the parameter form are reported to the Return Output file.

Where an SCA has been Transferred since being uploaded, the SCA is reported to the Return Output File as not Enrolled.

Students Transferred from and Transferred to Courses are reported to the Return Output file where the Transfer to Course has a CEPRC that has a CEPRC Type of UAC HECS or UAC FEE.

Students Transferred from Course is reported to the Return Output file and the Transfer to Course is not reported where the Transfer to Course has a CEPRC that does not have a CEPRC Type of UAC HECS or UAC FEE.

Where a Student has Transferred from a Course since the UAC Upload to a Course that does not have a CEPRC, or has a CEPRC that does not have a CEPRC Type of UAC, and then has Transferred to another Course that has a CEPRC that has a CEPRC Type of UAC, Report the initial Transfer from and the final Transfer to Course within the Return Output file.

The Offer Round is the only field with '%'. All other fields are Mandatory.

The Input/Output File Name may be no longer than 60 characters in length.

All passed in parameters must not be NULL

Even though the Input/Output File Name fields allows 60 characters, the count must include file extention and separator (*.txt).

Rules/Notes:

The Enrolment column of the Return Output file displays as E where the SCA has an Attempt Status of ENROLLED or INACTIVE.

The Enrolment column of the Return Output file displays as D where the ADM_COURSE_APPL_INSTANCE has an Offer Response Status of DEFERRAL and the Deferment Status is set to APPROVED.

The Enrolment column of the Return Output file displays as N where the SCA Attempt Status is set to UNCONFIRMED, INVALID, DISCONTINUED or COMPLETED.

The Attendance Type is appropriately derived for Students within the Return Output file or the nominated file if it can't be derived.

The Attendance Mode column of the Return Output file displays as I where the Government Attendance Type that is associated with the Attendance Mode defined to the SCA is set to 1. Callista Attendance Mode mapping is N for Government Attendance Mode of 1.

The Attendance Mode column of the Return Output file displays as E where the Government Attendance Type that is associated with the Attendance Mode defined to the SCA is set to 2. Callista Attendance Mode mapping is F or O for Government Attendance Mode of 2.

The Attendance Mode column of the Return Output file displays as M where the Government Attendance Type that is associated with the Attendance Mode defined to the SCA is set to 3. Callista Attendance Mode mapping is M for Government Attendance Mode of 1.

The Attendance Mode and Type Column reports as NULL where the SCA does not have an SCA Status of ENROLLED or INACTIVE.