RAC Cover File & Data Processes for Fleet Clients

List of authorized values

Column name

Description

Data type Mandatory/ Optional

This is the vehicle mileage at the date of acquisition (or renewal for the renewals)

Refer to Section 5 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 5 for the format that should be used Refer to Section 5 for the format that should be used Refer to Section 5 for the format that should be used Refer to Section 5 for the format that should be used Refer to Section 5 for the format that should be used Refer to Section 5 for the format that should be used

Integer [Cubic Centimetres]

Engine Size

Engine Size

Optional

Height

Height of the vehicle Number(2,3) [Meters]

Optional

Length

Length of the vehicle Number(2,3) [Meters]

Optional

Width

Width of the vehicle Number(2,3) [Meters]

Optional

Weight

Weight of the vehicle Number(5,0) [Kilograms]

Optional

Tyre Size

Tyre Size

Varchar(20)

Optional

Vehicle Colour

Vehicle colour

Varchar(50)

Optional

N/A

Mandatory if cover is beneficiary- based Mandatory if cover is beneficiary- based

"Mr"; "Mrs"; "Miss"; "Ms"; "Sir"; "Lady"; "Lord"; "Rev"

Honorific of the benefi- ciary

Title

Varchar(4)

Forename First name of the benefi- ciary

Varchar(50)

N/A

23

Go Home

Made with FlippingBook - Online magazine maker