AVETMISS Reporting

Last updated: Aug 17th, 2017 | Ver 2.0

About Module

The Australian Vocational Education and Training Management Information Statistical Standard (AVETMISS) is the national data standard that ensures consistent and accurate capture and reporting of vocational education and training (VET) information about students.

This module is a part of Legal & Compliance module and is intended for compliance team or people responsible for reporting AVETMISS data for various kind of programs. Below sections provide step-by-step guide for the same.

SolzRBM supports AVETMISS 7 and AVETMISS 8 both. Data elements specifically applicable to AVETMISS 8 version are marked with "AVETMISS 8 only" remark.

Access AVETMISS Reports

Access Reports

Login to SolzRBM (Dynamics CRM). On the top navigation bar, navigate to Settings section and then to 'Master Data' sub-menu. Master data section has a list of items that is required to manage master data and configuration of SolzRBM.

Accessing AVETMISS Reports
enquiry menu
Master Data Section
Master Data Section

Click on 'Compliance Reports' to navigate to compliance reporting section. Compliance reports is a dedicated section to generate specifically formatted reports as per compliance standards. Select 'AVETMISS' in report dropdown and 'National' (for national reporting) or 'QLD' (for QLD state funding reporting).

Select reporting year for which you need to report data and the click specific NAT file that you need to download.

AVETMISS Reports Menu
AVETMISS Reports Menu
Select NAT Files
Select NAT Files

In order to be able to access and export compliance reports you should be a member of Compliance team in SolzRBM.

NAT Files

Training organisation (NAT00010) file

The Training organisation (NAT00010) file contains records about training organisations.

File structure:
S.No. AVETMISS Data Element SolzRBM Field SolzRBM Entity  Remarks
1 Training organisation identifier RTO Registration Number/QLD/SA Code Business Unit For state funding report state based code else RTO Registration No
2 Training organisation name Organization Name Business Unit
3 Training organisation type identifier Training Organisation Type Business Unit Not required in AVETMISS 8
4 Address first line Address1 Line2 Business Unit Not required in AVETMISS 8
5 Address second line Address1 Line1 + Address1 Line3 Business Unit Not required in AVETMISS 8
6 Address location – suburb, locality or town Address1 City Business Unit Not required in AVETMISS 8
7 Postcode Address1 Postal code Business Unit Not required in AVETMISS 8
8 State identifier Address1 State Business Unit Not required in AVETMISS 8
9 Contact name Contact Name Business Unit
10 Telephone number Telephone Business Unit
11 Facsimile number Fax Business Unit
12 Email address Em Business Unit

Training organisation delivery location (NAT00020) file

The Training organisation delivery location (NAT00020) file contains a record for each training delivery location associated with enrolment activity in a training organisation during the collection period.

A training organisation delivery location is a specific training site.

File structure:
S.No. AVETMISS Data Element SolzRBM Field SolzRBM Entity  Remarks
1 Training organisation identifier RTO Registration Number/QLD/SA Code Business Unit For state funding report state based code else RTO Registration No
2 Training organisation delivery location identifier Account No Account
3 Training organisation delivery location name Name Account
4 Postcode Address1 Postal Code Account
5 State identifier Address1 State Account
6 Address location – suburb, locality or town Addres1 Suburp/City Account
7 Country identifier Address1 Country Account
General Rules:
  • Delivery locations assoicated with active VET enrolments having an outcome and finish date should be reported
  • Is Delivery location flag should be "Yes" (Account level)
  • Funding Program for Queensland- VETis, UC, C3G, HLS
  • Funding Program for National- VFH, VSL, FFS (both)
  • Funding Program for SA - TGSS

Program (NAT00030) file

The Program (NAT00030) file contains a record for each qualification, course or skill set associated with enrolments and completions during the collection period.

A qualification, course or skill set is a structured program that may include practical experience.

