UFN_REVENUEBATCH_GETCOLLECTIONDESCRIPTION

Returns a list of the solicitors or the constituents associated with recognitions for a revenue batch ID.

Return

Return Type
nvarchar(1000)

Parameters

Parameter	Parameter Type	Mode
@TYPECODE	tinyint	IN
@DESIGNATIONID	uniqueidentifier	IN
@BATCHREVENUEID	uniqueidentifier	IN
@ISRECOGNITIONS	bit	IN

Definition

Copy



      CREATE function dbo.UFN_REVENUEBATCH_GETCOLLECTIONDESCRIPTION
      (
        @TYPECODE tinyint,
        @DESIGNATIONID uniqueidentifier,
        @BATCHREVENUEID uniqueidentifier,
        @ISRECOGNITIONS bit
      )
      returns nvarchar(1000)
      as 
      begin
        declare @RETURN nvarchar(1000)

        if @ISRECOGNITIONS = 1
        begin
          select @RETURN = coalesce(@RETURN + '; ', '') + CONSTITUENT.NAME
          from dbo.BATCHREVENUERECOGNITION
          inner join dbo.CONSTITUENT on BATCHREVENUERECOGNITION.CONSTITUENTID = CONSTITUENT.ID
          where ADDITIONALAPPLICATIONDESIGNATIONID = @DESIGNATIONID
          and ADDITIONALAPPLICATIONTYPECODE = @TYPECODE
          and BATCHREVENUEID = @BATCHREVENUEID
        end
        else
        begin
          select @RETURN = coalesce(@RETURN + '; ', '') + CONSTITUENT.NAME
          from dbo.BATCHREVENUESOLICITOR
          inner join dbo.CONSTITUENT on BATCHREVENUESOLICITOR.CONSTITUENTID = CONSTITUENT.ID
          where ADDITIONALAPPLICATIONDESIGNATIONID = @DESIGNATIONID
          and ADDITIONALAPPLICATIONTYPECODE = @TYPECODE
          and BATCHREVENUEID = @BATCHREVENUEID
        end

          return @RETURN
      end