Field Mapping Between Luminate Online and Raiser's Edge NXT
When Raiser's Edge NXT and Luminate Online are integrated, unique IDs are used to link constituent and gift records between the two systems.
ID mapping
Constituent ID mapping
Each constituent record includes several identifiers that help maintain the connection between Raiser's Edge NXT and Luminate Online.
| Luminate Field | Raiser's Edge NXT Field |
|---|---|
|
Constituent ID |
Luminate ID (in Constituent summary, Aliases) |
|
Member ID |
System Record ID (in Constituent summary, View constituent properties) |
|
Exchange ID |
Import ID (in Constituent summary, View constituent properties) |
|
Tip: To search for a constituent using their Luminate ID, enter the ID in the search bar in Raiser's Edge NXT. |
|
Gift ID mapping
Importing in Luminate Online Post-Integration
Raiser’s Edge NXT integration requires member ID of records in Luminate Online to be unique. Once you're integrated, you should not import Member ID into Luminate Online at any time.
To get new contacts into Luminate Online, just import the contacts into Raiser’s Edge NXT. Raiser’s Edge NXT will automatically create the contact records in Luminate Online and link the two records.
Constituent field mapping
Both Luminate Online and Raiser's Edge NXT store constituent details like name, address, and contact information. Updates made in Luminate Online can transfer to Raiser's Edge NXT, keeping records aligned across systems.
Raiser's Edge NXT can create new constituent records for donors who exist only in Luminate Online.
| Luminate Online Field | Luminate Online Location | Raiser's Edge NXT Field | Raiser's Edge NXT Location | Comments |
|
Title |
Constituent profile, Biographical Information |
Title 1 |
Constituent record, Edit, Name |
|
|
Salutation (Casual) |
Constituent profile, Biographical Information |
Primary Salutation |
Constituent record, Constituent Summary tile |
|
|
Salutation (Formal) |
Constituent profile, Biographical Information |
Primary Addressee |
Constituent record, Constituent Summary tile |
|
|
First Name |
Constituent profile, Biographical Information |
First Name |
Constituent record, Edit, Name |
|
|
Middle Name |
Constituent profile, Biographical Information |
Middle Name |
Constituent record, Edit, Name |
|
|
Last Name |
Constituent profile, Biographical Information |
Last Name |
Constituent record, Edit, Name |
|
|
Nickname |
Constituent profile, Biographical Information |
Preferred name |
Constituent record, Edit, Preferred name |
|
|
Maiden Name |
Constituent profile, Biographical Information |
Former name |
Constituent record, Edit, Former name |
|
|
Suffix |
Constituent profile, Biographical Information |
Suffix |
Constituent record, Edit, Name |
|
|
Professional Suffix |
Constituent profile, Biographical Information |
(Field located to the right of Suffix) |
Constituent record, Edit, Name |
|
|
Date of Birth |
Constituent profile, Biographical Information |
Date of Birth |
Constituent record, Constituent summary tile, Edit, Personal info |
|
|
Gender |
Constituent profile, Biographical Information |
Gender |
Constituent record, Constituent summary tile, Edit, Personal info |
|
|
Marital Status |
Constituent profile, Biographical Information |
Marital status |
Constituent record, Constituent summary tile, Edit, Personal info |
|
|
Deceased |
Constituent profile, Biographical Information |
Deceased |
Constituent record, Constituent summary |
|
|
Ethnicity |
Constituent profile, Biographical Information |
Ethnicity |
Constituent record, Constituent summary |
|
|
Religion |
Constituent profile, Biographical Information |
Religion |
Constituent record, Constituent summary |
|
|
|
Constituent profile, Email |
|
Constituent record, Contact information |
|
|
Email Status |
Constituent profile, Email |
N/A |
N/A |
The Email Status field does not map to Raiser's Edge NXT. |
|
Email Opt-Out Date |
Constituent profile, Email |
|
Constituent record, Consent |
|
|
Accept Email |
Constituent profile, Email |
|
Constituent record, Consent |
|
|
Work Phone |
Constituent profile, Phone |
Work phone |
Constituent record, Contact information, Edit, Phone numbers |
|
|
Mobile Phone |
Constituent profile, Phone |
Mobile phone |
Constituent record, Contact information, Edit, Phone numbers |
|
|
Phone |
Constituent profile, Phone |
Phone |
Constituent record, Contact information, Edit, Phone numbers |
|
|
Fax |
Constituent profile, Phone |
N/A | N/A |
The Fax field does not map to Raiser's Edge NXT. |
|
Accept Mail |
Constituent profile, Address |
|
Constituent record, Consent |
|
|
Occupation |
Constituent profile, Employment |
N/A | N/A |
The Occupation field does not map to Raiser's Edge NXT. |
|
Position |
Constituent profile, Employment |
N/A | N/A |
The Position field does not map to Raiser's Edge NXT. |
|
Employer |
Constituent profile, Employment |
N/A | N/A |
The Employer field does not map to Raiser's Edge NXT. |
|
Employer AddressStreet 1 |
Constituent profile, Employment |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
Employer AddressStreet 2 |
Constituent profile, Employment |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
Employer Address Street 3 |
Constituent profile, Employment |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
Employer Address City |
Constituent profile, Employment |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
Employer AddressState/ Province |
Constituent profile, Employment |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
Employer AddressZIP/ Postal Code |
Constituent profile, Employment |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
Employer Address Country |
Constituent profile, Employment |
N/A | N/A | This field does not map to Raiser's Edge NXT. |
|
Member ID |
Constituent profile, Biographical Information |
ID |
Constituent record, Constituent summary |
|
|
Constituent ID |
Constituent profile, Biographical Information |
Constituent ID |
Constituent record, Constituent summary |
|
| User Name |
Constituent profile, Biographical Information |
Luminate Username |
Constituent record, Constituent Summary, under Aliases |
|
|
Exchange ID |
Constituent profile, Biographical Information |
Import ID |
Constituent record, Constituent summary, View constituent properties |
|
|
Street 1 |
Constituent profile, Address |
Address Lines |
Constituent record, Contact information |
|
|
Street 2 |
Constituent profile, Address |
Address Lines |
Constituent record, Contact information |
|
|
Street 3 |
Constituent profile, Address |
Address Lines |
Constituent record, Contact information |
|
|
City |
Constituent profile, Address |
City |
Constituent record, Contact information |
|
|
State/ Province |
Constituent profile, Address |
State |
Constituent record, Contact information |
|
|
ZIP/Postal Code |
Constituent profile, Address |
ZIP |
Constituent record, Contact information |
|
|
Country |
Constituent profile, Address |
Country |
Constituent record, Contact information |
|
|
County |
Constituent profile, Address |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
County ID (Manual Override) |
Constituent profile, Advocacy Information |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
County District(Manual Override) |
Constituent profile, Advocacy Information |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
Municipality (Manual Override) |
Constituent profile, Advocacy Information |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
Congressional District(Manual Override |
Constituent profile, Advocacy Information |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
State Senate District (Manual Override) |
Constituent profile, Advocacy Information |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
State House District (Manual Override) |
Constituent profile, Advocacy Information |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
County District (Automatic) |
Constituent profile, Advocacy Information |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
Municipality (Automatic) |
Constituent profile, Advocacy Information |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
Municipality ID (Automatic) |
Constituent profile, Advocacy Information |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
Municipal District (Automatic) |
Constituent profile, Advocacy Information |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
State House District (Automatic) |
Constituent profile, Advocacy Information |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
State Senate District (Automatic) |
Constituent profile, Advocacy Information |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
Congressional District (Automatic) |
Constituent profile, Advocacy Information |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
Significant other First Name |
Constituent profile, Significant Other |
First name |
Constituent record, Relationship |
|
|
Significant Other Middle Name |
Constituent profile, Significant Other |
Middle name |
Constituent record, Relationship |
|
|
Significant Other Last Name |
Constituent profile, Significant Other |
Last name |
Constituent record, Relationship |
|
|
Significant Other Title |
Constituent profile, Significant Other |
Title 1 |
Constituent record, Relationship |
|
|
Significant Other Suffix |
Constituent profile, Significant Other |
Suffix 1 |
Constituent record, Relationship |
|
|
Significant Other Gender |
Constituent profile, Significant Other |
Gender |
Constituent record, Relationship |
|
|
External First Gift Amount |
Constituent profile, Transaction Information |
N/A | N/A | This field does not map to Raiser's Edge NXT. |
|
External First Gift Date |
Constituent profile, Transaction Information |
N/A | N/A | This field does not map to Raiser's Edge NXT. |
|
External Last Gift Date |
Constituent profile, Transaction Information |
N/A | N/A | This field does not map to Raiser's Edge NXT. |
|
External Last Gift Amount |
Constituent profile, Transaction Information |
N/A | N/A | This field does not map to Raiser's Edge NXT. |
|
External Largest Gift Date |
Constituent profile, Transaction Information |
N/A | N/A | This field does not map to Raiser's Edge NXT. |
|
External Largest Gift Amount |
Constituent profile, Transaction Information |
N/A | N/A | This field does not map to Raiser's Edge NXT. |
|
External YTD Gift Count |
Constituent profile, Transaction Information |
N/A | N/A | This field does not map to Raiser's Edge NXT. |
|
External YTD Gift Amount |
Constituent profile, Transaction Information |
N/A | N/A | This field does not map to Raiser's Edge NXT. |
|
External Lifetime Gift Count |
Constituent profile, Transaction Information |
N/A | N/A | This field does not map to Raiser's Edge NXT. |
|
External Lifetime Gift Amount |
Constituent profile, Transaction Information |
N/A | N/A | This field does not map to Raiser's Edge NXT. |
|
Sustained givingStatus |
Constituent profile, Sustained Giving Information |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
Sustained givingStatus |
Constituent profile, Sustained Giving Information |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
|
Sustained givingStart Date |
Constituent profile, Sustained Giving Information |
N/A | N/A | This field does not map to Raiser's Edge NXT. |
|
Sustained givingActual End Date |
Constituent profile, Sustained Giving Information |
N/A | N/A | This field does not map to Raiser's Edge NXT. |
|
Sustained givingMonthly Amount |
Constituent profile, Sustained Giving Information |
N/A | N/A | This field does not map to Raiser's Edge NXT. |
|
Sustained givingPlanned End Date |
Constituent profile, Sustained Giving Information |
N/A | N/A | This field does not map to Raiser's Edge NXT. |
|
Sustained givingCard Expiration Date |
Constituent profile, Sustained Giving Information |
N/A | N/A | This field does not map to Raiser's Edge NXT. |
|
Sustained givingLast Payment Attempt Failure Code |
Constituent profile, Sustained Giving Information |
N/A | N/A | This field does not map to Raiser's Edge NXT. |
|
Membership Status |
Constituent profile, Membership Information |
N/A | N/A | This field does not map to Raiser's Edge NXT. |
|
Membership ID |
Constituent profile, Membership Information |
Membership ID | Constituent record, Membership | |
|
Expiration |
Constituent profile, Membership Information |
Expires on |
Constituent record, Membership |
|
|
Member Since Date |
Constituent profile, Membership Information |
Date joined |
Constituent record, Membership |
|
|
Donor Status |
Constituent profile, Biographical Information |
N/A | N/A |
This field does not map to Raiser's Edge NXT. |
Gift Field Mapping
Luminate Online and Raiser's Edge NXT both track donations and gifts, including amount, date, and receipts. When data is transferred, donation details from Luminate Online become gift records in Raiser's Edge NXT.
TeamRaiser donations and registrations show on the gift record, including form name and type.
Event registration records display participation type, team name, captain, and registration page URL in the Custom fields tile.
Tribute donations appear on the Tributes tile, with transferred tribute name, type, message, and address info for the honoree.
| Luminate Online Field | Luminate Online Location | Raiser's Edge NXT Field | Raiser's Edge NXT Location | Comments |
|
The Raiser's Edge Campaign |
Luminate Configuration, Cross References, Configure Cross References page |
Campaign |
Gift record, Gift |
|
|
The Raiser's Edge Fund |
Luminate Configuration, Cross References, Configure Cross References page |
Fund |
Gift record, Gift |
|
|
The Raiser's Edge Appeal field |
Luminate Configuration, Cross References, Configure Cross References page |
Appeal |
Gift record, Gift |
|
|
The Raiser's Edge Package |
Luminate Configuration, Cross References, Configure Cross References page |
Package |
Gift record, Gift |
|
|
The Raiser's Edge Gift Subtype |
Luminate Configuration, Cross References, Configure Cross References page |
Gift subtype |
Gift record, Gift |
|
|
Type |
Constituent profile, Transactions tab, Transaction History grid |
Gift type |
Gift record, Gift |
|
|
Donation Date |
Constituent profile, Transactions tab, Transaction History grid |
Gift date |
Gift record, Gift |
|
| N/A | N/A | Tribute | Gift record, Tribute tile | Tribute information comes from the donation form configured in Luminate Online. |
| N/A | N/A | Tribute Type | Gift record, Tribute tile | Tribute information comes from the donation form configured in Luminate Online. |
| N/A | N/A | Tribute Description | Gift record, Tribute tile | Tribute information comes from the donation form configured in Luminate Online. |
| N/A | N/A | Tribute Acknowledgee Name | Gift record, Tribute tile | Tribute information comes from the donation form configured in Luminate Online. |
| N/A | N/A | Tribute Acknowledgee Address lines | Gift record, Tribute tile | To view acknowledgee address information, access the individual relationship record for the acknowledgee that is created when the tribute is added to Raiser's Edge. |
| N/A | N/A | Tribute acknowledgeeCity | Gift record, Tribute tile | To view acknowledgee address information, access the individual relationship record for the acknowledgee that is created when the tribute is added to Raiser's Edge NXT. |
| N/A | N/A | Tribute AcknowledgeeState | Individual Relationship record for tribute acknowledgee | To view acknowledgee address information, access the individual relationship record for the acknowledgee that is created when the tribute is added to Raiser's Edge NXT. |
| N/A | N/A | Tribute AcknowledgeeZIP | Gift record, Tribute tile | To view acknowledgee address information, access the individual relationship record for the acknowledgee that is created when the tribute is added to Raiser's Edge NXT. |
| N/A | N/A | Tribute Acknowledgee Country | Gift record, Tribute tile | To view acknowledgee address information, access the individual relationship record for the acknowledgee that is created when the tribute is added to Raiser's Edge NXT. |
| N/A | N/A | Tribute AcknowledgeeEmail | Gift record, Tribute tile | To view acknowledgee email information, access the individual relationship record for the acknowledgee that is created when the tribute is added to Raiser's Edge NXT. |
Event field mapping
Luminate Online and Raiser's Edge NXT both track TeamRaiser and Calendar Events, including attendees, event names, and transaction amounts. When syncing data, event details from Luminate Online are transferred to Raiser's Edge NXT, which can also create new event records for new participants.
Calendar events
| Luminate Online Field | Luminate Online Location | Raiser's Edge NXT Field | Raiser's Edge NXT Location | Comments |
| Ticket Class | Event Attendee, Refund Transaction | Unit | Participant Record, Registration Fees Tab | Unit name |
| Tickets Current | Event Attendee, Refund Transaction | Num. Units | Participant Record, Registration Fees Tab | Total number of units purchased |
| Transaction Amount | Event Attendee, Refund Transaction | Gift Amount | Participant Record, Registration Fees Tab | Total gift amount |
| Amount Tax Deductible | Event Attendee, Refund Transaction | Receipt Amount | Participant Record, Registration Fees Tab | Any applicable receipt amount |
| Transaction Date | Event Attendee, Refund Transaction | Date | Participant Record, Registration Fees Tab | Registration date |
| Event Attendee, Refund Transaction | Comments | Participant Record, Registration Fees Tab | Luminate Registration Fee | |
| Survey Questions | Event Attendee, Edit Responses | Any Attributes | Participant Record, Attributes Tab |
Calendar event gifts
| Luminate Online Field | Luminate Online Location | Raiser's Edge NXT Field | Raiser's Edge NXT Location | Comments |
| Luminate Online Donation Type | Constituent, Gift, Attributes Tab | Ticket | ||
| Event > Name | Event Attendee, Refund Transaction | Luminate Online Event Name | Constituent, Gift, Attributes Tab | LO event name appended with event date |
| All Tickets, their quantity, totals and any additional gift associated with this transaction | Event Attendee, Refund Transaction, no single field | Luminate Online Ticket Description Luminate Gift ID | Constituent, Gift, Attributes Tab | All units with quantity, totals and additional gift example Gold Qty(2) @ $50.00 totalling $100.00 Additional gift of $25.99 |
| Constituent, Gift, Attributes Tab | Luminate gift ID |
TeamRaiser Fields
| Luminate Online Field | Luminate Online Location | Raiser's Edge NXT Field | Raiser's Edge NXT Location | Comments |
| Registration | Participant Record, General Registration field | Should display registered | ||
| Amount | Participant Registration Information, Luminate Online Gift History section |
Amount Paid | Participant Record, Registration Fees Tab | View Gifts enabled only if there is any registration fee |
| Registration | Participant Registration Information, Luminate Online Gift History section | Date Paid | Participant Record, Registration Fees Tab | |
| Gift Date | Participant Registration Information, Luminate Online Gift History section | Donation Gift Date | Participant Record, Donations Tab | If registration has additional gifts |
| NA | Donation Gift Type | Participant Record, Donations Tab | Always CASH | |
| Additional Gift | Participant Record, Edit Registration | Amount | Participant Record, Donations Gift record | |
| Name | Participant Record, Right below the registration Information | Constituent Name | Participant Record, Donations Constituent | |
| Participation Type | Participant Registration Information | TR Participation Type | Constituent record, Custom fields tile | |
| Team Name | Participant Registration Information | TR Team Name | Constituent record, Custom fields tile | |
| Captain | Participant Registration Information Team Name section | TR Team Captain | Constituent record, Custom fields tile | |
| TR Discount Code | Constituent record, Custom fields tile | |||
| TR Discount Amount | Constituent record, Custom fields tile | |||
| Participant Registration Information | TR Participant Page | Constituent record, Custom fields tile | ||
| Participant Company | Participant Registration Information | TR Company Name | Constituent record, Custom fields tile | |
| Upsell Name | Participant Record, Edit Registration | TR Upsell | Constituent record, Custom fields tile | |
| Luminate Online Registration ID | Constituent record, Custom fields tile | |||
| Additional Information | Participant Record, Edit Registration | Any Attributes | Constituent record, Custom fields tile |
TeamRaiser gifts
| Luminate Online Field | Luminate Online Location | Raiser's Edge NXT Field | Raiser's Edge NXT Location |
|---|---|---|---|
| Luminate Online Gift ID | Gift record, Custom fields | ||
| Luminate Online Donation Type | Gift record, Custom fields | ||
| Luminate Online Donation Form | Gift record, Custom fields |