USP_DATAFORMTEMPLATE_EDIT_BATCHCONSTITUENTUPDATEBATCHROW_12

Parameters

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

Definition

Copy



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

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHCONSTITUENTUPDATEBATCHROW 
      @ID = @ID, 
      @REQUESTSNOEMAIL = @REQUESTSNOEMAIL;

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHCONSTITUENTUPDATEBATCHROW_13
          @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,
          --@EDUCATIONALINVOLVEMENTS,

          @ADDRESSES,
          @EMAILADDRESSES,
          @PHONES,
          @CONSTITUENCIES,
          @GROUPTYPEID,
          @GROUPDESCRIPTION,
          @GROUPSTARTDATE,
          @ORG_INDUSTRYCODEID,
          @ORG_NUMEMPLOYEES,
          @ORG_NUMSUBSIDIARIES,
          @ORG_PARENTCORPID,
          @MARITALSTATUSCODEID,
          @SPOUSE_ID,
          @SPOUSE_BIRTHDATE,
          @SPOUSE_FIRSTNAME,
          @SPOUSE_GENDERCODE,
          @SPOUSE_LASTNAME,
          @SPOUSE_LOOKUPID,
          @SPOUSE_MAIDENNAME,
          @SPOUSE_MIDDLENAME,
          @SPOUSE_NICKNAME,
          @SPOUSE_SUFFIXCODEID,
          @SPOUSE_TITLECODEID,
          @SPOUSE_RELATIONSHIPTYPECODEID,
          @SPOUSE_RECIPROCALTYPECODEID,
          @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_ID,
          @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,
          @ROWFROMBATCHUI,
          @BBNCTRANID,
          @REMOVESPOUSE,
          @SOCIALMEDIAACCOUNTS,
          @RELATIONSHIPS,
      @NETCOMMUNITYTRANSACTIONPROCESSORID,
      @BBNCID,
      @NAMECODE,
      @SIMILARADDRESSCODE,
      @UNSIMILARADDRESSCODE,
      @NEWADDRESSENDDATECODE,
      @NEWADDRESSPRIMARYCODE,
      @BIRTHDATERULECODE,
      @DIFFERENTPHONECODE,
      @NEWPHONEENDDATECODE,
      @NEWPHONEPRIMARYCODE,
      @DIFFERENTEMAILCODE,
      @NEWEMAILENDDATECODE,
      @NEWEMAILPRIMARYCODE,
      @USEGLOBALSETTINGS,
      @CREATEHISTORICALNAMECODE,    
      @NAMEFORMATS,
      @SUBMITTEDLOOKUPID,
      @SUBMITTEDCLASSYEAR,
      @SUBMITTEDEDUCATIONALINSTITUTION,
      @DOMANUALREVIEWFORAUTOMATCH,
      @REQUESTSNOEMAIL;
end