Loading...

NAT File Guidelines

NAT files are a .txt file that are used in AVETMISS reporting. They are categorized according to their data.

The NAT files have specific structures defined by National and State governments. While there are differences, the core structure is the same.

The NAT120 file is the most important and is used to control which data is included in all other files (The NAT130 is an exception which is based on completion logic)

Hence the NAT120 requirements is the most important file which controls which records are included/excluded and is the best place to start to diagnose NAT file issues.

The Training Organisation (NAT00010) file provides details of the organisation responsible for administering the information contained in the collection files.

 

 

AVETMISS Data Element FieldWisenet FieldField Location
Training Organisation Identifier (TOID)Training Organisation Identifier State field.
Use correct state value. NCVER export will read from RTO Registration Number. Enter value from TGA without leading 0s. Wisenet will add 0s depending on state requirements.
Settings
Training Organisation NameNameSettings
Training Organisation Type IdentifierCodeSettings
Address First LineStreet Address Line 1Settings
Address Second LineStreet Address Line 2Settings
Address Location – Suburb or Town or LocalityStreet Address Suburb / TownSettings
PostcodeStreet Address PostcodeSettings
State IdentifierStreet Address StateSettings
Contact NameAs listed on training.gov.auSettings
Telephone NumberTelephoneSettings
Facsimile NumberFaxSettings
Email AddressEmailSettings
Software Product NameVIC and SA only. Auto-populated by Wisenet.N/A
Software Vendor Email AddressVIC and SA only. Auto-populated by Wisenet.N/A

The Training Organisation Delivery Location (NAT00020) file provides information about the geographic location of training activity undertaken by clients during the collection period.

For a Record to appear in the NAT00020 File it needs to have a record in the NAT00120 File

AVETMISS Data Element FieldState SpecificWisenet FieldField Location
Training Organisation IdentifierTraining Organisation Identifier State field.
Use correct state value. NCVER export will read from RTO Registration Number. Enter value from TGA without leading 0s. Wisenet will add 0s depending on state requirements.
Organisation
Training Organisation Delivery Location IdentifierLocation CodeOrganisation > Locations
Training Organisation Delivery Location NameLocation DescriptionOrganisation > Locations
PostcodeLocation PostcodeOrganisation > Locations
State IdentifierLocation StateOrganisation > Locations
Address Location – Suburb, Locality or TownLocation Suburb / TownOrganisation > Locations
Country IdentifierLocation CountryOrganisation > Locations
Address Building/ Property NameVICStreet Address Building NameOrganisation > Locations
Address Flat/ Unit DetailsVICStreet Address Unit DetailOrganisation > Locations
Address Street NumberVICStreet Address Street NoOrganisation > Locations
Address Street NameVICStreet Address StreetOrganisation > Locations

The Program (Course) (NAT00030) file provides information about programs (Courses) or skill sets that are undertaken and/or completed by clients during the collection period.

A record will only appear in the NAT30 when:

  • There is a matching Course record in the NAT120 or NAT130 Files
  • Therefore MUST have at least one Course Enrolment with a Commencing Course Identifier of 3 or 4 linked to the Course
  • Have a Course Code no longer than 10 Characters
AVETMISS Data Element FieldWisenet FieldField Location
Program IdentifierCourse CodeCourse Details
Program NameCourse DescriptionCourse Details
Nominal HoursNominal HoursCourse Details
Program Recognition IdentifierRecognition StatusCourse Details
Program Level Of Education IdentifierQualification CategoryCourse Details
Program Field Of Education IdentifierField of EducationCourse Details
ANZSCO (Occupation Type Identifier)ANZSCO CodeCourse Details
VET FlagVET FlagCourse Details

The Subject (Module/Unit of Competency) (NAT00060) file provides information about subjects (modules and units of competency) that are undertaken and/or completed by clients during the collection period.

A record will only appear in the NAT60 when:

  • There is a matching Course record in the NAT120 File

Data checks:

To check which Unit Offer is appearing, use data integrity report 0777

  1. Run your desired AVETMISS export
  2. Go to Report and run report 0777

