RAC Cover File & Data Processes
List of authorized values
Column name
Description
Data type Mandatory/ Optional
The IPT shall be equal to % of premium at current prevailing rate
Refer to Section 6 for the format that should be used
Insurance Premium Tax
Number(6,2) [£]
Optional
This is the manufacturer of the vehicle
Mandatory if vehicle based
Make
Varchar(50)
[NA]
This is the model of the vehicle
Mandatory if vehicle based
Model
Varchar(50)
[NA]
Type of vehicle - Moped, scooter, hatchback, saloon, etc.
Vehicle Type
Varchar(20)
Optional
[NA]
Mandatory if the vehicle has a motor manufacturer free cover period
Date the vehicle was first registered. Also referred to as DVLA date
Refer to Section 6 for the format that should be used
Registration Date
Date
Vehicle Identification Number. Same as chassis number. It is a unique code including a serial number, used by the automotive industry to identify individual motor vehicles This is the vehicle mileage at the date of acquisition (or renewal for the renewals)
VIN
Char(17)
Optional
[NA]
Refer to Section 6 for the format that should be used
Integer [Miles]
Vehicle Mileage
Optional
Transmission Type
Manual or Automatic
Varchar(30)
Optional
“Manual”;”Automatic”
This is the kind of fuel used by the vehicle
“Petrol”; “Diesel”; “Electric”; “Hybrid”
Fuel Type
Varchar(8)
Optional
Refer to Section 6 for the format that should be used Refer to Section 6 for the format that should be used
Integer [Cubic Centimeters]
Engine Size
Engine Size
Optional
Height
Height of the vehicle Number(8,3) [Meters]
Optional
25
Go Home
Made with FlippingBook Annual report