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