USP_DATAFORMTEMPLATE_EDIT_BATCHCONSTITUENTUPDATEBATCHROW_13

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN
@CHANGEAGENTID uniqueidentifier IN
@SEQUENCE int IN
@PRIMARYRECORDID uniqueidentifier IN
@CONSTITUENTTYPECODE tinyint IN
@BIRTHDATE UDT_FUZZYDATE IN
@FIRSTNAME nvarchar(50) IN
@GENDERCODE tinyint IN
@GIVESANONYMOUSLY bit IN
@KEYNAME nvarchar(100) IN
@LOOKUP_ID nvarchar(100) IN
@MAIDENNAME nvarchar(100) IN
@MIDDLENAME nvarchar(50) IN
@NICKNAME nvarchar(50) IN
@SUFFIXCODEID uniqueidentifier IN
@TITLECODEID uniqueidentifier IN
@WEBADDRESS UDT_WEBADDRESS IN
@ALTERNATELOOKUPIDS xml IN
@SECURITYATTRIBUTES xml IN
@DECEASED bit IN
@DECEASEDDATE UDT_FUZZYDATE IN
@CONSTITUENT_SITEID uniqueidentifier IN
@INTERESTS xml IN
@PROSPECTMANAGERFUNDRAISERID uniqueidentifier IN
@ADDRESSES xml IN
@PHONES xml IN
@EMAILADDRESSES xml IN
@CONSTITUENCIES xml IN
@GROUPTYPEID uniqueidentifier IN
@GROUPDESCRIPTION nvarchar(300) IN
@GROUPSTARTDATE datetime IN
@ORG_INDUSTRYCODEID uniqueidentifier IN
@ORG_NUMEMPLOYEES int IN
@ORG_NUMSUBSIDIARIES int IN
@ORG_PARENTCORPID uniqueidentifier IN
@MARITALSTATUSCODEID uniqueidentifier IN
@SPOUSE_ID uniqueidentifier IN
@SPOUSE_TITLECODEID uniqueidentifier IN
@SPOUSE_FIRSTNAME nvarchar(50) IN
@SPOUSE_NICKNAME nvarchar(50) IN
@SPOUSE_MIDDLENAME nvarchar(50) IN
@SPOUSE_MAIDENNAME nvarchar(100) IN
@SPOUSE_LASTNAME nvarchar(100) IN
@SPOUSE_SUFFIXCODEID uniqueidentifier IN
@SPOUSE_BIRTHDATE UDT_FUZZYDATE IN
@SPOUSE_GENDERCODE tinyint IN
@SPOUSE_LOOKUPID nvarchar(100) IN
@SPOUSE_RELATIONSHIPTYPECODEID uniqueidentifier IN
@SPOUSE_RECIPROCALTYPECODEID uniqueidentifier IN
@BUSINESS_ID uniqueidentifier IN
@BUSINESS_ADDRESSBLOCK nvarchar(150) IN
@BUSINESS_ADDRESSTYPECODEID uniqueidentifier IN
@BUSINESS_CART nvarchar(10) IN
@BUSINESS_CITY nvarchar(50) IN
@BUSINESS_COUNTRYID uniqueidentifier IN
@BUSINESS_DONOTMAIL bit IN
@BUSINESS_DONOTMAILREASONCODEID uniqueidentifier IN
@BUSINESS_DPC nvarchar(8) IN
@BUSINESS_EMAILADDRESS UDT_EMAILADDRESS IN
@BUSINESS_EMAILADDRESSTYPECODEID uniqueidentifier IN
@BUSINESS_INDUSTRYCODEID uniqueidentifier IN
@BUSINESS_LOOKUPID nvarchar(100) IN
@BUSINESS_LOT nvarchar(5) IN
@BUSINESS_NAME nvarchar(100) IN
@BUSINESS_NUMEMPLOYEES int IN
@BUSINESS_NUMSUBSIDIARIES int IN
@BUSINESS_PARENTCORPID uniqueidentifier IN
@BUSINESS_PHONENUMBER nvarchar(100) IN
@BUSINESS_PHONE_COUNTRYID uniqueidentifier IN
@BUSINESS_PHONETYPECODEID uniqueidentifier IN
@BUSINESS_RELATIONSHIPTYPECODEID uniqueidentifier IN
@BUSINESS_RECIPROCALTYPECODEID uniqueidentifier IN
@BUSINESS_STATEID uniqueidentifier IN
@BUSINESS_WEBADDRESS UDT_WEBADDRESS IN
@BUSINESS_POSTCODE nvarchar(12) IN
@SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST uniqueidentifier IN
@SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST uniqueidentifier IN
@BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST uniqueidentifier IN
@BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST uniqueidentifier IN
@BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit IN
@BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR decimal(5, 2) IN
@BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit IN
@BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR decimal(5, 2) IN
@BUSINESS_PRIMARYRECOGNITIONTYPECODEID uniqueidentifier IN
@BUSINESS_RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier IN
@BUSINESS_EMAILADDRESSSTARTDATE date IN
@SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit IN
@SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR decimal(5, 2) IN
@SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit IN
@SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR decimal(5, 2) IN
@SPOUSE_PRIMARYRECOGNITIONTYPECODEID uniqueidentifier IN
@SPOUSE_RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier IN
@CONSTITUENT_SITES xml IN
@SPOUSE_ALTERNATELOOKUPIDS xml IN
@SPOUSE_IMPORTLOOKUPID nvarchar(100) IN
@ROWFROMBATCHUI bit IN
@BBNCTRANID int IN
@PAGEID int IN
@PAGENAME nvarchar(100) IN
@BBNCUSERID int IN
@REMOVESPOUSE bit IN
@DUPLICATERECORDID uniqueidentifier IN
@SOCIALMEDIAACCOUNTS xml IN
@RELATIONSHIPS xml IN
@NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier IN
@BBNCID int IN
@NAMECODE tinyint IN
@SIMILARADDRESSCODE tinyint IN
@UNSIMILARADDRESSCODE tinyint IN
@NEWADDRESSENDDATECODE tinyint IN
@NEWADDRESSPRIMARYCODE tinyint IN
@BIRTHDATERULECODE tinyint IN
@DIFFERENTPHONECODE tinyint IN
@NEWPHONEENDDATECODE tinyint IN
@NEWPHONEPRIMARYCODE tinyint IN
@DIFFERENTEMAILCODE tinyint IN
@NEWEMAILENDDATECODE tinyint IN
@NEWEMAILPRIMARYCODE tinyint IN
@USEGLOBALSETTINGS bit IN
@CREATEHISTORICALNAMECODE tinyint IN
@NAMEFORMATS xml IN
@SUBMITTEDLOOKUPID nvarchar(100) IN
@SUBMITTEDCLASSYEAR nvarchar(4) IN
@SUBMITTEDEDUCATIONALINSTITUTION nvarchar(100) IN
@DOMANUALREVIEWFORAUTOMATCH bit IN
@REQUESTSNOEMAIL bit IN

