USP_DATALIST_REQUIREDANDDEFAULTSOLICITCODES

Returns a list of all required and default solicit codes.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_REQUIREDANDDEFAULTSOLICITCODES
(
    @CURRENTAPPUSERID uniqueidentifier
)
as
    set nocount on;

    select 
        REQUIREDDEFAULT.SOLICITCODEID,
        SOLICITCODE.DESCRIPTION,
        REQUIREDDEFAULT.REQUIRED
    from dbo.UFN_MKTSEGMENTATION_GETREQUIREDANDDEFAULTSOLICITCODEEXCLUSIONS(@CURRENTAPPUSERID) REQUIREDDEFAULT
    inner join dbo.SOLICITCODE
        on REQUIREDDEFAULT.SOLICITCODEID = SOLICITCODE.ID;