UFN_GIFTAIDREVENUESPLIT_SHOWSPLITASPOTENTIAL

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

        declare @QUALIFICATIONSTATUS bit;
        declare @DECLINESGIFTAID bit;
        declare @ELIGIBILITYCODE nvarchar(25);
        declare @TAXCLAIMNUMBER nvarchar(10);

        select @QUALIFICATIONSTATUS = (RULES_STATUS & ATTRIBUTES_STATUS),
               @DECLINESGIFTAID = DECLINESGIFTAID,
               @ELIGIBILITYCODE = dbo.UFN_GIFTAIDREVENUESPLIT_GETTAXCLAIMELIGIBILITY(ID),
               @TAXCLAIMNUMBER = TAXCLAIMNUMBER
        from dbo.REVENUESPLITGIFTAID
        where ID = @ID;

        if @QUALIFICATIONSTATUS = 0 or @DECLINESGIFTAID = 1 or @ELIGIBILITYCODE = 'Not eligible'
        begin
          if @TAXCLAIMNUMBER = ''
              return 0;
          else
            return 2;
        end
        else
        begin
            if @ELIGIBILITYCODE = 'No valid declaration' and @TAXCLAIMNUMBER = ''
                return 1;
            else
                return 2;
        end

        return 0;
      end