UFN_RECURRINGGIFTQUALIFICATIONSTATUS

            CREATE function dbo.UFN_RECURRINGGIFTQUALIFICATIONSTATUS
      (
      @ID uniqueidentifier
      )
      returns nvarchar(30)
      with execute as caller
      as begin

        declare @SPLITIDS table(SPLITID uniqueidentifier);

        insert into @SPLITIDS(SPLITID)
          select ID
          from dbo.FINANCIALTRANSACTIONLINEITEM
          where FINANCIALTRANSACTIONID = @ID
          and DELETEDON is null AND TYPECODE <> 1;

        if exists(select ID from dbo.REVENUESPLITGIFTAID where ID in 
                    (select SPLITID from @SPLITIDS) and (RULES_STATUS = 0 or ATTRIBUTES_STATUS = 0 or DECLINESGIFTAID = 1))
        begin
          if exists(select ID from dbo.REVENUESPLITGIFTAID where ID in 
                      (select SPLITID from @SPLITIDS) and (RULES_STATUS & ATTRIBUTES_STATUS = 1) and DECLINESGIFTAID = 0)
          begin
            return 'Partially qualified';
          end
          else
          begin
            return 'Not qualified';
          end
        end

        return 'Qualified for Gift Aid';

      end