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