Exporting the Demographic file

Summary

Australian schools are required to export state-level demographic data to provide accurate data on student enrolments. State-specific field configurations are provided below.

Please be aware that the following schools have alternative demographic solutions:

Catholic New South Wales schools. See Import_Export Student Data - CSNSW tab.
Lutheran schools. See Import_Export Student Data - LEA tab.
Northern Territory schools. See Exporting the Student Age Census file (NT Demographic).

Field Configurations

State

Field configurations

ACT

Click to view field configurations

Column	Heading	Description
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.
B	ACT 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.
C	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.
D	GivenName	Given 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	MiddleName	Middle 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.
F	PreferredName	Preferred 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.
G	YearLevel	Year 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.
H	ClassID	Form 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.
I	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. This field has a value of either: 1 for Male 2 for Female 3 for Intersex or Indeterminate 9 for Not stated. Note: You need to map luGender values to these ACT Demographic values using the ACTGOVDEMO interface setting. See Using the Interface Settings window.
J	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.
K	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 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. • 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.
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. • 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.
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 field is selected 2 when the Torres Strait Islander field is selected 3 when both fields are selected. 4 when no fields are 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. • 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.
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 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 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. 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.
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 • 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.
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. 1101) 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.
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 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 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. 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.
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. 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. 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.
V	StudentApartmentNumber	Apartment 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.
W	StudentStreetNumber	Street 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.
X	StudentStreetName	Street 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.
Y	StudentHomeSuburb	Suburb 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.
Z	StudentHomePostCode	Postcode 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.
AA	StudentHomeState	State 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.
AB	InternationalStudent	Whether the student is an international student.
AC	StudentFTE	FTE 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.

NT

For information about exporting demographic data, see Exporting the Student Age Census file (NT Demographic).

NSW

Click to view field configurations

Column	Field	Description
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.
B	StudentID	Synergetic ID of the student.
C	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. This field has a maximum length of characters.
D	MiddleName	Middle 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. This field has a maximum length of characters.
E	GivenName	Given 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. This field has a maximum length of characters.
F	PreferredName	Preferred name of the student.
		Configuration
		Type the preferred name of the student into the first text box of the Preferred field on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab.
G	YearLevel	Year 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. This field has a maximum length of characters.
H	Form	Form 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. This field has a maximum length of characters.
I	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. This field has a maximum length of characters. This field has a value of: 1 for Male 2 for Female. Note: You need to map luGender values to these NSW Demographic values using the NSWGOVDEMO interface setting. See Using the Interface Settings window.
J	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. This field has a maximum length of characters.
K	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. This field has a maximum length of characters. 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. • 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.
L	HomeLanguage	Language 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. This field has a maximum length of characters. 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. • 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.
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 maximum length of characters. This field has a value of: - 1 when the Indigenous Student field is selected - 2 when the Torres Strait Islander field is selected - 3 when both fields are selected. - 4 when no fields are 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. This field has a maximum length of characters. 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. • 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.
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 maximum length of characters. 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 using the Highest Qualification 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 maximum length of characters. 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. 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.
Q	MotherOccupation	Code 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. This field has a maximum length of characters. 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. 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. • 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.
R	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. This field has a maximum length of characters. 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. • 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.
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 maximum length of characters. 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 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 Maintenance. See Current Student Maintenance - Demographic tab. This field has a maximum length of characters. 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. 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.
U	FatherOccupation	Code 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. This field has a maximum length of characters. 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. 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. • 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.
V	StudentDisabilityStatus	Disability status of the student.
		Configuration
		This value is defined using the Disability field on the Flags tab of Current Student Maintenance. See Current Student Maintenance - Flags tab. This field has a maximum length of 1 character. This field has a value of Y or N.
W	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
X	InternationalStudent	Whether the student is an international student.
		Configuration
		This field value is defined by selecting International Baccalaureate from the Learning Pathway drop-down list on the Flags tab of Current Student Maintenance. This field has a maximum length of 1 characters. This field has a value of Y or N.
Y	FullFeePaying	Whether 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.

QLD

Click to view field configurations

