UFN_RECOGNITIONLEVEL_GETORGANIZATIONPLANNEDGIFTAMOUNTBYDATE

Returns the minimum planned gift amount of a recognition level in organization currency for a given date.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode	Description
@RECOGNITIONLEVELID	uniqueidentifier	IN
@DATE	datetime	IN

Definition

Copy



        create function dbo.UFN_RECOGNITIONLEVEL_GETORGANIZATIONPLANNEDGIFTAMOUNTBYDATE
        (
              @RECOGNITIONLEVELID uniqueidentifier, 
              @DATE datetime
        )
        returns money
        with execute as caller
        as begin
            declare @ORGANIZATIONPLANNEDGIFTAMOUNT money;

            select top 1 @ORGANIZATIONPLANNEDGIFTAMOUNT = ORGANIZATIONPLANNEDGIFTAMOUNT
            from dbo.RECOGNITIONLEVELAMOUNT
            where RECOGNITIONLEVELID = @RECOGNITIONLEVELID 
                and coalesce(ACTIVEDATE, 0) <= @DATE
            order by ACTIVEDATE desc;

            return @ORGANIZATIONPLANNEDGIFTAMOUNT 
        end