UFN_CONSTITUENT_GETMATCHEDTOTALFORYEAR

Returns the total amount matched for a constituent by an organization in a specified year for matching gift claims based in the organization currency.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@MATCHINGORGANIZATIONID	uniqueidentifier	IN
@YEARSTART	datetime	IN

Definition

Copy



            CREATE function dbo.UFN_CONSTITUENT_GETMATCHEDTOTALFORYEAR
            (
                @CONSTITUENTID uniqueidentifier = null,
                @MATCHINGORGANIZATIONID uniqueidentifier = null,
                @YEARSTART datetime
            ) 
            returns 
            money
            as
            begin
                return dbo.UFN_CONSTITUENT_GETMATCHEDTOTALFORYEARINCURRENCY(@CONSTITUENTID, @MATCHINGORGANIZATIONID, @YEARSTART, default);
            end