Below is a table detailing the required fields of the Result: Externally Set Tasks 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: RSEST | 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 | Externally Set Task (EST) code | Y | Maximum field length = 1 | Subject & Classes > Edit Subject > EST 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. Must be current year in YYYY format | From: Configure Compass |
I | Academic year | Y | Maximum field length = 2. Must be the following values only: 10, 11, 12 | From: Configure Compass |
J | EST total raw mark | Y, For year 12 General and Foundation courses who sat EST | Maximum field length = 3. A whole number, 0 to max EST raw score, or ABS for Absent | Subject & Classes > Learning Tasks (where the task is 'WA EST Result') > EST Total Marks |