USP_BATCHCONSTITUENT_APPLYBUSINESSRULES

Parameters

Parameter	Parameter Type	Mode
@BATCHROWID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NAMECODE	tinyint	IN
@ADDALL	bit	IN
@SIMILARADDRESSCODE	tinyint	IN
@UNSIMILARADDRESSCODE	tinyint	IN
@NEWADDRESSPRIMARYCODE	tinyint	IN
@BIRTHDATERULECODE	tinyint	IN
@DIFFERENTPHONECODE	tinyint	IN
@NEWPHONEPRIMARYCODE	tinyint	IN
@DIFFERENTEMAILCODE	tinyint	IN
@NEWEMAILPRIMARYCODE	tinyint	IN

Definition

Copy



CREATE procedure dbo.USP_BATCHCONSTITUENT_APPLYBUSINESSRULES(
  @BATCHROWID uniqueidentifier,
  @CONSTITUENTID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier, 
  @NAMECODE tinyint,
  @ADDALL bit,
  @SIMILARADDRESSCODE tinyint, 
  @UNSIMILARADDRESSCODE tinyint, 
  @NEWADDRESSPRIMARYCODE tinyint,
  @BIRTHDATERULECODE tinyint,
  @DIFFERENTPHONECODE tinyint,
  @NEWPHONEPRIMARYCODE tinyint,
  @DIFFERENTEMAILCODE tinyint,
  @NEWEMAILPRIMARYCODE tinyint

)
      as
      begin
          exec dbo.USP_CONSTITUENTUPDATEBATCH_APPLYNAMERULES @BATCHROWID, @CONSTITUENTID, @CHANGEAGENTID, @NAMECODE; -- Apply name rules

        exec dbo.USP_CONSTITUENTUPDATEBATCH_APPLYADDRESSRULES @BATCHROWID, @CONSTITUENTID, @CHANGEAGENTID, @ADDALL, @SIMILARADDRESSCODE, @UNSIMILARADDRESSCODE, @NEWADDRESSPRIMARYCODE; -- Apply address rules

        exec dbo.USP_CONSTITUENTUPDATEBATCH_APPLYBIRTHDATERULES @BATCHROWID, @CONSTITUENTID, @CHANGEAGENTID, @BIRTHDATERULECODE; -- Apply birthdate rules

        exec dbo.USP_CONSTITUENTUPDATEBATCH_APPLYPHONERULES @BATCHROWID, @CONSTITUENTID, @CHANGEAGENTID, @ADDALL, @DIFFERENTPHONECODE, @NEWPHONEPRIMARYCODE; -- Apply phone rules        

        exec dbo.USP_CONSTITUENTUPDATEBATCH_APPLYEMAILRULES @BATCHROWID, @CONSTITUENTID, @CHANGEAGENTID, @ADDALL, @DIFFERENTEMAILCODE, @NEWEMAILPRIMARYCODE; -- Apply email rules


      end