Column	Field	Description
A	Student ID	Synergetic ID of the student.
B	School no	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. This field has a maximum field length of 5 characters.
C	Year level	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. This field has a maximum field length of 2 characters.
D	First name	Given 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. This field has a maximum field length of 50 characters.
E	Last name	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. This field has a maximum field length of 50 characters.
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. This field has a value of: - M for Male - F for Female - X for Intersex or indeterminate. Note: You need to map luGender values to these QLD Demographic values using the QCAA interface setting. See Using the Interface Settings window.
G	Indigenous status	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 field is selected - 2 when the Torres Strait Islander field is selected - 3 when both fields are selected. - 4 when no fields are selected.
H	Country of birth	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. This field has a maximum length of 4 characters. Note: You need to map luCountry values to these QLD Demographic values using the QCAA interface setting. See Using the Interface Settings window.
I	Main language other than English spoken at home	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. This field has a maximum length of 4 characters. Note: You need to map luLanguage values to these QLD Demographic values using the QCAA interface setting. See Using the Interface Settings window.
J	Parent 1 main language other than English spoken at home	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. This field has a maximum length of 4 characters. Note: You need to map luLanguage values to these QLD Demographic values using the QCAA interface setting. See Using the Interface Settings window.
K	Parent 2 main language other than English spoken at home	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. This field has a maximum length of 4 characters. Note: You need to map luLanguage values to these QLD Demographic values using the QCAA interface setting. See Using the Interface Settings window.
L	Parent 1 parental school education	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 maximum length of 4 characters. 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	Parent 2 parental school education	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 maximum length of 4 characters. 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	Parent 1 parental 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 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab. This field has a maximum length of 4 characters. This field has a value of: - 0 for Not stated/unknown. - 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. 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.
O	Parent 2 parental 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 maximum length of 4 characters. This field has a value of: - 0 for Not stated/unknown. - 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. 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.
P	Parent 1 occupation	Code 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. This field has a maximum length of 4 characters. 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. 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. • 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
Q	Parent 2 occupation	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. This field has a maximum length of 4 characters. 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. 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. • 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.
R	Full fee paying	Whether the student is full-fee paying.
		Configuration
		This field is defined using 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 either: - 1 for full-fee paying - 2 for non-full-fee paying.

SA

Note: South Australian schools are no-longer required to submit February census data.

Click to view field configurations

Column	Field	Description
A	School code	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.
B	First name	Given 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.
C	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.
D	Date of birth	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.
E	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. This field has a value of either: 1 for Male 2 for Female 3 for Intersex or Indeterminate 9 for Not stated. Note: You need to map luGender values to these SA Demographic values using the SAGOVDEMO interface setting. See Using the Interface Settings window.
F	Indigenous status	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 field is selected 2 when the Torres Strait Islander field is selected 3 when both fields are selected. 4 when no fields are selected.
G	LBOTE status	Whether 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.
H	Year level	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.
I	Form class	Form 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.
J	Spacer	No configuration required.
K	Student home language	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 - English) 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. • 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.
L	Spacer 2	No configuration required.
M	Country 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 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 • 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.
N	Spacer 3	No configuration required.
O	Parent 1 school education	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.
P	Parent 1 non school education	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 Maintenance. See Current Student Maintenance - Demographic tab. This field has a value of: 0 for Not stated/unknown. 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. 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.
Q	Parent 1 occupation	Code 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. 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. 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. • 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.
R	Parent 1 home language	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 - English) 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. • 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.
S	Spacer 4	No configuration required.
T	Parent 2 school education	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.
U	Parent 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: 0 for Not stated/unknown. 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. 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.
V	Parent 2 occupation	Code 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. 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. 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. • 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
W	Parent 2 home language	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 - English) 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. • 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.

TAS

Note: Tasmanian schools are no-longer required to submit February census data.

Click to view field configurations

Column	Field	Description
A	Student ID	Synergetic ID of the student.
B	School code	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.
C	First name	Given name of the student.
		Configuration
		Type the 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	Preferred name	Preferred 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.
E	Middle name	Middle 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.
F	Family name	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.
G	Date of birth	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.
H	Year level	Year 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.
I	Home class	Form 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.
J	Numeracy class ID	Leave this field blank.
K	Reading class ID	Leave this field blank.
L	Writing language convention class ID	Leave this field blank.
M	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. This field has a value of either: 1 for Male 2 for Female 9 for Intersex or Indeterminate. Note: You need to map luGender values to these ACT Demographic values using the TASGOVDEMO interface setting. See Using the Interface Settings window.
N	Indigenous status	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.
O	Student home language	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 - English) 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. • 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.
P	Student country 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 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 • 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.
Q	Mother occupation	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. 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. 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.
R	Mother home language	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 - English) 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. • 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.
S	Mother school education	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.
T	Mother non school education	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 Maintenance. See Current Student Maintenance - Demographic tab. This field has a value of: 0 for Not stated/unknown. 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. 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.
U	Father occupation	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. 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. 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. • 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.
V	Father home language	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 - English) 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. • 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.
W	Father school education	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.
X	Father non school education	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 Maintenance. See Current Student Maintenance - Demographic tab. This field has a value of: 0 for Not stated/unknown. 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. 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.
Y	Full fee paying	Whether 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.

