USP_SIMPLEDATALIST_SOLICITCODEREQUIREDWITHSITE

List of required solicit codes with site description.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_SOLICITCODEREQUIREDWITHSITE
                (
                    @CURRENTAPPUSERID uniqueidentifier,
                    @OWNERID uniqueidentifier = null,
                    @BUSINESSPROCESSPARAMETERSETID uniqueidentifier = null
                )
                as                
                    set nocount on;

                    select 
                        SOLICITCODE.[ID] as VALUE, 
                        case when SOLICITCODE.SITEID is null then SOLICITCODE.[DESCRIPTION] else SOLICITCODE.[DESCRIPTION] + ' - ' + SITE.NAME end as LABEL 
                    from 
                        dbo.SOLICITCODE
                        left join dbo.SITE on SOLICITCODE.SITEID = SITE.ID
                    where
                        (
                            (
                                SOLICITCODE.ID in 
                                (
                                    select BUSINESSPROCESSCOMMPREFEXCLUSIONS.SOLICITCODEID 
                                    from dbo.BUSINESSPROCESSCOMMPREFEXCLUSIONS 
                                    where BUSINESSPROCESSCOMMPREFEXCLUSIONS.BUSINESSPROCESSPARAMETERSETID = @BUSINESSPROCESSPARAMETERSETID
                                )
                            ) or 
                            (
                                SOLICITCODE.ACTIVE = 1 and
                                (
                                    SOLICITCODE.SITEID is null or
                                    dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, SOLICITCODE.SITEID) = 1 or
                                    dbo.UFN_SITEALLOWEDFORUSER(@OWNERID, SOLICITCODE.SITEID) = 1
                                )
                            )
                        ) and
                        SOLICITCODE.EXCLUSIONCODE = 2
                    order by 
                        SOLICITCODE.[DESCRIPTION];