UFN_COMMITTEEPROFILE_FUNDRAISINGGOAL_GETPROGRESS

This function returns the KPI progress of a committee or campaign fundraising goal progress given the fundraising committee Id.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@GOALID	uniqueidentifier	IN
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN
@FUNDRAISERTYPE	nvarchar(20)	IN

Definition

Copy



CREATE function dbo.UFN_COMMITTEEPROFILE_FUNDRAISINGGOAL_GETPROGRESS
(
    @ID uniqueidentifier,
    @GOALID uniqueidentifier,
    @STARTDATE datetime,
    @ENDDATE datetime,
    @FUNDRAISERTYPE nvarchar(20)
)
returns money
as begin
    declare @VALUE as money

    if @FUNDRAISERTYPE = 'Fundraising'
    begin
        set @VALUE = dbo.UFN_REVENUESOLICITOR_GETSUM(@ID, @STARTDATE, @ENDDATE)
    end
    else
    begin

        declare @CAMPAIGNID uniqueidentifier;

        select 
            @CAMPAIGNID = CAMPAIGNID
        from CAMPAIGNGOAL
            where ID = @GOALID;

        set @VALUE = dbo.UFN_KPI_CAMPAIGNFUNDRAISER_GOALAMOUNTTOTAL (null, @ID, @CAMPAIGNID, @STARTDATE, @ENDDATE)

    end

    return @VALUE
end