USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTDUPLICATEMATCH

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

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTDUPLICATEMATCH
(
    @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
)

as
  set nocount on;

    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_CONSTITUENTDUPLICATEMATCH
        @ID = @ID,
        @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_CONSTITUENTDUPLICATEMATCH_2
        @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

  return 0;