Loading...

Data Integrity Reports AU

Wisenet has a range of reports designed to let you check your data in advance of government reporting.

  • You can export these reports to Excel and look for blank entries in compulsory fields using Excel data filtering
  • Or you can set the filters to return specific entries for a certain field
  • Use whichever method works for you
Report numberReport nameNotes
0003Course UnitsThis report will help you identify the NCVER duplicate units error 3808. For more information, see AVETMISS Error: Duplicate Units
0443Course Details AustraliaCheck that all mandatory fields are completed correctly.
- Required fields for AVETMISS reporting are colour-coded for ease of use.
- Note that you may not need to run this report of0443ten as Course details do not generally change very rapidly.
0446Unit Details (Australia)Check that all mandatory fields are completed correctly.
- Required fields for AVETMISS reporting are colour-coded for ease of use.
- Note that you may not need to run this report often as unit details do not generally change very rapidly.
0217Unit Enrolment Outcome Matrix1. In Step 2, In the General Filter section, select Unit Enrolment ForAVETMISS is 'True' and 'Outcome Code' is 'Empty'
- This will retrieve any unit enrolments with a blank outcome code
- Update unit enrolments with the correct outcomes - see How To Bulk Update
2. In Step 2, In the General Filter section, select 'unit enrolment end date' is less than or equal to the export date and 'Outcome Code' is '70'
- This will retrieve any unit enrolments where the end date has passed but the outcome code says 'Continuing Enrolment'
- Update unit enrolments with the correct outcomes - see How To Bulk Update
0316Client AVETMISS Details (EXCEL)Check that all required fields have been completed in learner personal and demographic details.
0448AVETMISS NAT120 Data IntegrityRun this report to check all learners, course and unit enrolment, outcomes and dates data
0359Qualification Issued ReportThis report will help in identifying the NCVER Error 4017 which often occurs in your first submission for the new year and the issue is caused by not reporting that the Program has been completed in the same Collection year as the Unit End Dates. Check the Issued year matches either the actual end date or the end date year.
0820Client Character ErrorsUse this report to identify any records that have been entered with special characters. For e.g. Instead of entering Jane in the first name, a user has erroneously entered J@ne.

Special characters in AV fields will cause the export to fail or blank NAT files may be generated.