Import_Export Student Data - SES tab

Use the SES tab to export SES (socioeconomic status) data for Commonwealth of Australia funding assessments of non-government schools. For information about the export including reporting requirements, submission instructions, and related documents, see Schools Hub - Address Collection.

Note: CEO schools can export socioeconomic status data using the Student Residential Addresses (SES) export on the CEO tab of the Import/Export Student Data window. See Import_Export Student Data - CEO tab.

Required configuration

You can click the following link for details of the settings and lookup tables that must be configured before you use the SES tab to export data.

View required configuration details

Synergetic setting/lookup table

Description

See...

SES parent extraction settings

Information is usually extracted based on the student's SC1 (primary) contact. You can control how the parent records are extracted. See

Note: Overseas parents must be the SC1 contact for full-fee-paying students.

SES parent extraction settings

LocationAGEID

This export identifies campuses using Location AGEID numbers assigned by the Department of Education. You must populate the Location AGEID number into the MCEETYASchoolCode field of the luCampus lookup table for each campus at your organisation.

luCampus lookup table

Inclusion criteria

Students must meet all of the following requirements to be included in the census. For information about field-level configurations, see the Output Mode field description below.

View inclusion criteria details

Field

Requirement

See...

Leave of Absence

Students that are on a leave of absence on or before the census date must return in the report year to be included in the export.

Students are considered to be on a leave of absence if Leave of Absence (LOA) is selected in the Status field. The date the student started their leave of absence is defined using the Leaving Date field and the date the student returns is defined using the Returning date field.

Current Student Maintenance - School tab - Status sub-tab

Opening the SES tab

To open the SES tab:

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 .
Click the SES tab.
The SES tab of the Import/Export Student Data window is displayed.

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

Field

Description

Output Type

Select either:

Comma Delimited to export a .csv file
Tab Delimited to export a .txt file.

Two files are produced when this export is run:

Statement of Student Addresses file.
Locations file.

Once the files are exported you need to insert the data into the Government XML production template to validate the data and produce the submission XML. See Exporting SES files.

File

Description

Statement of Student Addresses

Used to export student address details.

Important: Students with unusual residential address circumstances must not be included in the SES export. Unusual residential address circumstances are situations where your organisation is unable to provide Australian residential address information for the student and one or both parents. For more information about unusual residential address circumstances, see the Data Upload File Technical Specifications 2021 PDF on the Schools Hub website.

View configuration details

Statement of Student Addresses file (SES)

Column

Heading

Description

A

Location AGEID

School code allocated to each campus by the Department of Education.

Configuration

This field is defined using the MCEETYASchoolCode field of the luCampus lookup table. See luCampus lookup table.

Important: You must ensure that all campuses at your organisation have the MCEETYASchoolCode field of the luCampus lookup table populated with their corresponding Location AGEID values. Single-campus organisations must update one campus row and multi-campus organisations must update all relevant campus rows.

Note: If the MCEETYASchoolCode field of the luCampus lookup table is not populated this value is defined using the Value field of the MCEETYA_SchoolCode configuration setting. See MCEETYA_SchoolCode configuration setting.

B

Student Record Number (SRN)

Unique number used to identify each student.

Configuration

Unique number for each student created by combining these three components:

Location AGEID. See above.
Number (starting from 1) for their campus:
- This number is determined by sorting records of the luCampus lookup table using the CampusSort field then the Code field, and assigning each record a number starting from 1. See luCampus lookup table.
Five-digit sequential number.
- This number is automatically generated for each row of the SES data during the export process.

Example

LocationAGEID	Number	Sequential Number	Student Record Number
49225	3	00001	49225300001

C

Boarding (B) or Day (D)

Whether the student is a boarding student or a day student.

Configuration

Select the boarding status of students using the Boarder field on the Status sub-tab of the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
This field has a value of either:
- B for boarding students
- D for day students.

D

Primary or Secondary

Year level of the student.

Configuration

This field is defined using the Year Level field on the Current School group of the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
This field has a value of either:
- Primary for Primary school students
- Secondary for Secondary school students.

E

Address Line 1

First line of the student's home address.

Configuration

This field is defined using the Line 1 field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.

F

Address Line 2 (Optional)

Second line of the student's home address.

Configuration

This field is defined using the 2 field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.

G

Suburb/City

Suburb or city of the student's home address.

Configuration

This field is defined using the Suburb field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.

H

State or Territory

State or territory of the student's home address.

Configuration

This field is defined using the State field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.

I

Postcode

Post of the student's home address.

Configuration

This field is defined using the Postcode field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.

Columns J to AB

Parent/Guardian 1 and 2

Synergetic determines whether a student contact is a parent/guardian based on the value of the Parent flag on the Contacts tab of Current Student Maintenance. See Current Student Maintenance - Contacts tab.

J

P1 First Name

First name of the first parent/guardian.

Configuration

This field is defined using the Given field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.

K

P1 Last Name

Surname of the first parent/guardian.

Configuration

This field is defined using the Surname field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.

L

P1 Preferred Name (Optional)

Preferred name of the first parent/guardian.

Configuration

Optional

This field is defined using the Preferred field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.

M

P1 Same as student address?

