RAC Cover File & Data Processes for Beneficiaries

Column name

List of authorized values

Description

Data type Mandatory/ Optional

This is what uniquely identifies an beneficiary (vehicle or beneficiary) This identifier links beneficiaries that belong to the same group (in the case of multiple- beneficiary agreements) For example the insurance policy number or account reference number Gross retail price. The price at which the client

Unique Identifier

Varchar(50)

Mandatory

N/A

Mandatory for multi- beneficiary policies

Linked Identifier

Varchar(50)

N/A

sells the cover to the customer. Retail Sold Price = Commission + Price to RAC (which includes the IPT).

Refer to Section 7 for the format that should be used

Retail Sold Price

Number(6,2) [£]

Mandatory

Refer to Section 7 for the format that should be used

This is the client commission

Number(6,2) [£]

Commission

Optional

Net Sale Price. This is the amount that RAC gets from its partner. It includes the Insurance Premium Tax The IPT shall be equal to % of premium at current prevailing rate

Refer to Section 7 for the format that should be used

Net Sold Price

Number(6,2) [£]

Optional

Insurance Premium Tax

Refer to Section 7 for the format that should be used

Number(6,2) [£]

Optional

“Mr”; “Mrs”; “Miss”; “Ms”; “Sir”; “Lady”; “Lord”; “Rev”

Honorific of the beneficiary

Title

Varchar(4)

Mandatory

First name of the beneficiary

Forename

Varchar(50)

Mandatory

N/A

Last name of the beneficiary

Surname

Varchar(50)

Mandatory

N/A

26

Go Home