• All Files

 

IRA Individual Beneficiaries Fields

Refer to the following table when completing the fields on the IRA Individual Beneficiaries worksheet 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.
Beneficiary type	Y	Primary or Contingent
Relationship	Y	One of: Brother Daughter Estate Father Husband Mother Sister Son Wife Other
Percentage of ownership	Y	Must total 100%.
Salutation	Y	One of: Mr. Mrs. Ms. Dr.
First name	Y
Last name	Y
Middle name	N	Include middle initial only.
Suffix	N
City	Y	P.O. boxes or "in care of" addresses not allowed.
Home street address	Y
State/Province	Y	ISO 3166-1 for 2-letter state codes (http://www.iso.org) Mandatory for U.S. residents only.
Country	Y	ISO 3166-1 for 3-letter country codes (http://www.iso.org).
Zip	Y
Date of birth	Y	MM/DD/YYYY format.
Gender	Y	Male or Female.
Country of citizenship	Y	ISO 3166-1 for 3-letter country codes (http://www.iso.org).
Document type	Y	One of: SSN (for US) 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