UFN_PAPERLESSMANDATES_DAYSADVANCEDNOTICE_FORSITE

Returns the number of days of advance notice if paperless mandates are enabled for a site.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@SITEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PAPERLESSMANDATES_DAYSADVANCEDNOTICE_FORSITE(@SITEID uniqueidentifier = null)
            returns integer
            with execute as caller
            as begin
                declare @DAYSADVANCEDNOTICE integer;

                select
                    @DAYSADVANCEDNOTICE = DAYSADVANCEDNOTICE 
                from 
                    dbo.PAPERLESSMANDATESSITECONFIGURATION 
                where
                    ID = @SITEID;

                if @@ROWCOUNT = 0
                begin
                    select 
                        @DAYSADVANCEDNOTICE = DAYSADVANCEDNOTICE
                    from
                        dbo.PAPERLESSMANDATESCONFIGURATION  
                end

                return @DAYSADVANCEDNOTICE
            end