UFN_REMINDEROPTION_GETSOLICITCODES

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