VIC

Click to view field configurations

Column	Field	Description
A	Course type
B	DET school code	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.
C	Previous DET school code	Leave blank.
D	VCAA school code	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.
E	Student ID	Synergetic ID of the student.
F	Family name	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.
G	First name	First 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.
H	Second name	Middle 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.
I	Previous family name	Previous surname of the student.
J	Previous first name	Previous given name of the student.
K	Previous second name	Previous middle name of the student.
L	Salutation	Title 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	Date of birth	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	Address 1	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	Address line 2	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.
P	Suburb	Suburb 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.
Q	State country	State 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.
R	Postcode	Postcode 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	Phone number	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. This field currently supports values of: M for Male F for Female. Note: You need to map luGender values to these ACT Demographic values using the VICGOVDEMO interface setting. See Using the Interface Settings window.
U	Year level	Year 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.
V	Home group	Form or tutor group of the student.
		Configuration
		Select whether the populate the form or tutor group using the FormFieldName field on the luYearLevel lookup table. See luYearLevel lookup table. Select the form or tutor group using the Form or Tutor group drop-down lists on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
W	Indigenous status	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: K when the Indigenous Student flag is selected T when the Torres Strait Islander flag is selected B when both flags are selected. N when neither flag is selected.
X	LBOTE status	Whether 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	Parent 1 school education	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.
Z	Parent 2 school education	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	Parent 1 non school education	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. 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. 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.
AB	Parent 2 non school education	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. 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. 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.
AC	Parent 1 occupation	Code 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. 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. 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. • 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.
AD	Parent 2 occupation	Code 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. 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. 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. • 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.
AE	Student home language	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 - English) 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. • 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.
AF	Parent 1 home language	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 - English) 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. • 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.
AG	Parent 2 home language	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 Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab. Note: The actual field value (e.g. 1201 - English) 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. • 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.
AH	Country 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: 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 • 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.
AI	Government student number	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.

WA

Click to view field configurations

Column	Field	Description
A	Year	File year of the export.
		Configuration
		Select the year using the Year field on the Demographic tab of the Import/Export Student Data window.
B	Semester	Semester 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.
C	File date	Process 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.
D	School code	Australian 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.
E	School name	Name 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.
F	Previous school - code	Code of the previous school attended by the student.
		Configuration
		Select the previous school using the Previous School field on the Entry tab of Current Student Maintenance. See Current Student Maintenance - Entry tab. This field has a value of: your school code if the student has studied at your school during the previous year the previous school code if the student studied at another school during the previous year 0009 when the school code is invalid or blank. Note: The actual field value is defined using the ExternalSystemCode field of the luSchool lookup table. You need to populate the lookup table values by loading MCEETYA values into the luSchool lookup table. See: • luSchool 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.
G	Previous school - name	Name of the previous school attended by the student.
		Configuration
		Select the previous school using the Previous School field on the Entry tab of Current Student Maintenance. See Current Student Maintenance - Entry tab. This field has a value of: your school name if the student has studied at your school during the previous year the previous school name if the student studied at another school during the previous year Not stated when the school code is invalid or blank. Note: The actual field value is defined using the Description field of the luSchool lookup table. You need to populate the lookup table values by loading MCEETYA values into the luSchool lookup table. See: • luSchool 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.
H	Enrolment date	Date 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.
I	Student year level	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.
J	FTE	FTE 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.
K	KIN num hours total
L	Precompulsory sessions	Number 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.
M	Repeating	Whether 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.
N	Western Australian 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.
O	First name	Given 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.
P	Middle name	Middle 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.
Q	Family name	Surname 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.
R	Preferred Name	Preferred 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.
S	Indigenous Status	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.
T	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. This field has a value of either: 1 for Male 2 for Female 3 for Intersex or Indeterminate 9 for Not stated. Note: You need to map luGender values to these WA Demographic values using the WAGOVDEMO interface setting. See Using the Interface Settings window.
U	Date Of Birth	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.
V	Visa sub class	Visa subclass code of the student.
		Configuration
		Select the visa subclass using the Subclass drop-down list on the International tab of Current Student Maintenance. See Current Student Maintenance - International tab. Note: This column may be unexpectedly blank if there is bad data. If this occurs, check that the Citizenship, Visa Subclasses and Visa Conditions data is correct.
