USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTUPDATEBATCHDUPLICATEMATCH_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@LOOKUPID	nvarchar(50)	IN
@FIRSTNAME	nvarchar(50)	IN
@MIDDLENAME	nvarchar(50)	IN
@LASTNAME	nvarchar(100)	IN
@SUFFIXCODEID	uniqueidentifier	IN
@TITLECODEID	uniqueidentifier	IN
@MAIDENNAME	nvarchar(100)	IN
@NICKNAME	nvarchar(50)	IN
@GENDERCODE	tinyint	IN
@BIRTHDATE	UDT_FUZZYDATE	IN
@ADDRESSID	uniqueidentifier	IN
@ADDRESSTYPECODEID	uniqueidentifier	IN
@ADDRESS_ADDRESSBLOCK	nvarchar(150)	IN
@ADDRESS_CITY	nvarchar(50)	IN
@ADDRESS_STATEID	uniqueidentifier	IN
@ADDRESS_POSTCODE	nvarchar(12)	IN
@ADDRESS_COUNTRYID	uniqueidentifier	IN
@PHONEID	uniqueidentifier	IN
@PHONETYPECODEID	uniqueidentifier	IN
@PHONENUMBER	nvarchar(100)	IN
@EMAILID	uniqueidentifier	IN
@EMAILADDRESSTYPECODEID	uniqueidentifier	IN
@EMAILADDRESS	UDT_EMAILADDRESS	IN
@CREATEDON	datetime	IN
@DATECHANGED	datetime	IN
@ADDRESSES	xml	IN
@PHONES	xml	IN
@EMAILADDRESSES	xml	IN
@CONSTITUENTACTION	tinyint	IN
@ADDRESSACTION	tinyint	IN
@EMAILACTION	tinyint	IN
@PHONEACTION	tinyint	IN
@PRIMARYRECORDID	uniqueidentifier	IN
@EMAILISPRIMARY	bit	IN
@PHONEISPRIMARY	bit	IN
@ADDRESSISPRIMARY	bit	IN
Definition

Copy


CREATE procedure USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTUPDATEBATCHDUPLICATEMATCH_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @LOOKUPID nvarchar(50),
    @FIRSTNAME nvarchar(50),
    @MIDDLENAME nvarchar(50),
    @LASTNAME nvarchar(100),
    @SUFFIXCODEID uniqueidentifier,
    @TITLECODEID uniqueidentifier,
    @MAIDENNAME nvarchar(100),
    @NICKNAME nvarchar(50),
    @GENDERCODE tinyint,
    @BIRTHDATE dbo.UDT_FUZZYDATE,
    @ADDRESSID uniqueidentifier,
    @ADDRESSTYPECODEID uniqueidentifier,
    @ADDRESS_ADDRESSBLOCK nvarchar(150),
    @ADDRESS_CITY nvarchar(50),
    @ADDRESS_STATEID uniqueidentifier,
    @ADDRESS_POSTCODE nvarchar(12),
    @ADDRESS_COUNTRYID uniqueidentifier,
    @PHONEID uniqueidentifier,
    @PHONETYPECODEID uniqueidentifier,
    @PHONENUMBER nvarchar(100),
    @EMAILID uniqueidentifier,
    @EMAILADDRESSTYPECODEID uniqueidentifier,
    @EMAILADDRESS dbo.UDT_EMAILADDRESS,
    @CREATEDON datetime,
    @DATECHANGED datetime,
    @ADDRESSES xml,
    @PHONES xml,
    @EMAILADDRESSES xml,
    @CONSTITUENTACTION tinyint,
    @ADDRESSACTION tinyint,
    @EMAILACTION tinyint,
    @PHONEACTION tinyint,
    @PRIMARYRECORDID uniqueidentifier,
    @EMAILISPRIMARY bit,
    @PHONEISPRIMARY bit,
    @ADDRESSISPRIMARY bit
)

