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:
|
| Percentage of ownership | Y | Must total 100%. |
| Salutation | Y | One of:
|
| First name | Y | |
| Last name | Y | |
| Middle name | N | Include middle initial only. |
| Suffix | N | |
| Home street address | Y | |
| City | Y | P.O. boxes or "in care of" addresses not allowed. |
| 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 | N | One of:
|
| Country of issuance | N | ISO 3166-1 for 3-letter country codes (http://www.iso.org) |
| Number | N |