Input Column Sequence from CSV

AGEID of location

See extra information on Location AGEID

Numeric up 5 figures.

string

Student ID Original

This is the source system student original identifier (e.g. CEID’ER ID for Compass)– sometimes known within a school as an internal student identifier.

See extra information on Student and staff identifiers

 Alpha/Alphanumeric or Numeric up to 12 places.

string

Family name

This field must be blank.

string

Given name

This field must be blank.

string

Grade

The school grade that the student is enrolled on census date.

• Kindergarten

• Grade 1

• Grade 2

• Grade 3

• Grade 4

• Grade 5

• Grade 6

• Grade 7

• Grade 8

• Grade 9

• Grade 10

• Grade 11

• Grade 12

• Ungraded Primary*

• Ungraded Secondary*

string

Class (Primary only)

Name or ID of class that the student attends.

The value entered in this column must be the same for all children in the same class.

Note in previous years there has been tendency to group classes e.g. K/1/2

The requirement for this is what class does the child belong to - e.g. if he/she spends most time in Grade 1 Giraffes then put 1-Giraffes rather than 1-Giraffes/2-Rhinos/1-Lemurs which all Grade 1 students are split between.

string

Date of birth

The date the student was born. The student’s age in census will be calculated as at Census Reference Date (2020-Jul-01) – a different date to the Census Date.

Valid date

Date-dd/mm/yyyy

Gender

The gender of the student.

• Male

• Female

• Intersex/Unspecified

string

Indigenous

Indicates whether the student self-identifies as Aboriginal or Torres Strait Islander

• Yes

• No

• Not stated

string

Visa status

Indicates whether the student holds a permanent, bridging or temporary visa and if so, whether or not the Visa is eligible for funding. 

Those entered as "Funded Visa" or "Unfunded Visa" are counted as Students on Visas on DESE.

Those entered as "Unfunded Visa" are counted as Overseas Students.

• No Visa

• Funded Visa

• Unfunded Visa

Validate as warning on correlation with Indigenous status – if Yes to Indigenous and has a Visa then alert

string

Boarding

Indicates whether the student is accommodated in residential facilities administered by the school

• Yes

• No

string

Language status

Language status:

ESL=English as a second language +/- government assistance

LBOTE=Language background other than English

• ESL and receiving assistance

• ESL but not receiving assistance

• LBOTE but not ESL

• Not LBOTE

string

Religion

Student religious classification

• Catholic

• No religion

• Orthodox

• Other Christian

• Other faith

• Religion unknown

string

Enrolment status

Indicates whether the student is officially attending full-time or part-time

• Full-time

• Part-time

string

FTE

If part-time, proportion of study load compared to a full-time student

• Numerical – between 0 and 1 (non-inclusive) and rounded to one decimal place

• If between .5 and <1.0 then round up

• If  >0.0 and < 0.5 then round down

Decimal(6,1)

Attending another school (part-time only)

Indicates whether or not a part-time student attends another school.

For all Full-time students this will be No
For all Part-time students this will be Yes/No

• Yes

• No

string

Special Circumstances application

Most, if not all, students will be “No”.

NB February is all “No”

• Yes

• No

string

Special Circumstances application-Outcome

 NB February is all “N/A”

• N/A

• Waiting

• Approved

• Declined

string

Included in current census

“Yes” for if the student is to be the included in the current census. See extra section on Special Circumstances for further information(only August Census).

• Yes

• No

string

Student ID NCCD

 This a new field.  It is the  “external NCCD Student Identifier” as exposed by the NCCD system for an NCCD student. This required so can match the Census student record with the NCCD system record for export to DESE.

See extra information on NCCD

NB February is all “” as does not apply

Alpha/Alphanumeric or Numeric up to 12 places.

string

Input Column Sequence from CSV

AGEID of location

AGEID of location

See extra information on Location AGEID

string

Staff ID Orig

Staff ID Original