0777 will show you details of the NAT60 for your most recent export. This lets you see which Unit Offer is contributing the nominal hours to the NAT60

AVETMISS Data Element FieldWisenet FieldField Location
Subject IdentifierUnit CodeUnit Details
Subject NameUnit DescriptionUnit Details
Subject Field Of Education IdentifierUnit Field Of Education IdentifierUnit Details
VET FlagVET FlagUnit Details
Nominal HoursSupervised (Nominal) HoursUnit Offer Details. Of all the unit offers with an enrolment in the matching NAT120, the one with the latest start date.

The Client (NAT00080) file provides information about clients who undertake and/or complete training activity during the collection period. This information is used to monitor client participation patterns and to provide information related to equity issues.

A record will only appear in the NAT80 when:

  • There is a matching Client record in the NAT120 or NAT130 Files

Additional Rules:

  • For Client demographics fields, where ‘not stated’ or blank, the export will put the ‘@’ symbols as required
AVETMISS Data Element FieldState SpecificWisenet FieldField Location
Client (Student) IdentifierRef ExportLearner > Personal Details
Name for EncryptionClient First Name and Last Name
Vic only: When First Name is - or -- then it will export as 'none' for the name for encryption
Learner > Personal Details
Highest School Level CompletedHighest School Level CompletedLearner > Demographics
SexGender
If "Not Stated" or "Unspecified" then @
Learner > Demographics
Date Of BirthDate Of Birth. Else @@@@@@@@ when emptyLearner > Personal Details
PostcodePermanent Address Postcode
If at least 1 UnitEnrolment exported with National Fund Source = 30, 31, 32 then report 'OSPC'.
If PermanentAddressCountry is NOT Australia (Defined by CountryCode = 1100, 1101, 1102, 1199, 0000, @@@@) THEN report 'OSPC'.
Learner > Personal Details > Permanent Address
Indigenous Status IdentifierATSI StatusLearner > Demographics
Language IdentifierLanguageLearner > Demographics
Labour Force Status IdentifierLabour ForceLearner > Demographics
Country IdentifierCountry of BirthLearner > Demographics
Disability FlagDisability FlagLearner > Demographics
Prior Educational Achievement FlagPrior Education FlagLearner > Demographics
At School FlagStill at school? Else @ when emptyLearner > Demographics
Address Location - Suburb, Locality or TownPermanent Address Suburb / Town
If the Postcode = OSPC, 0000 or @@@@ THEN report 'Not Specified' (see Postcode logic above)
- Except SA which reports actual value
Learner > Personal Details > Permanent Address
Unique Student IdentifierUnique Student IdentifierLearner > Personal Details
State IdentifierPermanentAddressState
If at least 1 UnitEnrolment exported with National Fund Source = 30, 31, 32 then report '99'.
If PermanentAddressCountry is NOT Australia (Defined by CountryCode = 1100, 1101, 1102, 1199, 0000, @@@@) THEN report '99'.
Learner > Personal Details > Permanent Address
Address Building/ Property NamePermanent Address Building NameLearner > Personal Details > Permanent Address
Address Flat/ Unit DetailsPermanent Address Unit DetailLearner > Personal Details > Permanent Address
Address Street NumberPermanent Address Street Number
If the Postcode = OSPC, 0000 or @@@@ THEN report 'Not Specified' (see Postcode logic above)
- Except SA which reports actual value
Learner > Personal Details > Permanent Address
Address Street NamePermanent Address Street Name
If the Postcode = OSPC, 0000 or @@@@ THEN report 'Not Specified' (see Postcode logic above)
- Except SA which reports actual value
Learner > Personal Details > Permanent Address
Survey StatusSurvey StatusLearner > Personal Details
Statistical Area Level 1 Identifierleave blankLearner > Personal Details
Statistical Area Level 2 Identifierleave blankLearner > Personal Details
Learner Unique Identifier (LUI)QLDLearner Unique IdentifierLearner > Personal Details
Victorian Student Number (VSN)VICVictorian Student NumberLearner > Personal Details
Client Industry of EmploymentVIC / TASIndustry of EmploymentLearner > Demographics
Client Occupation IdentifierVIC / TASOccupation IdentifierLearner > Demographics

