Guidance

National Fraud Initiative: public sector data specifications

This guide sets out the dataset specifications for the NFI 2018 to 2019 national exercise and NFI council tax single person discount 2018 to 2019 exercise.

Please note that data:

Read more about uploading data to the NFI.

Changes for the 2018 to 2019 exercise

The NFI reviews data specifications before each exercise. Although changes have been kept to a minimum, some are necessary to improve the matching process and the quality of matches.

Changes for the 2018 to 2019 exercise

This file may not be suitable for users of assistive technology. Request an accessible format.

If you use assistive technology (such as a screen reader) and need a version of this document in a more accessible format, please email publiccorrespondence@cabinetoffice.gov.uk. Please tell us what format you need. It will help us if you say what assistive technology you use.

Trade creditors data specifications

Trade creditors standing data should:

  • be a snapshot of trade creditors current at the date of extraction
  • exclude dormant or suspended creditors
  • cover the period given in the data specification

Trade creditors standing data: draft data specification 2018 to 2019

This file may not be suitable for users of assistive technology. Request an accessible format.

If you use assistive technology (such as a screen reader) and need a version of this document in a more accessible format, please email publiccorrespondence@cabinetoffice.gov.uk. Please tell us what format you need. It will help us if you say what assistive technology you use.

Trade creditors payment history data: draft data specification 2018 to 2019

This file may not be suitable for users of assistive technology. Request an accessible format.

If you use assistive technology (such as a screen reader) and need a version of this document in a more accessible format, please email publiccorrespondence@cabinetoffice.gov.uk. Please tell us what format you need. It will help us if you say what assistive technology you use.

Personal budgets data specifications

Data should:

  • relate to Personal Budget payments paid as direct payments to those applicants over 18 years of age only
  • include only current recipients
  • have one single record for each recipient

Personal budgets: draft data specification 2018 to 2019

This file may not be suitable for users of assistive technology. Request an accessible format.

If you use assistive technology (such as a screen reader) and need a version of this document in a more accessible format, please email publiccorrespondence@cabinetoffice.gov.uk. Please tell us what format you need. It will help us if you say what assistive technology you use.

Pensions data specification

Data should be uploaded in 3 separate files:

  • current pensioners (those currently receiving a pension)
  • pensioners currently receiving a pension gratuity (if applicable)
  • deferred pensioners not currently in payment (optional)

Please note any pensions currently in payment should be included in the ‘current pensioners’ file.

Pensions: draft data specification 2018 to 2019

This file may not be suitable for users of assistive technology. Request an accessible format.

If you use assistive technology (such as a screen reader) and need a version of this document in a more accessible format, please email publiccorrespondence@cabinetoffice.gov.uk. Please tell us what format you need. It will help us if you say what assistive technology you use.

Payroll data specification

Payroll data should be provided in accordance with this data specification.

Payroll: draft data specification 2018 to 2019

This file may not be suitable for users of assistive technology. Request an accessible format.

If you use assistive technology (such as a screen reader) and need a version of this document in a more accessible format, please email publiccorrespondence@cabinetoffice.gov.uk. Please tell us what format you need. It will help us if you say what assistive technology you use.

Licences data specifications

This specification includes licences for market traders, taxi drivers and personal licences for the supply of alcohol.

Please upload data in 3 separate files:

  • current holders of a market trader or similar licence
  • current holders of a taxi driver licence (private hire and Hackney carriages)
  • current holders of a ‘personal alcohol licence’ (PAL) where the licence holder is also a ‘Designated Premises Supervisor’ (DPS)

Licences: draft data specification 2018 to 2019

This file may not be suitable for users of assistive technology. Request an accessible format.

If you use assistive technology (such as a screen reader) and need a version of this document in a more accessible format, please email publiccorrespondence@cabinetoffice.gov.uk. Please tell us what format you need. It will help us if you say what assistive technology you use.

Housing data specifications

Housing waiting list

The following housing waiting list data is required.

Housing waiting list: draft data specification 2018 to 2019

This file may not be suitable for users of assistive technology. Request an accessible format.

If you use assistive technology (such as a screen reader) and need a version of this document in a more accessible format, please email publiccorrespondence@cabinetoffice.gov.uk. Please tell us what format you need. It will help us if you say what assistive technology you use.

Housing tenants

The housing data that should be uploaded includes:

  • current named tenants, including those where a right to buy purchase is in progress
  • former tenants who completed a right to buy application during the period stated in the data specification

Housing tenants: draft data specification 2018 to 2019

This file may not be suitable for users of assistive technology. Request an accessible format.

If you use assistive technology (such as a screen reader) and need a version of this document in a more accessible format, please email publiccorrespondence@cabinetoffice.gov.uk. Please tell us what format you need. It will help us if you say what assistive technology you use.

Electoral Register data specifications

The NFI now requires Electoral Register data to be submitted annually. View the NFI council tax single person discount 2017/18 timetable. Please note that you are required to password protect each dataset once extracted from the relevant systems.

To find out who should supply data, refer to the data requirements guide.

