Purpose

To export the VET Student Loans eligible students' course enrolment data from Callista SMS to the Government eCAF site

SubSystem

Statistics

This job exports the course enrolment data for VET Student Loan eligible students to the Government eCAF Site using the API provided by the Department.
It precedes the STAJ2030 job which imports students' VET Student Loans Eligible Student Status information as new Student Status records to the Record Student Status (ENRF3110) form in Callista SMS.

The process exports students when the following conditions are met:

• Student is enrolled in a VET Student Loans Approved course (CRSF1210)
• Student Course Attempt is assigned to a Fee Category where it has a Fee Type with the VET Student Loans Loan Scheme
• The student's citizenship status maps to a govt citizenship status of 1, 2 or an 8 or is NULL (unknown)
• The student course attempt has not previously been exported (The ‘Exported to eCAF’ check box in the More T-list ENRF3000 is not ticked for a student’s student course attempt - ENRF3000). 
• The student is over 18, or is under 18 and is Independent or has Parental Consent (as indicated in ENRF3060).

This job is only available to VET sector and cross sector institutions.

This job is accessed via the main menu.

Parameters Tab

'Only include students marked as Help Eligible' check box

Rules/Notes:

If the 'Only include students marked as Help Eligible' check box is selected (default) then the process only exports the students who areHELP Eligible as recorded in ENRF3060 and who also satisfy the conditions described in the introduction above.

When the job completes successfully, the following message is output to the job run log: 'STAJ2020 completed successfully. XX records processed. Check s_log_entry for any processing errors.'

Configuration

• For the system configuration required to connect with the eCAF Portal refer to eCAF Portal Configuration.

Initial Processes

• Errors are raised if configuration details are not set up correctly. (See Errors below).
• An S_LOG record of type ECAF-EXP is created to facilitate creation of S_LOG_ENTRY records during processing or any errors or warnings generated. (See Errors and Warnings below).

Processing each student

• The process identifies students who meet the following conditions:
  • Student is enrolled in a VET Student Loans Approved course (CRSF1210)
  • Student Course Attempt is assigned to a Fee Category associated with a  VET Student Loans Loan Scheme in FINF2820.
  • The student's citizenship status maps to a govt citizenship status of 1, 2 or an 8 or is NULL (unknown)
  • The student course attempt has not previously been exported (The ‘Exported to eCAF’ check box in the More T-list ENRF3000 is not ticked for a student’s student course attempt - ENRF3000). 
  • The student is 18 or over, or is under 18 and is Independent or has Parental Consent (as indicated in ENRF3060).
  • If the help eligible indicator checkbox has been selected in as the job parameter, then only process students configured as help eligible (PERSON_STATISTICS.CNFRMD_HELP_ELIGIBLE_NZ_IND = ‘Y ’)
  • Enrolment date is greater than 2 days before the export date
  • If a student doesn't have any student Unit Attempts they are not included.
• For each student the enrolment details to send are sourced as described in the table below.
• If the email_address, family_name, date_of_birth, gender, address, suburb or postcode are null, then an error is logged to the s_log_entry table (see errors below) and the record is not processed. Get course details from the student_course_attempt and course_version tables.
• If the loan cap amount doesn’t exist for the SCA , then the current loan cap amount assigned to the course_version is used.
• If the SHORT_TITLE, LOAN_CAP_AMOUNT, EST_CRS_COST, LOCATION_DESCRIPTION or COMPLETION_TIME are null, then an error is logged to the S_LOG_ENTRY log and the record is not processed.
• If the export is successful, the STUDENT_COURSE_ATTEMPT.EXPORT_TO_ECAF_IND is updated for the student's enrolment and an S_LOG_ENTRY: 'The student  + p_person_id – p_course_cd + has been successfully transferred to the Government eCAF site', is created.

When the job completes successfully:

• The following is output to the job run log: 'STAJ2020 completed successfully. X successfully records processed. Check s_log_entry for any processing errors.'
  

Errors that may be generated for this job:

• ECAF Interface endpoint not configured. Please check configuration in GENF5000.
• ECAF Interface username not configured. Please check configuration in GENF5000.
• ECAF Interface password not configured. Please check configuration in GENF5000.
• Unable to determine if proxy is used for ECAF Interface. Please check configuration in GENF5000.
• Proxy Server not configured. Please check configuration in GENF4600.
• Oracle Wallet not defined. Check configuration in GENF4710.

Warnings that may be generated for this job:

• The student enrolment ' + p_person_id + ' - ' + p_course_cd + ' cannot be exported to the Government eCAF site as the following fields are required: ' ||LIST OF MISSING FIELDS||