as
  set nocount on;

  declare @INCOMINGADDRESSID uniqueidentifier;
    declare @INCOMINGEMAILID uniqueidentifier;
    declare @INCOMINGPHONEID uniqueidentifier;
    declare @SIMILARADDRESSCODE tinyint;
    declare @UNSIMILARADDRESSCODE tinyint;
    declare @NEWADDRESSPRIMARYCODE tinyint;
    declare @DIFFERENTPHONECODE tinyint;
    declare @NEWPHONEPRIMARYCODE tinyint;
    declare @DIFFERENTEMAILCODE tinyint;
    declare @NEWEMAILPRIMARYCODE tinyint;
    declare @DECEASED bit;
    declare @DECEASEDDATE dbo.UDT_FUZZYDATE;
    declare @GIVESANONYMOUSLY bit;
    declare @MARITALSTATUSCODEID uniqueidentifier;
    declare @WEBADDRESS dbo.UDT_WEBADDRESS;
    declare @ADDRESSHISTORICALSTARTDATE date;
    declare @ADDRESSHISTORICALENDDATE date;
    declare @ADDRESSDONOTMAIL bit;
    declare @ADDRESSDONOTMAILREASONCODEID uniqueidentifier;
    declare @ADDRESSSTARTDATE dbo.UDT_MONTHDAY;
    declare @ADDRESSENDDATE dbo.UDT_MONTHDAY;
    declare @ADDRESSDPC nvarchar(max);
    declare @ADDRESSCART nvarchar(max);
    declare @ADDRESSLOT nvarchar(5);
    declare @ADDRESSINFOSOURCECODEID uniqueidentifier;
    declare @ADDRESSINFOSOURCECOMMENTS nvarchar(256);
    declare @ADDRESSCOUNTYCODEID uniqueidentifier;
    declare @ADDRESSREGIONCODEID uniqueidentifier;
    declare @ADDRESSCONGRESSIONALDISTRICTCODEID uniqueidentifier;
    declare @ADDRESSSTATEHOUSEDISTRICTCODEID uniqueidentifier;
    declare @ADDRESSSTATESENATEDISTRICTCODEID uniqueidentifier;
    declare @ADDRESSLOCALPRECINCTCODEID uniqueidentifier;
    declare @ADDRESSCERTIFICATIONDATA int;
    declare @ADDRESSLASTVALIDATIONATTEMPTDATE date;
    declare @ADDRESSOMITFROMVALIDATION bit;
    declare @ADDRESSVALIDATIONMESSAGE nvarchar(200);
    declare @PHONEDONOTCALL bit;
    declare @PHONESTARTTIME dbo.UDT_HOURMINUTE;
    declare @PHONEENDTIME dbo.UDT_HOURMINUTE;
    declare @PHONEINFOSOURCECODEID uniqueidentifier;
    declare @PHONECOUNTRYID uniqueidentifier;
    declare @PHONESTARTDATE date;
    declare @PHONEENDDATE date;
    declare @PHONESEASONALSTARTDATE dbo.UDT_MONTHDAY;
    declare @PHONESEASONALENDDATE dbo.UDT_MONTHDAY;
    declare @EMAILADDRESSDONOTEMAIL bit;
    declare @EMAILADDRESSINFOSOURCECODEID uniqueidentifier;
    declare @EMAILADDRESSSTARTDATE date;
    declare @EMAILADDRESSENDDATE date;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTUPDATEBATCHDUPLICATEMATCH
        @ID = @ID,
    @INCOMINGADDRESSID = @INCOMINGADDRESSID output,
        @INCOMINGEMAILID = @INCOMINGEMAILID output,
        @INCOMINGPHONEID = @INCOMINGPHONEID output,
        @SIMILARADDRESSCODE = @SIMILARADDRESSCODE output,
        @UNSIMILARADDRESSCODE = @UNSIMILARADDRESSCODE output,
        @NEWADDRESSPRIMARYCODE = @NEWADDRESSPRIMARYCODE output,
        @DIFFERENTPHONECODE = @DIFFERENTPHONECODE output,
        @NEWPHONEPRIMARYCODE = @NEWPHONEPRIMARYCODE output,
        @DIFFERENTEMAILCODE = @DIFFERENTEMAILCODE output,
        @NEWEMAILPRIMARYCODE = @NEWEMAILPRIMARYCODE output,
        @DECEASED = @DECEASED output,
        @DECEASEDDATE = @DECEASEDDATE output,
        @GIVESANONYMOUSLY = @GIVESANONYMOUSLY output,
        @MARITALSTATUSCODEID = @MARITALSTATUSCODEID output,
        @WEBADDRESS = @WEBADDRESS output,
        @DECEASED = @DECEASED output,
        @DECEASEDDATE = @DECEASEDDATE output,
        @GIVESANONYMOUSLY = @GIVESANONYMOUSLY output,
        @MARITALSTATUSCODEID = @MARITALSTATUSCODEID output,
        @WEBADDRESS = @WEBADDRESS output,
        @ADDRESSHISTORICALSTARTDATE = @ADDRESSHISTORICALSTARTDATE output,
        @ADDRESSHISTORICALENDDATE = @ADDRESSHISTORICALENDDATE output,
        @ADDRESSDONOTMAIL = @ADDRESSDONOTMAIL output,
        @ADDRESSDONOTMAILREASONCODEID = @ADDRESSDONOTMAILREASONCODEID output,
        @ADDRESSSTARTDATE = @ADDRESSSTARTDATE output,
        @ADDRESSENDDATE = @ADDRESSENDDATE output,
        @ADDRESSDPC = @ADDRESSDPC output,
        @ADDRESSCART = @ADDRESSCART output,
        @ADDRESSLOT = @ADDRESSLOT output,
        @ADDRESSINFOSOURCECODEID = @ADDRESSINFOSOURCECODEID output,
        @ADDRESSINFOSOURCECOMMENTS = @ADDRESSINFOSOURCECOMMENTS output,
        @ADDRESSCOUNTYCODEID = @ADDRESSCOUNTYCODEID output,
        @ADDRESSREGIONCODEID = @ADDRESSREGIONCODEID output,
        @ADDRESSCONGRESSIONALDISTRICTCODEID = @ADDRESSCONGRESSIONALDISTRICTCODEID output,
        @ADDRESSSTATEHOUSEDISTRICTCODEID = @ADDRESSSTATEHOUSEDISTRICTCODEID output,
        @ADDRESSSTATESENATEDISTRICTCODEID = @ADDRESSSTATESENATEDISTRICTCODEID output,
        @ADDRESSLOCALPRECINCTCODEID = @ADDRESSLOCALPRECINCTCODEID output,
        @ADDRESSCERTIFICATIONDATA = @ADDRESSCERTIFICATIONDATA output,
        @ADDRESSLASTVALIDATIONATTEMPTDATE = @ADDRESSLASTVALIDATIONATTEMPTDATE output,
        @ADDRESSOMITFROMVALIDATION = @ADDRESSOMITFROMVALIDATION output,
        @ADDRESSVALIDATIONMESSAGE = @ADDRESSVALIDATIONMESSAGE output,
        @PHONEDONOTCALL = @PHONEDONOTCALL output,
        @PHONESTARTTIME = @PHONESTARTTIME output,
        @PHONEENDTIME = @PHONEENDTIME output,
        @PHONEINFOSOURCECODEID = @PHONEINFOSOURCECODEID output,
        @PHONECOUNTRYID = @PHONECOUNTRYID output,
        @PHONESTARTDATE = @PHONESTARTDATE output,
        @PHONEENDDATE = @PHONEENDDATE output,
        @PHONESEASONALSTARTDATE = @PHONESEASONALSTARTDATE output,
        @PHONESEASONALENDDATE = @PHONESEASONALENDDATE output,
        @EMAILADDRESSDONOTEMAIL = @EMAILADDRESSDONOTEMAIL output,
        @EMAILADDRESSINFOSOURCECODEID = @EMAILADDRESSINFOSOURCECODEID output,
        @EMAILADDRESSSTARTDATE = @EMAILADDRESSSTARTDATE output,
        @EMAILADDRESSENDDATE = @EMAILADDRESSENDDATE output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTUPDATEBATCHDUPLICATEMATCH_3
        @ID,
        @CHANGEAGENTID,
        @LOOKUPID,
        @FIRSTNAME,
        @MIDDLENAME,
        @LASTNAME,
        @SUFFIXCODEID,
        @TITLECODEID,
        @MAIDENNAME,
        @NICKNAME,
        @GENDERCODE,
        @BIRTHDATE,
        @ADDRESSID,
        @ADDRESSTYPECODEID,
        @ADDRESS_ADDRESSBLOCK,
        @ADDRESS_CITY,
        @ADDRESS_STATEID,
        @ADDRESS_POSTCODE,
        @ADDRESS_COUNTRYID,
        @PHONEID,
        @PHONETYPECODEID,
        @PHONENUMBER,
        @EMAILID,
        @EMAILADDRESSTYPECODEID,
        @EMAILADDRESS,
        @CREATEDON,
        @DATECHANGED,
        @ADDRESSES,
        @PHONES,
        @EMAILADDRESSES,
        @CONSTITUENTACTION,
        @ADDRESSACTION,
        @EMAILACTION,
        @PHONEACTION,
        @PRIMARYRECORDID,
        @EMAILISPRIMARY,
        @PHONEISPRIMARY,
        @ADDRESSISPRIMARY,
    @INCOMINGADDRESSID,
        @INCOMINGEMAILID,
        @INCOMINGPHONEID,
        @SIMILARADDRESSCODE,
        @UNSIMILARADDRESSCODE,
        @NEWADDRESSPRIMARYCODE,
        @DIFFERENTPHONECODE,
        @NEWPHONEPRIMARYCODE,
        @DIFFERENTEMAILCODE,
        @NEWEMAILPRIMARYCODE,
        @DECEASED,
        @DECEASEDDATE,
        @GIVESANONYMOUSLY,
        @MARITALSTATUSCODEID,
        @WEBADDRESS,
        @DECEASED,
        @DECEASEDDATE,
        @GIVESANONYMOUSLY,
        @MARITALSTATUSCODEID,
        @WEBADDRESS,
        @ADDRESSHISTORICALSTARTDATE,
        @ADDRESSHISTORICALENDDATE,
        @ADDRESSDONOTMAIL,
        @ADDRESSDONOTMAILREASONCODEID,
        @ADDRESSSTARTDATE,
        @ADDRESSENDDATE,
        @ADDRESSDPC,
        @ADDRESSCART,
        @ADDRESSLOT,
        @ADDRESSINFOSOURCECODEID,
        @ADDRESSINFOSOURCECOMMENTS,
        @ADDRESSCOUNTYCODEID,
        @ADDRESSREGIONCODEID,
        @ADDRESSCONGRESSIONALDISTRICTCODEID,
        @ADDRESSSTATEHOUSEDISTRICTCODEID,
        @ADDRESSSTATESENATEDISTRICTCODEID,
        @ADDRESSLOCALPRECINCTCODEID,
        @ADDRESSCERTIFICATIONDATA,
        @ADDRESSLASTVALIDATIONATTEMPTDATE,
        @ADDRESSOMITFROMVALIDATION,
        @ADDRESSVALIDATIONMESSAGE,
        @PHONEDONOTCALL,
        @PHONESTARTTIME,
        @PHONEENDTIME,
        @PHONEINFOSOURCECODEID,
        @PHONECOUNTRYID,
        @PHONESTARTDATE,
        @PHONEENDDATE,
        @PHONESEASONALSTARTDATE,
        @PHONESEASONALENDDATE,
        @EMAILADDRESSDONOTEMAIL,
        @EMAILADDRESSINFOSOURCECODEID,
        @EMAILADDRESSSTARTDATE,
        @EMAILADDRESSENDDATE

  return 0;