USP_DATALIST_CONSTITUENT_MATCHINGGIFTDETAILS

This datalist returns details about the way an organization matches gifts.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Constituent ID
@MATCHINGCONSTITUENTID	uniqueidentifier	IN	Matching constituent ID
@DATE	datetime	IN	Date

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_CONSTITUENT_MATCHINGGIFTDETAILS
                (
                    @CONSTITUENTID uniqueidentifier,
                    @MATCHINGCONSTITUENTID uniqueidentifier,
                    @DATE datetime
                )
                as
                    set nocount on;

                    declare @CONSTITUENTMATCHEDANNUALTOTAL money;
                    declare @CONSTITUENTMATCHEDTOTAL money;
                    declare @CONSTITUENTGIFTTOTAL money;
                    declare @CONSTITUENTGIFTANNUALTOTAL money;
                    declare @MATCHINGGIFTCONDITION xml;

                    declare @FISCALYEARSTARTDATE datetime;            
                    select @FISCALYEARSTARTDATE = dbo.UFN_DATE_THISFISCALYEAR_FIRSTDAY(@DATE, 0);

                    if @CONSTITUENTID is not null
                        select
                            @CONSTITUENTMATCHEDANNUALTOTAL = dbo.UFN_CONSTITUENT_GETMATCHEDTOTALFORYEAR(@CONSTITUENTID, @MATCHINGCONSTITUENTID, @FISCALYEARSTARTDATE),
                            @CONSTITUENTMATCHEDTOTAL = dbo.UFN_CONSTITUENT_GETMATCHEDTOTAL(@CONSTITUENTID, @MATCHINGCONSTITUENTID),
                            @CONSTITUENTGIFTANNUALTOTAL = dbo.UFN_CONSTITUENT_GETGIFTTOTALFORYEAR(@CONSTITUENTID, @FISCALYEARSTARTDATE),
                            @CONSTITUENTGIFTTOTAL = dbo.UFN_CONSTITUENT_GETGIFTTOTAL(@CONSTITUENTID)

                    else
                    begin
                        set @CONSTITUENTMATCHEDANNUALTOTAL = 0;
                        set @CONSTITUENTMATCHEDTOTAL = 0;
                        set @CONSTITUENTGIFTANNUALTOTAL = 0;
                        set @CONSTITUENTGIFTTOTAL = 0;
                    end

                    set @MATCHINGGIFTCONDITION = dbo.UFN_MATCHINGGIFTPLEDGE_GETCONDITION_2_TOITEMLISTXML(@MATCHINGCONSTITUENTID, @CONSTITUENTID);

                    select @CONSTITUENTMATCHEDANNUALTOTAL,@CONSTITUENTMATCHEDTOTAL,@CONSTITUENTGIFTANNUALTOTAL,@CONSTITUENTGIFTTOTAL,@MATCHINGGIFTCONDITION;