Table 1: Variables contained within the spring 2011 English School Census extract supplied to ONS
VARIABLE NAME DESCRIPTION
PUPILMATCHINGREFANONYMOUS_SPRxx Pupil matching reference: a unique number assigned by DfE to each pupil in national curriculum years above Nursery 2. In theory this number is fixed for the duration of a pupil’s education.
Therefore, if a pupil changes school (provided it is within scope i.e. not independent), name or gender the number should remain the same. In the case of school transfers a school can issue a temporary number until the original number is transferred.
Temporary numbers are identical to permanent numbers except that characters 11-13 are a two-digit serial number plus a letter (rather than a 3 digit serial number). 5
ACADEMICYEAR_SPRXX Academic year in which pupil started school
SURNAME_SPRXX Surname
DOB_SPRXX Date of Birth
ETHNICITY_SPRXX Pupil’s ethnicity
ETHNICGROUP_SPRXX Pupil's ethnic group based on ethnic code
LANGUAGE_SPRXX Pupil’s language – ENG = English
ENB = Not known but believed to be English OTH = Other than English
OTB = Not known but believed to be other than English REF = Refused
NOT = Information not obtained INV = Invalid code
LANGUAGEGROUP_SPRXX Pupil's language group based on language code.
LA_SPRXX Local Education Authority (LEA) of school where pupil attends
ESTAB_SPRXX Establishment number of the school attended as assigned by DfE.
SchoolName_SchXX School name in full, including the word „School‟ or „College‟ if this is part of the full name
SAON_SchXX School Flat, apartment name or number or other sub-division of a dwelling
PAON_SchXX Dwelling name and/or number of school
Street_SchXX School Street name or street description that has been allocated to a street by the street naming authority
Locality_SchXX School Locality: refers to a neighborhood, suburb, district, village, estate, settlement, or parish that may form part of a town, or stand in its own right within the context of an administrative area. Where an industrial estate contains streets it is defined as a locality in its in own right.
Town_SchXX School town: The town name refers to a city or town that is not an administrative area, a suburb of an administrative area that does not form part of another town or a London district
Beyond 2011 Administrative Data Sources Report: The English School Census and TheWelsh School Census 35 AdministrativeArea_SchXX School administrative areas: The administrative area is a geographic
area that may be the highest level local administrative area, which may be a county or a unitary authority, an island or island group or London PostTown_SchXX Post town of school: Post Office usually assigns these based on
Sorting Office
Postcode_SchXX Postcode of school
AddressLine1_SchXX First Line of School Address
AddressLine2_SchXX Second Line of School Address
AddressLine3_SchXX Third Line of School Address
AddressLine4_SchXX Fourth Line of School Address
AddressLine5_SchXX Fifth Line of School Address
ENTRYDATE_SPRXX Date of entry to current school.
BOARDER_SPRXX Indicates whether a pupil is a boarder or not.
B = Boarder, nights per week not specified 7 = Boarder, 7 nights a week
6 = Boarder, 6 nights or less a week N = not a boarder
ServiceChild_SPRXX** Indicates if a child has parent(s) who are Service personnel serving in regular military units of all forces and exercising parental care and responsibility.
Y = Yes, N=No, R=Refused U=Unknown
Postcode_SPRXX Pupils home postcode
SAON_SPRXX Start (single) dwelling number
PAON_SPRXX Start (single) dwelling number suffix
Street_SPRXX Street name or street description that has been allocated to a street by the street naming authority
Locality_SPRXX The locality name refers to a neighbourhood, suburb, district, village, estate, settlement, or parish that may form part of a town, or stand in its own right within the context of an administrative area. Where an industrial estate contains streets it is defined as a locality in its in own right.
Town_SPRXX Pupil‟s home town
AdministrativeArea_SPRXX Pupil‟s home administrative area
PostTown_SPRXX Pupil‟s home post town
AddressLine1_SPRXX First Line of pupil‟s home address
AddressLine2_SPRXX Second Line of pupil‟s home address
AddressLine3_SPRXX Third Line of pupil‟s home address
AddressLine4_SPRXX Fourth Line of pupil‟s home address
AddressLine5_SPRXX Fifth Line of pupil‟s home address
Postcode_mxx Pupil's home postcode (matchcode)
Home_LA_Code_mxx Pupils's home Local Authority code (matchcode)
Home_OA_Code_mxx Pupil's home Output Area code (matchcode)
XX denotes the year of data
**collected from 2008 onwards Source: ONS VML?
Beyond 2011 Administrative Data Sources Report: The English School Census and TheWelsh School Census 36 Table 2: Variables contained within the 2011 Welsh School Census extract supplied to ONS
Variable Description
Year Variable not taken forward to Admin Data set
Local Education Authority eg " 680"
School name eg "Mountain Lane Primary School"
Unique Pupil Number In the format "annnnnnnnnnnn"
Former Unique Pupil Number as above
Pupil's Surname eg "Jones"
Pupil's Forename eg "Emily"
Pupil's Middle names eg "Joe David"
Pupil's Gender M - Male
F - Female
Pupil's Date of Birth Held in SAS Date9 format ddmmmyyyy
eg "03MAR2007"
Pupil's Ethnic group See the worksheet - Ethnicity Codes, for the main and extended ethnicity codes and their description Source of Ethnic detail C - provided by the child (i.e. pupil)
P - provided by the parent
S - ascribed by the current school T- ascribed by a previous school O - other (or not known)
Pupil's Date of Entry to current school Held in SAS Date9 format ddmmmyyyy eg "02SEP2009"
Pupil's Home Postcode eg "SA18 2AP"
English as an Additional Language A - New to English B - Early Acquisition
C - Developing competence D - Competent
E - Fluent
0 - Not applicable
See the worksheet - English as Additional Language, for a fuller description of the codes used
Output Area Code Produced via Matchcode from Postcode -
NeSS_Output_Area_Code__P_
eg "00NUPX0007"
Local Authority Code Produced via Matchcode from Postcode -
NeSS_LA_UA_CA_DC_Code__P_
eg "00NU"
School number/establishment In the range 1000 - 7021
School Address Line 1 eg "Ysgol Morfa Rhianedd"
School Address Line 2 eg "Ffordd Cwm"
School Address Line 3 eg "Llandudno"
School Address Line 4 eg "Conwy"
School Address Line 5 eg "Carmarthenshire"
School Postcode eg "LL30 1EG"
School NeSS Output Area Code A Produced via Matchcode from SCH_Postcode eg "00NXQB0010"
School NeSS LA UA CA DC Code A Produced via Matchcode from SCH_Postcode eg "00NX"
Beyond 2011 Administrative Data Sources Report: The English School Census and TheWelsh School Census 37