UFN_GIFTAIDREVENUESPLIT_GETQUALIFICATIONSTATUS

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

        declare @STATUSCODE bit = 0;
        declare @DECLINESGIFTAID bit = 0;

        select @STATUSCODE = (RULES_STATUS & ATTRIBUTES_STATUS),
               @DECLINESGIFTAID = DECLINESGIFTAID
        from dbo.REVENUESPLITGIFTAID
        where ID = @ID;

        if @STATUSCODE = 1 and @DECLINESGIFTAID = 0
          return 'Qualified for Gift Aid';

        return 'Not qualified';
      end