UFN_SECURITY_APPUSER_IN_NONSITEROLE

            create function dbo.UFN_SECURITY_APPUSER_IN_NONSITEROLE
            (
                @APPUSERID uniqueidentifier
            )
            returns bit as

            /*
            Returns true if the given user is in a role whose site permission 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 if the user is ISSYSADMIN occurs outside 
            this function.  
            */

            begin
                if exists
                    (
                        select 
                            1 
                        from 
                            dbo.SYSTEMROLEAPPUSER
                        where 
                            SYSTEMROLEAPPUSER.APPUSERID = @APPUSERID and 
                            SYSTEMROLEAPPUSER.SECURITYMODECODE = 0
                    )
                 return 1;

                return  0;
            end