USP_MATCHINGGIFTPLEDGE_LOAD

Stored procedure to load a matching gift claim.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@ORIGINALGIFTID	uniqueidentifier	INOUT
@ORIGINALGIFTAMOUNT	money	INOUT
@CONSTITUENTID	uniqueidentifier	INOUT
@CONSTITUENTNAME	nvarchar(255)	INOUT
@MATCHINGORGANIZATIONID	uniqueidentifier	INOUT
@DATE	datetime	INOUT
@AMOUNT	money	INOUT
@SPLITS	xml	INOUT
@POSTSTATUSCODE	tinyint	INOUT
@POSTDATE	datetime	INOUT
@TSLONG	bigint	INOUT
@MATCHINGGIFTCONDITIONID	uniqueidentifier	INOUT
@MGCONDITIONTYPE	nvarchar(100)	INOUT
@MAXSOLICITORAMOUNT	money	INOUT
@MAXSOLICITORSPLITAMOUNTS	xml	INOUT

Definition

Copy



            CREATE procedure dbo.USP_MATCHINGGIFTPLEDGE_LOAD
            (
                @ID uniqueidentifier = null, 
                @DATALOADED bit = null output,
                @ORIGINALGIFTID uniqueidentifier = null output,
                @ORIGINALGIFTAMOUNT money = null output,
                @CONSTITUENTID uniqueidentifier = null output,
                @CONSTITUENTNAME nvarchar(255) = null output,
                @MATCHINGORGANIZATIONID uniqueidentifier = null output,
                @DATE datetime = null output,
                @AMOUNT money = null output,
                @SPLITS xml = null output,
                @POSTSTATUSCODE tinyint = null output,
                @POSTDATE datetime = null output,
                @TSLONG bigint = null output,
                @MATCHINGGIFTCONDITIONID uniqueidentifier output,
                @MGCONDITIONTYPE nvarchar(100) output,
                @MAXSOLICITORAMOUNT money = null output,
                @MAXSOLICITORSPLITAMOUNTS xml = null output
            )
            as
            set nocount on;
            set @DATALOADED = 0;

            select
                @DATALOADED = 1,
                @ORIGINALGIFTID = RMG.MGSOURCEREVENUEID,
                @MATCHINGORGANIZATIONID = REVENUE.CONSTITUENTID,
                @DATE = REVENUE.DATE,
                @AMOUNT = REVENUE.AMOUNT,
                @SPLITS = dbo.UFN_REVENUE_GETSPLITS_TOITEMLISTXML(REVENUE.ID),
                @POSTDATE =null,
                @POSTSTATUSCODE = 1,
                @TSLONG = REVENUE.TSLONG,
                @MATCHINGGIFTCONDITIONID = RMG.MATCHINGGIFTCONDITIONID,
                @MGCONDITIONTYPE = dbo.UFN_MATCHINGGIFTCONDITIONTYPECODE_GETDESCRIPTION(MGC.MATCHINGGIFTCONDITIONTYPECODEID),
                @MAXSOLICITORAMOUNT = 0,
                @MAXSOLICITORSPLITAMOUNTS = dbo.UFN_REVENUEDETAIL_GETMAXSOLICITORSPLITAMOUNTS_TOITEMLISTXML(@ID)
            from dbo.REVENUE
            left join dbo.REVENUEPOSTED on REVENUEPOSTED.ID = REVENUE.ID
            left join dbo.REVENUEMATCHINGGIFT RMG on REVENUE.ID = RMG.ID
            left join dbo.MATCHINGGIFTCONDITION MGC on RMG.MATCHINGGIFTCONDITIONID = MGC.ID
            where REVENUE.ID = @ID and REVENUE.TRANSACTIONTYPECODE = 3;

            select 
                @ORIGINALGIFTAMOUNT = REVENUE.AMOUNT,
                @CONSTITUENTID = CONSTITUENT.ID,
                @CONSTITUENTNAME = CONSTITUENT.NAME
            from dbo.REVENUE
            inner join dbo.CONSTITUENT on CONSTITUENT.ID = REVENUE.CONSTITUENTID
            where REVENUE.ID = @ORIGINALGIFTID

            return 0;