Column | Heading | Description |
---|
A | TID | This value is always 99 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 | Synergetic ID of the student 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 when students are added to the Synergetic community databaseThis 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 7 characters10 characters.
|
C | MKey | Unique 6-character Class ID as provided by BSSS. |
Configuration |
---|
Mandatory |
- Up until Release 71.9 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 five six characters of the the Assessment Code field on the General tab of Class Maintenance. See Class Maintenance - General tab.Post Release 71.9
- If On then this field is defined using the Class ID ID field on the General tab of Class Maintenance. See Class Maintenance - General tab.
- Pre Release 71.9 this field has a maximum field length of 5 characters.
- Post Release 71.9 this field has a maximum field length of 6 characters.
Note: A A unique identifier for the class provided by BSSS. Same data as Class |
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 | File semester description and file semester 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. |
Configuration |
---|
Mandatory |
- This field is defined using the Description and Sem fields for the default file semester set using the Set Current button on the File Semester tab of 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
See Student File Semester Maintenance - File Semester tab. - 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. |