USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTDUPLICATEMATCH_3

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
@EMAILS	xml	IN
@SPOUSENAME	nvarchar(154)	IN
@SPOUSELOOKUPID	nvarchar(50)	IN
@SPOUSESTARTDATE	datetime	IN
@SPOUSEENDDATE	datetime	IN
@HOUSEHOLDNAME	nvarchar(154)	IN
@HOUSEHOLDLOOKUPID	nvarchar(50)	IN
@BUSINESSNAME	nvarchar(154)	IN
@BUSINESSLOOKUPID	nvarchar(50)	IN
@CONSTITUENTACTION	tinyint	IN
@ADDRESSACTION	tinyint	IN
@EMAILACTION	tinyint	IN
@PHONEACTION	tinyint	IN
@ISORGANIZATION	bit	IN
@INDUSTRYCODEID	uniqueidentifier	IN
@NUMEMPLOYEES	int	IN
@NUMSUBSIDIARIES	int	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

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTDUPLICATEMATCH_3
(
    @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,
    @EMAILS xml,
    @SPOUSENAME nvarchar(154),
    @SPOUSELOOKUPID nvarchar(50),
    @SPOUSESTARTDATE datetime,
    @SPOUSEENDDATE datetime,
    @HOUSEHOLDNAME nvarchar(154),
    @HOUSEHOLDLOOKUPID nvarchar(50),
    @BUSINESSNAME nvarchar(154),
    @BUSINESSLOOKUPID nvarchar(50),
    @CONSTITUENTACTION tinyint,
    @ADDRESSACTION tinyint,
    @EMAILACTION tinyint,
    @PHONEACTION tinyint,
    @ISORGANIZATION bit,
    @INDUSTRYCODEID uniqueidentifier,
    @NUMEMPLOYEES int,
    @NUMSUBSIDIARIES int,
    @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
)

as
  set nocount on;

    declare @GENDERCODEID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTDUPLICATEMATCH
        @ID = @ID,
        @GENDERCODEID = @GENDERCODEID output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTDUPLICATEMATCH_4
        @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,
        @EMAILS,
        @SPOUSENAME,
        @SPOUSELOOKUPID,
        @SPOUSESTARTDATE,
        @SPOUSEENDDATE,
        @HOUSEHOLDNAME,
        @HOUSEHOLDLOOKUPID,
        @BUSINESSNAME,
        @BUSINESSLOOKUPID,
        @CONSTITUENTACTION,
        @ADDRESSACTION,
        @EMAILACTION,
        @PHONEACTION,
        @ISORGANIZATION,
        @INDUSTRYCODEID,
        @NUMEMPLOYEES,
        @NUMSUBSIDIARIES,
        @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,
        @GENDERCODEID

  return 0;