| The Raiser’s Edge | Paciolan |
| Constituent | Patron |
| Patron ID type in Alias table | Patron ID |
| First Name | First Name1 |
| Last Name | Last Name1 |
| Suffix 1 | Suffix1 |
| Title 1 | Title1 |
| Gender | Gender |
| Is Inactive | Status |
| Spouse Title | Title2 |
| Spouse First Name | FirstName2 |
| Spouse Last Name | LastName2 |
| Spouse Suffix | Suffix2 |
| Nick Name | NickName1 |
| Birthdate | Birth Date (Format: yyyy-MM-dd) |
| Deceased: Y/N | Patron Status = D* |
| Religion (dictionary) | Religion Code(s) |
| Ethnicity (dictionary) | Ethnicity Code(s) |
| Marital Status (dictionary) | Marital Status code |
| (often ignored) | VIP Code(s) |
| (often ignored) | Announcement |
| Address (see below for details) | Address type + address |
| Phone types + numbers (dictionary, 5 max) | Phone Types + Phone numbers |
| Email types + address (dictionary, 5 max) | Email Types + Email Addresses |
Address Mapping:
Address lines mapping between the two systems may be customized through the IOM tool for each client. The following is a sample of the common address line mapping. For example, if client uses Address line 1 in Paciolan for “care of” this can be mapped to the correct care of line in the Raiser’s Edge.
| The Raiser’s Edge | Paciolan |
| Constituent | Patron |
| (often ignored) | Mail Name (as associated with the address) |
| Address Line 1 (of the address block) | Address Line 1 (tRes address line) |
| Address Line 2 (of the address block) | Address Line 2 (tRes address line) |
| Address Line 3 (of the address block) | Address Line 3 (tRes address line) |
| (often ignored) | Address Line 4 (tRes address line) |
| City | City |
| State | State |
| Zip | Zip Code |
| Country | Country |
