Official List of Gift Type Name Mappings Between RE and NXT Web View
Hi All!,
Is there an official list or guide that outlines the mapping between the gift type names in RE and their equivalents in NXT?
Thank you,
Comments
-
@Yessenia Bernabet Claros You'll find some info here on names of fields db/web view
1 -
@Yessenia Bernabet Claros discussion moved to Raiser's Edge NXT. Thanks!
0 -
@Yessenia Bernabet Claros
Here's a table that I put together a year or so ago. I think they are still the same.DB Schema Type # DB Gift Type Webview Gift Type API Gift Type 1 Cash One-time gift Donation 2 Pay-Cash Pledge payment PledgePayment 3 MG Pay-Cash Matching gift payment MatchingGiftPayment 9 Stock/Property Stock/property Stock 10 Stock/Property (Sold) Stock/property (sold) SoldStock 11 Pay-Stock/Property Pledge payment PledgePayment 12 MG Pay-Stock/Property Matching gift payment MatchingGiftPayment 13 Pay-Stock/Property (Sold) Pledge payment PledgePayment 14 MG Pay-Stock/Property (Sold) Matching gift payment MatchingGiftPayment 18 Other Other Other 19 Pay-Other Pledge payment PledgePayment 20 MG Pay-Other Matching gift payment MatchingGiftPayment 31 Recurring Gift Pay-Cash Recurring gift payment RecurringGiftPayment 34 Planned Gift Planned gift PlannedGift 8 Pledge Pledge Pledge 15 Gift-in-Kind Gift-in-kind GiftInKind 16 Pay-Gift-in-Kind Pledge payment PledgePayment 17 MG Pay-Gift-in-Kind Matching gift payment MatchingGiftPayment 21 Write Off Pledge write off PledgeWriteOff 22 MG Write Off Matching gift write off MatchingGiftWriteOff 27 MG Pledge Matching gift pledge MatchingGiftPledge 30 Recurring Gift Recurring gift RecurringGift 7 -
Thank you for the chart!! That helped a lot! The fact that Pay-Stock/Property (Sold) has now been simplified to "Pledge Payment" makes Gift Lists (and presumably API reports) essentially useless for any sort of detailed report like those required for the 990. Going to have to be queries or nothing.
0 -
Thank you, Alex. This chart is incredibly helpful!
0 -
@Alex Wong would you be able to share how you found these or did you have to create them yourself?
I'm trying to move some old manual reports into Power BI but when I downloaded results using Power Automate I noticed these differences from our previous manual exports and I'm wondering how many other fields are affected.
I know for example Fund List in database gives us a list of Fund Codes, but in webview gives us the descriptions…
0 -
I created them myself.
0
Categories
- All Categories
- 6 Blackbaud Community Help
- 213 bbcon®
- 1.4K Blackbaud Altru®
- 402 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 360 Blackbaud eTapestry®
- 2.6K Blackbaud Financial Edge NXT®
- 655 Blackbaud Grantmaking™
- 576 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 939 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.6K Blackbaud Raiser's Edge NXT®
- 3.7K SKY Developer
- 248 ResearchPoint™
- 119 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 241 Member Lounge (Just for Fun)
- 34 Blackbaud Community Challenges
- 34 PowerUp Challenges
- 3 (Open) PowerUp Challenge: Chat for Blackbaud AI
- 3 (Closed) PowerUp Challenge: Data Health
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 792 Community News
- 2.9K Jobs Board
- 54 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)