The Client Postal Details (NAT00085) file provides client mailing address details for the purposes of conducting the Student Outcomes Survey and/or to invite students to participate in Department endorsed projects and/or training provider audits. Use of all student details, including student contact details, is consistent with the Student Enrolment Privacy Notice.

A record will only appear in the NAT85 when:

  • There is a matching Client record in the NAT120 or NAT130 Files

Additional Rules:

  • For Client demographics fields, where ‘not stated’ or blank, the export will put the ‘@’ symbols as required
  • If the Permanent Country is not “Australia” then the Postcode value will export as ‘OSPC’. If Postcode is empty, it will export as @@@@
  • SA & TAS Only
    • the mobile number must not include spaces in the export
    • it’s ok to include spaces when you enter the mobile number in the client record, because the export will remove them automatically.
AVETMISS Data Element FieldWisenet FieldField Location
Client IdentifierRef ExportLearner > Contact Details
Client TitleTitleLearner > Contact Details
Client First Given NameFirst Name
See rules for Learners with one name
Learner > Contact Details
Client Last NameLast Name
See rules for Learners with one name
Learner > Contact Details
Address Building/ Property NamePostal Address Building NameLearner > Personal Details >Postal Address
Address Flat/ Unit DetailsPostal Address Unit DetailLearner > Personal Details >Postal Address
Address Street NumberPostal Address Street Number
If the Postcode = OSPC, 0000 or @@@@ THEN report 'Not Specified' (Except SA which reports actual value)
Learner > Personal Details >Postal Address
Address Street NamePostal Address Street Name
If the Postcode = OSPC, 0000 or @@@@ THEN report 'Not Specified' (Except SA which reports actual value)
Learner > Personal Details >Postal Address
Address Postal Delivery BoxPostal Address PO BoxLearner > Personal Details >Postal Address
Address Postal - Suburb, Locality/TownPostal Address Suburb/ Town
If the Postcode = OSPC, 0000 or @@@@ THEN report 'Not Specified' (Except SA which reports actual value)
Learner > Personal Details >Postal Address
Postcode~Postal Address Postcode
If PostalAddressCountry is NOT Australia (Defined by CountryCode = 1100, 1101, 1102, 1199, 0000, @@@@) THEN report 'OSPC'.
Learner > Personal Details >Postal Address
State IdentifierPostal Address State
If PostalAddressCountry is NOT Australia (Defined by CountryCode = 1100, 1101, 1102, 1199, 0000, @@@@) THEN report '99'.
Learner > Contact Details
Telephone Number HomeTelephone HomeLearner > Contact Details
Telephone Number WorkTelephone WorkLearner > Contact Details
Telephone Number MobileMobileLearner > Contact Details
Email AddressEmailLearner > Contact Details
Email Address AlternativeAlternative EmailLearner > Contact Details

The Client Disability (NAT00090) file provides information about the participation of clients who declare a disability, impairment or long-term condition.

A record will only appear in the NAT90 when:

  • There is a matching Client record in the NAT120 File
  • The Client has at least on Disability Value Set

Additional:

  • This file will be blank if no students have a disability.

How to Submit Blank NAT files to AVS?

AVETMISS Data Element FieldWisenet FieldField Location
Client (Student) IdentifierRef ExportLearner > Current Details
Disability Type IdentifierDisabilityLearner > Demographics

The Client Prior Education Achievement (NAT00100) file provides information about client pathways between VET and other educational sectors.

A record will only appear in the NAT100 when:

  • There is a matching Client record in the NAT120 File

AND

  • The Client has at least one Prior Education Achieved Value Set

Additional:

  • This file will be blank if no students have a disability.

How to Submit Blank NAT files to AVS?

AVETMISS Data Element FieldWisenet FieldField Location
Client (Student) IdentifierRef ExportLearner > Current Details
Prior Educational Achievement IdentifierPrior Ed AchievedLearner > Demographics
Prior Educational Achievement Recognition IdentifierPrior Ed Achieved TypeLearner > Demographics

