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.