Definition

Copy 


CREATE procedure USP_DATAFORMTEMPLATE_EDIT_BATCHCONSTITUENTUPDATEBATCHROW_13
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @SEQUENCE int,
    @PRIMARYRECORDID uniqueidentifier,
    @CONSTITUENTTYPECODE tinyint,
    @BIRTHDATE dbo.UDT_FUZZYDATE,
    @FIRSTNAME nvarchar(50),
    @GENDERCODE tinyint,
    @GIVESANONYMOUSLY bit,
    @KEYNAME nvarchar(100),
    @LOOKUP_ID nvarchar(100),
    @MAIDENNAME nvarchar(100),
    @MIDDLENAME nvarchar(50),
    @NICKNAME nvarchar(50),
    @SUFFIXCODEID uniqueidentifier,
    @TITLECODEID uniqueidentifier,
    @WEBADDRESS dbo.UDT_WEBADDRESS,
    @ALTERNATELOOKUPIDS xml,
    @SECURITYATTRIBUTES xml,
    @DECEASED bit,
    @DECEASEDDATE dbo.UDT_FUZZYDATE,
    @CONSTITUENT_SITEID uniqueidentifier,
    @INTERESTS xml,
    @PROSPECTMANAGERFUNDRAISERID uniqueidentifier,
    @ADDRESSES xml,
    @PHONES xml,
    @EMAILADDRESSES xml,
    @CONSTITUENCIES xml,
    @GROUPTYPEID uniqueidentifier,
    @GROUPDESCRIPTION nvarchar(300),
    @GROUPSTARTDATE datetime,
    @ORG_INDUSTRYCODEID uniqueidentifier,
    @ORG_NUMEMPLOYEES int,
    @ORG_NUMSUBSIDIARIES int,
    @ORG_PARENTCORPID uniqueidentifier,
    @MARITALSTATUSCODEID uniqueidentifier,
    @SPOUSE_ID uniqueidentifier,
    @SPOUSE_TITLECODEID uniqueidentifier,
    @SPOUSE_FIRSTNAME nvarchar(50),
    @SPOUSE_NICKNAME nvarchar(50),
    @SPOUSE_MIDDLENAME nvarchar(50),
    @SPOUSE_MAIDENNAME nvarchar(100),
    @SPOUSE_LASTNAME nvarchar(100),
    @SPOUSE_SUFFIXCODEID uniqueidentifier,
    @SPOUSE_BIRTHDATE dbo.UDT_FUZZYDATE,
    @SPOUSE_GENDERCODE tinyint,
    @SPOUSE_LOOKUPID nvarchar(100),
    @SPOUSE_RELATIONSHIPTYPECODEID uniqueidentifier,
    @SPOUSE_RECIPROCALTYPECODEID uniqueidentifier,
    @BUSINESS_ID uniqueidentifier,
    @BUSINESS_ADDRESSBLOCK nvarchar(150),
    @BUSINESS_ADDRESSTYPECODEID uniqueidentifier,
    @BUSINESS_CART nvarchar(10),
    @BUSINESS_CITY nvarchar(50),
    @BUSINESS_COUNTRYID uniqueidentifier,
    @BUSINESS_DONOTMAIL bit,
    @BUSINESS_DONOTMAILREASONCODEID uniqueidentifier,
    @BUSINESS_DPC nvarchar(8),
    @BUSINESS_EMAILADDRESS dbo.UDT_EMAILADDRESS,
    @BUSINESS_EMAILADDRESSTYPECODEID uniqueidentifier,
    @BUSINESS_INDUSTRYCODEID uniqueidentifier,
    @BUSINESS_LOOKUPID nvarchar(100),
    @BUSINESS_LOT nvarchar(5),
    @BUSINESS_NAME nvarchar(100),
    @BUSINESS_NUMEMPLOYEES int,
    @BUSINESS_NUMSUBSIDIARIES int,
    @BUSINESS_PARENTCORPID uniqueidentifier,
    @BUSINESS_PHONENUMBER nvarchar(100),
    @BUSINESS_PHONE_COUNTRYID uniqueidentifier,
    @BUSINESS_PHONETYPECODEID uniqueidentifier,
    @BUSINESS_RELATIONSHIPTYPECODEID uniqueidentifier,
    @BUSINESS_RECIPROCALTYPECODEID uniqueidentifier,
    @BUSINESS_STATEID uniqueidentifier,
    @BUSINESS_WEBADDRESS dbo.UDT_WEBADDRESS,
    @BUSINESS_POSTCODE nvarchar(12),
    @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST uniqueidentifier,
    @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST uniqueidentifier,
    @BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST uniqueidentifier,
    @BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST uniqueidentifier,
    @BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit,
    @BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR decimal(5,2),
    @BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit,
    @BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR decimal(5,2),
    @BUSINESS_PRIMARYRECOGNITIONTYPECODEID uniqueidentifier,
    @BUSINESS_RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier,
    @BUSINESS_EMAILADDRESSSTARTDATE date,
    @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit,
    @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR decimal(5,2),
    @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit,
    @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR decimal(5,2),
    @SPOUSE_PRIMARYRECOGNITIONTYPECODEID uniqueidentifier,
    @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier,
    @CONSTITUENT_SITES xml,
    @SPOUSE_ALTERNATELOOKUPIDS xml,
    @SPOUSE_IMPORTLOOKUPID nvarchar(100),
    @ROWFROMBATCHUI bit,
    @BBNCTRANID int,
    @PAGEID int,
    @PAGENAME nvarchar(100),
    @BBNCUSERID int,
    @REMOVESPOUSE bit,
    @DUPLICATERECORDID uniqueidentifier,
    @SOCIALMEDIAACCOUNTS xml,
    @RELATIONSHIPS xml,
    @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
    @BBNCID int,
    @NAMECODE tinyint,
    @SIMILARADDRESSCODE tinyint,
    @UNSIMILARADDRESSCODE tinyint,
    @NEWADDRESSENDDATECODE tinyint,
    @NEWADDRESSPRIMARYCODE tinyint,
    @BIRTHDATERULECODE tinyint,
    @DIFFERENTPHONECODE tinyint,
    @NEWPHONEENDDATECODE tinyint,
    @NEWPHONEPRIMARYCODE tinyint,
    @DIFFERENTEMAILCODE tinyint,
    @NEWEMAILENDDATECODE tinyint,
    @NEWEMAILPRIMARYCODE tinyint,
    @USEGLOBALSETTINGS bit,
    @CREATEHISTORICALNAMECODE tinyint,
    @NAMEFORMATS xml,
    @SUBMITTEDLOOKUPID nvarchar(100),
    @SUBMITTEDCLASSYEAR nvarchar(4),
    @SUBMITTEDEDUCATIONALINSTITUTION nvarchar(100),
    @DOMANUALREVIEWFORAUTOMATCH bit,
    @REQUESTSNOEMAIL bit
)

