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 screen 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)
Customer Category	Optional	Optional	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	Optional	Optional	Mandatory	VARCHAR2 (255)
Citizenship by	Optional	Optional	Optional	VARCHAR2 (255)
Resident Status	Optional	Mandatory	Optional	VARCHAR2 (36)
Country of Residence	Optional	Optional	Optional	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)

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	Optional	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)

Table A-3 Contact Details

Field	Product Configuration	Regional Configuration		Data Type & Length
		US	Rest of the World
ISD Code	Optional	Optional	Optional	VARCHAR2 (12)
Mobile Number	Mandatory	Mandatory	Mandatory	VARCHAR2 (255)
Preferred	Mandatory	Mandatory	Mandatory	VARCHAR2 (1)
ISD Code	Mandatory	Mandatory	Mandatory	VARCHAR2 (12)
Area Code	Mandatory	Mandatory	Mandatory	VARCHAR2 (12)
Phone 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)
ISD Code	Mandatory	Mandatory	Mandatory	VARCHAR2 (12)
Area Code	Mandatory	Mandatory	Mandatory	VARCHAR2 (12)
Fax Number	Mandatory	Mandatory	Mandatory	VARCHAR2 (255)
Preferred	Mandatory	Mandatory	Mandatory	VARCHAR2 (1)
Business Identifier Code	Mandatory	Mandatory	Mandatory	VARCHAR2 (35)
Address Line 1	Optional	Optional	Optional	VARCHAR2 (35)
Address Line 2	Optional	Optional	Optional	VARCHAR2 (35)
Address Line 3	Optional	Optional	Optional	VARCHAR2 (35)
Address Line 4	Optional	Optional	Optional	VARCHAR2 (35)
Preferred	Mandatory	Mandatory	Mandatory	VARCHAR2 (1)

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)

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)

Table A-6 Tax Declaration

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

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)

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)

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)

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)

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)

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)

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)

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)

Table A-15 Guardian

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)

Table A-16 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	Mandatory	Mandatory	Mandatory	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)

Table A-17 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	Mandatory	Mandatory	Mandatory	DATE (7)

Table A-18 E-Sign

Field	Product Configuration	Regional Configuration		Data Type & Length
		US	Rest of the World
E-Sign Consent	Optional	Optional	Optional	VARCHAR2 (1)

Table A-19 Marketing Communication

Field	Product Configuration	Regional Configuration		Data Type & Length
		US	Rest of the World
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)

Table A-20 Privacy Information

Field	Product Configuration	Regional Configuration		Data Type & Length
		US	Rest of the World
Privacy Information	Optional	Optional	Optional	VARCHAR2 (255)

Table A-21 Minor Consent

Field	Product Configuration	Regional Configuration		Data Type & Length
		US	Rest of the World
Minor Consent	Optional	Optional	Optional	DATE (7)

Table A-22 Insider

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)

Table A-23 Special Needs

Field	Product Configuration	Regional Configuration		Data Type & Length
		US	Rest of the World
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)

Table A-24 Politically Exposed Person (PEP)

Field	Product Configuration	Regional Configuration		Data Type & Length
		US	Rest of the World
Politically Exposed Person (PEP)	Optional	Optional	Optional	VARCHAR2 (1)
Remarks	Optional	Optional	Optional	VARCHAR2 (250)

Table A-25 Armed Forces

Field	Product Configuration	Regional Configuration		Data Type & Length
		US	Rest of the World
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)

Table A-26 Armed Forces

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)

Table A-27 Total Income & Net-worth

Field	Product Configuration	Regional Configuration		Data Type & Length
		US	Rest of the World
Total Income Currency	Mandatory	Mandatory	Mandatory	VARCHAR2 (3)
Total Income Value	Mandatory	Mandatory	Mandatory	VARCHAR2 (255)
Total Networth Currency	Mandatory	Mandatory	Mandatory	VARCHAR2 (3)
Total Networth Value	Mandatory	Mandatory	Mandatory	NUMBER (22)

Table A-28 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)

Table A-29 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)

Table A-30 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)

Table A-31 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)