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,

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!