Export Student Classes

Modified on Sun, 19 Apr at 11:56 PM

Column	Heading	Description
A	TID	Unique Identifier for each row, based upon Student (SKey), BSSS Class ID (MKey), Year (CYear) and Assessment Period that remains the same each time the table is deleted and re-created.
		Configuration
		Mandatory
		The TID is defined by the checksum calculated from the concatenated fields SKey, MKey, CYear and Assessment Period. See below for the definition of each of these fields.
B	SKey	Student number allocated by the Board of Senior Secondary Studies. Students without the BSSS student number will not be populated into the BSSS data transfer table.
		Configuration
		Mandatory
		This field is defined using the Studies Code field on the Codes tab of Current Student Maintenance. See Current Student Maintenance - Codes tab. This field has a maximum field length of 10 characters.
C	MKey	Unique 6-character Class ID as provided by BSSS.
		Configuration
		Mandatory
		This field is defined based upon the BSSS tab Radio Button: Use Class ID for MKey of Student Classes. If Off then this field is defined using the first six characters of the Assessment Code field on the General tab of Class Maintenance. If On then this field is defined using the Class ID field on the General tab of Class Maintenance. See Class Maintenance - General tab. Note: A unique identifier for the class provided by BSSS.
D	Class	Unique 6-character Class ID as provided by BSSS.
		Configuration
		Mandatory
		This value is defined using the Class ID field on the General tab of Class Maintenance. See Class Maintenance - General tab. This field has a maximum field length of 6 characters. Note: As of late 2023, this field no longer used by BSSS.
E	TTPeriod	File year and semester of the class.
		Configuration
		Mandatory
		This field is defined using the Year and Term fields on the BSSS tab of the Import/Export Student Data window. This field has a maximum field length of 6 characters. Note: If Year and Term values are not selected on the BSSS tab, this field is defined the default values set using the Set Current button on the File Semester tab of Student File Semester Maintenance. See Student File Semester Maintenance - File Semester tab.
F	CYear	File year.
		Configuration
		Mandatory
		This field is defined using the Year field on the BSSS tab of the Import/Export Student Data window. This field has a maximum field length of 4 characters. Note: If a Year values is not selected on the BSSS tab, this field is defined the default value set using the Set Current button on the File Semester tab of Student File Semester Maintenance. See Student File Semester Maintenance - File Semester tab.
G	ACT_Class	Class code of the class.
		Configuration
		Mandatory
		This value is defined using the Class Code field when the class is created. See Class creation windows. This field has a maximum field length of 9 characters.
H	Course	Code allocated to the class by the Board of Senior Secondary Studies.
		Configuration
		Mandatory
		This field is defined using the Board Studies Code field on the General tab of Class Maintenance. See Class Maintenance - General tab. This field has a maximum field length of 4 characters. Note: This field contains the first four characters of the Board Studies Code.
I	Part_Year_Studied	This field is always blank.
J	Unit_Status	This field is always blank.
K	Unit_Score	This field value is always 0.
L	Unit_Grade01	This field is always blank.
M	ScaledUnitScore	This field value is always 0.
N	Assessment_Period	One of {Y1, S1, S2, Q1, Q2, Q3, Q4}.
		Configuration
		Mandatory
		Either the Assessment Period Value is defined exactly, or Y, S or Q is provided and the system determines the accompanying number. Based on the value of the Board Of Studies Type field on the General tab of Class Maintenance. See Class Maintenance - General tab. If the Board Of Studies Type field is one of {Y1, S1, S2, Q1, Q2, Q3, Q4} then the Assessment Period is populated with this value. If the Board Of Studies Type field is Y, then the Assessment Period value is Y1. If the Board Of Studies Type field is S, then the Assessment Period value is either S1 or S2. The second character 1 or 2, is defined by the Actual Sem value for the File Term for which the Export Student Classes is being run. From the File Semester tab of Student File Semester Maintenance. See Student File Semester Maintenance - File Semester tab. Note: Actual Semester must be 1 or 2. If the Board Of Studies Type field is Q, then the Assessment Period value is Q combined with the File Term the BSSS Export is being run for to be either Q1, Q2, Q3 or Q4. Quarter 1, 2, 3 or 4 is defined by the File Term value for which Export Student Classes is being run. Note: File Term must be 1, 2, 3 or 4. If the valued determined is not in {Y1, S1, S2, Q1, Q2, Q3, Q4}, then an exception occurs and a Warning is displayed This field has a maximum field length of 2 characters.
O	LastGetDate	Current date and time.
P	School_Code	BSSS school code for your organisation
		Configuration
		Mandatory
		This field is defined using the School Code field on the BSSS tab of the Import/Export Student Data window. This field has a maximum field length of 4 characters.
Q	SRKS_Number	Synergetic ID of the student.
		Configuration
		Mandatory
		This field is defined when students are added to the Synergetic community database. This field is an integer. Note: This field is not required by BSSS; however, is included to make the table easier to read for school staff.