File structure:
S.No. AVETMISS Data Element SolzRBM Field SolzRBM Entity  Remarks
1 Program identifier Product ID Course (Product)
2 Program name Name Course (Product)
3 Nominal hours Nominal Hours Course (Product)
4 Program recognition identifier Recognition Status Course (Product) Not required in AVETMISS 8
5 Program level of education identifier Qualification Category Course (Product) Not required in AVETMISS 8
6 Program field of education identifier Qualification Field of Education Course (Product) Not required in AVETMISS 8
7 ANZSCO identifier ANZCO Code Course (Product) Not required in AVETMISS 8
8 VET flag VET Flag Course (Product) Not required in AVETMISS 8
General Rules:
  • Program should have active study units associated with and outcome and end date OR it should have completions (NAT-130) reported in this period.
  • Student Study Unit dates should be in selection range.
  • Course Type Should be VET. Short courses are not reported
  • Student Course should be active.
  • Funding Program for Queensland- VETis, UC, C3G, HLS
  • Funding Program for National- VFH, VSL, FFS (both)
  • Funding Program for SA - TGSS

Subject (NAT00060) file

The Subject (NAT00060) file contains a record for each unit of competency or module associated with enrolment activity during the collection period.

A unit of competency or module can be studied independently but is usually offered as part of a qualification, course or skill set.

File structure:
S.No. AVETMISS Data Element SolzRBM Field SolzRBM Entity  Remarks
1 Subject flag Competency Level Study Unit Not required in AVETMISS 8
2 Subject identifier Unit Code Study Unit Specifies the unit code
3 Subject name Unit Name Study Unit Specifies the Name of unit
4 Subject field of education identifier Unit field of education Study Unit Specifies the field of education
5 VET flag Is VET Study Unit Specifies whether it's a VET
6 Nominal hours Superivised (Nominal Hours) Study Unit Specifies the nominal hours
General Rules:
  • Student Study Unit Should be Active.
  • Student Course Should be Active. "Eligible for Reporting" flag should be Yes.
  • Course Type Should be VET. Short courses are not reported
  • Funding Program for Queensland- VETis, UC, C3G, HLS
  • Funding Program for National- VFH, VSL, FFS (both).
  • Student Study Unit dates in duration range.
  • Funding Program for SA - TGSS
  • Funding Program for Queensland- VETis, UC, C3G, HLS

Client (NAT00080) file

The Client (NAT00080) file contains a record for each client who has participated in VET activity during the collection period or whose completion of a program of study is reported during the collection period.

A client is an individual who is engaged in or has completed a program of study.

File structure:
S.No. AVETMISS Data Element SolzRBM Field SolzRBM Entity  Remarks
1 Client identifier Contact ID Student
2 Name for encryption LastName, Firstname + Middlename Student
3 Highest school level completed identifier Highest School Level Completed Student Dossier
4 Year highest school level completed Year Highest School Level Completed Student Dossier Not required in AVETMISS 8
5 Sex Gender Student
6 Date of birth Date of Birth Student
7 Postcode Address1 Line2 Student If A1 country is Au, then pick from A1 else pick from A2. For International clients always "OSPC"
8 Indigenous status identifier Indegenous Status Student Dossier
9 Language identifier First Language Student Dossier
10 Labour force status identifier Labour Force Status Student Dossier
11 Country identifier Country of Birth Student Dossier
12 Disability flag Do you have any disability Student Dossier
13 Prior educational achievement flag Prior educational achievement flag Student Dossier
14 At school flag Still at School Student Dossier
15 Proficiency in spoken English identifier Proficiency in spoken English Student Dossier Not required in AVETMISS 8
16 Address location – suburb, locality or town Personal Email Student
17 Unique student identifier USI Number Student
18 State identifier Address1 or Address2 (State) Student If postcode is OSPC, always 99
19 Address building/property name Null Null
20 Address flat/unit details Address2 or Address1 (Unit No) Student
21 Address street number Address2 or Address1 (Street No) Student
22 Address street name Address2 or Address1 (Street name) Student
23 Survey contact status Survey Contact Status Student AVETMISS 8 Only
24 Learner Unique Identifier Learner Unique Identifier Student QLD only
General Rules:
  • Eligible for Reporting flag on contact should be "Yes"
  • Associated student dossier should be Active.
  • Associated Student course Should be Active.
  • Funding Program for Queensland- VETis, UC, C3G, HLS
  • Funding Program for National- VFH, VSL, FFS (both).
  • Funding Program for SA - TGSS
  • Student Study Unit dates in duration range.
  • Course Type Should be VET. Short courses are not reported
  • Contact should have active study units associated with and outcome and end date OR it should have completions (NAT-130) reported in this period.

