Export Course Offerings (OFCOS)

Export file code.

Note: This value is always "OFCOS".

Provider code of the school or organisation authorised to offer the Western Australian Certificate of Education.

• This value is defined using the CurriculumCouncil_SchoolCode configuration setting. See WASCSA_SchoolCode configuration setting.
• This value has a maximum field length of 10 characters.

Academic year.

• This value is defined using the Normal Year Level field on the General tab of Class Maintenance. See Class Maintenance - General tab.
• The values of the Normal Year Level field are defined using the luYearLevel lookup table. See luYearLevel lookup table.
• This value has a maximum field length of 2 characters.

Note: SCSA requires this value to be either 10, 11 or 12. This is not enforced in Synergetic, so you must check the export file to ensure no students prior to Year 10 are included.

Calendar year.

• This value is defined using the Process Date field on the WA SCSA tab of the Import/Export Student Data window. See Import_Export Student Data - WA SCSA tab.
• This value has a maximum field length of 4 characters.
• This value has the format YYYY.

Course code.

Note: The Course code is the third to fifth characters of the Board Studies Code.

• This value is defined using the Board Studies Code on the General tab of Class Maintenance. See Class Maintenance - General tab.
• The values of the Board Studies Code field are defined using the luBoardStudiesSubjects lookup table. See luBoardStudiesSubjects lookup table.
• This value has a maximum field length of 12 characters.

Course type.

Note: This value can be either COS or VETCOS.

• This value is defined using the Board Studies Type field on the General tab of Class Maintenance. See Class Maintenance - General tab.
• The values of the Board Studies Type field are defined using the luBoardStudiesType lookup table. See luBoardStudiesType lookup table.
• This value has a maximum field length of 6 characters.

Unit code.

Note: The Unit code is the first twelve characters of the Board Studies Code.

• This is defined using the Board Studies Code on the General tab of Class Maintenance. See Class Maintenance - General tab.
• The values of the Board Studies Code field are defined using the luBoardStudiesSubjects lookup table. See luBoardStudiesSubjects lookup table.
• This value has a maximum field length of 12 characters.

Qualification code.

• This value is defined using the Intended Tertiary Qualification field on the Status sub-tab School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
• This value is only mandatory for classes with VETCOS entered in the Board Studies Type field on the General tab of Class Maintenance. See Class Maintenance - General tab.
• This value has a maximum field length of 12 characters.

• This value has a maximum field length of 9 characters.

Surname of the staff member teaching the class.

• This value is defined using the community member information stored on the Staff tab of Class Maintenance. See Class Maintenance - Staff tab.
• This value has a maximum field length of 30 characters.

Given name of the staff member teaching the class.

• This value is defined using the community member information stored on the Staff tab of Class Maintenance. See Class Maintenance - Staff tab.
• This value has a maximum field length of 30 characters.

Registration number issued by the Teacher Registration Board of Western Australia (TRBWA).

• This value is defined using the Registration Number field on the School tab of Staff Maintenance. See Staff Maintenance - School tab.
• Registration Number field on the School tab of Staff Maintenance is populated with:
  • the Staff Maintenance > Check tab row that has:
    • a Synergy Meaning of Registration
    • the latest end date
    • or if there are 2 or more records with the same end date the last entered record.
• This value has a maximum field length of 15 characters.

Estimated number of students for each teacher.

Note: This value is automatically determined by adding up the Student Count (Column I) totals across all classes for each unique teacher as defined by the Teacher Family name, Teacher Given name, and Teacher Registration Number values.

• This value has a maximum length of 9 characters.

Whether the recorded staff member is the main teacher contact for the class.

• This value is Y where the staff member is the only teacher teaching a class with entered Board Studies Code and Board Studies Type field values.
• This value is N when multiple staff members teach classes with the same Board Studies Code and Board Studies Type field values.