Import_Export Student Data - SES tab

Import_Export Student Data - SES tab

Html Macro

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.  

Synergetic setting/lookup table

Description

See...

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.

Field

Requirement

See...

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

 

To open the SES 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 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

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.

Statement of Student Addresses file (SES)

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.

Locations (SES)

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

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.