A Regional Configuration

The regional configuration for the several fields are explained below.

Basic Info and Citizenship

The regional configuration for Basic Info and Citizenship data segment is appended as below.

Table A-1 Basic Info and Citizenship

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Title Mandatory Mandatory Mandatory VARCHAR2 (36)
First Name Mandatory Mandatory Mandatory VARCHAR2 (255)
Middle Name Optional Optional Optional VARCHAR2 (255)
Last Name Mandatory Mandatory Mandatory VARCHAR2 (255)
Short Name Optional Optional Optional VARCHAR2 (36)
Maiden Name Optional Optional Optional VARCHAR2 (255)
Name In Local Language Optional Optional Optional VARCHAR2 (255)
Date of Birth Mandatory Mandatory Mandatory DATE (7)
Occupation Optional Optional Optional VARCHAR2 (255)
Staff Optional Optional Optional VARCHAR2 (1)
Gender Optional Optional Mandatory VARCHAR2 (255)
Marital Status Optional Optional Mandatory VARCHAR2 (255)
National ID Optional Optional Optional VARCHAR2 (255)
Customer Category Mandatory Mandatory Mandatory VARCHAR2 (255)
Customer Segment Optional Optional Mandatory VARCHAR2 (255)
Customer Access Group Optional Optional Optional VARCHAR2 (10)
Profession Optional Optional Optional VARCHAR2 (50)
Relationship Manager ID Optional Optional Optional VARCHAR2 (255)
Photo Optional Optional Optional BLOB (4000)
Birth Country Optional Optional Mandatory VARCHAR2 (255)
Nationality Mandatory Mandatory Mandatory VARCHAR2 (255)
Citizenship by Optional Optional Optional VARCHAR2 (255)
Resident Status Optional Mandatory Optional VARCHAR2 (36)
Country of Residence Mandatory Mandatory Mandatory VARCHAR2 (255)
Preferred Language Optional Optional Mandatory VARCHAR2 (255)
Preferred Currency Optional Optional Mandatory VARCHAR2 (255)
Risk Level Optional Optional Mandatory VARCHAR2 (255)
Purpose Optional Optional Mandatory VARCHAR2 (255)

ID Details

The regional configuration for ID Details data segment is appended as below.

Table A-2 ID Details

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
ID Type Mandatory Mandatory Mandatory VARCHAR2 (250)
ID Status Optional Mandatory Mandatory VARCHAR2 (250)
Unique ID Mandatory Mandatory Mandatory VARCHAR2 (250)
Place of Issue Optional Optional Optional VARCHAR2 (250)
Valid From Optional Optional Optional DATE (7)
Valid Till Optional Optional Optional DATE (7)
Remarks Optional Optional Optional VARCHAR2 (250)
Preferred Optional Optional Optional VARCHAR2 (1)

Contact Details

The regional configuration for Contact Details data segment is appended as below.

Table A-3 Contact Details

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
ISD Code Mandatory Mandatory Mandatory VARCHAR2 (12)
Mobile Number Mandatory Mandatory Mandatory VARCHAR2 (255)
Preferred Mandatory Mandatory Mandatory VARCHAR2 (1)
Email Id Mandatory Mandatory Mandatory VARCHAR2 (255)
Preferred Mandatory Mandatory Mandatory VARCHAR2 (1)

Current Address

The regional configuration for Current Address data segment is appended as below.

Table A-4 Current Address

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Address Type Mandatory Mandatory Mandatory VARCHAR2 (255)
Location Optional Optional Mandatory VARCHAR2 (255)
Preferred Mandatory Mandatory Mandatory VARCHAR2 (1)
Address Since Mandatory Mandatory Mandatory DATE (7)
Address Line 1 / Building Name Mandatory Mandatory Mandatory VARCHAR2 (255)
Address Line 2 / Street Name Optional Optional Mandatory VARCHAR2 (255)
Address Line 3 / City / Town Name Mandatory Mandatory Mandatory VARCHAR2 (255)
State / Country Sub Division Mandatory Mandatory Mandatory VARCHAR2 (255)
Country Mandatory Mandatory Mandatory VARCHAR2 (255)
Zip Code / Post Code Mandatory Mandatory Mandatory VARCHAR2 (255)
Department Optional Optional Optional VARCHAR2 (70)
Sub Department Optional Optional Optional VARCHAR2 (70)
Building Number Optional Optional Optional VARCHAR2 (16)
Floor Optional Optional Optional VARCHAR2 (70)
Post Box Optional Optional Optional VARCHAR2 (70)
Room Optional Optional Optional VARCHAR2 (70)
Town Location Name / Locality Optional Optional Optional VARCHAR2 (255)
District Name Optional Optional Optional VARCHAR2 (35)
Landmark Optional Optional Optional VARCHAR2 (105)
Contact Name / Narrative Optional Optional Optional VARCHAR2 (255)

