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 | |||
Optional | Optional | Optional | VARCHAR2 (255) | |
Optional | Optional | Optional | VARCHAR2 (255) | |
Optional | Optional | Optional | VARCHAR2 (255) | |
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) |