Refer to the following table when completing the fields on the Employment Information and Second Holder Employment Information (for Joint accounts) worksheets in your Mass Upload Excel workbook.
If this section is not completed, clients will be prompted to enter their employment information when logging in for the first time. This section cannot be partially filled in for a client. Client employment information must be entered completely or left completely blank
| 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. |
| Employment type | Y | One of:
|
| Occupation | Y | One of the occupations listed here. |
| Name of employer | Y (if employed or self-employed) | |
| Nature of employer business/activities | Y (if employed or self-employed) | |
| Employer address | Y (if employed or self-employed) | P.O. boxes or “in care of” addresses not allowed. |
| City | Y (if employed or self-employed) | |
| State/Province | Y (if employed or self-employed) | ISO 3166-1 for 2-letter state codes (http://www.iso.org) |
| Country | Y (if employed or self-employed) | ISO 3166-1 for 3-letter country codes (http://www.iso.org) |
| Zip | Y (if employed or self-employed) | One of consulting, disability, inheritance, interest, real estate, rental, severance, spouse, trading & investments, unemployment, retirement / social security and other. |
| Additional Sources of Income | Y (if employed or self-employed) | |
| Description | Y (if employed or self-employed and additional source of income is 'other') | |
| Percentage | Y (if employed or self-employed) | 100 |