UFN_SECURITY_APPUSER_GRANTED_BATCHTEMPLATE_IN_NONRACROLE

            CREATE function dbo.UFN_SECURITY_APPUSER_GRANTED_BATCHTEMPLATE_IN_NONRACROLE
            (
                @APPUSERID uniqueidentifier,
                @BATCHTEMPLATEID uniqueidentifier
            )
            returns bit 
            as
            begin
                /*
                Returns true if the given user has permissions to the given batch
                in a role whose security group is blank

                This function is optimized for use from the Blackbaud.AppFx.Security.Catalog.ConstitRecordSecurityService
                class which implements the RecordSecurity service for Constituent record security.

                As such, it assumes that a check for DENY occurs outside this function
                and also assumes that a check for if the user is ISSYSADMIN occurs outside 
                this function.  
                */


                begin
                --If user granted permission to the feature in a role with no ringfence then 

                --the user has permission regardless of the record in question.

                if exists
                    (
                        select 
                            1
                        from 
                            dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATE as SV
                                with (NOEXPAND, INDEX(IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATE_BATCHTEMPLATEID_APPUSERID))
                        WHERE
                            SV.APPUSERID = @APPUSERID AND 
                            SV.BATCHTEMPLATEID = @BATCHTEMPLATEID AND 
                            SV.GRANTORDENY = 1 AND 
                            SV.RECORDSECURITYMODE = 0
                    union all                
                        select 
                            1
                        from 
                            dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE as SV
                            inner join dbo.BATCHTEMPLATE on BATCHTEMPLATE.BATCHTYPECATALOGID = SV.BATCHTYPECATALOGID                        
                        where 
                            SV.APPUSERID = @APPUSERID AND 
                            BATCHTEMPLATE.ID = @BATCHTEMPLATEID AND 
                            SV.GRANTORDENY = 1 AND 
                            SV.RECORDSECURITYMODE = 0
                    union all
                        select 
                            1
                        from 
                            dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHWORKFLOWSTATE as SV
                                with (NOEXPAND, INDEX(IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHWORKFLOWSTATE_BATCHWORKFLOWSTATEID_APPUSERID))                                
                            inner join dbo.BATCH on BATCH.BATCHWORKFLOWSTATEID = SV.BATCHWORKFLOWSTATEID                    
                        where 
                            SV.APPUSERID = @APPUSERID AND 
                            BATCH.BATCHTEMPLATEID = @BATCHTEMPLATEID AND 
                            SV.GRANTORDENY = 1 AND 
                            SV.RECORDSECURITYMODE = 0
                    union all
                        select 
                            1
                        from 
                            dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHPROCESSOR as SV
                                with (NOEXPAND, INDEX(IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATEPROCESSOR_BATCHTEMPLATEID_APPUSERID))                                                        
                        where 
                            SV.APPUSERID = @APPUSERID AND 
                            SV.BATCHTEMPLATEID = @BATCHTEMPLATEID AND 
                            SV.GRANTORDENY = 1 AND 
                            SV.RECORDSECURITYMODE = 0 
                    union all
                        select 
                            1
                        from 
                            dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATEAPPROVER as SV
                                with (NOEXPAND, INDEX(IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATEAPPROVER_BATCHTEMPLATEID_APPUSERID))                                                        
                        where 
                            SV.APPUSERID = @APPUSERID AND 
                            SV.BATCHTEMPLATEID = @BATCHTEMPLATEID AND 
                            SV.GRANTORDENY = 1 AND 
                            SV.RECORDSECURITYMODE = 0
                    )
                 return 1;

                return  0;

                end
            end