Previous Address

The regional configuration for Previous Address data segment is appended as below.

Table A-5 Previous Address

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Address Type Mandatory Mandatory Mandatory VARCHAR2 (255)
Location Optional Optional Mandatory VARCHAR2 (255)
Preferred Mandatory Mandatory Mandatory VARCHAR2 (1)
Address From Mandatory Mandatory Mandatory DATE (7)
Address To Mandatory Mandatory Mandatory DATE (7)
Address Line 1 / Building Name Mandatory Mandatory Mandatory VARCHAR2 (255)
Address Line 2 / Street Name Optional Optional Mandatory VARCHAR2 (255)
Address Line 3 / City / Town Name Mandatory Mandatory Mandatory VARCHAR2 (255)
State / Country Sub Division Mandatory Mandatory Mandatory VARCHAR2 (255)
Country Mandatory Mandatory Mandatory VARCHAR2 (255)
Zip Code / Post Code Mandatory Mandatory Mandatory VARCHAR2 (255)
Department Optional Optional Optional VARCHAR2 (70)
Sub Department Optional Optional Optional VARCHAR2 (70)
Building Number Optional Optional Optional VARCHAR2 (16)
Floor Optional Optional Optional VARCHAR2 (70)
Post Box Optional Optional Optional VARCHAR2 (70)
Room Optional Optional Optional VARCHAR2 (70)
Town Location Name / Locality Optional Optional Optional VARCHAR2 (255)
District Name Optional Optional Optional VARCHAR2 (35)
Landmark Optional Optional Optional VARCHAR2 (105)
Contact Name / Narrative Optional Optional Optional VARCHAR2 (255)

Tax Declaration

The regional configuration for Tax Declaration data segment is appended as below.

Table A-6 Tax Declaration

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Form Type Mandatory Mandatory Mandatory VARCHAR2 (250)
Valid From Optional Mandatory Optional DATE (7)
Valid Till Optional Conditional Optional DATE (7)
Remarks Optional Optional Optional VARCHAR2 (250)

Visa Details

The regional configuration for Visa Details data segment is appended as below.

Table A-7 Visa Details

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Country Of Visa Mandatory Mandatory Mandatory VARCHAR2 (250)
Class/Type Of Visa Mandatory Mandatory Mandatory VARCHAR2 (250)
Visa Number Mandatory Mandatory Mandatory VARCHAR2 (250)
Port Of Issue Optional Optional Optional VARCHAR2 (250)
Visa Issue Date Optional Optional Optional DATE (7)
Visa Expiry Date Optional Optional Optional DATE (7)
Remarks Optional Optional Optional VARCHAR2 (250)

Dates

The regional configuration for Dates data segment is appended as below.

Table A-8 Dates

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Date Type Mandatory Mandatory Mandatory VARCHAR2 (3)
Date Optional Optional Optional DATE (7)

Social Profile

The regional configuration for Social Profile data segment is appended as below.

Table A-9 Social Profile

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Facebook Optional Optional Optional VARCHAR2 (255)
Twitter Optional Optional Optional VARCHAR2 (255)
Instagram Optional Optional Optional VARCHAR2 (255)
Linkedin Optional Optional Optional VARCHAR2 (255)
Blog Optional Optional Optional VARCHAR2 (255)
Tumblr Optional Optional Optional VARCHAR2 (255)

Educational Qualification

The regional configuration for Educational Qualification data segment is appended as below.

Table A-10 Educational Qualification

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Education Type Mandatory Mandatory Mandatory VARCHAR2 (3)
Course Mandatory Mandatory Mandatory VARCHAR2 (55)
Specialization Optional Optional Optional VARCHAR2 (55)
University/Institute Optional Optional Optional VARCHAR2 (105)
Date of Completion Mandatory Mandatory Mandatory DATE (7)
Is Highest Degree Mandatory Mandatory Mandatory VARCHAR2 (1)

