Page Comparison

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

See:

ISO_3166-1_alpha-2

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

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

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

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

See:

ISO_3166-1_alpha-2

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