Client postal details (NAT00085) file

The Client postal details (NAT00085) file stores address details of clients for mailing lists under the administration of states and territories.

File structure:
S.No. AVETMISS Data Element SolzRBM Field SolzRBM Entity  Remarks
1 Client identifier Contact ID Student
2 Client title Title Student
3 Client first given name FirstName Student
4 Client last name (surname) LastName Student
5 Address building/property name N.A N.A
6 Address flat/unit details Address1 Line1 Student
7 Address street number Address1 Line2 Student
8 Address street name Address1 Line3 Student
9 Address postal delivery box N.A N.A
10 Address – suburb or locality Address1 City Student
11 Postcode Addres1 Postal Code Student
12 State Address1 State Student
13 Telephone ‐ home TelePhone2 Student
14 Telephone ‐ work N.A N.A
Telephone ‐ mobile Mobile Phone Student
15 E‐mail address Personal Email Student
16 Email address [alternative] Business Email Student AVETMISS 8 Only
General Rules:
  • Student Dossier Should be Active.
  • Student Course Should be Active.
  • Funding Program for QLD- VETis, UC, C3G, HLS.
  • Funding Program for National- VFH, VSL, FFS (both).
  • Student Study Unit dates in duration range.
  • Course Type Should be VET
  • Contact Type should be student.
  • Student Study Unit dates in duration range
  • Client should have active study units associated with and outcome and end date.

Disability (NAT00090) file

The Disability (NAT00090) file contains a record for each disability, impairment, or long-term condition associated with a client. A client may have more than one type of disability, impairment, or long-term condition.

File structure:
S.No. AVETMISS Data Element SolzRBM Field SolzRBM Entity  Remarks
1 Client identifier Contact ID Student
2 Disability type identifier Disability Types (11 to 19) Student Dossier
General Rules:
  • Eligible for Reporting flag on contact should be "Yes"
  • "Do you have a disability" flag in student dossier should be "Yes"
  • Student dossier should be active.
  • Student course should be active and have an associated student
  • Funding Program for Queensland- VETis, UC, C3G, HLS
  • Funding Program for National- VFH, VSL, FFS (both).
  • Funding Program for SA - TGSS
  • Course Type Should be VET. Short courses are not reported
  • Contact should have active study units associated with and outcome and end date OR it should have completions (NAT-130) reported in this period.

Prior educational achievement (NAT00100) file

The Prior educational achievement (NAT00100) file contains a record for each type of prior educational achievement for a client. A client may have more than one type of prior educational achievement.

File structure:
S.No. AVETMISS Data Element SolzRBM Field SolzRBM Entity  Remarks
1 Client identifier Contact ID Student
2 Prior educational achievement identifier Prior educational achievement flag Student Dossier
General Rules:
  • Student Should be Active
  • Prior Education Achievement Flag should be yes (student dossier)
  • Student dossier should be Active
  • Student course should be active
  • Course Type Should be VET. Short courses are not reported
  • Student study unit should be active.
  • Funding Program for Queensland- VETis, UC, C3G, HLS
  • Funding Program for National- VFH, VSL, FFS (both).
  • Funding Program for SA - TGSS
  • Contact should have active study units associated with and outcome and end date OR it should have completions (NAT-130) reported in this period.
  • Eligible for Reporting flag on contact should be "Yes"

