Below is a table detailing the required fields of the Result: COS Unit Result 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: RSCOS | n/a |
B | Provider code | Y | Maximum field length = 10 Unique code for the course provider | Campus Details > AGEID |
C | Course code | Y | Maximum field length = 10 | Third to fifth characters of Unit Code. |
D | Course type | Y | Either ‘VETCOS’ or ‘COS' | Subject & Classes > Edit Subject > Unit Code (the last part of the entry). VET in the interface = VETCOS in the report |
E | Unit code | Y | Maximum field length = 12. Unique code for the course unit that the student is enrolling where the course type is COS or VETCOS | Subject & Classes > Edit Subject > Unit Code (the first part of the entry) |
F | Qualification code | Y where the course type is VETCOS, Blank where course type is COS | Maximum field length = 12. | Subject & Classes > VET Type > Learning Tasks(where the task is 'WA VET Result') > WA Qualification Code |
G | WA student number | Y | Maximum field length = 15. Valid student number issued by SCSA | Govtcode1 |
H | Student family name | Y | Maximum field length = 30 | LastName |
I | Student given name | Y, but optional if student only has a family name | Maximum field length = 30 | FirstName |
J | Calendar year | Y | Maximum field length = 4. Must be current year in CCYY format | From: Configure Compass |
K | Academic year | Y | Maximum field length = 2. Must be in the range: 07 - 12 | From: Configure Compass |
L | Semester/year long | Y | Maximum field length = 1. Must be 1 = semester 1, 2 = semester 2, 3 = year long | Subject & Classes > Class > TimePeriod |
M | Grade | Y, but only if Course type = COS | Maximum field length = 1 | Lower primary 5 point scale |
N | Course unit practical mark–out of 10 | Y for ATAR courses with a practical examination component | Maximum field length = 3. A whole number, 0 to 100 | Subject & Classes > Learning Tasks (where the task is 'WA Course Unit Result') > WA Course Unit Practical Mark |
O | Course unit written mark – out of 10 | Y for ATAR courses | Maximum field length = 3. A whole number, 0 to 100 | Subject & Classes > Learning Tasks(where the task is 'WA Course Unit Result') > WA Course Unit Written Mark |
P | Course unit mark – out of 100 | Y for ATAR, General and Foundation Courses, | Maximum field length = 3. A whole number, 0 to 100 | Subject & Classes > Learning Tasks(where the task is 'WA Course Unit Result') > WA Course Unit Mark |