nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Official List of Gift Type Name Mappings Between RE and NXT Web View

Yessenia Bernabet Claros

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,

Find more posts tagged with

Comments

JoAnn Strommen

@Yessenia Bernabet Claros You'll find some info here on names of fields db/web view

Crystal Bruce

@Yessenia Bernabet Claros discussion moved to Raiser's Edge NXT. Thanks!

Alex Wong

@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

Tom Klimchak

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.

Josie Rodriguez

Thank you, Alex. This chart is incredibly helpful!

Ronnie Lee

@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…

Alex Wong

I created them myself.

Brenda Goo

Hi @Alex Wong - I appreciate the mapping. It's really helpful!! Hope it's still the same.