UFN_PAPERLESSMANDATES_ENABLED_FORSITE

            create function dbo.UFN_PAPERLESSMANDATES_ENABLED_FORSITE(@SITEID uniqueidentifier = null)
            returns integer
            with execute as caller
            as begin
                declare @ENABLED integer;
                set @ENABLED = 0;

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

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

                return @ENABLED
            end