SSIS Components for Blackbaud Raisers Edge NXT

Build 21.0.7930

Gifts

Returns a paginated list of gifts

Table Specific Information

Select

The component 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 component.

  • Id supports the '=' operator.
  • ConstituentId supports the '=,in' operators.
  • Date supports the '>=,<=' operators.
  • DateAdded supports the '>=,>' operators.
  • DateModified supports the '>=,>' operators.
  • PostStatus supports the '=,in' operators.
  • Type supports the '=' operator.
  • ListId supports the '=' operator.
  • AppealId supports the '=,in' operators.
  • FundId supports the '=,in' operators.
  • CampaignId supports the '=,in' operators.
  • AcknowledgmentStatus supports the '=,in' operators.
  • ReceiptStaus supports the '=,in' operators.
For example:
	
	SELECT * FROM Gifts WHERE ConstituentId IN ('280', '281')
	
	SELECT * FROM Gifts WHERE PostStatus = 'Posted'
	
	SELECT * FROM Gifts WHERE Type IN ('Pledge', 'GiftInKind')

Columns

Name Type References Description
Id [KEY] String The immutable system record ID of the gift.
AmountValue Double The monetary amount of the gift.
BalanceValue Double The balance remaining on the gift.
BatchNumber String The batch number associated with this gift.
Constituency String The constituency of the gift.
ConstituentId String The immutable system record ID of the constituent associated with the gift.
Date Date The gift date.
DateAdded Datetime The date when the gift was created.
DateModified Datetime The date when the gift was last modified.
GiftAidAmountValue Double This computed field calculates the total qualified amount of tax reclaimed from Gift Aid across all gift_splits for this gift.
GiftAidQualificationStatus String This computed field determines the Gift Aid qualification status based on tax declaration information and the database format. Available values are: Qualified, NotQualified, and PartlyQualified. For the UK only.
GiftStatus String The status of the gift. Available values are Active, Held, Terminated, Completed, and Cancelled.
IsAnonymous Bool Indicates whether the gift is anonymous.
LinkedGifts String The identifiers of other gifts that are linked to this gift.
LookupId String The user-defined identifier for the gift.
Origin String The origin of the gift.
PostDate Datetime The date that the gift was posted to general ledger.
PostStatus String The general ledger post status of the gift.
RecurringGiftStatusDateD Integer The date that the gift status was last modified.
RecurringGiftStatusDateM Integer The date that the gift status was last modified.
RecurringGiftStatusDateY Integer The date that the gift status was last modified.
Reference String Notes to track special details about a gift such as the motivation behind it or a detailed description of a gift-in-kind.
Subtype String The subtype of the gift.
Type String The gift type.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ListId String Defines a list identifier used to filter the set of gifts to those included in the specified list. If this value is set, other specified filters will be ignored.
AppealId String Returns gifts if any of the specified appeal identifiers match any of their appeals.
FundId String Returns gifts if any of the specified fund identifiers match any of their funds.
CampaignId String Returns gifts if any of the specified campaign identifiers match any of their campaigns.
AcknowledgmentStatus String Returns gifts if their acknowledgement status matches any specified.
ReceiptStaus String Returns gifts if their receipt status matches any specified.

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