USP_MATCHINGGIFTELIGIBLEREVENUE_MARKREVIEWED

Executes the "Matching Gift Eligible Revenue: Dismiss" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being updated.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the update.

Definition

Copy



                    CREATE procedure dbo.USP_MATCHINGGIFTELIGIBLEREVENUE_MARKREVIEWED
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier
                    )
                    as
                        set nocount on;

                        declare @CHANGEDATE datetime;
                        set @CHANGEDATE = getdate();

            /* CMC
                        update dbo.REVENUE_EXT
                        set ELIGIBLEFORMATCHINGGIFTCLAIM = 0
                        where ID = @ID

            update dbo.FINANCIALTRANSACTION
                        set 
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CHANGEDATE
                        where ID = @ID
            */
            update dbo.REVENUE
                        set ELIGIBLEFORMATCHINGGIFTCLAIM = 0,
            CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CHANGEDATE
                        where ID = @ID