Household Relationship

The regional configuration for Household Relationship data segment is appended as below.

Table A-11 Household Relationship

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Relationship Mandatory Mandatory Mandatory VARCHAR (3)
Is Dependent Mandatory Mandatory Mandatory VARCHAR (2)

Power or Attorney Relationship

The regional configuration for Power or Attorney Relationship data segment is appended as below.

Table A-12 Power or Attorney Relationship

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Associated Since Mandatory Mandatory Mandatory DATE (7)
Preferred Mandatory Mandatory Mandatory VARCHAR (2)

Service Member Relationship

The regional configuration for Service Member Relationship data segment is appended as below.

Table A-13 Service Member Relationship

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Relationship Mandatory Mandatory Mandatory VARCHAR (3)
MLA Covered Mandatory Mandatory Mandatory VARCHAR (2)

Related to Insider Relationship

The regional configuration for Related to Insider Relationship data segment is appended as below.

Table A-14 Related to Insider Relationship

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Relationship Mandatory Mandatory Mandatory VARCHAR (3)

Guardian Relationship

The regional configuration for Guardian Relationship data segment is appended as below.

Table A-15 Guardian Relationship

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Relationship Mandatory Mandatory Mandatory VARCHAR (3)
Preferred Mandatory Mandatory Mandatory VARCHAR (1)

Custodian Relationship

The regional configuration for Custodian Relationship data segment is appended as below.

Table A-16 Custodian Relationship

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Relationship Mandatory Mandatory Mandatory VARCHAR (3)
Preferred Mandatory Mandatory Mandatory VARCHAR (1)

Solicitor Relationship

The regional configuration for Solicitor Relationship data segment is appended as below.

Table A-17 Solicitor Relationship

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Registration Number Mandatory Mandatory Mandatory VARCHAR (3)
Preferred Mandatory Mandatory Mandatory VARCHAR (1)
Remarks Optional Optional Optional VARCHAR (255)

Salaried

The regional configuration for Salaried data segment is appended as below.

Table A-18 Salaried

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Employer Code Mandatory Mandatory Mandatory VARCHAR2 (105)
Employer Name Optional Optional Optional VARCHAR2 (105)
Employer Description Optional Optional Optional VARCHAR2 (256)
Organization Category Mandatory Mandatory Mandatory VARCHAR2 (3)
Demographics Mandatory Mandatory Mandatory VARCHAR2 (105)
Employee type Optional Optional Optional VARCHAR2 (3)
Employee ID Optional Optional Optional VARCHAR2 (21)
Employment Start Date Mandatory Mandatory Mandatory DATE (7)
Employment End Date Optional Optional Optional DATE (7)
Grade Optional Optional Optional VARCHAR2 (105)
Designation Optional Optional Optional VARCHAR2 (105)
I currently work in this role Mandatory Mandatory Mandatory VARCHAR2 (1)
Industry type Optional Optional Optional VARCHAR2 (4)

Consent & Preferences

The regional configuration for Consent & Preferences data segment is appended as below.

Table A-19 Consent & Preferences

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
E-Sign Consent Optional Optional Optional VARCHAR2 (1)
Consent to receive Marketing,Promotional, Sales and other Mandatory Mandatory Mandatory VARCHAR2 (1)
Channel Mandatory Mandatory Mandatory VARCHAR2 (255)
Contact Mandatory Mandatory Mandatory VARCHAR2 (255)
Preferred Time Mandatory Mandatory Mandatory VARCHAR2 (255)
Privacy Information Optional Optional Optional VARCHAR2 (255)
Minor Consent Optional Optional Optional DATE (7)

Additional Info

The regional configuration for Additional Info data segment is appended as below.

