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}.  Populated based on the Number of Terms Per Year a school is configured for and the Term the BSSS files are run for.

Mandatory

• The first character is defined using the value of the Number of Terms Per Year field on the File Semester tab of Student File Semester Maintenance.
    1 = Y
    2 = S
    4 = Q
  See Student File Semester Maintenance - File Semester tab.
• The second character is defined by the Actual Sem value for which the Semester BSSS is being generated, from the File Semester tab of Student File Semester Maintenance.  See Student File Semester Maintenance - File Semester tab.
• If the valued determined is not in {Y1, S1, S2, Q1, Q2, Q3, Q4}, then an exception occurs and the first character is replaced with the value of the Short field on the File Semester tab of Student File Semester Maintenance.
  See Student File Semester Maintenance - File Semester tab.
• 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.