Registration: Student Registration and Demographic CSV file format Column Column Name Comment number reference SRGDG 1 A Record type Maximum length = 5 Provider code (a provider is a Mandatory school or organisation Maximum field length = 10 2 B authorised to offer the Unique code for the a course provider Western Australian Certificate of Education) Mandatory 3 C Calendar year Maximum field length = 4 Must be current year format YYYY Mandatory Maximum field length = 15 4 D WA student number Must be valid student number issued by the School Curriculum and Standards Authority Optional 5 E Student title Maximum field length = 20 e.g. Mr, Mrs, Miss, Ms Mandatory Maximum field length = 30 6 F Student family name Legal family name of student Recommend using Title case, not all capitals e.g. Gogh’ not GOGH’ ‘van ‘VAN Mandatory (Optional if student only has a family name) 7 G Student given name Maximum field length = 30 given name of student Recommend using Title case, not all capitals Optional 8 H Student middle name Maximum field length = 30 Recommend using Title case, not all capitals Optional 9 I Student third initial Maximum field length = 1 Optional Maximum field length = 61 10 J Certificate name As printed on the certificate Recommend using Title case, not all capitals e.g. van Gogh’ not VAN GOGH’ ‘Vincent ‘VINCENT Mandatory Maximum field length = 10 11 K Date of birth Must be valid past date Format dd/mm/yyyy Mandatory 12 L Sex Maximum length = 1 M for male, F for female or X for Other Mandatory Maximum field length = 1 1 Currently at provider – 13 M Status 2 Deceased student – 3 Left secondary education – 4 Left from this provider – 5 Left Western Australia –
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
Upload-Formats-for-SIRS-2018.DOCX