Below is a table detailing the required fields of the Result:Endorsed Program Result (RSEND) 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: RSEND | n/a |
B | Provider code | Y | Maximum field length = 10 Unique code for the course provider | Campus Details>AGEID |
C | Endorsed programs code | Y | Maximum field length = 12 | Subject & Classes > Edit Subject > Unit Code |
D | WA student number | Y | Maximum field length = 15. Valid student number issued by SCSA | GovtCode1 |
E | Student family name | Y | Maximum field length = 30 | LastName |
F | Student given name | Y, but optional if student only has a family name | Maximum field length = 30 | FirstName |
G | Calendar year | Y | Maximum field length = 4. Format YYYY | From: Configure Compass |
H | Academic year | Y | Maximum field length = 2 Valid values: 10, 11, 12 | From: Configure Compass |
I | Semester | Y | Maximum field length = 1 Valid value 3 = year long | Subject & Classes > Class > TimePeriod |
J | Result code | Y | Maximum field length = 5 | Subject & Classes > Learning Tasks (where the task is 'WA Endorsed Program Result') > WA Endorsed Program Result |
K | Contact/teacher family name | Y, when given name or registration number is specified | Maximum field length = 30 | Subject & Classes > Class > LeadTeacher : LastName |
L | Contact/teacher given name | Y, when family name or registration number is specified | Maximum field length = 30 | Subject & Classes > Class > LeadTeacher : FirstName |
M | Contact/teacher registration number | Y, with the exception of overseas schools | Maximum field length = 15. Issued by TRBWA. Must be a whole number | Subject & Classes > Class > LeadTeacher : Teacher Registration Number (WA) |
N | Class identification | N | The name to identify the teacher class group as specified by the provider (i.e. Class 1) Maximum field length = 20 | Form Group |
O | Qualification code | Y | Maximum field length = 12 | Subject & Classes > VET Type > Learning Tasks(where the component is 'WA VET Result') > WA Qualification Code |