USP_DATAFORMTEMPLATE_VIEW_PLANNEDGIFTPAYMENTDETAILS

The load procedure used by the view dataform template "Planned Gift Payment Details View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@CONSTITUENTNAME	nvarchar(700)	INOUT	Constituent
@GIFTDATE	datetime	INOUT	Date
@VEHICLE	nvarchar(150)	INOUT	Vehicle
@GIFTAMOUNT	money	INOUT	Gift amount
@DESIGNATIONS	nvarchar(3000)	INOUT	Designations
@ANONYMOUS	bit	INOUT	Anonymous
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Transaction currency ID

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PLANNEDGIFTPAYMENTDETAILS
                (
                    @ID uniqueidentifier,    
                    @DATALOADED bit = 0 output,
                    @CONSTITUENTNAME nvarchar(700) = null output,
                    @GIFTDATE datetime = null output,
                    @VEHICLE nvarchar(150) = null output,
                    @GIFTAMOUNT money = null output,
                    @DESIGNATIONS nvarchar(3000) = null output,
                    @ANONYMOUS bit = null output,
                    @TRANSACTIONCURRENCYID uniqueidentifier = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @CONSTITUENTNAME = NF.NAME,
                        @GIFTDATE = PLANNEDGIFT.GIFTDATE,
                        @VEHICLE = PLANNEDGIFT.VEHICLE,
                        @GIFTAMOUNT = PLANNEDGIFT.TRANSACTIONGIFTAMOUNT,
                        @DESIGNATIONS = dbo.UDA_BUILDLIST(DESIGNATION.NAME),
                        @ANONYMOUS = PLANNEDGIFT.ISANONYMOUS,
                        @TRANSACTIONCURRENCYID = PLANNEDGIFT.TRANSACTIONCURRENCYID
                    from dbo.PLANNEDGIFT
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(PLANNEDGIFT.CONSTITUENTID) NF
                    inner join dbo.PLANNEDGIFTDESIGNATION on PLANNEDGIFT.ID = PLANNEDGIFTDESIGNATION.PLANNEDGIFTID
                    inner join dbo.DESIGNATION on DESIGNATION.ID = PLANNEDGIFTDESIGNATION.DESIGNATIONID
                    where
                        PLANNEDGIFT.ID = @ID
                    group by NF.NAME, PLANNEDGIFT.GIFTDATE, PLANNEDGIFT.VEHICLE, PLANNEDGIFT.TRANSACTIONGIFTAMOUNT, PLANNEDGIFT.ISANONYMOUS, PLANNEDGIFT.TRANSACTIONCURRENCYID