USP_DATALIST_PLANNEDGIFTADDITION

Displays a list of planned gift additions for a given planned gift.

Parameters

Parameter	Parameter Type	Mode	Description
@PLANNEDGIFTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



              CREATE procedure dbo.USP_DATALIST_PLANNEDGIFTADDITION
              (
                @PLANNEDGIFTID uniqueidentifier
              )
              as
                  set nocount on;

                  select 
                    PLANNEDGIFTADDITION.ID,
                    PLANNEDGIFTADDITION.GIFTDATE,
                    PLANNEDGIFTADDITION.TRANSACTIONGIFTAMOUNT,
                    PLANNEDGIFTADDITION.TRANSACTIONRECOGNITIONAMOUNT,
                    dbo.UDA_BUILDLIST(DESIGNATION.NAME),
                    PLANNEDGIFTADDITION.TRANSACTIONCURRENCYID
                  from dbo.PLANNEDGIFTADDITION
                  left join dbo.PLANNEDGIFTADDITIONDESIGNATION on PLANNEDGIFTADDITION.ID = PLANNEDGIFTADDITIONDESIGNATION.PLANNEDGIFTADDITIONID
                  left join dbo.DESIGNATION on PLANNEDGIFTADDITIONDESIGNATION.DESIGNATIONID = DESIGNATION.ID
                  where PLANNEDGIFTADDITION.PLANNEDGIFTID = @PLANNEDGIFTID
                  group by 
                    PLANNEDGIFTADDITION.ID,
                    PLANNEDGIFTADDITION.GIFTDATE,
                    PLANNEDGIFTADDITION.TRANSACTIONGIFTAMOUNT,
                    PLANNEDGIFTADDITION.TRANSACTIONRECOGNITIONAMOUNT,
                    PLANNEDGIFTADDITION.TRANSACTIONCURRENCYID
                  order by PLANNEDGIFTADDITION.GIFTDATE