RAC Cover File & Data Processes

Column name

List of authorized values

Description

Data type Mandatory/ Optional

Partner Name

Name of the partner (broker/office/agency/etc.) Varchar(100)

Optional

[NA]

Refer to Section 6 for the format that should be used

Cover Start Date

This is the first day of the coverage

Mandatory for delta files only

Date

Mandatory for delta files if variable agreement

This is the last day of the coverage - assets are still covered on that date [Unused field, for future usage only]. This is a list of optional extras chosen for this asset This is what uniquely identifies an asset (vehicle or beneficiary) This identifier links assets that belong to the same group (in the case of multiple-vehicle or multiple-beneficiary agreements) for example, a policy number Gross retail price. The price at which the broker

Refer to Section 6 for the format that should be used

Cover End Date

Date

Optional extras

Varchar(50) (200)

Not currently used

[NA]

Unique Identifier

Varchar(50)

Mandatory

[NA]

Mandatory for multi-assets policies

Linked Identifier

Varchar(50)

[NA]

Refer to Section 6 for the format that should be used

Retail Sold Price

sells the cover to the customer. Retail Sold Price = Commission + Price to RAC + IPT

Number(8,2) [£]

Mandatory

Refer to Section 6 for the format that should be used

Number(8,2) [£]

Commission This is the broker commission

Optional

Net Sale Price. This is the Gross Retail Sold Price MINUS IPT

Refer to Section 6 for the format that should be used

Net Sold Price

Number(8,2) [£]

Optional

24

Go Home