RAC Cover File & Data Processes
Column name Description Data type Mandatory/Optional
List of authorized values
First line of beneficiary address Second line of beneficiary address Third line of beneficiary address Fourth line of beneficiary address Fifth line of beneficiary address
Mandatory if cover is beneficiary-based or hybrid Mandatory if cover is beneficiary-based or hybrid
Address Line 1
Varchar(100)
[NA]
Address Line 2
Varchar(100)
[NA]
Address Line 3
Varchar(100)
Optional
[NA]
Address Line 4
Varchar(100)
Optional
[NA]
Address Line 5
Varchar(100)
Optional
[NA]
Mandatory if cover is beneficiary-based or hybrid Mandatory if cover is beneficiary-based or hybrid
Refer to Section 6 for the format that should be used Refer to Section 6 for the format that should be used Refer to Section 6 for the format that should be used Refer to Section 6 for the format that should be used “Personal”; “Business”
Postcode
Postcode
Varchar(8)
Country
Country
Varchar(50)
Address Type Personal or Business
Char(8)
Optional
Home Phone Number
Home Phone Number
Varchar(20)
Optional
Mobile Phone Number
Mobile Phone Number
Varchar(100)
Optional
Email Address Email Address Varchar(200)
Optional
[NA]
Client Reference 1 Client Reference 2 Client Reference 3 Client Reference 4
Additional information Varchar(200) Additional information Varchar(200) Additional information Varchar(200) Additional information Varchar(200)
Optional
[NA]
Optional
[NA]
Optional
[NA]
Optional
[NA]
Client Reference 5
Additional information Varchar(200)
Optional
[NA]
27
Go Home
Made with FlippingBook Annual report