USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTUPDATEBATCHDUPLICATEMATCH_5

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
@INCOMINGADDRESSID	uniqueidentifier	IN
@INCOMINGEMAILID	uniqueidentifier	IN
@INCOMINGPHONEID	uniqueidentifier	IN
@SIMILARADDRESSCODE	tinyint	IN
@UNSIMILARADDRESSCODE	tinyint	IN
@NEWADDRESSPRIMARYCODE	tinyint	IN
@DIFFERENTPHONECODE	tinyint	IN
@NEWPHONEPRIMARYCODE	tinyint	IN
@DIFFERENTEMAILCODE	tinyint	IN
@NEWEMAILPRIMARYCODE	tinyint	IN
@DECEASED	bit	IN
@DECEASEDDATE	UDT_FUZZYDATE	IN
@GIVESANONYMOUSLY	bit	IN
@MARITALSTATUSCODEID	uniqueidentifier	IN
@WEBADDRESS	UDT_WEBADDRESS	IN
@ADDRESSHISTORICALSTARTDATE	date	IN
@ADDRESSHISTORICALENDDATE	date	IN
@ADDRESSDONOTMAIL	bit	IN
@ADDRESSDONOTMAILREASONCODEID	uniqueidentifier	IN
@ADDRESSSTARTDATE	UDT_MONTHDAY	IN
@ADDRESSENDDATE	UDT_MONTHDAY	IN
@ADDRESSDPC	nvarchar(max)	IN
@ADDRESSCART	nvarchar(max)	IN
@ADDRESSLOT	nvarchar(5)	IN
@ADDRESSINFOSOURCECODEID	uniqueidentifier	IN
@ADDRESSINFOSOURCECOMMENTS	nvarchar(256)	IN
@ADDRESSCOUNTYCODEID	uniqueidentifier	IN
@ADDRESSREGIONCODEID	uniqueidentifier	IN
@ADDRESSCONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN
@ADDRESSSTATEHOUSEDISTRICTCODEID	uniqueidentifier	IN
@ADDRESSSTATESENATEDISTRICTCODEID	uniqueidentifier	IN
@ADDRESSLOCALPRECINCTCODEID	uniqueidentifier	IN
@ADDRESSCERTIFICATIONDATA	int	IN
@ADDRESSLASTVALIDATIONATTEMPTDATE	date	IN
@ADDRESSOMITFROMVALIDATION	bit	IN
@ADDRESSVALIDATIONMESSAGE	nvarchar(200)	IN
@PHONEDONOTCALL	bit	IN
@PHONESTARTTIME	UDT_HOURMINUTE	IN
@PHONEENDTIME	UDT_HOURMINUTE	IN
@PHONEINFOSOURCECODEID	uniqueidentifier	IN
@PHONECOUNTRYID	uniqueidentifier	IN
@PHONESTARTDATE	date	IN
@PHONEENDDATE	date	IN
@PHONESEASONALSTARTDATE	UDT_MONTHDAY	IN
@PHONESEASONALENDDATE	UDT_MONTHDAY	IN
@EMAILADDRESSDONOTEMAIL	bit	IN
@EMAILADDRESSINFOSOURCECODEID	uniqueidentifier	IN
@EMAILADDRESSSTARTDATE	date	IN
@EMAILADDRESSENDDATE	date	IN
@CONSTITUENCIES	xml	IN
@ORIGINAL_KEYNAME	nvarchar(100)	IN
@ORIGINAL_FIRSTNAME	nvarchar(50)	IN

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTUPDATEBATCHDUPLICATEMATCH_5
(
    @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,
    @INCOMINGADDRESSID uniqueidentifier,
    @INCOMINGEMAILID uniqueidentifier,
    @INCOMINGPHONEID uniqueidentifier,
    @SIMILARADDRESSCODE tinyint,
    @UNSIMILARADDRESSCODE tinyint,
    @NEWADDRESSPRIMARYCODE tinyint,
    @DIFFERENTPHONECODE tinyint,
    @NEWPHONEPRIMARYCODE tinyint,
    @DIFFERENTEMAILCODE tinyint,
    @NEWEMAILPRIMARYCODE tinyint,
    @DECEASED bit,
    @DECEASEDDATE dbo.UDT_FUZZYDATE,
    @GIVESANONYMOUSLY bit,
    @MARITALSTATUSCODEID uniqueidentifier,
    @WEBADDRESS dbo.UDT_WEBADDRESS,
    @ADDRESSHISTORICALSTARTDATE date,
    @ADDRESSHISTORICALENDDATE date,
    @ADDRESSDONOTMAIL bit,
    @ADDRESSDONOTMAILREASONCODEID uniqueidentifier,
    @ADDRESSSTARTDATE dbo.UDT_MONTHDAY,
    @ADDRESSENDDATE dbo.UDT_MONTHDAY,
    @ADDRESSDPC nvarchar(max),
    @ADDRESSCART nvarchar(max),
    @ADDRESSLOT nvarchar(5),
    @ADDRESSINFOSOURCECODEID uniqueidentifier,
    @ADDRESSINFOSOURCECOMMENTS nvarchar(256),
    @ADDRESSCOUNTYCODEID uniqueidentifier,
    @ADDRESSREGIONCODEID uniqueidentifier,
    @ADDRESSCONGRESSIONALDISTRICTCODEID uniqueidentifier,
    @ADDRESSSTATEHOUSEDISTRICTCODEID uniqueidentifier,
    @ADDRESSSTATESENATEDISTRICTCODEID uniqueidentifier,
    @ADDRESSLOCALPRECINCTCODEID uniqueidentifier,
    @ADDRESSCERTIFICATIONDATA int,
    @ADDRESSLASTVALIDATIONATTEMPTDATE date,
    @ADDRESSOMITFROMVALIDATION bit,
    @ADDRESSVALIDATIONMESSAGE nvarchar(200),
    @PHONEDONOTCALL bit,
    @PHONESTARTTIME dbo.UDT_HOURMINUTE,
    @PHONEENDTIME dbo.UDT_HOURMINUTE,
    @PHONEINFOSOURCECODEID uniqueidentifier,
    @PHONECOUNTRYID uniqueidentifier,
    @PHONESTARTDATE date,
    @PHONEENDDATE date,
    @PHONESEASONALSTARTDATE dbo.UDT_MONTHDAY,
    @PHONESEASONALENDDATE dbo.UDT_MONTHDAY,
    @EMAILADDRESSDONOTEMAIL bit,
    @EMAILADDRESSINFOSOURCECODEID uniqueidentifier,
    @EMAILADDRESSSTARTDATE date,
    @EMAILADDRESSENDDATE date,
    @CONSTITUENCIES xml,
    @ORIGINAL_KEYNAME nvarchar(100),
    @ORIGINAL_FIRSTNAME nvarchar(50)
)

as
  set nocount on;

    declare @SOLICITCODES xml;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTUPDATEBATCHDUPLICATEMATCH
        @ID = @ID,
        @SOLICITCODES = @SOLICITCODES output;

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTUPDATEBATCHDUPLICATEMATCH_6
        @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,
        @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,
        @CONSTITUENCIES,
        @ORIGINAL_KEYNAME,
        @ORIGINAL_FIRSTNAME,
        @SOLICITCODES;

  return 0;