USP_DATAFORMTEMPLATE_VIEW_CONSTITUENT_GIVINGSTATISTICS

The load procedure used by the view dataform template "Constituent Giving Statistics 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.
@AMOUNT	money	INOUT	Amount
@PLEDGEBALANCE	money	INOUT	Balance
@TYPE	nvarchar(22)	INOUT	Type
@SPLITS	xml	INOUT	Splits

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENT_GIVINGSTATISTICS (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @AMOUNT money = null output,
                    @PLEDGEBALANCE money = null output,
                    @TYPE nvarchar(22) = null output,
                    @SPLITS xml = null output
                ) as
                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @AMOUNT = R.AMOUNT - sum(coalesce(IWO.AMOUNT,0)),
                        @TYPE = R.TRANSACTIONTYPE,
                        @PLEDGEBALANCE = case R.TRANSACTIONTYPECODE when 1 then dbo.UFN_PLEDGE_GETBALANCE(R.ID) else null end,
                        @SPLITS = dbo.UFN_REVENUE_GETSPLITS_LIST_TOITEMLISTXML(R.ID)
                    from
                        dbo.REVENUE R
                    left join
                        dbo.WRITEOFF WO
                    on
                        WO.REVENUEID = R.ID
                    left join
                        dbo.INSTALLMENTWRITEOFF IWO
                    on
                        IWO.WRITEOFFID = WO.ID
                    where
                        R.ID = @ID
                    group by
                        R.ID, R.AMOUNT, R.TRANSACTIONTYPE, R.TRANSACTIONTYPECODE;

                    return 0;