UFN_REVENUEBATCHREGISTRANT_ISGUEST

            CREATE function dbo.UFN_REVENUEBATCHREGISTRANT_ISGUEST
            (
                @REGISTRANTID uniqueidentifier = null                
            ) 
            returns bit with execute as caller
            as
            begin                
                if exists(select ID from dbo.BATCHREVENUEREGISTRANT where ID = @REGISTRANTID and GUESTOFREGISTRANTID is not null)
                    return 1

                return 0
            end