Includes market trader, taxi driver and personal licenses for the supply of alcohol1
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:
- Current holders of a market trader or similar licence;
- Current holders of a taxi driver licence (private hire and Hackney carriages); and
- 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
- The Commission is also considering adding the following additional fields to this data specification; telephone number (home and mobile) and email address. The final decision will be confirmed by 31 May 2012.
| Field name |
Data format |
Comments |
Fields required |
| 1 |
2 |
3 |
| Reference number |
Character |
This should uniquely identify the individual, i.e. the licence number. |
√ |
√ |
√ |
| Title |
Character |
|
√ |
√ |
√ |
| Surname |
Character |
|
√ |
√ |
√ |
| 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. |
√ |
√ |
√ |
| Middle name(s) or middle initial(s) |
Character |
√ |
√ |
√ |
| Address line 1 |
Character |
|
√ |
√ |
√ |
| Address line 2 |
Character |
|
√ |
√ |
√ |
| Address line 3 |
Character |
|
√ |
√ |
√ |
| Address line 4 |
Character |
|
√ |
√ |
√ |
| Address Postcode |
Character |
|
√ |
√ |
√ |
| Date of birth |
Date |
|
√ |
√ |
√ |
| Home telephone number |
Numeric |
Potential new fields - a decision about whether these will be included will be confirmed by the Audit Commission by 31 May 2012. |
|
√ |
|
| Mobile telephone number |
Numeric |
|
√ |
|
| Email address |
Character |
|
√ |
|
| National insurance number |
Character |
|
√ |
√ |
√ |
| Premises name |
Character |
This field is required as a check that data only relates to small outlets. |
|
|
√3 |
| Licence start date |
Date |
|
√ |
√ |
√ |
| Licence expiry date |
Date |
|
√ |
√ |
√ |
| 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 |
√ |
√ |
√ |
1This data will primarily be matched to identify undeclared income and recourse to public funds.
2Data 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).
4This field only needs to be populated if you are unable to submit data in three separate files.