USP_DATALIST_PAPERLESSMANDATESSITECONFIGURATION

Lists all of the paperless mandates site configurations.

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_PAPERLESSMANDATESSITECONFIGURATION
                (
                    @CURRENTAPPUSERID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select 
                        SITE.ID,
                        SITE.NAME as SITENAME,
                        SITE.DESCRIPTION as SITEDESCRIPTION,
                        SITECONFIGURATION.ENABLED,
                        nullif(SITECONFIGURATION.DAYSADVANCEDNOTICE,-1) as DAYSADVANCEDNOTICE
                    from
                         dbo.PAPERLESSMANDATESSITECONFIGURATION SITECONFIGURATION
                    inner join dbo.SITE on
                        SITECONFIGURATION.ID = SITE.ID
                    inner join dbo.UFN_SITESFORUSER(@CURRENTAPPUSERID) SITESFORUSER on
                        SITESFORUSER.SITEID = SITE.ID