Protecting the public purse

Skip to content

Audit Commission

Audit Commission > National Fraud Initiative > NFI instructions > Data specifications – Public Sector > Licences

Licences

Includes market trader, taxi driver and personal licenses for the supply of alcohol 1

Please note, bodies in Wales should follow the data specification available on the Wales Audit Office website (external link).

Requirements

  • Data should only be submitted via the Data File Upload (DFU) facility. This is now the only acceptable method to supply data. If another submission method is used our policy is to inform the Director of Finance that data has been put at risk unnecessarily.
  • In order to ensure that the submission of data using the DFU is as straightforward as possible data should be uploaded in three separate files:
    1. Current holders of a market trader or similar licence;
    2. Current holders of a taxi driver licence (private hire and Hackney carriages); and
    3. Current holders of a ‘personal alcohol licence’ (PAL) where the licence holder is also a ‘Designated Premises Supervisor’ (DPS) and the associated premises is a small outlet.2
  • PLEASE NOTE: the following additional fields to this data specification have been confirmed as ‘telephone number’ (home and mobile) and ‘email address’.

 

Field name Data format Comments Fields required
1 2 3
Reference number Character This should uniquely identify the individual, i.e. the licence number. Yes Yes Yes
Title Character   Yes Yes Yes
Surname Character   Yes Yes Yes
Forename(s) Character Revised – Please ensure you capture any middle name(s) or initial(s). You can provide this in a separate Middle name(s) or middle initial(s) field or in the ‘Forename(s)’ cell if preferred. Yes Yes Yes
Middle name(s) or middle initial(s) Character Yes Yes Yes
Address line 1 Character   Yes Yes Yes
Address line 2 Character   Yes Yes Yes
Address line 3 Character   Yes Yes Yes
Address line 4 Character   Yes Yes Yes
Address Postcode Character   Yes Yes Yes
Date of birth Date   Yes Yes Yes
Home telephone number5 Character6 New fields. See note 5 below.   Yes  
Mobile telephone number5 Character6   Yes  
Email address5 Character   Yes  
National insurance number Character   Yes Yes Yes
Premises name Character This field is required as a check that data only relates to small outlets.     Yes 3
Licence start date Date    Yes Yes Yes
Licence expiry date Date   Yes Yes Yes
System type flag4 Character Insert ‘M’ in this field to indicate the data relates to a market trader/ operator, ‘T’ for taxi driver or ‘P’ for a Personal licence to supply alcohol Yes Yes Yes

1 This data will primarily be matched to identify undeclared income and recourse to public funds.

2 Data relating to major outlets, such as Tesco or Sainsburys is not required nor are one off licences for private events, etc.

3 Data for this field will be included within the premises database. Data should only be submitted for personal licence holders who are registered at a premise (e.g. Designated Premises Supervisor).

4 This field only needs to be populated if you are unable to submit data in three separate files.

5 These fields are collected for matching purposes only and will not be shown within any matches passed back to participants for review.

6 Updated 21/6/12 from numeric to character

Downloads

2012/13 NFI licences detailed data specification