Import_Export Student Data - SACE tab

Organisations from South Australia report to the SACE Board using the Schools Online Reporting System.

You can use the SACE tab to:

  • export:

    - Students details file
    - Teachers details file
    - SACE Classes file
    - SACE Enrolments file

  • Import student numbers.
 Opening the SACE tab

To open the SACE tab:

  1. Select Module > Students > Student Data Import/Export from the main menu.
    The WA SCSA tab of the Import/Export Student Data window is displayed.

    Tip:
    You can also access the student import and export functions by clicking
    .

  2. Click the SACE tab.
    The SACE tab of the Import/Export Student Data window is displayed.

Import/Export Student Data - SACE tab key fields and buttons
Fields

Field

Description

School Code

School code for your organisation.

Results for Month

Results month of the export.

Process Type

Process type. Valid options include:

  • Export Students
  • Export Teachers
  • Export SACE Classes
  • Export SACE Enrolments
  • Import Student Numbers.

Note: Synergetic field values may be longer than the maximum field length allowed by SACE. When this happens the field values are truncated and a report listing the truncated fields is displayed.

Process TypeDescription
Export Students

Used to export a data file containing student details.

 View configuration details

Students file (SACE)
Selection criteria
FieldDescription
YearStudents must be enrolled in a class in the current file year that has a code selected in the Board Studies Code field on the General tab of Class Maintenance. See Class Maintenance - General tab.
TermThis field is not used.
Campus

Students must be enrolled in a class at the selected campus, if a campus is selected. You can add students to classes using the Classes tab of Class Maintenance. See Current Student Maintenance - Classes tab.

Note: You can define the class campus during the class creation process. See Creating new classes.

Year Level From/ToStudents must be in one of the selected year levels. You can select student year levels using the Year Level field on the Status tab of the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
Process Date

Students must have active class enrolment at the process date. Class enrolment is defined using the Start Date and Stop Date fields on the Classes tab of Current Student Maintenance and is considered to be active when:

  • Start Date is blank or equal to or before the Process Date
  • Stop Date is blank or equal to or after the Process Date.

See Current Student Maintenance - Classes tab.

Export Assessable Classes OnlyWhen this field is selected, students are only included when the Assess column is selected on the Classes tab of Current Student Maintenance. For information about changing the value of this field, see Modifying student class details (current students).
Students with Blank Studies CodeWhen this field is selected, students are only included when they have a blank Studies Code field on the Codes tab of Current Student Maintenance. See Current Student Maintenance - Codes tab.

Export field configurations

ColumnHeadingDescription
AContact School NumberSchool Number issued to your organisation by the SACE Board.
Configuration
Mandatory
  • This field value is defined using the School Code field on the SACE tab of the Import/Export Student Data window.
  • This field has a maximum field length of 3.
BRegistration NumberSACE Board Identifier assigned to the student.
Configuration
Optional
CStudent CodeSynergetic ID of the student.
Configuration
Mandatory
  • This field value is defined when the student is added to the Synergetic community.
  • Synergetic IDs are displayed in the top-right corner of Current Student Maintenance.
  • This field has a maximum field length of 20.
DTitleTitle of the student. For example, Mr.
Configuration
Optional
  • This field value is defined using the Title field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.
  • This field has a maximum field length of 4.
EGiven NamesGiven Names of the student.
Configuration
Mandatory

FFamily NameSurname of the student.
Configuration
Mandatory

GGenderGender of the student.
Configuration
Mandatory

HDate of BirthDate of birth of the student.
Configuration
Mandatory

IPhone Country CodeCountry code of the phone number recorded for Parent 1.
Configuration
Optional
  • This field has a default value of 061
  • This field has a maximum field length of 3.

JPhone Area CodeArea code of the phone number recorded for Parent 1.
Configuration
Optional
  • This field has a default value of 08.
  • This field has a maximum field length of 4.

