Skip to end of banner
Go to start of banner

Import_Export Student Data - Demographic tab

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 20 Next »

Use the Demographic tab of the Import/Export Student Data window to export:

Note: You must map outbound Synergetic lookup table values to the values expected by your state education authority. For more information about the demographic mapping requirements of each state, see Using the Interface Settings window.

Note: Federal-level demographic data must be also be reported using the Student Census - Australian Non-Government Schools report. See Running the Student Census - Australian Non-Government Schools report. 

Note:
This is not required by Catholic or New Zealand schools. Catholic schools submit demographic data through CEO exports.


Before running the Demographic export

By default, the Demographic export converts the Highest Secondary Year Level of the parents to the appropriate demographic level for the corresponding year level. See the Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

Some organisations may have entered the demographic level instead. If this is the case for your organisation, you can set the ParentYearLevelNoConvert configuration setting so that the demographic levels are used from the data entered. See the ParentYearLevelNoConvert configuration setting.

 Opening the Demographic tab

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

Import/Export Student Data - Demographic tab fields and buttons
Fields

Field

Description

State

Australian State where the school is located.

Note: You must map outbound Synergetic lookup table values to the values expected by your state education authority. For more information about the demographic mapping requirements of each state, see Using the Interface Settings window.

StateFileConfiguration details
ACTDemographic
 Australian Capital Territory Demographic field configurations
ColumnHeadingDescription
A

SchoolCode

Australian government code identifying the school.

Configuration
Type the school code assigned to your organisation into the School Code field on the Demographic tab of the Import/Export Student Data window.
BACT StudentID

Student identification number.

Configuration

Select an option from the ACT Student ID Field drop-down list to define the field used as the student identification number for the export. You can select:

  • Studies Code
  • Government Student Number.

Note: Students with this field blank in the export do not have the selected student identification option populated on the Codes tab of Current Student Maintenance. See Current Student Maintenance - Codes tab.

CSurname

Surname of the student.

Configuration
Type the surname of the student into the Surname field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
DGivenNameGiven name of the student.
Configuration
Type the given name of the student into the first text box of the Given field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
EMiddleNameMiddle name of the student.
Configuration
Type the middle name of the student into the second text box of the Given field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
FPreferredNamePreferred name of the student.
Configuration
Type the preferred name of the student into the Preferred field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
GYearLevelYear level of the student.
Configuration
Select the year level of the student using the Year Level drop-down list on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
HClassIDForm of the student.
Configuration
Select the form of the student using the Form field on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
IGenderGender of the student.
Configuration

Select the gender of the student using the Gender field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.

This field has a value of:

  • 1 for Male
  • 2 for Female.
JDateOfBirthDate of birth of the student.
Configuration
Select the date of birth of the student using the Date of Birth field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
KCountryOfBirthCode used for the country of birth of the student.
Configuration

Select the country of birth of the student using the Country of Birth drop-down list on Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.

Note: The actual field value (e.g. 1101 - Australia) is defined using the ExternalSystemCode field of the luCountry lookup table. You need to populate the lookup table values by loading MCEETYA values into the luCountry lookup table. See luCountry lookup table.

L

StudentHomeLanguage

Language spoken by the student at home.
Configuration

Select the home language of the student using the Home Language drop-down list on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

M

IndigenousStatus

Indigenous status of the student.
Configuration

Select the Indigenous Student and Torres Strait Islander fields on the Flags tab of Current Student Maintenance to determine the value of this field. See Current Student Maintenance - Flags tab.

This field has a value of:

  • 1 when the Indigenous Student flag is selected
  • 2 when the Torres Strait Islander flag is selected
  • 3 when both flags are selected.
  • 4 when neither flag is selected.
N

MotherHomeLanguage

Code used for the language spoken by the mother at home.
Configuration

Select the home language using the Home language field on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

O

MotherSchoolEducation

Code used for the highest level of school education attained by the mother.
Configuration

Select the highest level of school education using the Highest Secondary Year Level field on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

This field has a value of:

  • 0 for Not stated/unknown
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent
  • 3 for Year 11 or equivalent
  • 4 for Year 12 or equivalent.
P

MotherNonSchoolEducation

Code used for the highest qualification level attained by the mother. 
Configuration
Select the highest qualification level of using the Highest Qualification Level field on the relevant Parent sub-tab of the Demographic tab of Current Student MaintenanceSee Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 4) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

This field has a value of:

  • 0 for Not stated/unknown.
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent or below
  • 3 for Year 11 or equivalent or below
  • 4 for Year 12 or equivalent or below
  • 5 for Certificate I to IV (including trades)
  • 6 for Diploma/Advanced Diploma
  • 7 for Bachelor Degree or higher
  • 8 for No non-school education.
Q

MotherOccupation

Code used for the occupation position of the mother.
Configuration

Select the occupation position of the mother using the Occupation Position field drop-down list on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 2) is defined using the ExternalSystemCode field of the luOccupationPosition lookup table. You need to populate the lookup table values by loading MCEETYA values into the luOccupationPosition lookup table. See luOccupationPosition lookup table.

R

FatherHomeLanguage

Code for the language spoken by the father at home.
Configuration

Select the home language using the Home language field on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

S

FatherSchoolEducation

Code used for the highest level of school education attained by the father.
Configuration

Select the highest level of school education using the Highest Secondary Year Level field on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

This field has a value of:

  • 0 for Not stated/unknown
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent
  • 3 for Year 11 or equivalent
  • 4 for Year 12 or equivalent.
T

FatherNonSchoolEducation

Code used for the highest qualification level attained by the father. 
Configuration
Select the highest qualification level of using the Highest Qualification Level field on the relevant Parent sub-tab of the Demographic tab of Current Student MaintenanceSee Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 4 ) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

This field has a value of:

  • 0 for Not stated/unknown.
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent or below
  • 3 for Year 11 or equivalent or below
  • 4 for Year 12 or equivalent or below
  • 5 for Certificate I to IV (including trades)
  • 6 for Diploma/Advanced Diploma
  • 7 for Bachelor Degree or higher
  • 8 for No non-school education.
U

FatherOccupation

Code used for the occupation position of the father.
Configuration

Select the occupation position of the father using the Occupation Position field drop-down list on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 2) is defined using the ExternalSystemCode field of the luOccupationPosition lookup table. You need to populate the lookup table values by loading MCEETYA values into the luOccupationPosition lookup table. See luOccupationPosition lookup table.

This field has a value of:

  • 1 for Senior management in large business organisation, government admin/defence, qualified professional
  • 2 for Other business manager, arts/media/sportsperson, associate professional
  • 3 for Tradesman/woman, clerk, skilled office/sales/service staff
  • 4 for Machine operator, hospitality staff, assistant, labourer, related worker
  • 8 for Not in paid work in last 12 months
  • 9 for Not stated or unknown.
VStudentApartmentNumberApartment number of the student's home address.
Configuration
Populate the Line 1 field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.  
WStudentStreetNumberStreet number of the student's home address.
Configuration
Populate the Line 1 field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab
XStudentStreetNameStreet name of the student's home address.
Configuration
Populate the Line 1 field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab
YStudentHomeSuburbSuburb of the student's home address.
Configuration
Populate the student's suburb into the Suburb field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.
ZStudentHomePostCodePostcode of the student's home address.
Configuration
Populate the student's postcode into the Postcode field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.
AAStudentHomeStateState of the student's home address.
Configuration
Populate the student's state into the State field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.
ABInternationalStudentWhether the student is an international student.
ACStudentFTEFTE of the student.
Configuration

