Registration: Student Registration and Demographic CSV file format Column number Column reference Name Comment 1 A Record type SRGDG Maximum length = 5 2 B Provider code (a provider is a school or organisation authorised to offer the Western Australian Certificate of Education) Mandatory Maximum field length = 10 Unique code for the a course provider 3 C Calendar year Mandatory Maximum field length = 4 Must be current year format YYYY 4 D WA student number Mandatory Maximum field length = 15 Must be valid student number issued by the School Curriculum and Standards Authority 5 E Student title Optional Maximum field length = 20 e.g. Mr, Mrs, Miss, Ms 6 F Student family name Mandatory Maximum field length = 30 Legal family name of student Recommend using Title case, not all capitals e.g. ‘van Gogh’ not ‘VAN GOGH’ 7 G Student given name Mandatory (Optional if student only has a family name) Maximum field length = 30 given name of student Recommend using Title case, not all capitals 8 H Student middle name Optional Maximum field length = 30 Recommend using Title case, not all capitals 9 I Student third initial Optional Maximum field length = 1 10 J Certificate name Optional Maximum field length = 61 As printed on the certificate Recommend using Title case, not all capitals e.g. ‘Vincent van Gogh’ not ‘VINCENT VAN GOGH’ 11 K Date of birth Mandatory Maximum field length = 10 Must be valid past date Format dd/mm/yyyy 12 L Sex Mandatory Maximum length = 1 M for male, F for female or X for Other 13 M Status Mandatory Maximum field length = 1 1 – Currently at provider 2 – Deceased student 3 – Left secondary education 4 – Left from this provider 5 – Left Western Australia
14 N Home address line 1 Mandatory Maximum field length = 50 15 O Home address line 2 Optional Maximum field length = 50 16 P Home suburb Mandatory Maximum field length = 50 17 Q Home state Optional if home country (field #19) not equal Australia Maximum field length = 30 18 R Home postcode Optional if home country #19) not equal Australia Maximum field length = 10 19 S Home country Optional Maximum field length = 30 20 T Postal address line 1 Mandatory – can be same as home address, field #14 Maximum field length = 50 21 U Postal address line 2 Optional – can be same as home address, field #15 Maximum field length = 50 22 V Postal suburb Mandatory – can be same as home address, field #16 Maximum field length = 50 23 W Postal state Optional if postal country (field #25) not equal Australia – can be same as home address, #17 Maximum length = 30 24 X Postal postcode Optional if postal country (field #25) not equal Australia – can be same as home address, field #18 Maximum length = 10 25 Y Postal country Optional Maximum field length = 30 26 Z Academic year Mandatory Maximum field length = 2 Must be in the range K, PP, 01 - 12 27 AA Australian residency status Mandatory Permanent resident or citizen or country of birth = Australia or New Zealand Maximum field length = 1 Y or N 28 AB Student fee status Mandatory Maximum length = 1 Y – required to pay full fees N – not required to pay full fees 29 AC Home phone number Optional Maximum field length = 20 30 AD Alternate/mobile number Optional Maximum field length = 20 31 AE Email address Optional Maximum field length = 80 32 AF Fax number Optional Maximum field length = 20
33 AG Previous student family name Optional Maximum field length = 30 Recommend using Title case, not all upper case 34 AH Previous student given name Optional Maximum field length = 30 Recommend Title case, not all upper case 35 AI Exemption from school Mandatory – Y/N Maximum field length = 1 Is the student currently exempt from school under section 11 of the School Education Act 1999? 36 AJ Country of birth identifier Optional Mandatory, if Visa Subclass supplied (field #60) Refer to the Australian standard classification of Country codes Maximum field length = 4 37 AK Language spoken at home identifier Optional Maximum field length = 4 Refer to the Australian standard classification of language code (1201 = English) 38 AL Proficiency in spoken English Optional 1 = very well 2 = well 3 = not well 4 = not at all Maximum length = 1 39 AM Labour identifier Optional Maximum field length = 2 01 = full-time employee 02 = part-time employee 03 = self employed 04 = employer 05 = employed – unpaid work in a family business 06 = unemployed – seeking full-time job 07 = unemployed – seeking part-time job 08 = not employed – not seeking employment 40 AN Highest school level completed Optional Maximum field length = 2 02 = did not attend school 08 = Year 8 or below 09 = Year 9 or equivalent 10 = completed Year 10 11 = completed Year 11 12 = completed Year 12 41 AO Year highest school level completed Optional Maximum field length = 4 In yyyy format
5 E Student family name Mandatory Maximum field length = 30 Recommend Title case, not all capitals e.g. ‘van Gogh’ not ‘VAN GOGH’ 6 F Student given name Mandatory (Optional if student only has a family name) Maximum length = 30 Recommend Title case, not all capitals 7 G Calendar year Mandatory Maximum field length = 4 Format YYYY 8 H Academic year Mandatory Maximum length = 2 Must be one of the following values: 10, 11, 12 9 I Semester Mandatory Maximum length = 1 Valid value 3 = year long 10 J Contact/teacher family name Mandatory Mandatory when name or registration number is specified Maximum field length = 30 Recommend using Title case, not all capitals 11 K Contact/teacher given name Mandatory Mandatory when family name or registration number is specified Maximum field length = 30 Recommend using Title case, not all capitals 12 L Contact/teacher registration number Mandatory except for overseas schools Issued by TRBWA Maximum field length = 15 Must be a whole number 13 M Class identification Optional Identifies the teacher class group as specified by the provider (i.e. Class 1) Maximum field length = 20 14 N Enrolment activity Mandatory Maximum field length = 1 E = enrolled W = withdrawn 15 O Course code Optional Maximum field length = 3 Leave blank DATA NOT USED FROM 2015 16 P Qualification code Mandatory when ADWPL is part of a VET industry specific course enrolment, otherwise leave blank Maximum field length = 12