Table A-20 Additional Info

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Insider Optional Optional Optional VARCHAR2 (1)
Role Optional Optional Optional VARCHAR2 (250)
Remarks Optional Optional Optional VARCHAR2 (250)
Special Need/ Disable Optional Optional Optional VARCHAR2 (1)
Details of Special Need Mandatory Mandatory Mandatory VARCHAR2 (250)
Remarks (Special Need) Optional Optional Optional VARCHAR2 (250)
Politically Exposed Person (PEP) Optional Optional Optional VARCHAR2 (1)
Remarks Optional Optional Optional VARCHAR2 (250)
Armed Forces Optional Optional Optional VARCHAR2 (1)
Service Branch Optional Optional Optional VARCHAR2 (250)
Remarks Optional Optional Optional VARCHAR2 (250)
Employee Id Mandatory Mandatory Mandatory VARCHAR2 (21)
MLA Covered Optional Optional Optional VARCHAR2 (1)
Unit Name Optional Optional Optional VARCHAR2 (250)
Order Number Mandatory Mandatory Mandatory VARCHAR2 (250)
Start Date Mandatory Mandatory Mandatory DATE (7)
End Date Mandatory Mandatory Mandatory DATE (7)
Notification Date Mandatory Mandatory Mandatory DATE (7)

Self Employed

The regional configuration for Self Employed data segment is appended as below.

Table A-21 Self Employed

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Profession Name Mandatory Mandatory Mandatory VARCHAR2 (255)
Profession Description Optional Optional Optional VARCHAR2 (255)
Company / Firm Name Optional Optional Optional VARCHAR2 (255)
Registration Number Optional Optional Optional VARCHAR2 (255)
Professional Email ID Optional Optional Optional VARCHAR2 (255)
From Date Mandatory Mandatory Mandatory DATE (7)
To Date Optional Optional Optional DATE (7)

Membership and Associations

The regional configuration for Membership and Associations data segment is appended as below.

Table A-22 Membership and Associations

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Institution Name Mandatory Mandatory Mandatory VARCHAR2 (255)
Institution Type Mandatory Mandatory Mandatory VARCHAR2 (30)
Membership Type Mandatory Mandatory Mandatory VARCHAR2 (30)
Membership Since Mandatory Mandatory Mandatory DATE (7)
Membership Upto Mandatory Mandatory Mandatory DATE (7)

Assets & Liabilities

The regional configuration for Assets & Liabilities data segment is appended as below.

Table A-23 Assets & Liabilities

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Asset Type Mandatory Mandatory Mandatory VARCHAR2 (255)
Currency Mandatory Mandatory Mandatory VARCHAR2 (255)
Amount Mandatory Mandatory Mandatory NUMBER (22)
Liability Type Mandatory Mandatory Mandatory VARCHAR2 (255)
Currency Mandatory Mandatory Mandatory VARCHAR2 (255)
Amount Mandatory Mandatory Mandatory NUMBER (22)

Income & Expense

The regional configuration for Income & Expense data segment is appended as below.

Table A-24 Income & Expense

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Income Type Mandatory Mandatory Mandatory VARCHAR2 (3)
Frequency Mandatory Mandatory Mandatory VARCHAR2 (3)
Currency Mandatory Mandatory Mandatory VARCHAR2 (3)
Amount Mandatory Mandatory Mandatory NUMBER (22)
Expense Type Mandatory Mandatory Mandatory VARCHAR2 (3)
Frequency Mandatory Mandatory Mandatory VARCHAR2 (3)
Currency Mandatory Mandatory Mandatory VARCHAR2 (3)
Amount Mandatory Mandatory Mandatory NUMBER (22)

Other Relationship

The regional configuration for Other Relationship data segment is appended as below.

Table A-25 Other Relationship

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Institution Name Mandatory Mandatory Mandatory VARCHAR2 (255)
Relationship Type Optional Optional Optional VARCHAR2 (3)
Relationship worth Optional Optional Optional NUMBER (22)
Relationship worth Currency Mandatory Mandatory Mandatory VARCHAR2 (3)
Relationship Since Mandatory Mandatory Mandatory VARCHAR2 (3)
Relationship worth Currency Optional Optional Optional VARCHAR2 (3)

Beneficially Owned Company

The regional configuration for Beneficially Owned Company data segment is appended as below.

Table A-26 Beneficially Owned Company

Field Product Configuration Regional Configuration Data Type & Length
US Rest of the World
Company Name Mandatory Mandatory Mandatory VARCHAR2 (250)
Location Optional Optional Optional VARCHAR2 (250)
Percentage Holding Mandatory Mandatory Mandatory VARCHAR2 (250)
Annual Income Currency Optional Optional Optional VARCHAR2 (255)
Annual Income Amount Optional Optional Optional VARCHAR2 (250)
Line of Business Optional Optional Optional VARCHAR2 (250)