Type the FTE of the student into the FTE field on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.

Note: FTE is recorded as the number of days attended. For example, 5 indicates a full-time student.

CSNSWDemographic

Catholic New South Wales schools can use the CSNSW tab of the Import/Export Student Data window to export student census data. See Import_Export Student Data - CSNSW tab.

LEVNTDemographic

Lutheran schools can use the LEA tab of the Import/Export Student Data window to export Lutheran Student Census data. See Import_Export Student Data - LEA tab.

NSWDemographic
 New South Wales Demographic field configurations
ColumnFieldDescription
A

SchoolCode

Australian government code identifying the school.

Configuration

Type the school code assigned to your organisation into the School Code field on the Demographic tab of the Import/Export Student Data window.
BStudentIDSynergetic ID of the student.
CSurnameSurname of the student.
Configuration
Type the surname of the student into the Surname field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
DMiddleNameMiddle name of the student.
Configuration
Type the middle name of the student into the second text box of the Given field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
EGivenNameGiven name of the student.
Configuration
Type the given name of the student into the first text box of the Given field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
FYearLevelYear level of the student.
Configuration
Select the year level of the student using the Year Level drop-down list on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
GFormForm of the student.
Configuration
Select the form of the student using the Form drop-down list on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
HGenderGender of the student.
Configuration

Select the gender of the student using the Gender field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.

This field has a value of:

  • 1 for Male
  • 2 for Female.
IDateOfBirthDate of birth of the student.
Configuration
Select the date of birth of the student using the Date of Birth field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
J

CountryOfBirth

Country of birth of the student.
Configuration

Select the country of birth of the student using the Country of Birth drop-down list on Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.

Note: The actual field value (e.g. 1101 - Australia) is defined using the ExternalSystemCode field of the luCountry lookup table. You need to populate the lookup table values by loading MCEETYA values into the luCountry lookup table. See luCountry lookup table.

KHomeLanguageLanguage spoken by the student at home.
Configuration

Select the home language of the student using the Home Language drop-down list on Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

LIndigenousStatusIndigenous status of the student.
Configuration

Select the Indigenous Student and Torres Strait Islander fields on the Flags tab of Current Student Maintenance to determine the value of this field. See Current Student Maintenance - Flags tab.

This field has a value of:

  • 1 when the Indigenous Student flag is selected
  • 2 when the Torres Strait Islander flag is selected
  • 3 when both flags are selected.
  • 4 when neither flag is selected.
MMotherHomeLanguageCode used for the language spoken by the mother at home.
Configuration

Select the home language using the Home language field on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

NMotherSchoolEducationCode used for the highest level of school education attained by the mother.
Configuration

Select the highest level of school education using the Highest Secondary Year Level field on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

This field has a value of:

  • 0 for Not stated/unknown
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent
  • 3 for Year 11 or equivalent
  • 4 for Year 12 or equivalent.
OMotherNonSchoolEducationCode used for the highest qualification level attained by the mother.
Configuration
Select the highest qualification level using the Highest Qualification Level field on the relevant Parent sub-tab of the Demographic tab of Current Student MaintenanceSee Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 4 ) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

This field has a value of:

  • 0 for Not stated/unknown.
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent or below
  • 3 for Year 11 or equivalent or below
  • 4 for Year 12 or equivalent or below
  • 5 for Certificate I to IV (including trades)
  • 6 for Diploma/Advanced Diploma
  • 7 for Bachelor Degree or higher
  • 8 for No non-school education.
PMotherOccupationCode used for the occupation position of the mother.
Configuration

Select the occupation position using the Occupation Position field drop-down list on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

Note: The actual field value (e.g. 2) is defined using the ExternalSystemCode field of the luOccupationPosition lookup table. You need to populate the lookup table values by loading MCEETYA values into the luOccupationPosition lookup table. See luOccupationPosition lookup table.

This field has a value of:

  • 1 for Senior management in large business organisation, government admin/defence, qualified professional
  • 2 for Other business manager, arts/media/sportsperson, associate professional
  • 3 for Tradesman/woman, clerk, skilled office/sales/service staff
  • 4 for Machine operator, hospitality staff, assistant, labourer, related worker
  • 8 for Not in paid work in last 12 months
  • 9 for Not stated or unknown.
Q

FatherHomeLanguage

Code used for the language spoken by the father at home.
Configuration

Select the home language using the Home language field on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 1201 ) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

RFatherSchoolEducationCode used for the highest level of school education attained by the father.
Configuration

Select the highest level of school education using the Highest Secondary Year Level field on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

This field has a value of:

  • 0 for Not stated/unknown
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent
  • 3 for Year 11 or equivalent
  • 4 for Year 12 or equivalent.
SFatherNonSchoolEducationCode used for the highest qualification level attained by the mother.
Configuration
Select the highest qualification level using the Highest Qualification Level field on the relevant Parent sub-tab of the Demographic tab of Current Student MaintenanceSee Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 4 ) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

This field has a value of:

  • 0 for Not stated/unknown.
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent or below
  • 3 for Year 11 or equivalent or below
  • 4 for Year 12 or equivalent or below
  • 5 for Certificate I to IV (including trades)
  • 6 for Diploma/Advanced Diploma
  • 7 for Bachelor Degree or higher
  • 8 for No non-school education.
TFatherOccupationCode used for the occupation position of the father.
Configuration

Select the occupation position of the father using the Occupation Position  drop-down list on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 2) is defined using the ExternalSystemCode field of the luOccupationPosition lookup table. You need to populate the lookup table values by loading MCEETYA values into the luOccupationPosition lookup table. See luOccupationPosition lookup table.

This field has a value of:

  • 1 for Senior management in large business organisation, government admin/defence, qualified professional
  • 2 for Other business manager, arts/media/sportsperson, associate professional
  • 3 for Tradesman/woman, clerk, skilled office/sales/service staff
  • 4 for Machine operator, hospitality staff, assistant, labourer, related worker
  • 8 for Not in paid work in last 12 months
  • 9 for Not stated or unknown.
U



Configuration



V

Suburb

Suburb where the home address of the student is located.
Configuration
Populate the Suburb field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab
W



Configuration



XFullFeePayingWhether the student is full-fee paying.
Configuration
Select the Full Fee Paying field on the Debtor tab of Current Student Maintenance. See Current Student Maintenance - Debtor tab.
NT

Demographic

(Student Age Census)

For instructions about how to export the Northern Territory demographic file (Student Age Census file), see Exporting the Student Age Census file (NT Demographic).

 Northern Territory Demographic (Student Age Census file) field configurations

Student Age Census (NT)

ColumnFieldDescription
ASchool name

Registered name of your organisation.

Configuration

Type your school name into the School Name field on the Demographic tab of the Import/Export Student Data window. See Import_Export Student Data - Demographic tab.

Note: You can pre-populate the School Name field by typing your school name into the Value field of the MCEETYA_SchoolName configuration setting. See MCEETYA_SchoolName configuration setting

BStudent IDSynergetic ID of the student.
C

SurnameSurname of the student.
Configuration

Type the surname of the student into the Surname field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.

Note: You can override the value in the Surname field by populating the Override Legal Surname field on the Community Names window accessed by clicking  on the Name tab of Community Maintenance. See Community Maintenance - Name tab.