The Enrolment (NAT00120) File provides information about training activity undertaken by Learners during the collection period. This information is used to measure training activity and output for the VET sector.

A record will only appear in the NAT120 when:

Course Enrolment Field:

  • ForAvetmiss is True

Unit Enrolment Fields:

  • Contract State matches selected export value
  • Contract Code matches selected export value
  • ForAvetmiss is True
  • Location is not empty
  • NOT have an Outcome Code that is empty OR @@ for any Export State
  • have a Unit Enrolment Start Date Year that is less than or equal to ( <= ) the Export Year (Exceptions see NSW and ACT below)
  • have a Unit Enrolment End Date Year that is greater than or equal to ( >= ) the Export Year (Exceptions see TAS)

State Specific Rules

NCVER

NSW

  • have a Unit Enrolment Start Date Year that is less than or equal to (<=) the Export Year UNLESS the Outcome = 85 then the Unit Enrolment will always report
  • the Course Enrolment “For AVETMISS Export” field must be True
  • there must be a NSW CommitmentID entered in Course Enrolment > Individual Contract ID.

ACT

For ACT you should only submit unit enrolments with training activity during the reporting period.

  • If you run the export before 30 April, unit enrolments that start after 31 March will not be included
  • If you run the export after 30 April and before 31 July, unit enrolments that start after 30 June will not be included
  • If you run the export after 31 July and before 31 October, unit enrolments that start after 30 September will not be included
  • If you run the export after 31 October, unit enrolments with a start date up til the end of the year will be included

SA

  • School Location ID This is only required where the Vet in School Flag = Y and hence a SACEID is provided against a Learner.
    This requires specific Workplace setup
  • SACE ID – Add the SACE ID against Learner (Clients) > Personal Details > SACEID. This will report in the NAT120 in the Associated course identifier position.

Learn More? Reporting Requirements in South Australia

TAS

  • have a Unit Enrolment End Date that is greater than (>) the Export Year when Outcome = ’70’
  • have a Unit Enrolment End Date that is equal to the Export Year when the Outcome is NOT = 70
AVETMISS Data Element FieldState OnlyWisenet FieldField Location
Training Organisation IdentifierTraining Organisation Identifier State field.
Use correct state value. NCVER export will read from RTO Registration Number. Enter value from TGA without leading 0s. Wisenet will add 0s depending on state requirements.
Organisation
Training Organisation Delivery Location IdentifierLocationUnit Enrolment
Client (Student) IdentifierRef ExportLearner > Contact Details
Subject IdentifierUnit CodeUnit
Program IdentifierCourse Code.
This is left empty if CommencingCourseIdentifier is 8.
Course
Activity Start DateUnit Start DateUnit Enrolment
Activity End DateUnit End DateUnit Enrolment
Delivery Mode IdentifierDelivery Mode
This will transition from AV7 to AV8
Unit Enrolment
Predominant Delivery ModeDelivery Mode Predominant (for AV8)Unit Enrolment
Outcome Identifier - NationalOutcome CodeUnit Enrolment
Scheduled HoursNominal (Supervised) Hours
Note for SA only:
- When VETFlag is False then report 0000
- When VETFlag is True then it will report the value from Scheduled Hours
Unit Enrolment
Funding Source - NationalFunding Source National (AV)Unit Enrolment
Commencing Program IdentifierCommencing Course IdentifierCourse Enrolment
Training Contract IdentifierRegistration NumberCourse Enrolment
Client Identifier - ApprenticeshipsApprenticeship IdentifierLearner > Personal
Study Reason IdentifierStudy Reason (AV)Course Enrolment
VET In Schools FlagVET in SchoolUnit Enrolment
School TypeOnly reported in QLD and NCVER.
Reported from the Workplace > School Type which is linked to the Course Enrolment > Client Position
- Create a Workplace for the School ensuring that 'School Type' is set
- Add the Learner Position for this School ensuring that 'Workplace Type' of 'School' is set
- Link this Position against the Course Enrolment
Course Enrolment
Specific Funding IdentifierSpecific Program IdentifierUnit Enrolment
Outcome Identifier - Training OrganisationOutcome Code (AV)
SA only:
Outcome Code however AP will report instead of 70 for Academic Pass