KLocal Phone NumberPhone number recorded for Parent 1.
Configuration
Optional
  • This field value is defined using the home phone number recorded for Parent 1 in the Home Phone field on the Phone tab of Community Maintenance. See Community Maintenance - Phone tab.
  • This field has a maximum field length of 10.

Tip: You can launch to the Parent 1 community record by clicking  on the Parent 1 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.


LStreet Address Line 1Line 1 of the student's postal address.
Configuration
Mandatory

MStreet Address Line 2Line 2 of the student's postal address.
Configuration
Optional

NStreet Address Line 3Line 3 of the student's postal address.
Configuration
Optional

OSuburbSuburb of the student's postal address.
Configuration
Mandatory

PStateState of the student's postal address.
Configuration
Mandatory

QPost CodePostcode of the student's postal address.
Configuration
Mandatory

RHome GroupHome group of the student.
Configuration
Optional
  • This field value is defined using the HomeGroupDefinition field of the luYearLevel lookup table. See luYearLevel lookup table.
  • This field has a maximum field length of 8.

SYear LevelYear level of the student.
Configuration
Optional

TStreet Address Line 4Leave this field blank.
UTAFE ID

Vocational Education Code assigned to the student by the government.

Configuration
Optional
  • This field is defined using the Vocational Education 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.

VED IDLeave this field blank.
WAb/Tr IndWhether the student is an Aboriginal or Torres Strait Islander.
Configuration
Optional
  • This field value is defined using the Indigenous Student and Torres Strait Islander fields on the Flags tab of Current Student Maintenance. See Current Student Maintenance - Flags tab.
  • This field has a value of Y when either of these fields is selected. Otherwise, the field has a value of N.
  • This field has a maximum field length of 1.

XEmail AddressEmail address of the student.
Configuration
Optional

Export Teachers

Used to export a data file containing teacher details.

 View configuration details

Teachers file (SACE)
Selection criteria
FieldDescription
YearTeachers must be teaching a class in the current file year that has a code selected in the Board Studies Code field on the General tab of Class Maintenance. See Class Maintenance - General tab.
TermThis field is not used.
Campus

Teachers must be teaching a class at the selected campus, if a campus is selected.

Note: You can define the class campus during the class creation process. See Creating new classes.

Year Level From/To

Teachers must be teaching a class with students in one of the selected year levels. You can add students to classes using the Classes tab of Class Maintenance. See Current Student Maintenance - Classes tab.

Note: You can select student year levels using the Year Level field on the Status tab of the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.

Process Date

Teachers must be teaching a class with active class enrolment at the process date. Class enrolment is defined using the Start Date and Stop Date fields on the Classes tab of Current Student Maintenance and is considered to be active when:

  • Start Date is blank or equal to or before the Process Date
  • Stop Date is blank or equal to or after the Process Date.

See Current Student Maintenance - Classes tab.

Export Assessable Classes OnlyWhen this field is selected, teachers are only included when they teach classes that have active student enrolment and the Assess field selected on the Classes tab of Current Student Maintenance. For information about changing the value of this field, see Modifying student class details (current students).
Students with Blank Studies CodeWhen this field is selected, teachers are only included when they teach classes that have at least one student with a blank Studies Code field on the Codes tab of Current Student Maintenance. See Current Student Maintenance - Codes tab.

Export field configurations

ColumnHeadingDescription
AContact School Number School Number issued to your organisation by the SACE Board.
Configuration
Mandatory
  • This field value is defined using the School Code field on the SACE tab of the Import/Export Student Data window.
  • This field has a maximum field length of 3.
BTeacher CodeSynergetic ID of the teacher.
Configuration
Mandatory
  • This field is defined when the teacher is added to the Synergetic community.
  • Synergetic IDs are displayed in the top right corner of Staff Maintenance.
  • This field has a maximum field length of 8.
CFamily NameSurname of the teacher.
Configuration
Mandatory
  • This field value is defined using the Surname field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.
  • This field has a maximum field length of 30.
