USP_DATALIST_MEMBERSHIPDUESBATCH_RAISEEXCEPTIONFORAUTOMATCHES

                CREATE procedure dbo.USP_DATALIST_MEMBERSHIPDUESBATCH_RAISEEXCEPTIONFORAUTOMATCHES
                (
                    @BATCHROWID uniqueidentifier,
                    @AUTOMATCHRECORDID uniqueidentifier,
                    @CURRENTAPPUSERID uniqueidentifier = null
                )
                as
                    set nocount on;

                    declare @DOMANUALREVIEWFORAUTOMATCH bit = 0;
                    declare @ORIGINALCONSTITUENTID uniqueidentifier;

                    -- get rules settings from the batch row

                    declare @NAMECODE tinyint;
                    declare @SIMILARADDRESSCODE tinyint;
                    declare @UNSIMILARADDRESSCODE tinyint;
                    declare @DIFFERENTPHONECODE tinyint;
                    declare @DIFFERENTEMAILCODE tinyint;

                    select
                        @NAMECODE = NAMECODE,
                        @SIMILARADDRESSCODE = SIMILARADDRESSCODE,
                        @UNSIMILARADDRESSCODE = UNSIMILARADDRESSCODE,
                        @DIFFERENTPHONECODE = DIFFERENTPHONECODE,
                        @DIFFERENTEMAILCODE = DIFFERENTEMAILCODE,
                        @ORIGINALCONSTITUENTID = BILLTOCONSTITUENTID
                    from dbo.BATCHMEMBERSHIPDUES
                    where ID = @BATCHROWID;

                    -- first load the new constituent's data and save the matched constituent to the CUB tables

                    exec dbo.USP_BATCHMEMBERSHIPDUES_DUPLICATEMATCH_EDITSAVE_CONSTITUENT @BATCHROWID, @ORIGINALCONSTITUENTID, @AUTOMATCHRECORDID, @CURRENTAPPUSERID;

                    exec dbo.USP_CONSTITUENTUPDATEBATCH_DOMANUALREVIEWFORAUTOMATCH @BATCHROWID, @AUTOMATCHRECORDID, @NAMECODE, @SIMILARADDRESSCODE, @UNSIMILARADDRESSCODE, @DIFFERENTPHONECODE, @DIFFERENTEMAILCODE, @DOMANUALREVIEWFORAUTOMATCH output;

                    update dbo.BATCHCONSTITUENTUPDATE
                    set DOMANUALREVIEWFORAUTOMATCH = @DOMANUALREVIEWFORAUTOMATCH
                    where ID = @BATCHROWID;

                    select @DOMANUALREVIEWFORAUTOMATCH as DOMANUALREVIEWFORAUTOMATCH