• All Files

 

Customer Information Worksheet Fields

Refer to the following table when completing the fields on the Customer Information and Second Holder Information (for Joint accounts) worksheets in your Mass Upload Excel workbook.

Field Name	Required	Documentation
Customer ID	Y	A unique id to map customer information from worksheet to worksheet. Use alphanumeric characters only or current account id at your firm.
Salutation	Y	One of: Mr. Mrs. Ms. Dr.
First name	Y
Last name	Y
Middle name	N	Include middle initial only.
Suffix	N
Home street address	Y	P.O. boxes or “in care of” addresses not accepted.
City	Y
State/Province	Y	2-letter code.
Country	Y	3-letter country code.
Zip	Y
Phone number (1)	Y	###-###-#### format.
Phone number (2)	N	###-###-#### format.
Fax	N	###-###-#### format.
Email address	Y	If including two or more, please add comma to separate.
Date of birth	Y	MM/DD/YYYY format.
Gender	Y	Male or Female
Marital status	Y	One of: Single Married Divorced Widowed
Dependents	Y	0 through 5. Select 5 for 5 or more dependents.
Country of citizenship	Y	ISO 3166-1 for 3-letter country codes (http://www.iso.org).
Document type	Y	One of: SSN (for US) Digits only- ###-##-####. Driver’s License Alien Identification Card Passport National Identity Card
Country of issuance	Y	ISO 3166-1 for 3-letter country codes (http://www.iso.org).
Number	Y