The data:

  • should be the ‘full version’ of the Electoral Register (not the commercially available ‘edited version’)
  • should relate to the appropriate registration exercise
  • should include the Unique Property Reference Number (UPRN) field in your submission if it is fully or part populated
  • should be extracted and submitted after the Register is formally published

The upload process involves automatic mapping of fields to the specification by field name recognition. However, if there are no field names within the extracted data, it will require the person uploading to manually map each field to the appropriate field within the specification on the data file upload system. Therefore, it’s better to include field names within the data extract if possible.

Electoral Register: draft public sector data specification 2018 to 2019

This file may not be suitable for users of assistive technology. Request an accessible format.

If you use assistive technology (such as a screen reader) and need a version of this document in a more accessible format, please email publiccorrespondence@cabinetoffice.gov.uk. Please tell us what format you need. It will help us if you say what assistive technology you use.

Council Tax data specifications

The NFI now requires Council Tax (CT) data to be submitted annually. This means that when you have submitted CT and Electoral Register (ER) datasets for single person discount (SPD) fraud matching, the NFI can release your matches (unless you encounter data issues that we need to resolve). You will not need to wait for all councils to submit their data.

View the NFI council tax SPD 2017/18 timetable. Please note that you are required to password-protect each dataset once extracted from the relevant systems.

To find out who should supply council tax data, view the data requirements.

Extracting data

Whilst the process is up to individual bodies, we encourage the principle of sharing extraction routines to make the process more efficient and economical. For example, we are aware that standard extract routines are being offered by all the major Council Tax (CT) system suppliers. If you would like more information about this, contact your system supplier.

Data fields

The upload process involves automatic mapping of fields to the specification using field name recognition. However, if there are no field names within the extracted data, it will require the person uploading to manually map each field to the appropriate field within the specification on the data file upload system. Therefore, it would be preferable to include field names within the data file if possible.

If the surname and forename fields are not fully populated, or are unpopulated, these fields will still need to be provided as they have to be mapped for the upload to be accepted. CT systems where this is the case will normally also include an aggregated field that holds all name details. Where this happens, the aggregated field should also be provided so it can be mapped to the ‘Full name’ field within the specification.

A date of birth field is included, but it is accepted that this is not routinely stored as it is not mandatory for charging of CT. However, if it is captured, even as an optional field, it should be included in the extraction.

The data should:

  • include the Unique Property Reference Number (UPRN) field in your submission if it is populated or part populated
  • only be current/live accounts
  • relate to all CT accounts, whether or not there is a discount or exemption (i.e. it should cover every domestic property where CT applies)

Council Tax Reduction Scheme: draft data specification 2018 to 2019

This file may not be suitable for users of assistive technology. Request an accessible format.

If you use assistive technology (such as a screen reader) and need a version of this document in a more accessible format, please email publiccorrespondence@cabinetoffice.gov.uk. Please tell us what format you need. It will help us if you say what assistive technology you use.

Transport passes and permits data specifications

Please note, as in the 2016 to 2017 NFI exercise, the Blue Badge Improvement Service (BBIS) plan to upload data on behalf of all local authorities.

Please upload data in 3 separate files:

  • current holders of a resident’s parking permit
  • current holders of a blue badge (including local schemes)
  • current holders of a concessionary travel pass (eg a Freedom pass)

Transport Passes and Permits: draft data specification 2018 to 2019

This file may not be suitable for users of assistive technology. Request an accessible format.

If you use assistive technology (such as a screen reader) and need a version of this document in a more accessible format, please email publiccorrespondence@cabinetoffice.gov.uk. Please tell us what format you need. It will help us if you say what assistive technology you use.

Private supported care home patients data specifications

All data should relate to current care home residents at the date of extract who are receiving all, or part, of their funding from the Local Authority.

Private supported care home patients: draft data specification 2018 to 2019

This file may not be suitable for users of assistive technology. Request an accessible format.

If you use assistive technology (such as a screen reader) and need a version of this document in a more accessible format, please email publiccorrespondence@cabinetoffice.gov.uk. Please tell us what format you need. It will help us if you say what assistive technology you use.

Council Tax Reduction Scheme data specification

Data should be provided in accordance with the Council Tax Reduction scheme data specification.

Council Tax Reduction Scheme: draft data specification 2018 to 2019

This file may not be suitable for users of assistive technology. Request an accessible format.

If you use assistive technology (such as a screen reader) and need a version of this document in a more accessible format, please email publiccorrespondence@cabinetoffice.gov.uk. Please tell us what format you need. It will help us if you say what assistive technology you use.

Published 20 March 2015
Last updated 2 April 2018 + show all updates
  1. 2016 to 2017 information has been updated to 2018 to 2019 data specs. Link to archived page added for users to see previous specs. 'Insurance claimants data spec' removed and Transport data spec becomes 'Concessionary travel data'.
  2. Updated data specification sets for 2016/17.
  3. Updated for 2016/2017 NFI exercise
  4. Council tax and electoral register data specifications updated.
  5. Updated references to council tax timetable and the single person discount
  6. Updated council tax and electoral register data specifications.
  7. First published.