NSW only:
D - Reported when the Learner's Course Enrolment Status is set to 'Deferred'
TNC - Reported when the Learner's Course Enrolment Status is set to 'Withdrawn', 'Cancelled (no penalty)', 'Cancelled (penalty)' or 'Partial Attendance'
Unit Enrolment
Funding Source - State Training AuthorityFunding Source State (AV)Unit Enrolment Inherited from Unit Offer
Client Tuition FeeVIC / QLD / TASSee Client Tuition Fee / Course Enrolment FeeUnit Enrolment
Fee Exemption / Concession Type IdentifierFee Exemption (All except NSW/SA/VIC)
Fee Exemption AND Fee Exemption Waiver (VIC)
Concession Flag (NSW/SA)
Unit Enrolment
Purchasing Contract IdentifierContract Code (All states except (NSW/ACT)
- will report as empty based on contract export logic
SA only: Client SACE ID will report if Client > SACEID is not empty.
NSW only: Course Enrolment > CommitmentID will report if provided
ACT only: Course Enrolment > Skilled Capital ID will report if provided
Unit Enrolment
Purchasing Contract Schedule IdentifierTraining Schedule Code (Booking ID)

VIC Only: Create new training schedules under the contract with codes EXC and R38. Use these codes to exclude a specific
unit enrolment from claim processing or claim confirmation/invoicing. See How to Add or Edit a Contract and Training Schedule
Unit Enrolment
Hours AttendedActual Hours when Outcome = 40

For SA Only: Requires School Location ID to be reported. This comes from the Workplace Code for linked Learner Position where Position.WorkplaceType = School

Learn More? South Australia Reporting Rules
Unit Enrolment
Associated Course Identifier (Previous Course Identifier - VIC Only)Associated Course Code (Only displays when Recognition Status is a Skillset option)
VIC only: Previous Course Identifier from Course Enrolment
SA only: Learner > SACEID if provided
Course OR Course Enrolment (Vic)
Course Commencement DateCommencement Start DateCourse Enrolment
This date is determined by the earliest unit start date in the unit enrolment grid
VET Fee Help IndicatorVICAccessed VET FEE- HELP?Course Enrolment
Industry Code (ANZSIC)VICNo longer reported.
Enrolment DateVICMinimum value of Invoice Date or Commencement Start DateCourse Enrolment
Enrolment IdentifierVICAutomatically generatedUnit Enrolment
Client Fees – OtherVICClient Fees Other OR Resource FeeFor the Client Fee - Other, divide this evenly among all unit enrolments for this course enrolment in the NAT120.
If the Client Fee - Other is empty or zero, then report the unit enrolment resource fee for each unit enrolment instead. If the unit enrolment resource fee is empty, report it as zero.
Delivering Training RTO ABNVICDelivery Organisation ABN
This defaults from Organisation ABN unless a record is selected in the 'Delivery Organisation' field The Delivery Organisation links to a Workplace and will report the Workplace ABN
Unit Enrolment
Funding Eligibility KeyVICIndividual Contract IDCourse Enrolment
Program Enrolment IdentifierVIC / TASAutomatically generatedCourse Enrolment
Booking ID (new DET specific)NSWTraining Schedule (Training Schedule / Booking ID)Client Unit Enrolment
Course Site ID (new DET specific)NSWTraining Schedule (Contract Code)Client Unit Enrolment
Commitment IDNSWIndividual Contract ID (NSW Commitment)Course Enrolment
Training Plan DevelopedNSWTraining Plan IssuedCourse Enrolment
Full Time Identifier
(Full Time Learning Option)
QLDStudy ModeWhen Full-Time then 'Y' else 'N'Course Enrolment
Eligibility Exemption IndicatorVICEligibility Exemption FlagCourse Enrolment
Specific Program IdentifierSASpecific Program Identifier
This field is only for use by state training authorities or by training organisations as directed by the Department of Industry, Innovation, Science, Research and Tertiary Education. It must only be used when Funding source — national is ‘13 — Commonwealth specific purpose programs’.
Unit Enrolment
Client Resource FeeTASResource Fee
Rounded to nearest dollar. Proportion $ across unit enrolments as required. Empty if Nat Fund Code NOT = 11, 13 or 15.
Unit Enrolment
Workplace ABNVICWorkplace > ABNInherited from the Learner Position Workplace linked to the Course Enrolment

The Program (Qualification) Completed (NAT00130) file provides information about clients completing the requirements of qualifications. This information is used to measure the success of VET sector outcomes.

A record will only appear in the NAT130 when:

  • The Qual Issued Year must be equal to the selected Collection Year
    • The record does not need to exist in the NAT120 but does need to match the contract selection
    • Program Completion Date (Actual End Date) must be in the same year as the last Unit Enrolment End Date
  • The Qual Issue Flag is True
  • It will exclude Course Enrolments that have a Course Commencing Identifier = 8

Check Data:

If you have missing records you can generate a report:

  • 0359 and filter by COR End Date is in reporting year.
  • Download to Excel and then filter report to determine which records are missing Qual Issued Flag and/or Qual Issued Date or Program Completion Date

Vic Only

All Program Enrolments in the NAT120 will appear irrespective of Program Completion.

  • This means the count of records in the NAT130 is always at least as large as the count of records in the NAT80, and can be larger if a student studies towards more than one course in the same export year
  • If a Learner has no Year Program Completed, then when the export file is created those Learners will be reported with ‘Year Program Completed’ as @@@@.
  • Note that you cannot set a value of @@@@ in the field for Year Program Completed. The export will produce this value automatically if you simply ensure the Year Program Completed field is blank for a Learner who has not yet completed the course.

Vic and ACT

  • NAT130 excludes Program Enrolments where Commencing Course Identifier = 8.

NSW Only

  • All enrolments with a QualIssuedFlag = True irrespective of collection year will be reported where there is a matching record in NAT120 file.

TAS Only

All Program Enrolments in the NAT120 will appear irrespective of Program Completion.

  • This means the count of records in the NAT130 is always at least as large as the count of records in the NAT80, and can be larger if a student studies towards more than one course in the same export year
AVETMISS Data Element FieldState SpecificWisenet FieldField Location
Training Organisation IdentifierTraining Organisation Identifier State field.
Use correct state value. NCVER export will read from RTO Registration Number. Enter value from TGA without leading 0s. Wisenet will add 0s depending on state requirements.
Organisation
Program IdentifierCourse CodeCourse Enrolment
Client IdentifierRef ExportLearner > Personal Details
Date Program CompletedActual End Date (If empty then Nominal End Date)

For VIC: This will only report if QualIssued = Y OR Program Status is 10, 20, 60 or 80.
For TAS: Will report End Date logic if Program Status = 10 or 20 else will auto report 01/01/9999
Course Enrolment
Issued FlagQualification IssuedCourse Enrolment
Parchment NumberParchment NumberCourse Enrolment
Parchment Issue DateDate IssuedCourse Enrolment
Program Course Commencement DateVIC / TASCourse Commencement DateCourse Enrolment
This date is determined by the earliest unit start date in the unit enrolment grid
Program Unique Supervised Hours [PUSH Hours]VICUnique Training HoursCourse Enrolment
Program Supervised Teaching Activity Completion DateVICNominal End DateCourse Enrolment
Program Status IdentifierVIC / TASProgramStatusIdentifierCourse Enrolment
Program Enrolment IdentifierVIC / TASAuto generatedCourse Enrolment
Income Contingent Loan IndicatorTASAccessed VSL/VFHCourse Enrolment
Client Resource FeeTASNot currently supported. Setup Resource Fees at Unit Enrolment level to report in NAT120
Client Tuition FeeTASNot currently supported. Setup Resource Fees at Unit Enrolment level to report in NAT120
Commencing Program Cohort IdentifierVICCommencing Program Cohort (VIC)Course Enrolment
Commenced At School FlagVICCommenced At School FlagCourse Enrolment
Specialisation NameVICSpecialisation NameCourse Offer