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 Provider code of course provider 3 C Academic year Mandatory Maximum field length = 2 Must be in the 07 - 12 4 D Calendar year Mandatory Maximum field length = 4 Format: YYYY 5 E Course code Mandatory Maximum length = 12 Unique code of the course e.g. MPA or VBS 6 F Course type Mandatory Maximum field length = 6 Either ‘VETCOS’ or ‘COS’ VETCOS identifies an offering in a VET industry specific course 7 G Unit code Mandatory Maximum field length = 12 Unique code for the course unit 8 H Qualification code Mandatory – where the course type is ‘VETCOS’ Maximum length = 12 Leave blank where the course type is ‘COS’ Unique code for the qualification in the VET industry specific course 9 I Estimated number of students for the course unit/qualification for the entire school regardless of teacher/class Mandatory Maximum field length = 9 Must be a whole number 10 J Contact/teacher family name Mandatory Maximum field length = 30 11 K Contact/teacher given name Mandatory Maximum field length = 30 12 L Contact/teacher registration number Mandatory Maximum field length = 15 Issued by TRBWA Must be a whole number 13 M Estimated number of students for the teacher Optional Maximum field length = 9 Must be a whole number 14 N Is this the main teacher/contact Mandatory Maximum field length = 1 Y or N Registration: Student Registration and Demographic CSV file format Column number Column reference Field Name Comment 1 A Record type SRGDG Maximum field length = 5
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 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 completed Optional Maximum field length = 4 In yyyy format 42 AP Prior education achievement 1 Optional Maximum field length = 3 008 = Bachelor degree or higher 410 = Advanced diploma or associate degree 420 = Diploma level 511 = Certificate 4 514 = Certificate 3 521 = Certificate 2 524 = Certificate 1 990 = misc education
5 E Unit code Optional Maximum field length = 12 Leave blank for a credit transfer unit of competency enrolment Mandatory when VET industry specific course code is specified 6 F Qualification code Mandatory Maximum length = 12 Unique code for the qualification the student is working towards by completing this unit of competency 7 G Unit of competency code Mandatory Maximum field length = 12 Unique code of the VET unit of competency the student is enrolling in 8 H Registered training organisation code Mandatory Maximum field length = 10 The unique code of registered training organisation offering the unit of competency on behalf of the COS provider 9 I Registered training organisation location code Optional Maximum field length = 10 Must be RTO location code for contracted RTO provider 10 J School Curriculum and Standards Authority student number Mandatory Maximum field length = 15 Must be valid student number issued by School Curriculum and Standards Authority 11 K Student family name Mandatory Maximum field length = 30 12 L Student given name Mandatory (Optional if student only has a family name) Maximum field length = 30 13 M Calendar year Mandatory Maximum field length = 4 Format YYYY 14 N Academic year Mandatory Maximum length = 2 Must be in the range: 07 - 12 15 O Semester Optional Maximum field length = 1 Mandatory for an enrolment in a UoC integrated in a VET industry specific course unit enrolment Must be 1 = semester 1, 2 = semester 2, 3 = year long 16 P Contact/teacher family name Optional Mandatory – when given name or registration number is specified Maximum field length = 30 17 Q Contact/teacher given name Optional Mandatory – when family name or registration number is specified Maximum field length = 30
18 R Contact/teacher registration number Optional Maximum field length = 15 Issued by TRBWA Must be a whole number 19 S Class identification Optional The name to identify the teacher class group as specified by the provider (i.e. Class 1) Maximum field length = 20 20 T Commencing course identifier Optional Maximum field length = 1 3 = commencing enrolment in the qualification or course 4 = continuing enrolment in the qualification or course from a previous year 8 = unit of competency or module enrolment only 21 U Enrolment activity start date Mandatory Maximum field length = 10 In valid date format – dd/mm/yyyy 22 V Enrolment activity end date Optional – will need to be specified with results. Maximum field length = 10 In valid date format – dd/mm/yyyy 23 W Delivery mode identifier Mandatory Maximum length = 2 10 = classroom-based 20 = electronic-based 30 = employment-based 40 = other delivery (e.g. correspondence) 90 = not applicable 24 X Traineeship/apprenticeship contract ID Optional Maximum field length = 10 25 Y Enrolment activity Mandatory Maximum field length = 1 E = enrolled W = withdrawn 26 Z Study reason identifier Optional Maximum length = 2 01 = to get a job 02 = to develop my existing business 03 = to start my own business 04 = to try for a different career 05 = to get a better job or promotion 06 = it was a requirement of my job 07 = I want extra skills for my job 08 = to get in another course 11 = other reason 12 = for personal interest or self-development 27 AA VET type Optional Maximum length = 1 Y = VET in schools N = VET outside of a school arrangement 28 AB Qualification enrolment Optional Maximum field length = 1 Y = enrolled in full qualification to be completed N = not enrolled in full qualification to be completed
Result: VET Unit of Competency (credit transfer or VET industry specific) CSV file format Column number Column Field Name Comment 1 A Record type RSVET Maximum field length = 5 2 B Provider code Mandatory Maximum field length = 10 Unique code for the course provider 3 C Course code Optional Maximum field length = 12 blank for a VET credit transfer unit of competency achievement Unique code of the course that the unit of competency is integrated to 4 D Course type Optional Maximum field length = 6 Must be ‘VETCOS’ when UoC is integrated into a VET industry specific course, otherwise blank 5 E Unit code Optional Maximum field length = 12 Leave blank for a VET credit transfer unit of competency enrolment Mandatory when VET industry specific course code is specified 6 F Qualification code Mandatory Maximum length = 12 Unique code for the qualification the student is working towards by completing this unit of competency 7 G Unit of competency code Mandatory Maximum field length = 12 Unique code the VET unit of competency that the results are for 8 H Registered training organisation code Mandatory Maximum length = 10 The unique code of contracted registered training organisation VETCOS or COS provider 9 I School Curriculum and Standards Authority student number Mandatory Maximum length = 15 Must be valid student number issued by the School Curriculum and Standards Authority 10 J Student family name Mandatory Maximum field length = 30 11 K Student given name Mandatory (Optional if student only has a family name) Maximum field length = 30 12 L Calendar year Mandatory Maximum field length = 4 Format YYYY
23 W Delivery mode identifier Mandatory Maximum field length = 2 10 = classroom-based 20 = electronic-based 30 = employment-based 40 = other delivery (e.g. correspondence) 90 = not applicable 24 X Traineeship/apprentices contract ID Optional Maximum field length = 10 25 Y Study reason identifier Optional Maximum field length = 2 01 = to get a job 02 = to develop my existing business 03 = to start my own business 04 = to try for a different career 05 = to get a better job or promotion 06 = it was a requirement of my job 07 = I want extra skills for my job 08 = to get in another course 11 = other reason 12 = for personal interest or 26 Z VET type Optional Maximum length = 1 Y = VET arranged and managed by school N = VET outside of a school arrangement 27 AA School-based apprenticeship/ traineeship Optional Maximum length = 4 SBT = School-Based Traineeship ASBT = Aboriginal Traineeship SBA = School-Based Apprenticeship ASBA = Aboriginal School-Based Apprenticeship PAiS = Pre-Apprenticeship in School IB = Industry based accredited course 28 AB VET USI Optional Field length = 10 Alphanumeric VET unique student identifier (USI) is required for unit of competency result to contribute towards the WACE requirements Estimates: VET Qualification Estimates CSV file format Column number Column reference Name Comment 1 A Record type ESQUAL Maximum field length = 6
Must be K, PP or 01-06 C Calendar year Mandatory Maximum field length = 4 Must be current year in CCYY format D Provider code Mandatory Maximum length = 10 Unique school code E Teacher title Mandatory Maximum field length = 10 F Teacher family name Mandatory Maximum length = 30 G Teacher given name Mandatory Maximum field length = 30 H Teacher registration number Mandatory Issued by TRBWA Maximum field length = 15 Must be whole number I Work email address Mandatory Used for the User ID Maximum field length = 100 J Administration rights for Brightpath Mandatory Maximum field length = 1 Y or N K Class identification Optional This is the name to identify the teacher class group as specified by the provider (e.g. class ABC) Maximum field length = 10 Changes to Upload Formats Upload format Date required Field Comment Number Name OFCOS Jan 2017 3 Academic year now 07-12 - 14-68 All fields 5 fields No Longer in Use removed from format. Note renumbering of columns and change of column references. Fields removed: Community service completed Release of information for Individual awards Release of information for career information Release of information for educational publications