USP_DATAFORMTEMPLATE_EDIT_BATCHCONSTITUENTUPDATEBATCHROW_16

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
@ORIGINAL_KEYNAME nvarchar(100) IN
@ORIGINAL_FIRSTNAME nvarchar(50) IN
@SOLICITCODES xml IN
@GENDERCODEID uniqueidentifier IN
@SPOUSE_GENDERCODEID uniqueidentifier IN

Definition

Copy 


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHCONSTITUENTUPDATEBATCHROW_16
(
    @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,
    @ORIGINAL_KEYNAME nvarchar(100),
    @ORIGINAL_FIRSTNAME nvarchar(50),
    @SOLICITCODES xml,
    @GENDERCODEID uniqueidentifier,
    @SPOUSE_GENDERCODEID uniqueidentifier
) as
set nocount on;

--Fetching value from table before update

if (@BBNCTRANID is null or @BBNCTRANID =0)
begin
    if exists(select 1 from BATCHCONSTITUENTUPDATEBBNCINFO where BATCHCONSTITUENTUPDATEID = @ID)
    begin
         select @BBNCTRANID=BBNCTRANID, @NETCOMMUNITYTRANSACTIONPROCESSORID = NETCOMMUNITYTRANSACTIONPROCESSORID from BATCHCONSTITUENTUPDATEBBNCINFO where BATCHCONSTITUENTUPDATEID = @ID;
    end
end

-- enhanced revenue batch will be calling this as well - ??

exec dbo.USP_EDITSAVE_BATCHCONSTITUENTUPDATEBATCHROW_4
    @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, @REQUESTSNOEMAIL,
    @ORIGINAL_KEYNAME, @ORIGINAL_FIRSTNAME, @SOLICITCODES, @GENDERCODEID,
    @SPOUSE_GENDERCODEID;

return 0;