Whether the first parent/guardian has the same address as the student.

Configuration

This field has a value of Y or N.

N

P1 Address Line 1

First line of the first parent's home address.

Configuration

This field is defined using the Line 1 field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.

O

P1 Address Line 2 (Optional)

Second line of the first parent/guardian's home address.

Configuration

Optional

This field is defined using the 2 field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.

P

P1 Suburb/City

Suburb of the first parent/guardian's home address.

Configuration

This field is defined using the Suburb field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.

Q

P1 State or Territory

State or territory of the first parent/guardian's home address.

Configuration

This field is defined using the State field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.

R

P1 Postcode

Postcode of the first parent/guardian's home address.

Configuration

This field is defined using the Postcode field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.

S

Are you reporting Parent 2? (Y or N)

Whether you are reporting the second parent/guardian.

Configuration

This field has a value of Y or N.

T

P2 First Name

First name of the second parent/guardian.

Configuration

This field is defined using the Given field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.

U

P2 Last Name

Surname of the second parent/guardian.

Configuration

This field is defined using the Surname field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.

V

P2 Preferred Name (Optional)

Preferred name of the second parent/guardian.

Configuration

Optional

This field is defined using the Preferred field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.

W

P2 Same as student address?

Whether the second parent/guardian has the same address as the student.

Configuration

This field has a value of Y or N.

X

P2 Address Line 1

First line of the second parent/guardian's home address.

Configuration

This field is defined using the Line 1 field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.

Y

P2 Address Line 2 (Optional)

Second line of the second parent/guardian's home address.

Configuration

Optional

This field is defined using the 2 field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.

Z

P2 Suburb or City

Suburb of the second parent's home address.

Configuration

This field is defined using the Suburb field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.

AA

P2 State or Territory

State or territory of the second parent's home address.

Configuration

This field is defined using the State field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.

AB

P2 Postcode

Postcode of the second parent's home address.

Configuration

This field is defined using the Postcode field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.

Locations

Used to export details of your location and the details of the primary contact at your organisation.

Note: You need to manually populate the primary contact fields.

View configuration details

Locations (SES)

Column	Heading	Description
A	Location AGEID	School code allocated to each campus by the Department of Education.
		Configuration
		This field is defined by populating the Location AGEID value assigned to each campus at your organisation into the MCEETYASchoolCode field of the relevant row of the luCampus lookup table. See luCampus lookup table. Important: You must ensure that all campuses at your organisation have the MCEETYASchoolCode field of the luCampus lookup table populated with their corresponding Location AGEID values. Single-campus organisations must update one campus row and multi-campus organisations must update all relevant campus rows. Note: If the MCEETYASchoolCode field of the luCampus lookup table is not populated this value is defined using the Value field of the MCEETYA_SchoolCode configuration setting. See MCEETYA_SchoolCode configuration setting.
B	Location Name (Optional)	Location name for each campus.
		Configuration
		This field is defined using the MCEETYASchoolCode and Description fields of the luCampus lookup table. See luCampus lookup table. When: Only one row in the luCampus lookup table has the MCEETYASchoolCode populated this field is populated with the Description field value. Multiple rows in the luCampus lookup table have the MCEETYASchoolCode populated this field is populated with all the pipe-separated Description field values (e.g. Junior\|Senior). Note: If the MCEETYASchoolCode field of the luCampus lookup table is not populated for any campuses this value is defined using the Value field of the MCEETYA_SchoolName configuration setting. See MCEETYA_SchoolName configuration setting.
C	Boarding students at Location? (Y or N)	Used to indicate whether boarding students are included in the report.
		Configuration
		Select the boarding status of students using the Boarder field on the Status sub-tab of the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab. This value is Y when your organisation has students with a SynergyMeaning is BOARDER. Otherwise, this value is N. Note: You must ensure the option selected in the Boarder field value has a SynergyMeaning of BOARDER. For more information, see luBoarder lookup table.
D	Location education level (Primary, Secondary, Combined)	Education level of your organisation.
		Configuration
		This field is defined using the Year Level field on the Status sub-tab of the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab. This field has a value of either: Primary for schools with only primary school students Secondary for schools with only secondary school students Combined for schools with both primary and secondary school students.
E	First Name	First name of the primary contact at your organisation.
F	Last Name	Last name of the primary contact at your organisation.
G	Position (Optional)	Occupation position of the primary contact at your organisation.
H	Phone Number	Phone number of the primary contact at your organisation.
I	Email Address	Email address of the primary contact at your organisation.

Year Level From / To

Range of year levels to export.

Addresses File Name

File name of the Statement of Student Addresses file.

Note: Do not include the file extension at the end of the file name.

Locations File Name

File name of the Locations file.

Note: This field is read-only. The file name of the Locations file is automatically generated based on the Addresses file name.

Buttons

Button	Description
	Select the file location.
	Export the SES files for the selected year levels. A report is produced for Australian addresses then overseas addresses. Any errors on the report are denoted with a double asterisk ({}{}). Fix any errors before sending the file. See Exporting SES files.
(Output Type)	Display additional information for the Output Type field.
(Locations File Name)	Display additional information for the Locations File Name field.