USP_MEMBERSHIPDUESBATCH_CUSTOMVALIDATE

Parameters

Parameter	Parameter Type	Mode
@BATCHROWID	uniqueidentifier	IN
@BATCHNUMBER	nvarchar(255)	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@BATCHOWNERID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_MEMBERSHIPDUESBATCH_CUSTOMVALIDATE
            (
                @BATCHROWID uniqueidentifier,
                @BATCHNUMBER nvarchar(255),
                @CHANGEAGENTID uniqueidentifier,
                @CURRENTAPPUSERID uniqueidentifier,
                @BATCHOWNERID uniqueidentifier
            )
            as
            begin

                update dbo.BATCHMEMBERSHIPDUESBATCHSYSTEMMESSAGES
                set
                    MESSAGETEXT = 'Data in batch is different from data for this constituent. Click here to review.'
                where
                    BATCHMEMBERSHIPDUESID = @BATCHROWID and
                    MESSAGETYPECODE = 1 and
                    SEVERITYCODE = 0 and
                    exists
                    (
                        select top 1 'x'
                        from dbo.BATCHCONSTITUENTUPDATE
                        where ID= @BATCHROWID and DOMANUALREVIEWFORAUTOMATCH = 1
                    );
            end