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
Made with FlippingBook Annual report