Tableau Connector for Blackbaud Raisers Edge NXT

Build 21.0.7930

GiftSplits

Returns the splits for a gift.

Table Specific Information

Select

The connector will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
Note: GiftId are required in order to query GiftSplits.

  • GiftId supports the '=' operator.
For example:
	SELECT * FROM GiftSplits WHERE GiftId = '476'

Columns

Name Type References Description
Id [KEY] String The immutable system record ID of the gift split.
GiftId String

Gifts.Id

The immutable system record ID of the gift associated with the gift split.
AmountValue Integer The amount of the gift split.
AppealId String The immutable system record ID of the appeal associated with the gift split.
CampaignId String The immutable system record ID of the campaign associated with the gift split.
FundId String The immutable system record ID of the fund associated with the gift split.
GiftAidAmount String The amount of tax reclaimed from gift aid for this gift split. For the UK only.
GiftAidQualificationStatus String The gift aid qualification status of the gift split. Available values are: Qualified, and NotQualified. For the UK only.
PackageId String The immutable system record ID of the package associated with the gift split.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930