UFN_GIFTAIDSTATUS_GETBASEDONRULES

            CREATE function dbo.UFN_GIFTAIDSTATUS_GETBASEDONRULES
            (
                @REVENUESPLITID uniqueidentifier
            )
            returns bit
            with execute as caller
            as begin
                declare @STATUS bit
                set @STATUS = 1

                if (select count(*) from dbo.UFN_REVENUESPLIT_GETDISQUALIFICATIONS(@REVENUESPLITID, 0)) > 0
                    set @STATUS = 0
                else
                begin
                    if dbo.UFN_REVENUESPLITGIFTAID_GIFTAIDEXPIRED(@REVENUESPLITID) = 1
                        set @STATUS = 0
                end

                return @STATUS
            end