Enrolment (NAT00120) file

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

File structure:
S.No. AVETMISS Data Element SolzRBM Field SolzRBM Entity  Remarks
1 Training Organisation Delivery Location Identifier Account Number Account (Delivery location of Student course)
2 Client identifier Contact ID Contact (Student)
3 Subject identifier Unit Code Study Unit
4 Program identifier Product ID Product
5 Activity start date Start Date Student Study Unit or Student Course If dates are not found on student study unit, student course start and finish dates will be reported
6 Activity end date Finish Date Student Study Unit or Student Course
7 Delivery Mode Identifier Delivery Medium Student Study Unit For CT and EX units it's always 70
8 Outcome Identifier - National Competency Student Study Unit
9 Scheduled Hours Nominal (Supervised) Hours Study Unit State Funding Only (AVETMISS 8). Zero if Outcome identifier — national is ‘60 — Credit transfer/national recognition’.
10 Funding Source National Funding Source National Student Study Unit
11 Commencing program identifier Logic Based If a unit started in same year and ended in same year 3 else 4.
12 Training Contract Identifier New Apprenticeships Registration Number Student Course AAC Only Applicable for User Choice
13 Client Identifier – New Apprenticeships Contact ID Contact (Student)
14 Study Reason Identifier Reason for Study Student Dossier
15 VET In Schools Flag Logic Based If program is being offered under VETis Funding Yes
16 Specific funding identifier Not being reported Not being reported
17 School type identifier Schoot Type Identfieri Account (Delivery location of Student course) AVETMISS 8 Only
18 Outcome Identifier Training Organisation Competency Student Study Unit
19 Funding Source State Training Authority Funding Source State Student Study Unit
20 Client Tuition Fee Unit Fees Student Study Unit
21 Fee Exemption / Concession Type Identifier Fee Exemption Student Study Unit
22 Purchasing Contract Identifier Logic Based -
23 Purchasing Contract Schedule Identifier Logic Based -
24 Hours Attended Not being reported Not being reported For SA/TGSS funding report School Location ID (student course level/School Location)
25 Associated course identifier Not being reported Not being reported For SA/TGSS funding report SACE student ID (student/contact level)
26 Full Time Learning Option^ Study Mode Student Course
27 Predominant delivery mode Predominant delivery mode Student Course AVETMISS 8 Only
General Rules:
  • Only study unit enrolments with an outcome and end date should be reported.
  • Student study unit must be active. Study Unit should also be active
  • Course Type Should be VET. Short courses are not reported
  • Funding Program for Queensland- VETis, UC, C3G, HLS
  • Funding Program for National- VFH, VSL, FFS (both)
  • Funding Program for SA - TGSS
  • There should a delivery location associated with Student Course and "Is Delivery Location" flag should be "Yes".
  • Student course should be Active
  • Study Unit (linked with) Student Study unit should be active
  • Eligible for Reporting flag on student course should be "Yes"

Program completed (NAT00130) file

Fill any other details and save all the changes. Once changes are saved, click on the 'Qualify' button located in the record menu bar at the top. This will convert this enquriy to an application.

File structure:
S.No. AVETMISS Data Element SolzRBM Field SolzRBM Entity  Remarks
1Training organisation identifierTraining organisation identifierQLD code/Registration No.Business Unit
2Program identifierProgram identifierProduct IDCourse (Product)
3Client identifierClient identifierContact IDStudent
4Date Program CompletedDate Program CompletedQualification issued dateStudent Course
5Year program completedYear program completedQualification issued dateStudent Course
6Issued FlagIssued FlagDefault valueDefault
7Parchment Issue DateParchment Issue DateDate IssuedCertificate
8Parchment NumberParchment NumberNameCertificate
General Rules:
  • Qualification issued flag on student course level should be "Yes"
  • Qualification issued date should be in reporting duration
  • Student Couse should be active
  • Course Type Should be VET. Short courses are not reported
  • Eligible for Reporting flag should be "Yes" on student course.