UFN_DONORCHALLENGE_GETREMAININGFUNDS

Returns the remaining funds amount for a given Donor Challenge

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_DONORCHALLENGE_GETREMAININGFUNDS(@ID uniqueidentifier) returns money
            as
            begin

            declare @ENCUMBEREDFUNDS money = dbo.UFN_DONORCHALLENGE_ENCUMBEREDAMOUNT(@ID);

              declare @MATCHEDFUNDS money = dbo.UFN_DONORCHALLENGE_MATCHEDAMOUNT(@ID);

            declare @REMAININGAMOUNT money;

              select
              @REMAININGAMOUNT = case when TYPECODE = 1 then MATCHTHRESHOLD - (@ENCUMBEREDFUNDS + @MATCHEDFUNDS) 
                                 else TOTALFUNDS - (@ENCUMBEREDFUNDS + @MATCHEDFUNDS) end

              from 
                    dbo.DONORCHALLENGE
                where
                    ID = @ID;

              return @REMAININGAMOUNT;
            end