Objective

This articles explains the key file structure of NAT00120 - Training activity file, which explains how we mapped AVETMISS fields within the Paradigm SMS. You will learn how to generate NAT00120 file from the Paradigm. You will understand the missing information from the Report Details by referring to the below File Structure.

Complexity High

Page Contents

1 Objective
2 Assumptions
3 Key terms and concepts
4 Training activity File Structure
5 Workflow
6 Further reading
7 Related Pages

Assumptions

The User understands AVETMISS national reporting, state reporting if applicable
The User has access to AVETMISS Validation software (AVS)
The User has an understanding of txt file formats
The User has downloaded and read the latest version of VET Provider Collection specifications
The user has an understanding of the Australian Vocational Education System.

Key terms and concepts

The Training activity (NAT00120) file contains a record for each unit of competency or module undertaken by a client at a training organisation’s delivery location during the collection period.

File relationships

For each unique combination of Training organisation identifier and Training organisation delivery
location identifier in the Training activity (NAT00120) file there must be one corresponding record
in the:
Training organisation delivery location (NAT00020) file.
For each unique Program identifier in the Training activity (NAT00120) file there must be one
corresponding record in the:
Program (NAT00030) or (NAT00030A) file.

For each unique Subject identifier in the Training activity (NAT00120) file there must be one
corresponding record in the:
Subject (NAT00060) file.
For each unique Client identifier in the Training activity (NAT00120) file there must be one
corresponding record in the:
Client (NAT00080) file.
If there is no training activity and therefore no Training organisation delivery location (NAT00020)
file or Subject (NAT00060) file, then the Training activity (NAT00120) file is not required.

Training activity 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	Notes

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	Notes
AVET073	Training Organisation Identifier (TOID)	Provider	Training Organisation Identifier	avet073	Providers > Edit details > VET Providers Details	TEXT		10	N/A
AVET071	Training Organisation Delivery Location Identifier	Provider	Training Organisation Delivery Location Identifier	avet071	Providers > Edit details > VET Providers Details	TEXT		10	N/A
AVET008	Client Identifier	Student	Student No.	studentNumber	Student > Student Details > Edit details	TEXT		10	N/A
AVET037	Subject (Module/Unit of Competency Identifier)	Scheduled assessment	Code Id	codeId	Units > Unit Details > Edit Details > Assessments	TEXT	-	12	N/A
AVET053	Qualification/Course Identifier	Base Course	Qualification / Course Identifier	avet053	Course > Edit details > AVETMISS fields	TEXT		10	N/A
AVET024	Enrolment Activity Start Date	Unit Enrolment	Start Date	startDate	Student > Course Enrolment > Unit	TEXT		8	N/A
AVET023	Enrolment Activity End Date	Unit Enrolment	Not a single field		Student > Course Enrolment > Unit			8	YES	If the withdrawal date on unit enrolment is not blank, then will report this date. Otherwise, compare between Grade Release Date and Expected End Date on the unit enrolment records and report the one is greater as AVET023 in a ‘DDMMYYYY’ format.
AVET126	Delivery Mode	Scheduled unit	Delivery Mode Indentifier	avet126	Units > Scheduled Unit Details > Edit Scheduled	SELECT	YYY	3	N/A
AVET041	Outcome Identifier - National							2	YES
AVET027	Funding Source Identifier - National	Course Enrolment	Funding Source - National	avet027	Student >Course Enrolment > Course, AVETMISS Details	SELECT	11	2	N/A
AVET013	Commencing Program (Course) Identifier	Course Enrolment	Commencing Course Identifier	avet013	Student >Course Enrolment > Course, AVETMISS Details	SELECT	3	1	N/A
AVET070	Training Contract Identifier - Australian Apprenticeships	Provider	Training Contract Identifier - New Apprenticeships	avet070	Providers > Edit Details, VET provider details	TEXT		10	N/A
AVET009	Client Identifier - Australian Apprenticeships	Student	Client Identifier - New Apprenticeships	avet009	Student > Student Details > Edit details, VET students only	TEXT	0	10	N/A
AVET063	Study Reason Identifier	Course Enrolment	Study Reason Identifier	avet063	Student >Course Enrolment > Course, AVETMISS Details	SELECT	@@	2	N/A
AVET078	VET in Schools Flag	Scheduled assessment	VET in Schools	avet078	Units > Scheduled Unit Details > Edit Scheduled Assessment details	SELECT	N	1	N/A
AVET104	Specific Funding (Specific Program) Identifier						Blank space	10	N/A	None of Silveband clients will report this AVETMISS field
AVET121	School type identifier						Blank space	2	N/A	None of Silveband clients will report this AVETMISS field

Workflow

Click on the Report tab on the side menu
Click on AVETMISS option on the side menu
Find AVETMISS Enrolment (NAT00120) File, click on Get Report blue button
Refer to the following parameters of generating a report

Institution: don’t need to make selection, leave it blank

AVETMISS Report template: choose 2018 NAT00120 Enrolment (Note: Government has no major updates to the AVETMISS reporting guidelines since 2018)
Submission Year: the year you are submitting
Unit Start Date: From and to period, select the reporting year, for example, 01/01/2019 to 31/12/2019
Unit enrolment Status: The system has picked a few by default
Course/degree: leave it blank, the system will pull the relevant course/degree
Funding Source Identifier - State Training Authority: leave it blank, do not select
Report Mode: choose Ultra fast mode when the option is available

5. Click on Produce Report button

Related Pages