UFN_CONSTITUENT_HASRECEIVEDFUNDS

          create function dbo.UFN_CONSTITUENT_HASRECEIVEDFUNDS
          (
            @CONSTITUENTID uniqueidentifier
          )
          returns bit
          with execute as caller
          as begin
              declare @HASRECEIVEDFUNDS as bit = 0

              if exists( 
                select top 1 ID 
                from dbo.DESIGNATIONLEVELRECIPIENT as RECIPIENT 
                where RECIPIENT.CONSTITUENTID = @CONSTITUENTID
              )
                set @HASRECEIVEDFUNDS = 1

              return @HASRECEIVEDFUNDS
          end