Cash vs Donation
The gift api outputs gift type = Cash as Donation. Is this proper behavior? Can we assume all Cash will be translated as Donation?
{ "id": "291632", "acknowledgements": [{ "status": "NEEDSACKNOWLEDGEMENT" }], "amount": { "value": 10.0000 }, "constituent_id": "72335", "date": "2020-07-23T00:00:00", "date_added": "2020-07-24T08:16:17.463+01:00", "date_modified": "2020-07-24T08:16:17.557+00:00", "fundraisers": [], "gift_aid_amount": { "value": 0.0 }, "gift_aid_qualification_status": "Qualified", "gift_splits": [{ "id": "301876", "amount": { "value": 10.0000 }, "appeal_id": "53", "campaign_id": "35", "fund_id": "122", "gift_aid_amount": { "value": 0.0 }, "gift_aid_qualification_status": "Qualified" }], "gift_status": "Active", "is_anonymous": false, "linked_gifts": [], "constituency": "Alumnus", "lookup_id": "282421", "payments": [{ "payment_method": "PersonalCheck" }], "post_date": "2020-07-24T00:00:00", "post_status": "NotPosted", "receipts": [{ "amount": { "value": 10.000000 }, "status": "NEEDSRECEIPT" }], "soft_credits": [],
"type": "Donation" }
Comments
-
@Victor Heijke
This is the behavior that Blackbaud has coded.RE Database view's gift type is not the same as RE Webview's gift type and is not the same as API gift type.
Database view: Cash
Webview: One-time Gift
SKY API: Donation0 -
@Victor Heijke
There is also no distinction between different Pay-### that database view has. on the SKY API, it is all PledgePayment.Unfortunately that's what we are dealing with where Blackbaud did not keep same terminology (even webview and SKY API not same is odd to me)
0 -
Hi @Alex Wong, thanks for the helpful descriptions. Would you mind putting up a mapping table between Database View and Sky API? I'm trying to pull the equivalent gifts from a report that filters on: {"Cash", “Pay-Cash”, “MG Pay-Cash”, “Recurring Gift Pay-Cash”, “Pledge”}. Thank you!
0 -
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 0 -
@Victor Heijke @Alex Wong - You guys are the best! Thanks so much for the great information! Not sure how/where we could have found this on our own??
0
Categories
- All Categories
- 6 Blackbaud Community Help
- 209 bbcon®
- 1.4K Blackbaud Altru®
- 394 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 359 Blackbaud eTapestry®
- 2.5K Blackbaud Financial Edge NXT®
- 646 Blackbaud Grantmaking™
- 563 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 934 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.4K Blackbaud Raiser's Edge NXT®
- 3.7K SKY Developer
- 243 ResearchPoint™
- 118 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 238 The Tap (Just for Fun)
- 33 Blackbaud Community Challenges
- 28 PowerUp Challenges
- 3 (Open) 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
- 779 Community News
- 2.9K Jobs Board
- 53 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)