This is the source system staff original identifier (e.g. SAS Identifier or NESA Registration #).

See extra information on Student and staff identifiers

string

Family name

This field must be blank.

string

Given name

This field must be blank.

string

Column005

Date of birth

The date the staff member was born. The staff member’s age in census will be calculated as at Census Reference Date (2020-Jul-01) – a different date to the Census Date.

Valid date (optional)

Date-dd/mm/yyyy

Column006

Country of birth

Country of birth

string

Column007

Indigenous

Indicates whether the student self-identifies as Aboriginal or Torres Strait Islander

• Yes

• No

• Not stated

string

Gender

The gender of the staff member.

• Male

• Female

• Intersex/Unspecified

string

Column009

Diversity-Language

• People whose first language spoken as a child was not English

• People whose first language spoken as a child was English

• Not stated/Unknown

• FLSCNOTEng

• FLSCEng

• NS/Unk

string

Column010

Diversity-Disability

• People with a disability

• People who do not have a disability

• Not stated/Unknown

• Yes

• No

• NS/Unk

string

Column0011

Workload status

Indicates whether the staff member is employed full-time or part-time.  This is campus-specific - if the staff member works full-time in total but part-time at each of two or more campuses, they should be recorded as part-time.

• Full-time

• Part-time

string

Primary FTE

Proportion of full-time staff FTE workload worked at a primary level

Numerical – between 0 and 1 to one decimal place.  Restrictions on values shown on "Instructions - Staff FTE" page.

Decimal(6,1)

Secondary FTE

Proportion of full-time staff FTE workload worked at a secondary level

Numerical – between 0 and 1 to one decimal place.  Restrictions on values shown on "Instructions - Staff FTE" page

Decimal(6,1)

Class (Primary only)

Name or ID of class that the staff supervises.

It is understood this may be a range of classes

Note in previous years there has been a tendency to group classes e.g. K/1/2

The requirement for this is what class does the teacher staff member belong to - e.g. if he/she spends most time in Grade 1 Giraffes then put 1-Giraffes rather than 1-Giraffes/2-Rhinos/1-Lemurs which are split between.

Position on staff

The most senior position in which the staff member is employed

• Principal

• Assistant Principal

• RE Coordinators

• Coordinators 1-3

• Teachers

• Teacher Librarian

string

Years of Teaching Experience-Total

• 1st Year

• 2nd Year

• 3rd to 5th Year

• 6th to 10th Year

• 11th to 15th Year

• 16th to 20th Year

• More than 20 Years

string

Column017

Years of Teaching Experience-School

• 1st Year

• 2nd Year

• 3rd to 5th Year

• 6th to 10th Year

• 11th to 15th Year

• 16th to 20th Year

• More than 20 Years

string

Column018

Salary Band

<$40,000

$40,000-$59,999

$60,000-$79,999

$80,000-$99,999

$100,000-$119,999

$120,000+

p.a.

<$40,000

$40,000-$59,999

$60,000-$79,999

$80,000-$99,999

$100,000-$119,999

$120,000+

string

Column019

NESA Accreditation

• Conditional accreditation

• Highly Accomplished Teacher accreditation

• Lead Teacher accreditation

• Not stated/Unknown

• Proficient Teacher accreditation

• Provisional accreditation

• Conditional

• Highly Accomplished Teacher

• Lead Teacher

• Not stated/Unknown

• Proficient Teacher

• Provisional

string

Column020

Religion

Religious affiliation

• Catholic

• Non-Catholic

• Religion unknown

string

Religious status

“Yes” for staff belonging to a religious order

“No” for lay staff

• Yes

• No

string

Column022

Included in current census

Most, if not all, staff will be “Yes”.

• Yes

• No

string

Input Column Sequence from CSV

Header-Display in CSV

Description and specific instructions

Permissible values

Datatype

Column001

AGEID of location

AGEID of location

See extra information on Location AGEID

string

Column002

Staff ID Orig

Staff ID Original

This is the source system staff original identifier (e.g. SAS Identifier or NESA Registration #).

See extra information on Student and staff identifiers

string

Column003

Family name

This field must be blank.

string

Column004

Given name

This field must be blank.

string

Column005

Date of birth

The date the staff member was born. The staff member’s age in census will be calculated as at Census Reference Date (2020-Jul-01) – a different date to the Census Date.

Valid date (optional)

Date-dd/mm/yyyy

Column006

Country of birth

Country of birth

string

Column007

Indigenous

Indicates whether the student self-identifies as Aboriginal or Torres Strait Islander

• Yes

• No

• Not stated

string

Column008

Gender

The gender of the staff member.

• Male

• Female

• Intersex/Unspecified

string

Column009

Diversity-Language

• People whose first language spoken as a child was not English

• People whose first language spoken as a child was English

• Not stated/Unknown

• FLSCNOTEng

• FLSCEng

• NS/Unk

string

Column010

Diversity-Disability

• People with a disability

• People who do not have a disability

• Not stated/Unknown

• Yes

• No

• NS/Unk

string

Column0011

Workload status

Indicates whether the staff member is employed full-time or part-time.  This is campus-specific - if the staff member works full-time in total but part-time at each of two or more campuses, they should be recorded as part-time.

• Full-time

• Part-time

string

Column012

Primary FTE

Proportion of full-time staff FTE workload worked at a primary level

Numerical – between 0 and 1 to one decimal place.  Restrictions on values shown on "Instructions - Staff FTE" page.

Decimal(6,1)

Column013

Secondary FTE

Proportion of full-time staff FTE workload worked at a secondary level

Numerical – between 0 and 1 to one decimal place.  Restrictions on values shown on "Instructions - Staff FTE" page

Decimal(6,1)

Column014

Class (Primary only)

Name or ID of class that the staff supervises.

It is understood this may be a range of classes

Note in previous years there has been a tendency to group classes e.g. K/1/2

The requirement for this is what class does the teacher staff member belong to - e.g. if he/she spends most time in Grade 1 Giraffes then put 1-Giraffes rather than 1-Giraffes/2-Rhinos/1-Lemurs which are split between.

Column015

Staff Specialist Role

• Home School Liaison Officers

• Instructional Leaders

• Itinerant Support  Teachers, Vision & Hearing

• Learning & Support Teachers

• Not stated/Unknown

• Principals & School Leadership-Performance, Effectiveness & Student Improvement

• Positive Behaviour for Learning

• HSLO

• IL

• ISTV&H

• L&ST

• NS/Unk

• P&SL

• PBL

string

Column016

Years of Teaching Experience-Total

• 1st Year

• 2nd Year

• 3rd to 5th Year

• 6th to 10th Year

• 11th to 15th Year

• 16th to 20th Year

• More than 20 Years

string

Column017

Years of Teaching Experience-School

• 1st Year

• 2nd Year

• 3rd to 5th Year

• 6th to 10th Year

• 11th to 15th Year

• 16th to 20th Year

• More than 20 Years

string

Column018

Salary Band

<$40,000

$40,000-$59,999

$60,000-$79,999

$80,000-$99,999

$100,000-$119,999

$120,000+

p.a.

<$40,000

$40,000-$59,999

$60,000-$79,999

$80,000-$99,999

$100,000-$119,999

$120,000+

string

Column019

NESA Accreditation

• Conditional accreditation

• Highly Accomplished Teacher accreditation

• Lead Teacher accreditation

• Not stated/Unknown

• Proficient Teacher accreditation

• Provisional accreditation

• Conditional

• Highly Accomplished Teacher

• Lead Teacher

• Not stated/Unknown

• Proficient Teacher

• Provisional

string

Column020

Religion

Religious affiliation

• Catholic

• Non-Catholic

• Religion unknown

string

Column021

Religious status

“Yes” for staff belonging to a religious order

“No” for lay staff

• Yes

• No

string

Column022

Included in current census

Most, if not all, staff will be “Yes”.

• Yes

• No

string