VIC Demographic

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.