DFirst nameFirst name of the student.
Configuration
Type the first and middle names into the Given field on the Personal tab of Current Student Maintenance. See Community Maintenance - Name tab.
EResidential addressHome address of the student.
Configuration
Populate the Line 1 to Line 3 fields on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.
FSuburbSuburb of the student's home address.
Configuration
Populate the Suburb field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.
GStateState of the student's home address.
Configuration
Populate the State field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.
HPostcodePostcode of the student's home address.
Configuration
Populate the Postcode field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.
IYear level/grade

Year level of the student.

Important: You must map Synergetic year level values to accepted census values using the NTGOVDEMO external system on the Interface Settings window. See Using the Interface Settings window.

Configuration

Select the year level of the student using the Year Level drop-down list on the Status sub-tab of the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.

JDate of birthDate of birth of the student.
Configuration

Select the date of birth of the student using the Date of Birth field on the Other tab of Community Maintenance. See Community Maintenance - Other tab.

KGender

Gender of the student.

Configuration
  • Select the gender of the student using the Gender field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
  • This field has a maximum length of 1 character.
  • This field has a value of:

    1 for Male
    2 for Female
    - 3 for Intersex or Indeterminate
    - 9 for Not stated.

Note: You need to map luGender values to these NT Demographic values using the NTGOVDEMO interface setting. See Using the Interface Settings window.

LIndigenous statusIndigenous status of the student.
Configuration

Select the Indigenous Student and Torres Strait Islander fields on the Flags tab of Current Student Maintenance to determine the value of this field. See Current Student Maintenance - Flags tab.

This field has a value of:

  • Aboriginal when the Indigenous Student flag is selected
  • Torres Strait Islander when the Torres Strait Islander flag is selected
  • Both Aboriginal & Torres Strait Islander when both flags are selected.
  • Neither Aboriginal nor Torres Strait Islander when neither flag is selected.
MFTEFTE of the student.
Configuration

Type the FTE of the student into the FTE field on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.

NClass/form

School form of the student.
Configuration
Populate the HomeGroupDefinition field of the luYearLevel lookup table. See luYearLevel lookup table.
OFFPOSWhether the student is full-fee paying.
Configuration

Select the Full Fee Paying field on the Debtor tab of Current Student Maintenance. See Current Student Maintenance - Debtor tab.

This field has a value of:

  • Yes for full-fee paying students
  • No for non-full-fee paying students 
PDual enrolment statusWhether the student is enrolled at more than one school.
Configuration
Populate the details of any additional schools attended by the student into the Other Schools Attended sub-tab of the External tab of Current Student Maintenance. See Current Student Maintenance - External tab.
QEnrolment start dateDate the student entered your organisation.
Configuration

Type the entry date of the student into the Entry Date field on the Entry tab of Current Student Maintenance. See Current Student Maintenance - Entry tab.

R

Student other spoken languageCode used for the language spoken by the student at home.
Configuration

Select the home language of the student using the Home Language drop-down list on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.

Note: You need to populate the Home Language field with MCEETYA values by loading the MCEETYA values into the luLanguage lookup table. See:

SCountry of birth

Code used for the country of birth of the student.
Configuration

Select the country of birth of the student using the Country of Birth drop-down list on Student sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

Note: You need to populate the Country of Birth field with MCEETYA values by loading the MCEETYA values into the luCountry lookup table. See:

TParent 1 relationship to student

Relationship of the first parent to the student.

Important: You must map Synergetic relationship values to accepted census values using the NTGOVDEMO external system on the Interface Settings window. See Using the Interface Settings window.

Configuration
Add relationships using the Relations tab of Current Student Maintenance. See Current Student Maintenance - Relations tab.
U

Parent 1 school education

Code used for the highest level of school education attained by the first parent.

Important:  When the ParentYearLevelNoConvert configuration setting is set to True you must ensure that the Highest Secondary Year Level field is populated with one of the five values below. See ParentYearLevelNoConvert configuration setting.

Configuration

Select the highest level of school education using the Highest Secondary Year Level field on the Parent 1 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

This field has a value of either:

  • Not stated/unknown
  • Year 9 or equivalent or below
  • Year 10 or equivalent
  • Year 11 or equivalent
  • Year 12 or equivalent.
VParent 1 non-school education

Code used for the highest qualification level attained by the first parent.
Configuration

Select the highest qualification level of using the Highest Qualification Level field on the Parent 1 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

This field has a value of either:

  • Not stated/unknown.
  • Certificate I to IV (including trades)
  • Diploma/Advanced Diploma
  • Bachelor Degree or higher
  • No non-school education.

Note: The actual field value (e.g. 2) is defined using the ExternalSystemCode field of the luQualificationLevel lookup table. You need to populate the lookup table values by loading MCEETYA values into the luQualificationLevel lookup table. See:

 luQualificationLevel lookup table
 Loading lookup tables for external systems.

Important: Data is not loaded when the details of an existing row match the corresponding row from the loaded data. When this happens you need to manually select the MCEETYA ExternalSystemType and ExternalSystemCode values.

WParent 1 occupation groupDescription of the occupation position of the first parent.
Configuration

Select the occupation position of the first parent using the Occupation Position field drop-down list on the Parent 1 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

This field has a value of either:

  • Senior management in large business organisation, government admin/defence, qualified professional
  • Other business manager, arts/media/sportsperson, associate professional
  • Tradesman/woman, clerk, skilled office/sales/service staff
  • Machine operator, hospitality staff, assistant, labourer, related worker
  • Not in paid work in last 12 months
  • Not stated or unknown.

Note: The actual field value (e.g. 2) is defined using the ExternalSystemCode field of the luOccupationPosition lookup table. You need to populate the lookup table values by loading MCEETYA values into the luOccupationPosition lookup table. See:

 luOccupationPosition lookup table
 Loading lookup tables for external systems.

Important: Data is not loaded when the details of an existing row match the corresponding row from the loaded data. When this happens you need to manually select the MCEETYA ExternalSystemType and ExternalSystemCode values.

XParent 1 other spoken language

Description of the home language of the first parent.
Configuration

Select the home language using the Home language field on the Parent 1 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLangauge lookup table. See:

 luLanguage lookup table.
 Loading lookup tables for external systems.

Important: Data is not loaded when the details of an existing row match the corresponding row from the loaded data. When this happens you need to manually select the MCEETYA ExternalSystemType and ExternalSystemCode values.

YParent 2 relationship to student

Relationship of the second parent to the student.

Important: You must map Synergetic relationship values to accepted census values using the NTGOVDEMO external system on the Interface Settings window. See Using the Interface Settings window.

Configuration
Add relationships using the Relations tab of Current Student Maintenance. See Current Student Maintenance - Relations tab.
ZParent 2 school education

Code used for the highest level of school education attained by the second parent.

Important:  When the ParentYearLevelNoConvert configuration setting is set to True you must ensure that the Highest Secondary Year Level field is populated with one of the four values below. See ParentYearLevelNoConvert configuration setting.

Configuration

Select the highest level of school education using the Highest Secondary Year Level field on the Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab.

This field has a value of either:

  • Not stated/unknown
  • Year 9 or equivalent or below
  • Year 10 or equivalent
  • Year 11 or equivalent
  • Year 12 or equivalent.
AAParent 2 non-school education

Code used for the highest qualification level attained by the second parent.
Configuration

Select the highest qualification level of using the Highest Qualification Level field on the Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab.

This field has a value of either:

  • Not stated/unknown.
  • Certificate I to IV (including trades)
  • Diploma/Advanced Diploma
  • Bachelor Degree or higher
  • No non-school education.