DInitialsInitials of the teacher.
Configuration
Mandatory
  • This field value is defined using the Initials field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.
  • This field has a maximum field length of 4.
ETitleTitle of the teacher.
Configuration
Mandatory
  • This field value is defined using the Title field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.
  • This field has a maximum field length of 4.
FType

Type of staff member.

Note: This field does not require any configuration. The value is always T - Teacher.

GTeacher Registration NumberRegistration number of the teacher.
Configuration
Optional
  • This field value is defined using the Registration Number field on the School tab of Staff Maintenance. See Staff Maintenance - School tab.
  • This field has a maximum field length of 50.

Note: Staff registrations are added on the Checks tab of Staff Maintenance. See Staff Maintenance - Checks tab.

HEmail Address

Occupation email address of the teacher.

Configuration
Optional
  • This field value is defined by:

    - selecting Occupation Email in the Default Email field
    - populating the occupation email of the teacher into the Email field.

    See Staff Maintenance - Personal tab.

    Note: Email addresses will not be exported when an email type other than Occupation Email is selected in the Default Email field. 

  • This field has a maximum field length of 100.

Note: You can edit the staff email using the Phone tab of Community Maintenance. See Community Maintenance - Phone tab.

IGiven NamesGiven names of the teacher.
Configuration
Optional
  • This field value is defined using the Given field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.
  • This field has a maximum field length of 50.
JDate of BirthDate of birth of the teacher.
Configuration
Optional
  • This field is defined using the Date of Birth field on the Other tab of Community Maintenance. See Community Maintenance - Other tab.
  • This field has a maximum field length of 10.
KGenderGender of the teacher.
Configuration
Optional
  • This field value is defined using the Gender field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.
  • This field has a maximum field length of 1.

Export SACE Classes

Used to export a data file containing SACE class details.

 View configuration details

Classes file (SACE)
Selection criteria
FieldDescription
YearClasses must be taught in the selected year and have a code selected in the Board Studies Code field on the General tab of Class Maintenance. See Class Maintenance - General tab.
TermThis field is not used.
CampusClasses must be taught in the selected campus, if a campus is selected. Classes are assigned to campuses during the class creation process. See Creating new classes.
Year Level From/ToClasses must be taught in one of the selected year levels.
Process Date

Classes must have active class enrolment at the process date.

Class enrolment is defined using the Start Date and Stop Date fields on the Classes tab of Current Student Maintenance and is considered to be active when:


Start Date is blank or equal to or before the Process Date
- Stop Date is blank or equal to or after the Process Date.

See Current Student Maintenance - Classes tab.

Export Assessable Classes OnlyWhen this field is selected, classes are only included when the Assess column is selected on the Classes tab of Current Student Maintenance. For information about changing the value of this field, see Modifying student class details (current students).
Students with Blank Studies CodeWhen this field is selected, classes are only included when they include at least one student with a blank Studies Code field on the Codes tab of Current Student Maintenance. See Current Student Maintenance - Codes tab.

Export field configurations

ColumnHeadingDescription
A


Contact School NumberSchool Number issued to your organisation by the SACE Board.
Configuration
Mandatory
  • This field value is defined using the School Code field on the SACE tab of the Import/Export Student Data window.
  • This field has a maximum field length of 3.
B


YearFile Year.
Configuration
Mandatory
  • This field value is defined using the Year field on the SACE tab of the Import/Export Student Data window.
  • This field has a maximum field length of 4.
C


StageStage of the subject.
Configuration
Mandatory
  • This field value is exported as 0.  Users must manually populate the field in the exported file with the stage of the subject.
  • This field has a value of 1 or 2.
  • This field has a maximum field length of 1.
D


SACE CodeSACE Subject code.
Configuration
Mandatory
  • This field value 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 3.
E


