...
*See /wiki/spaces/ISMS/pages/625377424
...
Guide on How to Fix Errors Procedure
This section is divided up into two main sections:
aXcelerate Validation Warnings/Errors – This section contains guidance with common errors or warnings which may appear in aXcelerate due to its built in validation rules. These rules are not as strict as those found in the national or state validation software, therefore there may be additional errors once the data has been extracted/downloaded from aXcelerate and uploaded to state or national reporting authorities.
State/National Validation Warnings/Errors – This section contains guidance with common errors or warnings which may appear on error reports from state or national reporting authorities.
aXcelerate Validation Warnings/Errors
When an AVETMISS report is run, aXcelerate runs the data through some validations to check the data for discrepancies and identify possible errors prior to the data being submitted to state or national authorities.
...
Error Example | Reason/Issue | Fix |
---|---|---|
Outcome Code cannot be 105 if the enrolment start date has passed | Unit is currently set to NoSt - Not yet started (105), with the Activity Start Date set to a date in the past. | Check if student has commenced the unit - look on cloud assess or moodle.
|
Mandatory field Student Given Names must not be blank | The student only has one name | Okay to leave as is if the name is correct for the student. Okay as per AVETMISS requirements. However, Mandatory field Student Surname must not be blank is not ok as per AVETMISS requirements. If a surname is missing and the student only has one name, move the name to the surname, the USI will still verify in this format. |
Mandatory field Course Fee must not be blank | There is not currently the option in aXcelerate to put $0 per hour in the finance model. The coordinator has had to individually update each subject. | See instructions outlined in https://team-1597131381081.atlassian.net/wiki/spaces/QD/pages/3038642224/Scope+Management+Policy+and+Procedure#Finance-models---WA-Fee-Free-Coursesfor a work around. |
Mandatory field USI must not be blank | The student who has been reported with accredited training is Missing USI. Important: A missing USI is a breach in reporting requirements. | Must obtain a USI, we cannot choose to not report competencies for VET accredited training. The only allowance for not reporting an outcome is where the Fees have not been paid. |
USI for this contact has not yet been verified in aXcelerate | A USI has not been verified. A USI must be verified to ensure that training data is not submitted against a USI which belongs to someone else. Important: An unverified USI is a breach in reporting requirements. | The USI must be verified prior to submitting the data. |
State/National Validation Warnings/Errors
Once a report in aXcelerate is clear of errors and downloaded, the next areas where errors may arise depend on the state and format:
National, SA & NSW - the AVETMISS Report (NAT files) are then uploaded to NCVER to be validated. Once validated successfully, they are then uploaded to the state portal.
QLD - the AVETMISS Report (NAT files) are uploaded directly to the state portal.
WA - the TAMS/RAPT report (Enrolment and Student files) are uploaded directly to the state portal.
National (For Total Data submission)
NCVER Validation Report
See the following NCVER links for guidance on amending validation errors and warnings:
...
Errors | Fix |
---|---|
Address - Suburb, Locality or Town and Postcode in combination (SUBURB, POSTCODE) must match the Australia Post postcode reference list. Please refer to http://auspost.com.au/postcode for the correct postcode for this address location. | This error will occur where:
To fix:
|
Address Location and Postcode in combination (SUBURB, POSTCODE) must match the Australia Post postcode reference list | As above, generally appears along with the above error |
A Specific Funding Identifier has been entered, therefore Funding Source - National (11) should be '13' or the Specific Funding Identifier should be deleted | This error will occur where:
To fix:
|
Activity periods, for Nationally recognised training, cannot overlap where multiple instances exist for a combination of Training organisation identifier (31418), Unique student identifier (XXXXXXXXX), and Subject identifier (SUBJECT CODE) | This error will occur where:
To fix:
e.g. For SA - Individual Support and disability skill set. Student is enrolled in both intakes. Only the IS intake should have CA’s first and the skill set should have N.R until the IS intake is completed. |
Activity Start Date (XXXXXXXX) must not be more than 5 years before the Collection Period Start Date | This error will occur where: A student has been enrolled in the same qualification/unit for more than 5 years. Note: this information only applies to Fee For Service training, state funding rules may be different. To fix:
*Information sourced from email received from NCVER Support to Compliance on 15 Nov 2023. See information for student Ruth Taylor for more guidance. |
'Time between Activity End Date (XXXXXXXX) and Activity Start Date (XXXXXXXX) must not be greater than 5 years' |
Queensland
The SAS Guide to Contract Errors lists the errors and information that may assist in correcting errors.
...
Below is a list of the common errors and the potential fixes that have worked previously.
AVETMISS Error Validation Report
Common Errors | Fix | |||||
---|---|---|---|---|---|---|
Multiple claim – this Module/Competency has been claimed previously | Important* Look at the supporting details_2 column on the avetmiss spreadsheet. This will help you see what the unit in question is currently being reported as with start and end dates vs what this unit was previously reported as. This information will help you figure out if the unit is a false multiple or if a ct was missed. *rare situation: The unit is seen on the USI transcript and it was completed at an RTO in another state. For some reason interstate data doesn’t always record so our data doesn’t recognise it was completed even though the transcript says it was. In this case Coordinator is to email Compliance and they will email DTET to clear this error. This error will occur where:
To fix:
| |||||
State funding not approved – Previously held qualification | This error will occur where:
Having previously completed a qualification in most instances deems the student ineligible for funding. Exemptions include:
How do I fix it?
| |||||
The postcode/suburb combination is not a Delivery Area on the Australia Post list | This error will occur where:
To fix:
| |||||
Invalid Tuition Fees Supplied | This error will occur where:
To fix:
| |||||
Student’s residential postcode is not in Queensland | The first time this error appears the Coordinator will need to fix address/postcode in aXcelerate and mark off in green on avetmiss spreadsheet. This error is likely to occur the next few times the report is run - in this case Compliance need to email DTET (contractmanagement) along with the student’s ID that proves their address. The error will keep appearing unless Compliance email DTET with evidence | |||||
AISS search not conducted | This error will occur where:
To fix:
| |||||
At school flag of Y is inconsistent with Labour force status identifier of '01' | This error will occur where:
To fix:
| |||||
Survey Contact Status ID must not be blank |
If nothing nothing is identified as mentioned above then try the fix below: In the enrolment, the field ‘Study reason’ should have an answer selected. Don’t leave as ‘not specified’. To check what the student answered for this go to their portfolio and look at the enrolment form application. Whatever the student answered for ‘What is your primary reason for wanting to study with us’ enter that answer in the study reason field on aXc | |||||
Date of birth is invalid Gender must be F, M, X Country of birth ID is invalid Survey Contact Status ID must not be blank | If multiple errors like this show at the same time it’s because there’s a symbol incorrectly used in the students name (same as above). Once the symbol is corrected then these multiple errors will clear | |||||
You have assigned a Queensland Subsidy Contract Number but the State Fund Source Code is not compatible. Please check the allocation of this Fund Source code. It may affect your payments. | This error will occur where:
To fix:
| |||||
Training Agreement status was not active for the end date supplied for module/competency. | This error will occur where:
To fix:
| |||||
Warning - Training Contract has been terminated and Training has not been finalised. | This error will occur where:
To fix:
Note: This way around is not great, as we may not be able to claim and report outcomes (Withdrawns, Competencies etc) if the agreed date has already passed. There should be communication with the trainer/employer/AASN around what agreed date is required to allow time for processing on our end for reporting and claiming outcomes (withdrawns, comptencies, completions etc). We will not get paid if the dates are not suitable. | |||||
Your organisation is not recorded as the SRTO for this Apprentice/Trainee for the duration of the training activity. | This error will occur where:
Fix:
| |||||
Withdrawn (40) outcome not supported - No record of Apprentice/Trainee training contract cancellation, withdrawal or change of SRTO. | This error will occur where:
Fix:
| |||||
Invalid Contract/Training Schedule number supplied. | This error will occur where:
Fix:
| |||||
Invalid Contract, qualification or Training contract registration number supplied (User Choice/traineeship) | Several reason why this error will occur:
Fix:
| |||||
All other errors |
Info |
---|
Note: New Validations have been introduced October 2022, which may appear on the AVETMISS Validation Error Report:
Example error received for student #10597336: |
Data Quality Errors
The AVETMISS data which Strategix submits to DTET is forwarded on by DTET to NCVER each quarter. During this process each quarter, there may be validation errors that arise, which are the Data Quality Errors received from stac@DTET.qld.gov.au.
...
Common Errors | Fix | ||||
---|---|---|---|---|---|
DQ_Overlaps | This error will occur where:
To fix:
| ||||
DQ_Postcodes_StateID | This error will occur where:
To fix:
| ||||
DQ_ProgramAudit | This error will occur where:
To fix:
| ||||
All other errors |
|
New South Wales
When NSW data is downloaded from aXcelerate, it is then uploaded to NCVER for validation and formatting purposes before being uploaded into the STS portal.
Below is a list of the common errors that have appeared at each stage of the process, and the potential fixes that have worked previously.
NCVER Validation
Potential Errors | Fix |
---|---|
Activity End Date (XXXXXXXX) must not be before the Collection Period Start Date | No fix required - This error must be ignored |
Record for this Client Identifier (C00XXXXXXX) contains publicly funded data. Please be aware that this data must be submitted via your state training authority and cannot be submitted via AVS. | No fix required - This error must be ignored |
Outcome ID - 70 should not be used for this Activity End Date (XXXXXXXX), unless reporting an Interim collection for future dated activity. | No fix required - This error must be ignored |
All other errors | Guidance on fixing all other errors is located on https://www.ncver.edu.au/rto-hub/rto-fact-sheets: |
STS Online Validation Report
The Smart and Skilled eReporting –Technical Specifications and Business Validations lists validation errors and information that may assist in correcting errors. If the link no longer works, this document is available in STS Online by clicking on the Supporting Documents page, under Smart and Skilled Contract Management.
Common Errors | Fix |
---|---|
Training Activity Data has been finalised for Commitment Id [{0}]. No further data can be accepted | The final data for this student has been successfully submitted and the Commitment ID has a status of finalised. No further data will be accepted. More of a notification - The coordinator will need to tick the following box in the student enrolment on aXcelerate: “AVETMISS: Do NOT report AVETMISS for this Student” This will ensure the enrolment no longer reports and will not be included in the next submission. |
The required number of Core Units of Competency for this qualification as specified in the training package have not been submitted. (Error ID: 1113) | These errors generally appear together, and will occur where:
To fix:
|
The Units of Competency supplied are not in accordance with the Training Package rules for this Qualification [QUAL CODE]. (Error ID: 1110) | |
At least one Unit of Competency must be reported with an outcome code of 20, 30, 40, 41, 51 or 70 before enrolment data is accepted for subsidised training. (Error ID: 1132) | |
Earliest Unit of Competency Start Date cannot be changed after commencement of training | This error will occur where:
To fix:
|
No valid program identifiers found for client ID (Error ID: 1510) | This error will occur where: The course code has not been entered at the qualification setup level in aXcelerate. Compliance will need to fix this and add the course code |
Training Activity Data clarification required Email
Sometimes while data passes initial Smart and Skilled validations, on further review of the data by the department inaccuracies may be found and the data may be rejected. The following are some errors we have received via email to the Quality team previously:
...
Note |
---|
IMPORTANT - If data is corrected or changed for any reason for a finalised enrolment (which has the “AVETMISS: Do NOT report AVETMISS for this Student” box ticked), this box must then be unticked. If it is left ticked, it will not be included in the next submission and therefore the updated data will not be reported. This could result in non-payment. |
South Australia
When SA data is downloaded from aXcelerate, it is then uploaded to NCVER for validation and formatting purposes before being uploaded into the STELA portal.
Below is a list of the common errors that have appeared at each stage of the process, and the potential fixes that have worked previously.
Pre-claim check - Training Account Data
These checks are to avoid as many Claims Errors/ loss of funding instances as possible. Checks for a comparison between data entered into aXcelerate and the Skills & Employment portal (where the training accounts are created). When found during our checks, these errors are put on the AVETMISS Errors - SA sheet.
Check | How | Why | Action |
---|---|---|---|
Training Account Found | Checks if a Training Account has been created. Searches the Skills & Employment portal data (RTO Contact ID field) for the exact Contact ID from aXcelerate. Formula: =XLOOKUP(O3,'Paste All Data report here'!H:H,'Paste All Data report here'!V:V,"MISSING",0,-1) | To avoid Claims Error “Training Account not found”. Without a valid Training Account created, we will not receive funding for the enrolment. | Check:
Action/Update:
|
Training Account Date Match | Checks if the Training Account Creation Date (SA) field in aXc enrolment exactly matches the date in the Skills & Employment portal (TA Create Date field). Formula: =IF(L3=M3,"Y","CHECK") | We refer to this field in the aXcelerate enrolment, so should keep it up to date for a reference point. | Check:
Action/Update:
|
Training Account Date created is before the Activity Start Date | Checks if the Activity Start Date in aXcelerate is before the Training Account was created (TA Create Date field in Skills & Employment Portal). Formula: =IF(G3>=M3,"Y","CHECK") | To avoid Claims Error “Unit start date is before the Training Account create date”. Any training that commenced before the creation date of the training account is not eligible for funding. If the date is not updated, we will not receive payment. | Check:
Action:
|
NCVER Validation
Potential Errors | Fix |
---|---|
Activity End Date (19072018) must not be before the Collection Period Start Date | No fix required - This error must be ignored |
Record for this Client Identifier (C0XXXXXXX) contains publicly funded data. Please be aware that this data must be submitted via your state training authority and cannot be submitted via AVS. | No fix required - This error must be ignored as the data is not being reported to NCVER, it is only being validated using this system then will be reported directly to SA. |
Outcome ID - 70 should not be used for this Activity End Date (30092019), unless reporting an Interim collection for future dated activity. | No fix required - This error must be ignored |
Survey contact status 'O' is inconsistent with Postcode (@@@@) for this Client identifier | Permanent Street Address Field: Postcode should be entered as OSPC State entered as OVS (Overseas) Street Number/Name as @@ then name of street |
All other errors | Guidance on fixing all other errors is located on https://www.ncver.edu.au/rto-hub/rto-fact-sheets: |
STELA Validation Report
The STELA NAT Upload User Guide lists validation errors and information that may assist in correcting errors during the submission.
Potential Errors | Fix |
---|---|
Duplicate Enrolments | This error will occur where:
To fix:
|
Discontinued Studies | This error will occur where:
To fix:
|
Claims Errors Report
The Skills & Employment Portal User Guide lists the payment errors.
Potential Errors | Fix |
---|---|
Qualification completion payment cannot be paid unless the Training Account status is set to Qualification Issued. | The Training Account for this Participant has not been updated to reflect that the Qualification is complete. Update the status of the Training Account to 'Qualification Issued'; |
Unit start date is before the Training Account create date | Provider is reporting units with training start date before the Any training activity that commenced before the date of the Participant’s Training Account is created is not eligible for subsidies. Check:
Action:
|
Participant has already passed this Unit | This error will occur where:
To fix:
|
Unit attempts overlap, this unit start date is within a previous unit attempt start and end date range for this unit. | This error will occur where:
To fix:
|
Combination for same student: Participant has already passed this Unit & Unit attempts overlap | This error will occur where:
To fix:
|
Training Account Not Found | This error will occur where:
To fix:
|
Western Australia
TAMS Errors
When WA data is downloaded from aXcelerate, it is then uploaded directly to the TAMS portal.
...
When errors are found, they are put on the AVETMISS / RAPT Errors - WA sheet.
Student Text File Errors:
Potential Errors | Fix |
---|---|
/ The same errors for Residential Address | This error will occur where:
To fix:
|
Mobile Phone No is invalid | Check number in Update Contact screen, and ensure correct number of digits are entered along with no “+61” etc |
Error raised when the Student ID has already been used for another student. | There has likely been a merge. Check the notes on the student’s profile. The merged student contact Student Contact ID will appear in the notes. This means that the student and enrolment txt files to contains the old student ID not the current student ID showing on aXcelerate Check which Student ID number is showing in the Student and Enrolment txt files, then update the ID number in the files to the merged ID or the current ID (i.e. if the files show the current ID, update it to the merged ID and vice versa). |
Enrolment Text File Errors:
Potential Errors | Fix |
---|---|
Duplicate Enrolment across RTO's | This error will occur where:
To fix:
|
Duplicate Enrolment within lodgement | This error will occur where:
To fix:
|
The Outcome Code is 05 or 105 and the enrolment end date has past but is less than 28 days before the lodgement date. | This error will occur where:
To fix:
|
Out of Commencing Period Error | This error will occur where:
To fix:
|
Enrolment End Date is before the Enrolment Start Date | This error will occur where:
To fix:
|
Reported UoC End Date is greater than CPS Training Activity End Date | This error will occur where:
To fix:
|
UoC/Module Hours do not match the hours as defined by STARS | This error will occur where:
To fix:
NCVER nationally agreed nominal hours *STARS = Student Training Activity Reporting System |
Enrolment Text File Warnings:
Note: warnings do not affect the lodgement of data, the monthly claim can still proceed with warnings on the list. However, these should be checked over and monitored regularly. All new warnings should have a note.
Potential Errors | Fix |
---|---|
Student is of school age and appropriate documentation must be obtained. | This error will occur where:
To fix:
|
UoC/Module is not a core or elective unit and does not belong to the same Training Package as the Contracted Program of Study | This error will occur where:
To fix:
|
A student must have the same Concession/Fee Type in a contract | This error will occur where:
To fix:
|
Enrolment Summary Checks
Potential Errors | Fix |
---|---|
Start and End Dates the same for a Competent outcome | This error will occur where:
To fix:
|
Incorrect Fees - either more or less than expected | This error will occur where:
To fix:
|
Wrong CPS used | This error will occur where:
To fix:
|
Incorrect number of units | This error will occur where:
To fix:
|
Unsuccessful enrolments check (only have a combination of CT & W-N outcomes) | This error will occur where:
To fix:
|
Incorrect Hours - either more or less than expected | This error will occur where:
To fix:
|
...