Note: The actual field value (e.g. 2) is defined using the ExternalSystemCode field of the luQualificationLevel lookup table. You need to populate the lookup table values by loading MCEETYA values into the luQualificationLevel lookup table. See:

 luQualificationLevel lookup table
 Loading lookup tables for external systems.

Important: Data is not loaded when the details of an existing row match the corresponding row from the loaded data. When this happens you need to manually select the MCEETYA ExternalSystemType and ExternalSystemCode values.

ABParent 2 occupation group

Description of the occupation position of the second parent.
Configuration

Select the occupation position of the second parent using the Occupation Position field drop-down list on the Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab.

This field has a value of either:

  • Senior management in large business organisation, government admin/defence, qualified professional
  • Other business manager, arts/media/sportsperson, associate professional
  • Tradesman/woman, clerk, skilled office/sales/service staff
  • Machine operator, hospitality staff, assistant, labourer, related worker
  • Not in paid work in last 12 months
  • Not stated or unknown.

Note: The actual field value (e.g. 2) is defined using the ExternalSystemCode field of the luOccupationPosition lookup table. You need to populate the lookup table values by loading MCEETYA values into the luOccupationPosition lookup table. See:

 luOccupationPosition lookup table
 Loading lookup tables for external systems.

Important: Data is not loaded when the details of an existing row match the corresponding row from the loaded data. When this happens you need to manually select the MCEETYA ExternalSystemType and ExternalSystemCode values.

ACParent 2 other spoken language


Description of the language spoken by the second parent.
Configuration

Select the home language using the Home language field on the Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLangauge lookup table. See:

 luLanguage lookup table.
 Loading lookup tables for external systems.

Important: Data is not loaded when the details of an existing row match the corresponding row from the loaded data. When this happens you need to manually select the MCEETYA ExternalSystemType and ExternalSystemCode values.

ADAvailableHoursAs these fields are outside the scope of Synergetic, they are listed in the proc, but no output is produced.
AEAvailableMinutes
AFAttended
AGECQualifiedTeacher
AHAttendedHours
AIAttendedMinutes

QLDDemographic
 Queensland Demographic field configurations
ColumnFieldDescription
AStudentIDSynergetic ID of the student.
BSchoolCode

Australian government code identifying the school.

Configuration
Type the school code assigned to your organisation into the School Code field on the Demographic tab of the Import/Export Student Data window.
CYearLevelYear level of the student.
Configuration
Select the year level of the student using the Year Level field on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
DGivenNameGiven name of the student.
Configuration
Type the given name of the student into the first text box of the Given field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
E

Surname

Surname of the student.
Configuration
Type the surname of the student into the Surname field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
F

Gender

Gender of the student.
Configuration
Select the gender of the student using the Gender field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
G


IndigenousStatus

Indigenous status of the student.
Configuration

Select the Indigenous Student and Torres Strait Islander fields on the Demographic tab of Current Student Maintenance to determine the value of this field. See Current Student Maintenance - Demographic tab.

This field has a value of:

  • 1 when the Indigenous Student flag is selected
  • 2 when the Torres Strait Islander flag is selected
  • 3 when both flags are selected.
  • 4 when neither flag is selected.
H

StudentCountryOfBirth

Code the country of birth of the student.
Configuration
Select the country of birth of the student using the Country of Birth drop-down list on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
I

StudentHomeLanguage

Code for the language spoken at home by the student.
Configuration

Select the home language of the student using the Home Language drop-down list on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

J

Parent1HomeLanguage

Code for the language spoken by the first parent at home.
Configuration

Select the home language using the Home language field on the  Parent 1 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

K

Parent2HomeLanguage

Code for the language spoken by the second parent at home.
Configuration

Select the home language using the Home language field on the Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

L

Parent1SchoolEducation

Code used for the highest level of school education attained by the first parent.
Configuration

Select the highest level of school education using the Highest Secondary Year Level field on the Parent 1 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

This field has a value of:

  • 0 for Not stated/unknown
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent
  • 3 for Year 11 or equivalent
  • 4 for Year 12 or equivalent.
M

Parent2SchoolEducation

Code used for the highest level of school education attained by the second parent.
Configuration

Select the highest level of school education using the Highest Secondary Year Level field on the Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab.

This field has a value of:

  • 0 for Not stated/unknown
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent
  • 3 for Year 11 or equivalent
  • 4 for Year 12 or equivalent.
N

Parent1NonSchoolEducation

Code used for the highest qualification level attained by the first parent.
Configuration
Select the highest qualification level of using the Highest Qualification Level field on the Parent sub-tab of the Demographic tab of Current Student MaintenanceSee Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 4 ) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

This field has a value of:

  • 0 for Not stated/unknown.
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent or below
  • 3 for Year 11 or equivalent or below
  • 4 for Year 12 or equivalent or below
  • 5 for Certificate I to IV (including trades)
  • 6 for Diploma/Advanced Diploma
  • 7 for Bachelor Degree or higher
  • 8 for No non-school education.
O

Parent2NonSchoolEducation

Code used for the highest qualification level attained by the second parent.
Configuration
Select the highest qualification level of using the Highest Qualification Level field on the Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab.

Note: The actual field value (e.g. 4) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

This field has a value of:

  • 0 for Not stated/unknown.
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent or below
  • 3 for Year 11 or equivalent or below
  • 4 for Year 12 or equivalent or below
  • 5 for Certificate I to IV (including trades)
  • 6 for Diploma/Advanced Diploma
  • 7 for Bachelor Degree or higher
  • 8 for No non-school education.
P

Parent1OccupationCode used for the occupation position of the first parent.
Configuration

Select the occupation position of the first parent using the Occupation Position field drop-down list on the Parent 1 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

Note: The actual field value (e.g. 2) is defined using the ExternalSystemCode field of the luOccupationPosition lookup table. You need to populate the lookup table values by loading MCEETYA values into the luOccupationPosition lookup table. See luOccupationPosition lookup table.

This field has a value of:

  • 1 for Senior management in large business organisation, government admin/defence, qualified professional
  • 2 for Other business manager, arts/media/sportsperson, associate professional
  • 3 for Tradesman/woman, clerk, skilled office/sales/service staff
  • 4 for Machine operator, hospitality staff, assistant, labourer, related worker
  • 8 for Not in paid work in last 12 months
  • 9 for Not stated or unknown.
Q

Parent2Occupation

Code used for the occupation position of the second parent.
Configuration

Select the occupation position of the second parent using the Occupation Position field drop-down list on the Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab.

Note: The actual field value (e.g. 2) is defined using the ExternalSystemCode field of the luOccupationPosition lookup table. You need to populate the lookup table values by loading MCEETYA values into the luOccupationPosition lookup table. See luOccupationPosition lookup table.

This field has a value of:

  • 1 for Senior management in large business organisation, government admin/defence, qualified professional
  • 2 for Other business manager, arts/media/sportsperson, associate professional
  • 3 for Tradesman/woman, clerk, skilled office/sales/service staff
  • 4 for Machine operator, hospitality staff, assistant, labourer, related worker
  • 8 for Not in paid work in last 12 months
  • 9 for Not stated or unknown.
SADemographic

Note: South Australian schools are no-longer required to submit February census data. Use the following field configurations for exporting demographic data for the August census.

 South Australia Demographic field configurations
ColumnFieldDescription
AIDSynergetic ID of the student.
BSchoolCode

Australian government code identifying the school.

Configuration
Type the school code assigned to your organisation into the School Code field on the Demographic tab of the Import/Export Student Data window.
CFirstNameGiven name of the student.
Configuration
Type the first given name of the student into the first text field of the Given field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
D

