UFN_COMMUNICATIONLETTER_GETEXCLUDEDSOLICITCODES

Retrieve the solicit codes to be excluded from this appeal mailing letter.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@COMMUNICATIONLETTERID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_COMMUNICATIONLETTER_GETEXCLUDEDSOLICITCODES
(
    @COMMUNICATIONLETTERID uniqueidentifier
)
returns table as
    return (
        select
            COMMUNICATIONLETTEREXCLUDEDSOLICITCODE.ID,
            COMMUNICATIONLETTEREXCLUDEDSOLICITCODE.SOLICITCODEID,
            SOLICITCODE.EXCLUSIONCODE as TYPE,
            SOLICITCODE.DESCRIPTION as NAME
        from dbo.COMMUNICATIONLETTEREXCLUDEDSOLICITCODE
        inner join dbo.SOLICITCODE
            on COMMUNICATIONLETTEREXCLUDEDSOLICITCODE.SOLICITCODEID = SOLICITCODE.ID
        where COMMUNICATIONLETTERID = @COMMUNICATIONLETTERID
            and SOLICITCODE.EXCLUSIONCODE <> 2
)