Export Course Offerings (OFCOS)

Selection criteria

This report only includes classes with:

Course codes recorded in the Board Studies Code field on the General tab of Class Maintenance. See Class Maintenance - General tab.
Course types of COS or VETCOS recorded in the Board Studies Type field on the General tab of Class Maintenance. See Class Maintenance - General tab.

Report values

Column	Heading	Description
A	Record Type	Export file code. Note: This value is always "OFCOS".
B	Provider Code	Provider code of the school or organisation authorised to offer the Western Australian Certificate of Education.
		Key configuration details
		Mandatory
		This value is defined using the CurriculumCouncil_SchoolCode configuration setting. See CurriculumCouncil_SchoolCode configuration setting. This value has a maximum field length of 10 characters.
C	Academic Year	Academic year.
		Key configuration details
		Mandatory
		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.
D	Calendar Year	Calendar year.
		Key configuration details
		Mandatory
		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.
E	Course Code	Course code. Note: The Course code is the third to fifth characters of the Board Studies Code.
		Key configuration details
		Mandatory
		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.
F	Course Type	Course type. Note: This value can be either COS or VETCOS.
		Key configuration details
		Mandatory
		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.
G	Unit Code	Unit code. Note: The Unit code is the first twelve characters of the Board Studies Code.
		Key configuration details
		Mandatory
		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.
H	Qualification Code	Qualification code.
		Key configuration details
		Mandatory (VETCOS)
		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.
I	Student Count	Number of students enrolled in the class.
		Key configuration details
		Mandatory
		This value has a maximum field length of 9 characters.
J	Teacher Family Name	Surname of the staff member teaching the class.
		Key configuration details
		Mandatory
		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.
K	Teacher Given Name	Given name of the staff member teaching the class.
		Key configuration details
		Mandatory
		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.
L	Teacher Registration Number	Registration number issued by the Teacher Registration Board of Western Australia (TRBWA).
		Key configuration details
		Mandatory
		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 field has a maximum field length of 15 characters. This value has a maximum field length of 15 characters.
M	Number of Students for Teacher	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.
		Key configuration details
		Optional
		This value has a maximum length of 9 characters.
N	Main Teacher Contact	Whether the recorded staff member is the main teacher contact for the class.
		Key configuration details
		Mandatory
		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.