Surname

Surname of the student.
Configuration
Type the surname of the student into the Surname field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
EDateOfBirth

Date of birth of the student.
Configuration
Select the date of birth of the student using the Date of Birth field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
F

Gender

Gender of the student.
Configuration
Select the gender of the student using the Gender field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
GIndigenousStatus

Indigenous status of the student.
Configuration

Select the Indigenous Student and Torres Strait Islander fields on the Flags tab of Current Student Maintenance to determine the value of this field. See Current Student Maintenance - Flags tab.

This field has a value of:

  • 1 when the Indigenous Student flag is selected
  • 2 when the Torres Strait Islander flag is selected
  • 3 when both flags are selected.
  • 4 when neither flag is selected.
HLBOTEStatusWhether the student speaks a language other than English.
Configuration

Select the home language of the student using the Home Language field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.

This field has a value of:

  • Y when then student has a home language other than English
  • N when the student has a home language of English.
IYearLevel

Year level of the student.
Configuration
Select the year level of the student using the Year Level field on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
JFormClassForm of the student.
Configuration
Select the form of the student using the Form drop-down list on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
KSpacerNo configuration required.
L

StudentHomeLanguage

Language spoken by the student at home.
Configuration

Select the home language of the student using the Home Language drop-down list on Student sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

MSpacer2No configuration required.
N

CountryOfBirth

Code used for the country of birth of the student.
Configuration

Select the country of birth of the student using the Country of Birth drop-down list on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.

Note: The actual field value (e.g. 1101) is defined using the ExternalSystemCode field of the luCountry lookup table. You need to populate the lookup table values by loading MCEETYA values into the luCountry lookup table. See luCountry lookup table.

OSpacer3No configuration required.
P

Parent1SchoolEducation

Code used for the highest level of school education attained by the first parent.
Configuration

Select the highest level of school education using the Highest Secondary Year Level field on the Parent 1 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

Note: Parent 1 and Parent 2 are determined by the order of the parent contacts on the Contacts tab of Current Student Maintenance. See Current Student Maintenance - Contacts tab.

This field has a value of:

  • 0 for Not stated/unknown
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent
  • 3 for Year 11 or equivalent
  • 4 for Year 12 or equivalent.
Q

Parent1NonSchoolEducation

Code used for the highest qualification level attained by the first parent.
Configuration
Select the highest qualification level using the Highest Qualification Level field on the relevant Parent sub-tab of the Demographic tab of Current Student MaintenanceSee Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 4 ) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

This field has a value of:

  • 0 for Not stated/unknown.
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent or below
  • 3 for Year 11 or equivalent or below
  • 4 for Year 12 or equivalent or below
  • 5 for Certificate I to IV (including trades)
  • 6 for Diploma/Advanced Diploma
  • 7 for Bachelor Degree or higher
  • 8 for No non-school education.
RParent1OccupationCode used for the occupation position of the first parent.
Configuration

Select the occupation position using the Occupation Position field drop-down list on the Parent 1 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

Note: The actual field value (e.g. 2) is defined using the ExternalSystemCode field of the luOccupationPosition lookup table. You need to populate the lookup table values by loading MCEETYA values into the luOccupationPosition lookup table. See luOccupationPosition lookup table.

This field has a value of:

  • 1 for Senior management in large business organisation, government admin/defence, qualified professional
  • 2 for Other business manager, arts/media/sportsperson, associate professional
  • 3 for Tradesman/woman, clerk, skilled office/sales/service staff
  • 4 for Machine operator, hospitality staff, assistant, labourer, related worker
  • 8 for Not in paid work in last 12 months
  • 9 for Not stated or unknown.
S

Parent1HomeLanguage

Code used for the language spoken by the first parent at home.
Configuration

Select the home language using the Home language field on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

TSpacer4No configuration required.
U

Parent2SchoolEducation

Code used for the highest level of school education attained by the second parent.
Configuration

Select the highest level of school education using the Highest Secondary Year Level field on the Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab.

Note: Parent 1 and Parent 2 are determined by the order of the parent contacts on the Contacts tab of Current Student Maintenance. See Current Student Maintenance - Contacts tab.

This field has a value of:

  • 0 for Not stated/unknown
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent
  • 3 for Year 11 or equivalent
  • 4 for Year 12 or equivalent.
V

Parent2NonSchoolEducation

Code used for the highest qualification level attained by the second parent.
Configuration
Select the highest qualification level of using the Highest Qualification Level field on the Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab.

Note: The actual field value (e.g. 4) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

This field has a value of:

  • 0 for Not stated/unknown.
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent or below
  • 3 for Year 11 or equivalent or below
  • 4 for Year 12 or equivalent or below
  • 5 for Certificate I to IV (including trades)
  • 6 for Diploma/Advanced Diploma
  • 7 for Bachelor Degree or higher
  • 8 for No non-school education.
WParent2OccupationCode used for the occupation position of the second parent
Configuration

Select the occupation position using the Occupation Position field drop-down list on the Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab.

Note: The actual field value (e.g. 2) is defined using the ExternalSystemCode field of the luOccupationPosition lookup table. You need to populate the lookup table values by loading MCEETYA values into the luOccupationPosition lookup table. See luOccupationPosition lookup table.

X

Parent2HomeLanguage

Code used for the language spoken by the second parent at home.
Configuration

Select the home language using the Home language field on the Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

TASDemographic

Note: Tasmanian schools are no-longer required to submit February census data. Use the following field configurations for exporting demographic data for the August census.

 Tasmania Demographic field configurations
ColumnFieldDescription
AStudentIDSynergetic ID of the student.
BSchoolCode

Australian government code identifying the school.

Configuration
Type the school code assigned to your organisation into the School Code field on the Demographic tab of the Import/Export Student Data window.
CPreferredNamePreferred name of the student.
Configuration
Type the preferred name of the student into the Preferred field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
DMiddleNameMiddle name of the student.
Configuration
Type the middle name into the second text field of the Given field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
E

FamilyNameSurname of the student.
Configuration
Type the surname of the student into the Surname field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
F

DateOfBirth

Date of birth of the student.
Configuration
Select the date of birth of the student using the Date of Birth field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
GYearLevelYear level of the student.
Configuration
Select the year level of the student using the Year Level drop-down list on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
HHomeClassForm of the student.
Configuration
Select the form of the student using the Form drop-down list on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab.
INumeracyClassIDLeave this field blank.
JReadingClassIDLeave this field blank.
KWritingLanguageConventionClassIDLeave this field blank.
L

Sex

Gender of the student.
Configuration
Select the gender of the student using the Gender field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
M

IndigenousStatus

Indigenous status of the student.
Configuration

Select the Indigenous Student and Torres Strait Islander fields on the Flags tab of Current Student Maintenance to determine the value of this field. See Current Student Maintenance - Flags tab.

This field has a value of:

  • 1 when the Indigenous Student flag is selected
  • 2 when the Torres Strait Islander flag is selected
  • 3 when both flags are selected.
  • 4 when neither flag is selected.
N

StudentHomeLanguageLanguage spoken by the student at home.
Configuration

Select the home language of the student using the Home Language drop-down list on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

O

StudentCountryOfBirth

Code used for the country of birth of the student.
Configuration

Select the country of birth of the student using the Country of Birth drop-down list on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.

Note: The actual field value (e.g. 1101) is defined using the ExternalSystemCode field of the luCountry lookup table. You need to populate the lookup table values by loading MCEETYA values into the luCountry lookup table. See luCountry lookup table.

