Below is a table detailing the required fields of the Enrolment:COS 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 | Field Name | Mandatory | Field Requirements | Compass Source |
A | Record type | Y | Hardcoded to: ENCOS | 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 = 12. Unique code for the Course | Subject & Classes > Edit Subject > 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 | 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 YYYY format | From: Configure Compass |
K | Academic year | Y | Maximum field length = 2. Must be in the range: 07 - 12 | From: Configure Compass |
L | Semester | Y | Maximum field length = 1 Must be 1 = semester 1, 2 = semester 2, 3 = year long | Subject & Classes > Class > TimePeriod |
M | Contact/teacher family name | Y | Maximum field length = 30 | Subject & Classes > Class > LeadTeacher : LastName |
N | Contact/teacher given name | Y | Maximum field length = 30 | Subject & Classes > Class > LeadTeacher : FirstName |
O | 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) |
P | Class identification | Y | Maximum field length = 20 | FormGroup of student |
Q | Contact/teacher email address | Y | Maximum field length = 100 | Subject & Classes > Class > LeadTeacher : Email |
R | Enrolment activity for course | Y | Hardcoded to "E" as we only retrieve active enrolments. Valid values are "E" and "W" | n/a |
S | Enrolment activity for course unit | Y | Hardcoded to "E" as we only retrieve active enrolments. Valid values are "E" and "W" | n/a |