Export ESQUAL File (ESQUAL)

Modified on Sun, 19 Apr at 11:56 PM

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 type of ENVET 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 "ESQUAL".
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	Qualification Code	Code allocated to the class by the School Curriculum and Standards Authority.
		Key configuration details
		Mandatory
		This value is defined using the entire Board Studies Code entered 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.
D	Registered Training Organisation Provider Code	Leave this field blank.
E	Western Australian Student Number (WASN)	Candidate number allocated to the student by the School Curriculum and Standards Authority.
		Key configuration details
		Mandatory
		This value is defined using the Studies Code field on the Codes tab of Current Student Maintenance. See Current Student Maintenance - Codes tab. This value has a maximum field length of 15 characters.
F	Student Family Name	Family name of the student taking the class.
		Key configuration details
		Mandatory
		This value is defined using the Surname field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab. This value has a maximum field length of 30 characters.
G	Student Given Name	Given name of the student taking the class.
		Key configuration details
		Mandatory (Unless student only has a surname)
		This value is defined using the Given field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab. This value has a maximum field length of 30 characters.
H	Calendar Year	Calendar year.
		Key configuration details
		Mandatory
		This value is defined using the Year field on the WA SCSA tab of 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.
I	Academic Year	Academic year.
		Key configuration details
		Mandatory
		This value is defined using the Year Level field on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab. The values of the Year Level field are defined using the luYearLevel lookup table. See luYearLevel lookup table. This value must be in the range of 07 to 12. Note: SCSA requires this value to be in the range of 07 to 12. This is not enforced in Synergetic, so you must check the export file to ensure no students prior to Year 07 are included.
J	Delivery Arrangement Identifier	Leave this field blank
K	Enrolment Activity	Whether the student is enrolled in the course.
		Key configuration details
		Mandatory
		This value is defined using the Start and Stop fields on the matching student entry on the Students tab of Class Maintenance. See Class Maintenance - Students tab. This value is W (Withdrawn) when either: Start date is after the Process Date entered on the WA SCSA tab of the Import/Export Student Data window. See Import_Export Student Data - WA SCSA tab. Stop date is before the Process Date entered on the WA SCSA tab of the Import/Export Student Data window. See Import_Export Student Data - WA SCSA tab. This value is E (Enrolled) when both the above statements are false.