UFN_DONORCHALLENGE_VALIDMAPPING

      create function dbo.UFN_DONORCHALLENGE_VALIDMAPPING
      (
        @DONORCHALLENGEID uniqueidentifier,
        @MATCHINGDESIGNATIONID uniqueidentifier
      )
      returns bit with execute as caller
      as
      begin

        declare @TYPECODE tinyint;

        select
          @TYPECODE = TYPECODE
        from
          dbo.DONORCHALLENGE
        where
          ID = @DONORCHALLENGEID

        if @TYPECODE = 0 and @MATCHINGDESIGNATIONID is null
          return 0;
        else if @TYPECODE = 1 and @MATCHINGDESIGNATIONID is not null
          return 0;

        return 1;
      end