WA - Offering - COS Offering

WA - Offering - COS Offering

Overview

Below is a table detailing the required fields of the Offering: COS Offering and where in Compass the data is sourced from.

For further details on SCSA reports, please refer to the 'SCSA Reports' article from the Knowledge Base.


Offering: COS Offering (OFCOS)

Column ReferenceField NameMandatoryField RequirementsCompass Source
ARecord typeYHardcoded to: OFCOSn/a
BProvider codeYMaximum field length = 10. Provider code of course providerCampus Details > AGEID
CAcademic yearYMaximum field length = 2. Must be in the range: 07 - 12Subject > YearLevel
DCalendar yearYMaximum field length = 4. Format: YYYYSubject > Academic Year
ECourse codeYMaximum field length = 12. Unique code of the course e.g. MPA or VBSThird to fifth characters of Unit Code.
FCourse typeYMaximum field length = 6. Either ‘VETCOS’ or ‘COS’. VETCOS identifies an offering in a VET industry specific courseSubject & Classes > Edit Subject > Unit Code (the last part of the entry). VET in the interface = VETCOS in the report
GUnit codeYMaximum field length = 12. Unique code for the course unitSubject & Classes > Edit Subject > Unit Code (the first part of "")
HQualification codeY where the course type is VETCOS, Blank where course type is COSMaximum field length = 12. Unique code for the qualification in the VET industry specific courseSubject & Classes > VET Type > Learning Tasks(where the component is 'WA VET Result') > WA Qualification Code
IEstimated number of students for the course unit/qualification for the entire school regardless of teacher/classYMaximum field length = 9. Must be a whole numberInteger - number of students enrolled in all classes within this subject
JContact/teacher family nameYMaximum field length = 30LastName
KContact/teacher given nameYMaximum field length = 30FirstName
LContact/teacher registration numberYMaximum field length = 15. Issued by TRBWA. Must be a whole numberIdentifications > Teacher Registration Number (WA)
MEstimated number of students for the teacherNMaximum field length = 9. Must be a whole numberTotal number , defaults to 0
NIs this the main teacher/contactYValid values are "Y" or "N"Subject & Classes > Class > LeadTeacher : Email

    • Related Articles

    • WA - Result - Qualification Achieved

      Overview Below is a table detailing the required fields of the Result: Qualification Achieved export and where in Compass the data is sourced from. For further details on SCSA reports, please refer to the 'SCSA Reports' article from the Knowledge ...

    • WA - Estimates - VET Qualification

      OverviewBelow is a table detailing the required fields of the Estimates: VET Qualification export and where in Compass the data is sourced from. For further details on SCSA reports, please refer to the 'SCSA Reports' article from the Knowledge Base. ...

    • WA - Result - COS Unit Result

      Overview Below is a table detailing the required fields of the Result: COS Unit Result export and where in Compass the data is sourced from. For further details on SCSA reports, please refer to the 'SCSA Reports' article from the Knowledge Base. ...

    • WA - Enrolment - COS

      Overview Below is a table detailing the required fields of the Enrolment:COS export and where in Compass the data is sourced from. For further details on SCSA reports, please refer to the 'SCSA Reports' article from the Knowledge Base. Enrolment: COS ...

    • WA - Enrolment - VET Unit of Competency

      Overview Below is a table detailing the required fields of the Enrolment:VET Unit of Competency export and where in Compass the data is sourced from. For further details on SCSA reports, please refer to the 'SCSA Reports' article from the Knowledge ...