GiftSplits
Returns the splits for a gift.
Table Specific Information
Select
The driver 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 driver.
Note: GiftId are required in order to query GiftSplits.
- GiftId supports the '=' operator.
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. |