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 |