Pupil Premium Dfe Report 2019/20 and Pupil Premium Calculation Spreadsheet

Update from CAPITA 15/03/2019:

Following the response kindly provided by the DfE, see below, I have made the following changes to these report definition files.

  • The reports have been renamed to ensure that schools understand that they can only be an approximation of FSM Ever as used by the DfE for allocating Deprivation Pupil Premium.  For example, the DfE knows the YTI reported for pupils in School Census when particular records of exclusion were report in School Census, but such data will not be known by a school when the pupils exclusion took place in a previous school.
  • The start and end date used for checking relevant exclusion records has been changed from 03/10/2013 - 17/01/2019 to 18/01/2013 - 17/01/2019

Two variants of the report definition file for DfE FSM Ever 6 at Spring Census 2019 are available from My Account.  Please select the one(s) suitable for your school phase.  The only difference between the two is that class is shown for primary and registration groups for secondary.

The file should be extracted from the ZIP before being imported via Reports | Import

This report definition uses the following logic and you should feel free to make adjustments as you see fit to meet your schools individual needs. 

On roll on 17/01/2019


Enrolment Status is: “Main – Dual Registration” or “Single Registration”


Eligible for FSM with FSM Country blank or set to “England” at any point between 18/01/2013 and 17/01/2019



NC Year Actual is: “R”, “1”, “2”, “3”, “4”, “5”, “6”, “7”, “8”, “9”, “10” or “11”


NC Year Actual is: “X” AND date of birth is between 01/09/2002 and 31/08/2014

Date ranges are inclusive.


Attached to this article are the Pupil Premium Dfe FSM Ever 6 Report for the Spring Census 2019, please download either the Primary or Secondary one based on your school phase.

To import into SIMS download the report below, and then in SIMS goto Reports >Import:

Then Click Open and browse to the reports you have saved, click on one, and then click on Import to import into SIMS. 

To Run the report go to Reports > Run Report > Focus > Student and search in the Report list for Dfe FSM Ever 6 @ Spring Census 2019.

Also attached is a CAPITA presentation and spreadsheet that can be used to understand and check the data that the Dfe will release in July via CSV file, the presentation shows how to copy the CSV information into the spreadsheet. There is also a sample CSV file to use if schools want to practice with the spreadsheet whilst they wait for the real data to be released.

Finally see below for some information on the Pupil Premium Grant per-pupil, and types of Pupil Premium for financial year 2019/20:

PPG (Pupil Premium Grant) per-pupil for financial year 2019/20

Adopted from Care Premium: £2,300 per year

Deprivation Premium - Reception to Year 6: £1,320 per year

Deprivation Premium - Year 7 to 11: £935 per year

Early Years Premium: 53p per hour up to a maximum of £302.10 per year (53p up to a maximum of 570 hours per year)

LAC (Looked After Children) Premium: £2,300 per year

Service Child Premium: £300 per year

The following information is based on the DfE specification for the financial year 2019/20 CSV download.

Deprivation pupil premium

This is reported in the DfE CSV download.

This is allocated to pupils on roll in the January 2019 school census or alternative provision census that are known to have been eligible for free school meals (FSM) on any pupil level census since summer 2013 (known as ‘FSM Ever 6’).

Service child pupil premium

This is reported in the DfE CSV download.

This is allocated to those pupils on roll in the January 2019 school census or alternative provision census who have been either:

  • recorded as a service child in either January 2014, January 2015, January 2016, January 2017 or January 2018; or
  • in receipt of a War Pension Scheme (WPS) or Armed Forces and Reserve Forces Compensation Scheme (AFCS) pension from the Ministry of Defence (MoD) as a result of injury, illness or death caused by service

Adopted from care pupil premium (also referred to as Post LAC pupil premium)

This is reported in the general DfE CSV downloads, but is not reported via the CSV files generated by the DfE search facility, as this pupil data is not intended to be passed between schools.

This allocated to pupils on roll in the January 2019 school census or alternative provision census who are recorded in January 2019 as either adopted from care or ceased to be looked after through a child arrangement order, special guardianship order or residence order.

Looked after children pupil premium

This is reported in the DfE CSV download where the pupil would have attracted one or more of the other pupil premiums.  It can be more accurately reported in the second general download than the first.

This allocated to children who have been recorded on the local authority SSDA903 return as looked after for 1 day or more between 1 April 2018 and 31 March 2019. This excludes children whose only episode(s) of care during the year was as a result of respite, or were on remand/committed for trial or sentence and accommodated by the local authority.

Due to the FSM and service child ever aspects used to allocate elements of the pupil premium, it is possible that some schools and local authorities may not know the identity of all the children for which they are being funded. For this reason the download was introduced to help schools and local authorities identify which of their pupils are eligible for pupil premium funding.

Further information on the pupil premium is available here (a link to a GOV.UK page).

Early years pupil premium (EYPP)

This is NOT reported in the DfE CSV download.

The early years pupil premium (EYPP) was introduced in April 2015 to allocate extra funding to providers of early years education to support disadvantaged 3- and 4-year-olds.

EYPP participation data is collected from early years providers via the school census, early years census and alternative provision census to allocate the EYPP. However as the funding is allocated directly to local authorities based on the data returned via the January census (meaning providers will be able to identify all of their eligible pupils from the data they have provided to the department), and as the eligibility, payment and distribution methodology is different from the school-age pupil premium, we will not be including details of children eligible for the EYPP in the pupil premium download.

Further information on the early years pupil premium is available here (a link to a GOV.UK page).

Have more questions? Submit a request


Article is closed for comments.