W	Country of Birth	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 - 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. • 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.
X	Main 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. 1101) 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 • 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.
Y	Residential Address 1	First 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.
Z	Residential Address 2	Second 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.
AA	Suburb/Locality	Suburb 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.
AB	PostCode	Postcode 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.
AC	Parent/Guardian 1 School Education	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.
AD	Parent/Guardian 1 Non-School Education	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. This field has a value of: 0 for Not stated/unknown. 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. 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.
AE	Parent/Guardian 1 Occupation	Code 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. 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. 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. • 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.
AF	Parent/Guardian 1 Language Background	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 • 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.
AG	Parent/Guardian 2 School Education	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.
AH	Parent/Guardian 2 Non-School Education	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 th 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. 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. 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.
AI	Parent/Guardian 2 Occupation	Code 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. 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. 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.
AJ	Parent/Guardian 2 Language Background	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 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 • 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.
AK	Attendance Type
AK	Form Group	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.
AL	Religion	Religion 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 AV	Disability 1 to 9	Disability code if student has a disability Non-Govt Schools can be blank
		Configuration
		Intentionally blank. Although student disabilities are recorded using the Disability tab of Current Student Maintenance, they are not included in the data at export, but can be manually added post export and pre-submission. See Current Student Maintenance - Disability tab. Note: Up to nine disability codes can be manually added to the data file post export and pre-submission. Must be a current WA DoE disability code - see current WA DoE CSV DATA FILE Specifications for the WA School Census.
AW	Participating	Whether 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.
AX	Category of Disability	Category 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.
AY	Disability Adjustment Provided	Disability 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.
AZ	International Fee Paying	Whether 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.

To export the Demographic file:

Map the outbound Synergetic lookup table values to the values expected by your state education authority using the Interface Settings window. For

• ACT organisations use the ACTGOVDEMO external system
• NSW organisations use the NSWGOVDEMO external system
• NT organisations use the NTGOVDEMO external system
• QLD organisations use the QCAA external system
• SA organisations use the SAGOVDEMO external system
• TAS organisations use the TASGOVDEMO external system
• VIC organisations use the VICGOVDEMO external system
• WA organisations use the WAGOVDEMO external system.

See Using the Interface Settings window.
Open the Demographic tab of the Import/Export Student Data window. See Import_Export Student Data - Demographic tab.
The Demographic tab of the Import/Export Student Data window is displayed.
Select the year using the Year field.
Select the term using the Term field.

Note: You do not need to select the Campus.
Ensure the correct state is selected using the State field.

Note: You can define the default state of this field using the MCEETYA_State configuration setting.
Select Demographic is selected using the Export File drop-down list.
For ACT organisations, select an option from the ACT Student ID drop-down list to determine which field from the Codes tab of Current Student Maintenance is used to define the student number.
Select how fields in the report are separated using the Delimiter field.

Tip: We recommend using the Comma delimiter.
Select the date up to which student data will be included in the Demographic file using the Process Date field.

Note: Students are excluded if their Entry Date is after this date or their Leaving Date is prior to this date.
Click to select a location to save the file.
The Save As window is displayed.
Navigate to the file location where the Demographic file is to be saved.
Type a filename into the File name field followed by .txt. For example, Demographic Export 2020.txt.

Note: Exporting the SBD file as a text file ensures that values with leading zeroes are maintained. Later in this process we will export this data into the ACARA Spreadsheet.
Click .
Click .
The Demographic file is exported.
Open Microsoft Excel.
Click the Data tab.
The Data tab is displayed.
Click in the Get External Data area.
The Import Text File window is displayed.
Select the 2019 SBD Export.txt file.
Click .
The Text Import Wizard - Step 1 of 3 window is displayed.

Tip: You can change the value of the Start import at row field if you are using the ACARA spreadsheet with pre-defined headers.
Select the My Data has headers field.
Click .
The Text Import Wizard - Step 2 of 3 window is displayed.
Select the delimiter used for the text file using the Delimiters area. For example, Comma.
The Data preview area is refreshed to display the content in columns.
Click .
The Text Import Wizard - Step 3 of 3 window is displayed.
Select one of the following columns in the Data preview area.

•
Select the Text field in the Column data format area.
Repeat Steps 22 and 23 for the remaining fields.
Click .
The Import Data window is displayed.

Tip: You can update the Existing worksheet field to change the row and column insertion point.
Click .
The 2019 SBD Export is imported.
Review the information for completeness.

Note: You can use the field information below these steps to determine acceptable values and where the values are defined in Synergetic.
Repeat the export process, if necessary.
Submit the Demographic file to .
Exporting the Demographic file is complete.