NAT00130 - Qualification Completed File
Overview
The Program completed (NAT00130) file contains records for which all requirements for the completion of the qualification, course or skill set, including on-the-job requirements, have been met. Completions for Australian Qualifications Framework (AQF) qualifications and courses are achieved when the client is eligible for the award to be conferred.
File Relationships
For each unique Training organisation identifier in the Program completed (NAT00130) file, there must be one corresponding record in the: Training organisation (NAT00010) file. For each unique Program identifier in the Program completed (NAT00130) file, there must be one corresponding record in the: Program (NAT00030) file. For each unique Client identifier in the Program completed (NAT00130) file, there must be one corresponding record in the: Client (NAT00080) file. If there are no program completions to report, then the Program completed (NAT00130) file is not required.
Qualification Completed File Structure
Silverband generated ID
AVETMISS Field Name
Paradigm Entities
Paradigm Internal Field Names
Default Paradigm field labels
Paradigm Menu Location
Field Type
Default Paradigm Value
Width
Derived Field
AVET073
Training Organisation Identifier
Provider
Training Organisation Identifier
avet073
Providers > Edit details > VET Providers Details
TEXT
-
10
N/A
AVET053
Qualification/Program Identifier
Base Course
Qualification / Course Identifier
avet053
Course > Edit details > AVETMISS fields
TEXT
-
10
N/A
AVET008
Client Identifier
Student
Student No.
studentNumber
Student > Student Details > Edit details
TEXT
-
10
N/A
AVET123
Date program completed
Course enrolment
Expected End Date
Plus
Enrolment Status = ‘Completed’
expectedEndDate
Plus
enrolmentStatusId = ‘ENROLMENT_COMPLETED’
Student > Course enrolment > Course
TEXT
-
8
N/A
AVET057
Qualification/Program (Course) Issued Flag
Course enrolment
Certificate
program_enrolment_certificate
Student > Course enrolment > Course > Graduation
SELECT
-
1
N/A
Workflow
Choose Reports > AVETMISS menus on the side.
Find the AVETMISS Qualification Completed (NAT00130) File and click the GET REPORT button
Refer to the following parameters when generating the report:
Institution: don’t need to make a selection, leave it blank
AVETMISS Report template: choose 2018 NAT00130 Qualification/Program (Course) Completed (Note: Government has no major updates to the AVETMISS reporting guidelines since 2018)
Submission Year: the year students completed their qualifications
Course enrolment Status: the system has picked Completed as the default.
Funding Source Identifier - State Training Authority: this field is for providers who need to do State VET reporting
Report Mode: choose Ultra-fast mode when the option is available
5. Click the PRODUCE REPORT button after setting the fields mentioned above.
6. In the new page, right-click on the blue hyperlink 'Here is the file' and choose "save the link as.."
7. Save the file to your preferred location
8. Open the file and double-check the file content.
NOTE:
Refer to the report details and the above file structure where you will find out where to fill out the missing information.
Last updated