Appendix B enhanced dataset

Field name

Description

SubmitterLocalAuthorityCode

Code of the local authority that submitted the data

SubmitterLocalAuthorityName

Name of the local authority that submitted the data

SubmitterRegionCode

Code of region that the submitting LA is in

SubmitterRegionName

Name of region that the submitting LA is in

NCMPSystemId

Unique system code for each record

PupilReference

The local authority’s own pupil reference code

NHSNumber

NHS number

FirstName

Pupil first name

LastName

Pupil last name

Sex

Pupil sex

DateOfBirth

Pupil date of birth

AgeInMonths

Pupil age in months on date of measurement

SchoolYear

The school year that the pupil is in (Reception or Year 6)

Ethnicity

Ethnicity code as provided by the local authority

NHSEthnicCode

Ethnicity code mapped to NHS ethnicity code

NHSEthnicDescription

Ethnicity code mapped to NHS ethnicity description

NCMPEthnicity

Ethnicity code mapped to NCMP ethnicity category

Height

Pupil height (cm)

HeightZScore

Number of standard deviations the height is above or below the mean

HeightPScore

Height centile

Weight

Pupil weight (kg)

WeightZScore

Number of standard deviations the weight is above or below the mean

WeightPScore

Weight centile

Bmi

Pupil body mass index

BmiZScore

Number of standard deviations the BMI is above or below the mean

ClinicalBMIcategory

BMI category based on clinical thresholds

GroupedClinicalBMIcategory

BMI category based on clinical thresholds grouped to combine “overweight” and “very overweight”

BmiCentile(PScore)

BMI centile

PopulationBMIcategory

BMI category based on population thresholds2

GroupedPopulationBMIcategory

BMI category based on population thresholds grouped to combine “overweight” and “very overweight”

DateOfMeasurement

Date pupil was measured

DayOfMeasurement

Day of measurement

MonthOfMeasurement

Month of measurement

NonMeasurementReasonCode

Non-measurement reason code

NonMeasurementReasonDescription

Non-measurement reason description

FeedbackDateSent

Date that feedback extract for parental letter was generated (if generated)

Address1

Pupil address

Address2

Pupil address

Address3

Pupil address

Address4

Pupil address

Address5

Pupil address

Postcode

Pupil postcode

Notes

Notes about pupil

ParentTelephone

Parent telephone number

ParentEmail

Parent email address

SchoolUrn

6 digit DfE school reference number

SchoolName

School name

SchoolPostcode

School postcode

NcmpSchoolType

Category assigned by NHS England. Records from state schools are included in national analyses and records from independent schools are excluded

PupilSchoolPostcodeDistance

Distance in km between child’s home and school

PupilGovernmentOfficeRegion

Region (formerly GOR)

PupilGovernmentOfficeRegionCode

GOR Code

PupilGovernmentOfficeRegionName

GOR Name

Pupil2001CensusOutputArea

Census output area 2001

Pupil2001LowerSuperOutputArea

Lower Super Output Area 2001

Pupil2001MiddleSuperOutputArea

Middle Super Output Area 2001

Pupil2011CensusOutputArea

Census output area 2011

Pupil2011LowerSuperOutputArea

Lower Super Output Area 2011

Pupil2011MiddleSuperOutputArea

Middle Super Output Area 2011

Pupil2021CensusOutputArea

Census output area 2021

Pupil2021LowerSuperOutputArea

Lower Super Output Area 2021

PupilNationalGridReferenceNorthing

National Grid Reference (100m) - Northing

PupilNationalGridReferenceEasting

National Grid Reference (100m) - Easting

PupilElectoralWard

Electoral ward

PupilUrbanRuralIndicator

Rural/Urban Definition

PupilUrbanRuralDescription

Rural/Urban Definition

PupilUrbanRuralGroup

Rural/Urban Definition grouping "sparse" and "less sparse" together

PupilTier1LocalAuthorityCode

Upper tier local authority code

PupilTier1LocalAuthorityName

Upper tier local authority name

PupilTier2LocalAuthorityCode

Lower tier local authority code

PupilTier2LocalAuthorityName

Lower tier local authority name

PupilIndexOfMultipleDeprivationScore

Index of multiple deprivation

PupilIndexOfMultipleDeprivationDecile

Index of multiple deprivation

PupilOnsSupergroupCode

ONS area classification

PupilOnsSupergroupDescription

ONS area classification

PupilOnsGroupCode

ONS area classification

PupilOnsGroupDescription

ONS area classification

PupilOnsSubgroupCode

ONS area classification

PupilOnsSubgroupDescription

ONS area classification

SchoolGovernmentOfficeRegion

Region (formerly GOR)

SchoolGovernmentOfficeRegionCode

GOR Code

SchoolGovernmentOfficeRegionName

GOR Name

School2001CensusOutputArea

Census output area 2001

School2001LowerSuperOutputArea

Lower Super Output Area 2001

School2001MiddleSuperOutputArea

Middle Super Output Area 2001

School2011CensusOutputArea

Census output area 2011

School2011LowerSuperOutputArea

Lower Super Output Area 2011

School2011MiddleSuperOutputArea

Middle Super Output Area 2011

School2021CensusOutputArea

Census output area 2021

School2021LowerSuperOutputArea

Lower Super Output Area 2021

SchoolNationalGridReferenceNorthing

National Grid Reference (100m) - Northing

SchoolNationalGridReferenceEasting

National Grid Reference (100m) - Easting

SchoolElectoralWard

Electoral ward

SchoolUrbanRuralIndicator

Rural/Urban Definition

SchoolUrbanRuralDescription

Rural/Urban Definition

SchoolUrbanRuralGroup

Rural/Urban Definition grouping "sparse" and "less sparse" together

SchoolTier1LocalAuthorityCode

Upper tier local authority code

SchoolTier1LocalAuthorityName

Upper tier local authority name

SchoolTier2LocalAuthorityCode

Lower tier local authority code

SchoolTier2LocalAuthorityName

Lower tier local authority name

SchoolIndexOfMultipleDeprivationScore

Index of multiple deprivation

SchoolIndexOfMultipleDeprivationDecile

Index of multiple deprivation

SchoolOnsSupergroupCode

ONS area classification

SchoolOnsSupergroupDescription

ONS area classification

SchoolOnsGroupCode

ONS area classification

SchoolOnsGroupDescription

ONS area classification

SchoolOnsSubgroupCode

ONS area classification

SchoolOnsSubgroupDescription

ONS area classification

DQFlagCode

Data quality flag code

DQFlagDescription

Data quality flag description

ExtremeBmiWarning

States if pupil is "Very thin" (BMI centile <=0.4) or "Severely obese" (BMI centile >=99.6)