Returns the lifetime giving information for a constituent.
Table Specific Information
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: ConstituentId are required in order to query LifetimeGiving.
- ConstituentId supports the '=' operator.
SELECT * FROM LifetimeGiving WHERE ConstituentId = '280'
|ConsecutiveYearsGiven||Integer||This computed field calculates the number of consecutive years the constituent has given.|
|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.|