Below is a table detailing the required fields of the Enrolment:Endorsed Programs 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.
Only Includes students enrolled in course type: END
Column Reference | Field Name | Mandatory | Field Requirements | Compass Source |
A | Record type | Y | Hardcoded to: ENEND | n/a |
B | Provider code | Y | Maximum field length = 10 | 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 | 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 | Subject & Classes > Class > TimePeriod |
J | Contact/teacher family name | Y when given name or registration number is specified | Maximum field length = 30 | Subject & Classes > Class > LeadTeacher : LastName |
K | Contact/teacher given name | Y | Maximum field length = 30 | Subject & Classes > Class > LeadTeacher : FirstName |
L | Contact/teacher registration number | Y, Except for overseas schools | Maximum field length = 15. Must be whole number | Subject & Classes > Class > LeadTeacher : Teacher Registration Number (WA) |
M | Class identification | N | Maximum field length = 20 | Subject Name |
N | Enrolment Activity | Y | Hardcoded to "E" as we only retrieve active enrolments. Valid values are "E" and "W" | n/a |
O | Course code | N | Left Blank | n/a |
P | Qualification code | Y when ADWPL is part of a VET industry specific course enrolment. Otherwise, left blank. | Left Blank | n/a |