PMotherOccupationCode used for the occupation position of the mother.
Configuration

Select the occupation position of the mother using the Occupation Position field drop-down list on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 2) is defined using the ExternalSystemCode field of the luOccupationPosition lookup table. You need to populate the lookup table values by loading MCEETYA values into the luOccupationPosition lookup table. See luOccupationPosition lookup table.

This field has a value of:

  • 1 for Senior management in large business organisation, government admin/defence, qualified professional
  • 2 for Other business manager, arts/media/sportsperson, associate professional
  • 3 for Tradesman/woman, clerk, skilled office/sales/service staff
  • 4 for Machine operator, hospitality staff, assistant, labourer, related worker
  • 8 for Not in paid work in last 12 months
  • 9 for Not stated or unknown.
Q

MotherHomeLanguage

Code used for the language spoken by the mother at home.
Configuration

Select the home language using the Home language field on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

R

MotherSchoolEducation

Code used for the highest level of school education attained by the mother.
Configuration

Select the highest level of school education using the Highest Secondary Year Level field on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

This field has a value of:

  • 0 for Not stated/unknown
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent
  • 3 for Year 11 or equivalent
  • 4 for Year 12 or equivalent.
S

MotherNonSchoolEducation

Code used for the highest qualification level attained by the mother.
Configuration
Select the highest qualification level of using the Highest Qualification Level field on the relevant Parent sub-tab of the Demographic tab of Current Student MaintenanceSee Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 4 ) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

This field has a value of:

  • 0 for Not stated/unknown.
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent or below
  • 3 for Year 11 or equivalent or below
  • 4 for Year 12 or equivalent or below
  • 5 for Certificate I to IV (including trades)
  • 6 for Diploma/Advanced Diploma
  • 7 for Bachelor Degree or higher
  • 8 for No non-school education.
TFatherOccupationCode used for the occupation position of the father.
Configuration

Select the occupation position of the father using the Occupation Position field drop-down list on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 2) is defined using the ExternalSystemCode field of the luOccupationPosition lookup table. You need to populate the lookup table values by loading MCEETYA values into the luOccupationPosition lookup table. See luOccupationPosition lookup table.

This field has a value of:

  • 1 for Senior management in large business organisation, government admin/defence, qualified professional
  • 2 for Other business manager, arts/media/sportsperson, associate professional
  • 3 for Tradesman/woman, clerk, skilled office/sales/service staff
  • 4 for Machine operator, hospitality staff, assistant, labourer, related worker
  • 8 for Not in paid work in last 12 months
  • 9 for Not stated or unknown.
U

FatherHomeLanguage

Code used for the language spoken by the father at home.
Configuration

Select the home language using the Home language field on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

V

FatherSchoolEducation

Code used for the highest level of school education attained by the father.
Configuration

Select the highest level of school education using the Highest Secondary Year Level field on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

This field has a value of:

  • 0 for Not stated/unknown
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent
  • 3 for Year 11 or equivalent
  • 4 for Year 12 or equivalent.
W

FatherNonSchoolEducation

Code used for the highest qualification level attained by the father.
Configuration
Select the highest qualification level of using the Highest Qualification Level field on the relevant Parent sub-tab of the Demographic tab of Current Student MaintenanceSee Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 4) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

This field has a value of:

  • 0 for Not stated/unknown.
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent or below
  • 3 for Year 11 or equivalent or below
  • 4 for Year 12 or equivalent or below
  • 5 for Certificate I to IV (including trades)
  • 6 for Diploma/Advanced Diploma
  • 7 for Bachelor Degree or higher
  • 8 for No non-school education.
XFullFeePayingWhether the student is full-fee paying.
Configuration
Select the Full Fee Paying field on the Debtor tab of Current Student Maintenance. See Current Student Maintenance - Debtor tab.
VICDemographic
 Victoria Demographic field configurations
ColumnFieldDescription
ACourseType
BDETSchoolCode

School code including the MCEETYA Campus code.

Configuration

Populate MCEETYA values into the ExternalSystemType and ExternalSystemCode fields of the luCampus lookup table then type the school code assigned to your organisation into the School Code field on the Demographic tab of the Import/Export Student Data window.

For information about the luCampus lookup table, see luCampus lookup table.

CPreviousDETSchoolCodeLeave blank.
DVCAASchoolCodeAustralian government code identifying the school.
Configuration
Type the school code assigned to your organisation into the School Code field on the Demographic tab of the Import/Export Student Data window.
EStudentIDSynergetic ID of the student.
F

FamilyName

Surname of the student.
Configuration
Type the surname of the student into the Surname field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
GFirstNameFirst given name of the student.
Configuration
Type the first given name of the student into the Given field on the Personal tab of Current Student Maintenance.
HSecondNameMiddle name of the student.
Configuration
Type the middle name of the student into the second text field of the Given field on the Personal tab of Current Student Maintenance.
IPreviousFamilyNamePrevious surname of the student.
JPreviousFirstNamePrevious given name of the student.
KPreviousSecondNamePrevious middle name of the student.
LSalutationTitle used to address the student.
Configuration
Select the title using the Title field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.
M

DateOfBirth

Date of birth of the student.
Configuration
Select the date of birth of the student using the Date of Birth field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
N

Address1

First line of the student's home address.
Configuration
Populate the Line 1 field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab
O

AddressLine2

Second line of the student's home address.
Configuration
Populate the Line 2 field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab
PSuburbSuburb of the student's home address.
Configuration
Populate the Suburb field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.
QStateCountryState of the student's home address.
Configuration
Populate the state into the State field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.
RPostCodePostcode of the student's home address.
Configuration
Populate the postcode into the Postcode field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.
S

PhoneNumber

Phone number of the student.
Configuration
Type the phone number of the student into the Home Phone field on the Phone tab of Community Maintenance. See Community Maintenance - Home Address tab.
T

Gender

Gender of the student.
Configuration
Select the gender of the student using the Gender field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
UYearLevelYear level of the student.
Configuration
Select the year level of the student using the Year Level drop-down list on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
VHomeGroup
W

IndigenousStatus

Indigenous status of the student.
Configuration

Select the Indigenous Student and Torres Strait Islander fields on the Demographic tab of Current Student Maintenance to determine the value of this field. See Current Student Maintenance - Demographic tab.

This field has a value of:

  • 1 when the Indigenous Student flag is selected
  • 2 when the Torres Strait Islander flag is selected
  • 3 when both flags are selected.
  • 4 when neither flag is selected.
XLBOTEStatusWhether the student speaks a language other than English.
Configuration

Select the home language of the student using the Home Language field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.

This field has a value of:

  • Y when then student has a home language other than English
  • N when the student has a home language of English.
Y

Parent1SchoolEducationCode used for the highest level of school education attained by the first parent.
Configuration

Select the highest level of school education using the Highest Secondary Year Level field on the Parent 1 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

This field has a value of:

  • 0 for Not stated/unknown
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent
  • 3 for Year 11 or equivalent
  • 4 for Year 12 or equivalent.
Z

Parent2SchoolEducation

Code used for the highest level of school education attained by the second parent.
Configuration

Select the highest level of school education using the Highest Secondary Year Level field on the Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab.

This field has a value of:

  • 0 for Not stated/unknown
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent
  • 3 for Year 11 or equivalent
  • 4 for Year 12 or equivalent.
AA

Parent1NonSchoolEducation

Code used for the highest qualification level attained by the first parent.
Configuration
Select the highest qualification level using the Highest Qualification Level field on the Parent 1 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