CreditsCredits assigned for successful completion of the subject.
Configuration
Mandatory
  • This field value is defined by manually populating the field with the number of credits assigned for completing the class.
  • This field has a value of 10 or 20.
  • This field has a maximum field length of 2.
F


Class NumberClass code for the class.
Configuration
Mandatory
  • This field value is defined using the first two characters of the Class Code field in Class Maintenance.
  • This Class Code is defined when the class is created. See Creating new classes.
  • This field has a maximum field length of 2.

Tip: You can change the class code if necessary by right-clicking the class and selecting Rename from the right-click menu.

GProgram VariantLeave this field blank.
H


SemesterFile semester.
Configuration
Mandatory
  • This field is defined using the Semester field on the SACE tab of the Import/Export Student Data window.
  • This field has a maximum field length of 1.
I


Teacher CodeSynergetic ID of the teacher.
Configuration
Mandatory
  • This field is defined using the ID field of the Seq 1 staff member on the Staff tab of Class Maintenance. See Class Maintenance - Staff tab.
  • This field has a maximum field length of 8.
J


School Class CodeClass code used for the class.
Configuration
Optional
  • This field value is defined using the Class Code field in Class Maintenance.
  • This field is defined when the class is created. See Creating new classes.
  • This field has a maximum field length of 10.

Tip: You can change the class code if necessary by right-clicking the class and selecting Rename from the right-click menu.

K


Results DueMonth that results are due.
Configuration
Mandatory
  • This field value is defined using the Results for Month field on the SACE tab of the Import/Export Student Data window.
  • This field has a value of J (June) or D (December).
  • This field has a maximum field length of 1.

Export SACE Enrolments

Used to export a data file containing student enrolment details.

 View configuration details

SACE Enrolments file (SACE)
Selection criteria
FieldDescription
YearStudents must be enrolled in a class in the current file year that has a code selected in the Board Studies Code field on the General tab of Class Maintenance. See Class Maintenance - General tab.
TermThis field is not used.
Campus

Students must be enrolled in a class at the selected campus, if a campus is selected. You can add students to classes using the Classes tab of Class Maintenance. See Current Student Maintenance - Classes tab.

Note: You can define the class campus during the class creation process. See Creating new classes.

Year Level From/ToStudents must be in one of the selected year levels. You can select student year levels using the Year Level field on the Status tab of the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
Process Date

Students must have active class enrolment at the process date. Class enrolment is defined using the Start Date and Stop Date fields on the Classes tab of Current Student Maintenance and is considered to be active when:

  • Start Date is blank or equal to or before the Process Date
  • Stop Date is blank or equal to or after the Process Date.

See Current Student Maintenance - Classes tab.

Export Assessable Classes OnlyWhen this field is selected, students are only included when the Assess column is selected on the Classes tab of Current Student Maintenance. For information about changing the value of this field, see Modifying student class details (current students).
Students with Blank Studies CodeWhen this field is selected, students are only included when they have a blank Studies Code field on the Codes tab of Current Student Maintenance. See Current Student Maintenance - Codes tab.

Export field configurations

ColumnHeadingDescription
AContact School NumberSchool Number issued to your organisation by the SACE Board.
Configuration
Mandatory
  • This field value is defined using the first three characters of School Code field on the SACE tab of the Import/Export Student Data window.
  • This field has a maximum field length of 3.
BRegistration Number

SACE Board Identifier assigned to the student.

Configuration
Optional
CStudent CodeSynergetic ID of the student.
Configuration
Mandatory
  • This field value is defined when the student is added to the Synergetic community.
  • Synergetic IDs are displayed in the top-right corner of Current Student Maintenance.
  • This field has a maximum field length of 20.
DYearFile year.
Configuration
Mandatory
  • This field value is defined using the Year field on the SACE tab of the Import/Export Student Data window.
  • This field has a maximum field length of 4.
ESemesterFile semester.
Configuration
Mandatory
  • This field is defined using the Semester field on the SACE tab of the Import/Export Student Data window.
  • This field has a maximum field length of 1.
