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 | Curriculum council number | Curriculum council Western Australian Student Number (WASN) | Student number assigned to the student by the government. |
Configuration |
Type the curriculum council number 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 . If this occurs, check that the Citizenship, Visa Subclasses and Visa Conditions data are filled in correctlyis 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 | Disabilities recorded for the student.Disability code if student has a disability
Non-Govt Schools can be blank |
Configuration |
Record 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: You can record up to nine disabilities. The order is based on the row order of the disabilities on the Disability tab 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. |