Below is a table detailing the required fields of the Result: Qualification Achieved export and where in Compass the data is sourced from.
For further details on SCSA reports, please refer to the 'SCSA Reports' article from the Knowledge Base.
Column Reference | Field Name | Mandatory | Field Requirements | Compass Source |
A | Record type | Y | Hardcoded to: RSQUAL | Include Only student enrolled in a VET course and have the WA VET Result = Achieved |
B | Provider code | Y | Maximum field length = 10 Unique code for the course provider | Campus Details > AGEID |
C | Qualification code | Y | Maximum field length = 12. | Subject & Classes > VET Type > Learning Tasks(where the task is 'WA VET Result') > WA Qualification Code |
D | Registered training organisation provider code | Y | Maximum field length = 10. The unique code of registered training organisation offering the qualification on behalf of the COS provider | Subject & Classes > VET Type > Learning Tasks(where the component is 'WA VET Unit of Competency') > RTO Code |
E | WA student number | Y | Maximum field length = 15. Valid student number issued by SCSA | GovtCode1 |
F | Student family name | Y | Maximum field length = 30 | LastName |
G | Student given name | Y, but optional if student only has a family name | Maximum field length = 30 | FirstName |
H | Calendar year | Y | Maximum field length = 4. Format YYYY | From: Configure Compass |
I | Academic year | Y | Maximum field length = 2. Must be in the range: 07 - 12 | From: Configure Compass |
J | Certificate issued | Y | Y/N. Y = the student has both achieved the qualification and received the qualification certificate transcript from the RTO. N = the student has achieved the qualification but has not yet received the certificate transcript from the RT | Subject & Classes > VET Type > Learning Tasks(where the component is 'WA VET Unit of Competency') > Certificate Issue |
K | VET USI | N | Field length = 10. VET unique student identifier (USI) is required for qualifications to contribute towards the WACE requirements. | Identification > VET USI |