FStageStage of the subject.
Configuration
Mandatory
  • This field value is defined by manually populating the field with the stage of the subject
  • This field has a value of 1 or 2.
  • This field has a maximum field length of 1.
GSACE CodeSACE Subject code.
Configuration
Mandatory
  • This field value 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 3.
HCreditsCredits assigned for successful completion of the subject.
Configuration
Mandatory
  • This field value is defined by manually populating the field with the number of credits assigned for completing the class.
  • This field has a value of 10 or 20.
  • This field has a maximum field length of 2.
IEnrolment NumberEnrolment number of the student.
Configuration
Optional

Note: New enrolments are assumed when this value is not defined.

JResults DueMonth that results are due.
Configuration
Mandatory
  • This field value is defined using the Results for Month field on the SACE tab of the Import/Export Student Data window.
  • This field has a value of J (June) or D (December).
  • This field has a maximum field length of 1.
KProgram VariantLeave this field blank.
LTeaching School NumberSchool code for the school where the subject is taught.
Configuration
Mandatory
  • This field value is defined using the School Code field on the SACE tab of the Import/Export Student Data window.
  • This field has a maximum field length of 3.
MAssessment School NumberSchool code for the school where the subject is assessed.
Configuration
Mandatory
  • This field value is defined using the School Code field on the SACE tab of the Import/Export Student Data window.
  • This field has a maximum field length of 3.
NClass NumberClass code used for the class.
Configuration
Mandatory
  • This field value is defined using the first two characters of the Class Code field in Class Maintenance.
  • This Class Code is defined when the class is created. See Creating new classes.
  • This field has a maximum field length of 2.

Note: This value is blank if the class code in the Class Code field in Class Maintenance is longer than two characters.

Tip: You can change the class code if necessary by right-clicking the class and selecting Rename from the right-click menu.

OEnrolment StatusEnrolment status of the student.
Configuration
Mandatory
  • This field value is defined using SynergyMeaning assigned to the enrolment status selected in the Status field on the Classes tab of Current Student Maintenance. See Current Student Maintenance - Classes tab.
  • This field has a maximum field length of 1.

    Note: You can define the values of the Status field using the luStudentClassStatus lookup table. See luStudentClassStatus lookup table.

  • The field value is:

    • C (Completed) when the SynergyMeaning of the status is either:

      - Exempt
      - Complete

    • E (Enrolled) when the SynergyMeaning of the status is Normal.
    • W (Withdrawn) when the SynergyMeaning of the status is either:

      - Cancelled
      - Left.
PRepeat IndicatorLeave this field blank.
QSchool Class CodeUnique code used to identify the class.
Configuration
Optional
  • This field value is defined using the Class Code field in Class Maintenance.
  • This field is defined when the class is created. See Creating new classes.
  • This field has a maximum field length of 10.

Tip: You can change the class code if necessary by right-clicking the class and selecting Rename from the right-click menu.

RStage 1 GradeLeave this field blank.
SPartial CreditsLeave this field blank.
TED IDLeave this field blank.

Import Student Numbers

Used to import student registration numbers. See Importing student registration numbers.

Year Level From / To

Range of year levels to export.

Note: This field and the following three fields are disabled when the Import Student Numbers process type field is selected.

Process DateDate the export is completed.
Export Assessable Classes OnlySelect when exporting student classes that are assessable.
Students with Blank Studies Code OnlySelect to export a listing of students with no studies code populated into the Studies Code field on the Codes tab of Current Student Maintenance. See Current Student Maintenance - Codes tab.
Enrolment Status to Import

Select the student enrolment statuses to import.

You can select:

  • Enrolled
  • Completed
  • Deleted
  • Blank.

Note: You can only edit these fields when the Import Student Numbers process type is selected.

Directory

File location.

Buttons

Button

Description

Select the file location.