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 | FirstName | 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 | 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. |
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 | 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.
|
G | LBOTEStatus | 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 | YearLevel
| 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 | FormClass | 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
| StudentHomeLanguage
| Language spoken by the student at home. |
Configuration |
Select the home language of the student using the Home Language drop-down list on Student sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab. Note: The actual field value (e.g. 1201 - 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 delete the row and reload the data. Tip: You can identify rows that prevented data being loaded because these rows will have blank ExternalSystemType and ExternalSystemCode fields. |
L | Spacer2 | No configuration required. |
M
| CountryOfBirth
| Code used for the country of birth of the student. |
Configuration |
Select the country of birth of the student using the Country of Birth drop-down list on the Personal tab of Current Student Maintenance. See Current Student Maintenance - Personal tab. Note: The actual field value (e.g. 1101) is defined using the ExternalSystemCode field of the luCountry lookup table. You need to populate the lookup table values by loading MCEETYA values into the luCountry lookup table. See • luCountry lookup table • 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 delete the row and reload the data. Tip: You can identify rows that prevented data being loaded because these rows will have blank ExternalSystemType and ExternalSystemCode fields. |
N | Spacer3 | No configuration required. |
O | Parent1SchoolEducation
| Code used for the highest level of school education attained by the first parent. |
Configuration |
Select the highest level of school education using the Highest Secondary Year Level field on the Parent 1 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab. Note: Parent 1 and Parent 2 are determined by the order of the parent contacts on the Contacts tab of Current Student Maintenance. See Current Student Maintenance - Contacts tab. This field has a value of: - 0 for Not stated/unknown
- 1 for Year 9 or equivalent or below
- 2 for Year 10 or equivalent
- 3 for Year 11 or equivalent
- 4 for Year 12 or equivalent.
|
P | Parent1NonSchoolEducation
| Code used for the highest qualification level attained by the first parent. |
Configuration |
Select the highest qualification level using the Highest Qualification Level field on the relevant Parent sub-tab of the Demographic tab of Current Student 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 luOccupationPosition lookup table. |
Q | Parent1Occupation | 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. |
R | Parent1HomeLanguage
| Code used for the language spoken by the first parent at home. |
Configuration |
Select the home language using the Home language field on the relevant Parent sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 1 sub-tab. Note: The actual field value (e.g. 1201 - 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 delete the row and reload the data. Tip: You can identify rows that prevented data being loaded because these rows will have blank ExternalSystemType and ExternalSystemCode fields. |
S | Spacer4 | No configuration required. |
T | Parent2SchoolEducation
| Code used for the highest level of school education attained by the second parent. |
Configuration |
Select the highest level of school education using the Highest Secondary Year Level field on the Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab. Note: Parent 1 and Parent 2 are determined by the order of the parent contacts on the Contacts tab of Current Student Maintenance. See Current Student Maintenance - Contacts tab. This field has a value of: - 0 for Not stated/unknown
- 1 for Year 9 or equivalent or below
- 2 for Year 10 or equivalent
- 3 for Year 11 or equivalent
- 4 for Year 12 or equivalent.
|
U | Parent2NonSchoolEducation
| Code used for the highest qualification level attained by the second parent. |
Configuration |
Select the highest qualification level of using the Highest Qualification Level field on the Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab. 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 luOccupationPosition lookup table. |
V | Parent2Occupation | 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. |
W | Parent2HomeLanguage
| Code used for the language spoken by the second parent at home. |
Configuration |
Select the home language using the Home language field on the Parent 2 sub-tab of the Demographic tab of Current Student Maintenance. See Current Student Maintenance - Demographic tab - Parent 2 sub-tab. Note: The actual field value (e.g. 1201 - 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 delete the row and reload the data. Tip: You can identify rows that prevented data being loaded because these rows will have blank ExternalSystemType and ExternalSystemCode fields. |