Note: The actual field value (e.g. 4) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

This field has a value of:

  • 0 for Not stated/unknown.
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent or below
  • 3 for Year 11 or equivalent or below
  • 4 for Year 12 or equivalent or below
  • 5 for Certificate I to IV (including trades)
  • 6 for Diploma/Advanced Diploma
  • 7 for Bachelor Degree or higher
  • 8 for No non-school education.
AB

Parent2NonSchoolEducation

Code used for the highest qualification level attained by the second parent.
Configuration
Select the highest qualification level using the Highest Qualification Level field on the  Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab.

Note: The actual field value (e.g. 4) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

This field has a value of:

  • 0 for Not stated/unknown.
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent or below
  • 3 for Year 11 or equivalent or below
  • 4 for Year 12 or equivalent or below
  • 5 for Certificate I to IV (including trades)
  • 6 for Diploma/Advanced Diploma
  • 7 for Bachelor Degree or higher
  • 8 for No non-school education.
ACParent1OccupationCode used for the occupation position of the first parent.
Configuration

Select the occupation position using the Occupation Position field drop-down list on the Parent 1 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

Note: The actual field value (e.g. 2) is defined using the ExternalSystemCode field of the luOccupationPosition lookup table. You need to populate the lookup table values by loading MCEETYA values into the luOccupationPosition lookup table. See luOccupationPosition lookup table.

This field has a value of:

  • 1 for Senior management in large business organisation, government admin/defence, qualified professional
  • 2 for Other business manager, arts/media/sportsperson, associate professional
  • 3 for Tradesman/woman, clerk, skilled office/sales/service staff
  • 4 for Machine operator, hospitality staff, assistant, labourer, related worker
  • 8 for Not in paid work in last 12 months
  • 9 for Not stated or unknown.
ADParent2OccupationCode used for the occupation position of the second parent.
Configuration

Select the occupation position using the Occupation Position field drop-down list on the Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

Note: The actual field value (e.g. 2) is defined using the ExternalSystemCode field of the luOccupationPosition lookup table. You need to populate the lookup table values by loading MCEETYA values into the luOccupationPosition lookup table. See luOccupationPosition lookup table.

This field has a value of:

  • 1 for Senior management in large business organisation, government admin/defence, qualified professional
  • 2 for Other business manager, arts/media/sportsperson, associate professional
  • 3 for Tradesman/woman, clerk, skilled office/sales/service staff
  • 4 for Machine operator, hospitality staff, assistant, labourer, related worker
  • 8 for Not in paid work in last 12 months
  • 9 for Not stated or unknown.
AE

StudentHomeLanguage

Language spoken by the student at home.
Configuration

Select the home language of the student using the Home Language drop-down list on Student sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

AF

Parent1HomeLanguage

Code used for the language spoken by the first parent at home.
Configuration

Select the home language using the Home language field on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

AG

Parent2HomeLanguage

Code used for the language spoken by the second parent at home.
Configuration

Select the home language using the Home language field on the relevant Parent 2 sub-tab of the Demographic tab of Current Student MaintenanceSee Current Student Maintenance - Demographic tab - Parent 2 sub-tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

AH

CountryOfBirth

Code used for the country of birth of the student.
Configuration

Select the country of birth of the student using the Country of Birth drop-down list on Student sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 1101) is defined using the ExternalSystemCode field of the luCountry lookup table. You need to populate the lookup table values by loading MCEETYA values into the luCountry lookup table. See luCountry lookup table.

AIGovernmentStudentNumber

Student number assigned to the student by the government.

Configuration
Type the student number into the Government Student Number field on the Codes tab of Current Student Maintenance. See Current Student Maintenance - Codes tab.
WADemographic
 Western Australia Demographic field configurations
ColumnFieldDescription
AYearFile year of the export.
Configuration
Select the year using the Year field on the Demographic tab of the Import/Export Student Data window.
B


SemesterSemester of the export.
Configuration

Select the term using the Term field on the Demographic tab of the Import/Export Student Data window.

Note: This value corresponds to the value of the Sem field on the File Semester tab of Student File Semester Maintenance. The actual value populated in the export is determined by the value of the Actual Sem field. See Student File Semester Maintenance - File Semester tab.

CFile DateProcess date of the export.
Configuration
Select the process date using the Process Date field on the Demographic tab of the Import/Export Student Data window.
DSchool CodeAustralian government code identifying the school. 
Configuration
Type the school code into the School Code field on the Demographic tab of the Import/Export Student Data window.
ESchool NameName of your organisation.
Configuration
Type the name of your organisation into the School Name field on the Page 1 tab of the School tab of School Settings Maintenance. See School Settings Maintenance - School tab.
FPrevious School - Code
GPrevious School - Name
HEnrolment DateDate the student entered your organisation.
Configuration
Select the date using the Entry date field on the Entry tab of Current Student Maintenance. See Current Student Maintenance - Entry tab.
IStudentYearLevelYear level of the student.
Configuration
Select the year level of the student using the Year Level field on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab.
JFTEFTE of the student.
Configuration
Type the FTE of the student into the FTE field on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab.
KKINNumHoursTotal
LPrecompulsory SessionsNumber of half-days completed by kindergarten students.
Configuration

This value is defined based on the value typed into the FTE field on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab.

For example, with an FTE of 0.8 this field has a value 8.

MRepeatingWhether the student is repeating the year level.
Configuration
Select a status of Repeating using the Status field on the Status sub-tab of the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
NWestern Australia Student Number (WASN)

Student number assigned to the student by the government.

Configuration
Type the student number into the Government Student Number field on the Codes tab Current Student Maintenance. See Current Student Maintenance - Codes tab.
OFirst NameGiven name of the student.
Configuration
Type the given name of the student into the first text field of the Given field of the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
PMiddle NameMiddle name of the student.
Configuration
Type the middle name of the student into the second text field of the Given field of the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
QFamily NameSurname of the student.
Configuration
Type the surname of the student into the Surname field of the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
RPreferred NamePreferred name of the student.
Configuration
Type the preferred name of the student into the Preferred field of the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
SIndigenous StatusIndigenous status of the student.
Configuration

Select the Indigenous Student and Torres Strait Islander fields on the Demographic tab of Current Student Maintenance to determine the value of this field. See Current Student Maintenance - Demographic tab.

This field has a value of:

  • 1 when the Indigenous Student flag is selected
  • 2 when the Torres Strait Islander flag is selected
  • 3 when both flags are selected.
  • 4 when neither flag is selected.
TSexGender of the student.
Configuration
Select the gender of the student using the Gender field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab
UDate Of BirthDate of birth of the student.
Configuration
Select the date of birth of the student using the Date of Birth field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
VVisa Sub ClassVisa subclass of the student.
WCountry of BirthCountry of birth of the student.
Configuration

Select the country of birth of the student using the Country of Birth drop-down list on Student sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 1101) is defined using the ExternalSystemCode field of the luCountry lookup table. You need to populate the lookup table values by loading MCEETYA values into the luCountry lookup table. See luCountry lookup table.

XMain language other than English spoken at home by the student

Select the home language of the student using the Home Language drop-down list on Student sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

YResidential Address 1First line of home address of the student
Configuration
Populate the Line 1 field for the student on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.
ZResidential Address 2Second line of home address of the student
Configuration
Populate the Line 2 field for the student on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.
AASuburb/LocalitySuburb of the home address of the student.
Configuration
Populate the Suburb field for the student on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.
ABPostCodePostcode of the home address of the student.
Configuration
Populate the Postcode field for the student on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.
ACParent/Guardian 1 School EducationCode used for the highest level of school education attained by the first parent.
Configuration

