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

1. Choose Reports > AVETMISS menus on the side.

2. Find the AVETMISS Qualification Completed (NAT00130) File and click the GET REPORT button

3. 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.