SSIS Components for Blackbaud Raisers Edge NXT

Build 21.0.7930

LifetimeGiving

Returns the lifetime giving information for a constituent.

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.
Note: ConstituentId are required in order to query LifetimeGiving.

  • ConstituentId supports the '=' operator.
For example:
	SELECT * FROM LifetimeGiving WHERE ConstituentId = '280'

Columns

Name Type References Description
ConsecutiveYearsGiven Integer This computed field calculates the number of consecutive years the constituent has given.
ConstituentId String

Constituents.Id

The immutable system record ID of the constituent associated with the lifetime giving.
TotalCommittedMatchingGiftsValue Double This computed field calculates the total amount of matching gift commitments attributed to the constituent.
TotalGivingValue Double This computed field calculates the total amount given by the constituent.
TotalPledgeBalanceValue Double This computed field calculates the unpaid pledge balance for the constituent.
TotalReceivedGivingValue Double This computed field calculates the total received amount given by the constituent.
TotalReceivedMatchingGiftsValue Double This computed field calculates the total amount of payments toward matching gift pledges attributed to the constituent.
TotalSoftCreditsValue Double This computed field calculates the total amount of soft credits applied to the constituent.
TotalYearsGiven Integer This computed field calculates the total number of years the constituent has given.

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