UFN_GIFTFEE_APPLICATIONCODEINCLUDED

Returns true is an application should be considered for gift fees for a designation level.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@APPLICATIONCODE	tinyint	IN
@DESIGNATIONLEVELID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_GIFTFEE_APPLICATIONCODEINCLUDED(@APPLICATIONCODE tinyint, @DESIGNATIONLEVELID uniqueidentifier)
returns bit
as

begin;

    if exists(select ID from dbo.DESIGNATIONLEVELGIFTFEEOPTION where ID = @DESIGNATIONLEVELID)
    begin
        --defaults overridden check at purpose

        if exists(
        select ID 
        from dbo.DESIGNATIONLEVELGIFTFEEAPPLICATIONTYPE
        where DESIGNATIONLEVELID = @DESIGNATIONLEVELID
                and APPLICATIONCODE = @APPLICATIONCODE)
        return 1;
    end
    else
    begin
        --use defaults

        if exists(
        select ID 
        from dbo.GIFTFEEAPPLICATIONTYPE
        where APPLICATIONCODE = @APPLICATIONCODE)
        return 1;
    end

    return 0;

end