Select the highest level of school education using the Highest Secondary Year Level field on the Parent 1 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

Note: Parent 1 and Parent 2 are determined by the order of the parent contacts on the Contacts tab of Current Student Maintenance. See Current Student Maintenance - Contacts tab.

This field has a value of:

  • 0 for Not stated/unknown
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent
  • 3 for Year 11 or equivalent
  • 4 for Year 12 or equivalent.
ADParent/Guardian 1 Non-School EducationCode used for the highest qualification level attained by the first parent.
Configuration
Select the highest qualification level using the Highest Qualification Level field on the Parent 1 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

Note: The actual field value (e.g. 4) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

This field has a value of:

  • 0 for Not stated/unknown.
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent or below
  • 3 for Year 11 or equivalent or below
  • 4 for Year 12 or equivalent or below
  • 5 for Certificate I to IV (including trades)
  • 6 for Diploma/Advanced Diploma
  • 7 for Bachelor Degree or higher
  • 8 for No non-school education.
AEParent/Guardian 1 OccupationCode used for the occupation position of the first parent.
Configuration

Select the occupation position using the Occupation Position field drop-down list on the Parent 1 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

Note: The actual field value (e.g. 2) is defined using the ExternalSystemCode field of the luOccupationPosition lookup table. You need to populate the lookup table values by loading MCEETYA values into the luOccupationPosition lookup table. See luOccupationPosition lookup table.

This field has a value of:

  • 1 for Senior management in large business organisation, government admin/defence, qualified professional
  • 2 for Other business manager, arts/media/sportsperson, associate professional
  • 3 for Tradesman/woman, clerk, skilled office/sales/service staff
  • 4 for Machine operator, hospitality staff, assistant, labourer, related worker
  • 8 for Not in paid work in last 12 months
  • 9 for Not stated or unknown.
AFParent/Guardian 1 Language BackgroundCode used for the language spoken by the first parent at home.
Configuration

Select the home language using the Home language field on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

AGParent/Guardian 2 School EducationCode used for the highest level of school education attained by the second parent.
Configuration

Select the highest level of school education using the Highest Secondary Year Level field on the Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab.

This field has a value of:

  • 0 for Not stated/unknown
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent
  • 3 for Year 11 or equivalent
  • 4 for Year 12 or equivalent.
AHParent/Guardian 2 Non-School EducationCode used for the highest qualification level attained by the first parent.
Configuration
Select the highest qualification level using the Highest Qualification Level field on th Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab.

Note: The actual field value (e.g. 4) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

This field has a value of:

  • 0 for Not stated/unknown.
  • 1 for Year 9 or equivalent or below
  • 2 for Year 10 or equivalent or below
  • 3 for Year 11 or equivalent or below
  • 4 for Year 12 or equivalent or below
  • 5 for Certificate I to IV (including trades)
  • 6 for Diploma/Advanced Diploma
  • 7 for Bachelor Degree or higher
  • 8 for No non-school education.
AIParent/Guardian 2 OccupationCode used for the occupation position of the first parent.
Configuration

Select the occupation position using the Occupation Position field drop-down list on the Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab.

Note: The actual field value (e.g. 2) is defined using the ExternalSystemCode field of the luOccupationPosition lookup table. You need to populate the lookup table values by loading MCEETYA values into the luOccupationPosition lookup table. See luOccupationPosition lookup table.

This field has a value of:

  • 1 for Senior management in large business organisation, government admin/defence, qualified professional
  • 2 for Other business manager, arts/media/sportsperson, associate professional
  • 3 for Tradesman/woman, clerk, skilled office/sales/service staff
  • 4 for Machine operator, hospitality staff, assistant, labourer, related worker
  • 8 for Not in paid work in last 12 months
  • 9 for Not stated or unknown.
AJParent/Guardian 2 Language BackgroundCode used for the language spoken by the first parent at home.
Configuration

Select the home language using the Home language field on the relevant Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab.

Note: The actual field value (e.g. 1201) is defined using the ExternalSystemCode field of the luLanguage lookup table. You need to populate the lookup table values by loading MCEETYA values into the luLanguage lookup table. See luLanguage lookup table.

AKAttendance Type
AKForm GroupYear level of the student.
Configuration
Select the year level of the student using the Year Level field on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab.
ALReligionReligion of the student.
Configuration
Select the religion of the student using the Religion field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
AM to AVDisability 1 to 9Disabilities recorded for the student.
Configuration

Record student disabilities using the Disability tab of Current Student Maintenance. See Current Student Maintenance - Disability tab.

Note: You can record up to nine disabilities. The order is based on the row order of the disabilities on the Disability tab.

AWParticipatingWhether the student is participating in the Nationally Consistent Collection of Data on School Students with Disability (NCCD SWD) census.
Configuration

Select the Include in Export field for the student disability to be reported on the Disability tab of Current Student Maintenance. See Current Student Maintenance - Disability tab.

AXCategory of DisabilityCategory of the disability being reported for the Nationally Consistent Collection of Data on School Students with Disability (NCCD SWD) census.
Configuration
Select the category of the student disability to be reported using the Category drop-down list on the Disability tab of Current Student Maintenance. See Current Student Maintenance - Disability tab.
AYDisability Adjustment ProvidedDisability adjustment level of the disability being reported for the Nationally Consistent Collection of Data on School Students with Disability (NCCD SWD) census.
Configuration
Select the disability adjustment level of the student disability to be reported using the Adjustment Level drop-down list on the Disability tab of Current Student Maintenance. See Current Student Maintenance - Disability tab.
AZInternational Fee PayingWhether the student is an international full-fee paying student.
Configuration
Select the Full Fee Paying field on the Debtor tab of Current Student Maintenance. See Current Student Maintenance - Debtor tab.
Export File

Select the file to export. You can export:

School CodeAustralian government code identifying the school.
School Code 2State government code identifying the school.
School Name

Northern Territory schools can use this field to enter their school name.

Note: You must select NT in the State field to view this field.

Note: You can define the value of this field using the MCEETYA_SchoolName MCEETYA_SchoolName configuration setting

Exclude Tagged Students

Select this field to exclude any tagged students from the export.

Note: You must select the ACARA - SBD option in the Export File drop-down list to view this field.

ACT Student ID Field

Australian Capital Territory schools can use this field to determine which field from the Codes tab of Current Student Maintenance is used to define the student number. See Current Student Maintenance - Codes tab.

You can select:

  • Studies Code
  • Government Student Number.

Note: You must select ACT using the State field to view this field.

Field Delimiter

How fields in the report are separated. Values include:

  • comma
  • tab
  • pipe
  • none.

Note: The school's governing body determines the delimiter to be used, as each country and state has different requirements. For example, the Association of Independent Schools Victoria (AISV) has their own standard.

Year Level From / To

Range of year levels to export.

Note: If the range of year levels you select is not compatible with the campus you are exporting data from then this filtering does not apply and data is exported regardless of the year level.

Process Date

Date the import or export was completed.

Reference Period From/To

Northern Territory schools can use this field to enter the reference period dates for the demographic export.

Note: You must select NT in the State field to view this field.

File Name

Name and location of exported file.

Progress

Progress of the import.

Buttons

Button

Description

Select the file location.

Icons

Button

Description

 (NT)

Northern Territory schools can hover over this icon to display additional information about the Reference Period From/To fields. See above.
  • No labels