Export Student Classes

A

TID

Unique Identifier for each row, based upon Student, Class, Year and Term that remains the same each time the table is deleted and re-created.

Configuration

Mandatory

• This field is defined using the database field StudentClassesSeq from the table StudentClasses. 
• This field can be seen on the Classes tab of Class Maintenance of the Students Module, by enabling Grid Enhancements and adding the Seq column. See Current Student Maintenance - Classes tab.

Note:     Deleting and re-enrolling a student from and to the Class will change the TID.  BSSS should be informed if this occurs post-first submission of the data to BSSS.

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.

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.

Unique 6-character Class ID as provided by BSSS.

• 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.

Unique 6-character Class ID as provided by BSSS.

• 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.

• 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.

• 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.

• 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.

• 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.

N

Assessment_Period

One of {Y1, S1, S2, Q1, Q2, Q3, Q4}.

Mandatory

• Based on the value of the Board Of Studies Type field on the General tab of Class Maintenance. See Class Maintenance - General tab.  Either the Assessment Period Value is defined exactly, or Y, S or Q is provided and the system determines the accompanying number.
• 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.

• 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.

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.