Insurance claimants

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.
Claims data should only relate to personal injury claims i.e. trip and slips.
Claim details from 1 April 2009 to date of extract (8 October 2012) should be provided, or as a minimum 1 April 2012 to date of extract.
Please Note: Providers of insurance services are being approached to provide insurance data in bulk on behalf of local authorities. An update on this will be provided well in advance of the data submission deadline.

Field name	Data format	Comments
Case/claim reference	Character
Title	Character
Surname	Character	This should be the claimants details, e.g., NOT the Solicitor.
Forename(s)	Character
Middle name(s) or middle initial(s)		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.
Address line 1	Character	This should be the claimants home address, e.g., NOT the Solicitor’s address.
Address line 2	Character
Address line 3	Character
Postcode	Character
Date of birth	Date
National insurance number	Character
Incident date	Date
Time of incident	Character
Nature of incident	Character	Include a brief description only.
Nature of injuries	Character
Details of financial losses incurred	Character
Location of incident	Character
Date claim received	Date
Insurer	Character
Estimated cost	Numeric	The full estimated cost should be provided where no actual payments have been made or where only part payment has been made. Solicitors costs should be excluded.
Actual cost (previously ‘Total cost’)	Numeric	Include actual payments made. Solicitors costs should be excluded.
Date paid	Date	Provide the date the claim was paid.
Solicitor	Character
Claims agent or farmer	Character
Status	Character	Insert an ‘O’ in this field if the case is still open, ‘C’ if it is closed or ‘R’ if it was repudiated.
Name of expert	Character