as
  set nocount on;

    declare @ORIGINAL_KEYNAME nvarchar(100);
    declare @ORIGINAL_FIRSTNAME nvarchar(50);

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHCONSTITUENTUPDATEBATCHROW
        @ID = @ID,
        @ORIGINAL_KEYNAME = @ORIGINAL_KEYNAME output,
        @ORIGINAL_FIRSTNAME = @ORIGINAL_FIRSTNAME output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHCONSTITUENTUPDATEBATCHROW_14
        @ID,
        @CHANGEAGENTID,
        @SEQUENCE,
        @PRIMARYRECORDID,
        @CONSTITUENTTYPECODE,
        @BIRTHDATE,
        @FIRSTNAME,
        @GENDERCODE,
        @GIVESANONYMOUSLY,
        @KEYNAME,
        @LOOKUP_ID,
        @MAIDENNAME,
        @MIDDLENAME,
        @NICKNAME,
        @SUFFIXCODEID,
        @TITLECODEID,
        @WEBADDRESS,
        @ALTERNATELOOKUPIDS,
        @SECURITYATTRIBUTES,
        @DECEASED,
        @DECEASEDDATE,
        @CONSTITUENT_SITEID,
        @INTERESTS,
        @PROSPECTMANAGERFUNDRAISERID,
        @ADDRESSES,
        @PHONES,
        @EMAILADDRESSES,
        @CONSTITUENCIES,
        @GROUPTYPEID,
        @GROUPDESCRIPTION,
        @GROUPSTARTDATE,
        @ORG_INDUSTRYCODEID,
        @ORG_NUMEMPLOYEES,
        @ORG_NUMSUBSIDIARIES,
        @ORG_PARENTCORPID,
        @MARITALSTATUSCODEID,
        @SPOUSE_ID,
        @SPOUSE_TITLECODEID,
        @SPOUSE_FIRSTNAME,
        @SPOUSE_NICKNAME,
        @SPOUSE_MIDDLENAME,
        @SPOUSE_MAIDENNAME,
        @SPOUSE_LASTNAME,
        @SPOUSE_SUFFIXCODEID,
        @SPOUSE_BIRTHDATE,
        @SPOUSE_GENDERCODE,
        @SPOUSE_LOOKUPID,
        @SPOUSE_RELATIONSHIPTYPECODEID,
        @SPOUSE_RECIPROCALTYPECODEID,
        @BUSINESS_ID,
        @BUSINESS_ADDRESSBLOCK,
        @BUSINESS_ADDRESSTYPECODEID,
        @BUSINESS_CART,
        @BUSINESS_CITY,
        @BUSINESS_COUNTRYID,
        @BUSINESS_DONOTMAIL,
        @BUSINESS_DONOTMAILREASONCODEID,
        @BUSINESS_DPC,
        @BUSINESS_EMAILADDRESS,
        @BUSINESS_EMAILADDRESSTYPECODEID,
        @BUSINESS_INDUSTRYCODEID,
        @BUSINESS_LOOKUPID,
        @BUSINESS_LOT,
        @BUSINESS_NAME,
        @BUSINESS_NUMEMPLOYEES,
        @BUSINESS_NUMSUBSIDIARIES,
        @BUSINESS_PARENTCORPID,
        @BUSINESS_PHONENUMBER,
        @BUSINESS_PHONE_COUNTRYID,
        @BUSINESS_PHONETYPECODEID,
        @BUSINESS_RELATIONSHIPTYPECODEID,
        @BUSINESS_RECIPROCALTYPECODEID,
        @BUSINESS_STATEID,
        @BUSINESS_WEBADDRESS,
        @BUSINESS_POSTCODE,
        @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST,
        @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST,
        @BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST,
        @BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST,
        @BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
        @BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR,
        @BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
        @BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR,
        @BUSINESS_PRIMARYRECOGNITIONTYPECODEID,
        @BUSINESS_RECIPROCALRECOGNITIONTYPECODEID,
        @BUSINESS_EMAILADDRESSSTARTDATE,
        @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
        @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR,
        @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
        @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR,
        @SPOUSE_PRIMARYRECOGNITIONTYPECODEID,
        @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID,
        @CONSTITUENT_SITES,
        @SPOUSE_ALTERNATELOOKUPIDS,
        @SPOUSE_IMPORTLOOKUPID,
        @ROWFROMBATCHUI,
        @BBNCTRANID,
        @PAGEID,
        @PAGENAME,
        @BBNCUSERID,
        @REMOVESPOUSE,
        @DUPLICATERECORDID,
        @SOCIALMEDIAACCOUNTS,
        @RELATIONSHIPS,
        @NETCOMMUNITYTRANSACTIONPROCESSORID,
        @BBNCID,
        @NAMECODE,
        @SIMILARADDRESSCODE,
        @UNSIMILARADDRESSCODE,
        @NEWADDRESSENDDATECODE,
        @NEWADDRESSPRIMARYCODE,
        @BIRTHDATERULECODE,
        @DIFFERENTPHONECODE,
        @NEWPHONEENDDATECODE,
        @NEWPHONEPRIMARYCODE,
        @DIFFERENTEMAILCODE,
        @NEWEMAILENDDATECODE,
        @NEWEMAILPRIMARYCODE,
        @USEGLOBALSETTINGS,
        @CREATEHISTORICALNAMECODE,
        @NAMEFORMATS,
        @SUBMITTEDLOOKUPID,
        @SUBMITTEDCLASSYEAR,
        @SUBMITTEDEDUCATIONALINSTITUTION,
        @DOMANUALREVIEWFORAUTOMATCH,
        @REQUESTSNOEMAIL,
        @ORIGINAL_KEYNAME,
        @ORIGINAL_FIRSTNAME

  return 0;