Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.




Report Date

For simplicity, it is assumed that the report date is always 31st July in the contract year of the QAR (i.e. the last day of the contract year).

Note that the format is “year/year-plus-one”, so 2021 is actually 2020/2021 and therefore represents the 2020 contract year.


The first 8 characters of the filename represent the UKPRN.

This is used to filter the PICS QAR data, and a value must be selected as the QAR extract only ever contains the data for one UKPRN.

QAR Report Type

The report type is set based on the filename containing as follows:

  • APPS_

  • : Apprenticeship Programmes

  • ET_

  • : Education and Training

  • Train_

  • : Traineeship Programmes

PICS produces separate Traineeship reports for programme and component aims, whereas the QAR data contains all traineeship aims in one file. Therefore it is required to manually change to Traineeship Component Aims if a reconciliation for component aims is wanted.

Only include data affecting the latest reporting year

As both the PICS and QAR reports contain a lot of aims which ended in previous years, and therefore have no effect on the current year’s QAR totals, this option can be used to only show aims where either the PICS or QAR Overall Year is the report year, with all other aims removed.