USP_DATAFORMTEMPLATE_EDIT_BATCHCONSTITUENTUPDATEBATCHCOMMIT_16

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@VALIDATEONLY	bit	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
@CURRENTAPPUSERID	uniqueidentifier	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
@BATCHOWNERID	uniqueidentifier	IN
@BATCHROWID	uniqueidentifier	IN
@SPOUSE_ALTERNATELOOKUPIDS	xml	IN
@SPOUSE_IMPORTLOOKUPID	nvarchar(100)	IN
@ROWFROMBATCHUI	bit	IN
@BBNCTRANID	int	IN
@REMOVESPOUSE	bit	IN
@DUPLICATERECORDID	uniqueidentifier	IN
@SOCIALMEDIAACCOUNTS	xml	IN
@RELATIONSHIPS	xml	IN
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	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
@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_BATCHCONSTITUENTUPDATEBATCHCOMMIT_16
(
        @ID uniqueidentifier,
        @CHANGEAGENTID uniqueidentifier,
        @VALIDATEONLY bit,
        @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),
        @CURRENTAPPUSERID uniqueidentifier,
        @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,
        @BATCHOWNERID uniqueidentifier,
        @BATCHROWID uniqueidentifier,
        @SPOUSE_ALTERNATELOOKUPIDS xml,
        @SPOUSE_IMPORTLOOKUPID nvarchar(100),
        @ROWFROMBATCHUI bit, 
        @BBNCTRANID int,
        @REMOVESPOUSE bit,
        @DUPLICATERECORDID uniqueidentifier,
        @SOCIALMEDIAACCOUNTS xml,
        @RELATIONSHIPS xml,
        @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
        @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,
        @REQUESTSNOEMAIL bit,
        @ORIGINAL_KEYNAME nvarchar(100),
        @ORIGINAL_FIRSTNAME nvarchar(50),
        @SOLICITCODES xml,
        @GENDERCODEID uniqueidentifier,
        @SPOUSE_GENDERCODEID uniqueidentifier
) as
set nocount on;

if @CHANGEAGENTID is null
                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

        begin try
        exec dbo.USP_SKIPSEARCHCONSTITUENTUPDATES;

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTUPDATEBATCHTEMPLATE_15
                @ID = @ID, 
                @CHANGEAGENTID = @CHANGEAGENTID, 
                @CONSTITUENTTYPECODE = @CONSTITUENTTYPECODE, 
                @BIRTHDATE = @BIRTHDATE, 
                @FIRSTNAME = @FIRSTNAME, 
                @GENDERCODE = @GENDERCODE, 
                @GIVESANONYMOUSLY = @GIVESANONYMOUSLY, 
                @KEYNAME = @KEYNAME, 
                @LOOKUPID = @LOOKUP_ID, 
                @MAIDENNAME = @MAIDENNAME, 
                @MIDDLENAME = @MIDDLENAME, 
                @NICKNAME = @NICKNAME, 
                @SUFFIXCODEID = @SUFFIXCODEID, 
                @TITLECODEID = @TITLECODEID, 
                @WEBADDRESS = @WEBADDRESS, 
                @ALTERNATELOOKUPIDS = @ALTERNATELOOKUPIDS,
                @SECURITYATTRIBUTES = @SECURITYATTRIBUTES, 
                @DECEASED = @DECEASED, 
                @DECEASEDDATE = @DECEASEDDATE, 
                @CONSTITUENT_SITEID = @CONSTITUENT_SITEID, 
                @INTERESTS = @INTERESTS, 
                @PROSPECTMANAGERFUNDRAISERID = @PROSPECTMANAGERFUNDRAISERID, 
                @ADDRESSES = @ADDRESSES,
                @EMAILADDRESSES = @EMAILADDRESSES, 
                @PHONES = @PHONES, 
                @CONSTITUENCIES = @CONSTITUENCIES, 
                @GROUPTYPEID = @GROUPTYPEID,
                @GROUPDESCRIPTION = @GROUPDESCRIPTION, 
                @GROUPSTARTDATE = @GROUPSTARTDATE, 
                @ORG_INDUSTRYCODEID = @ORG_INDUSTRYCODEID,
                @ORG_NUMEMPLOYEES = @ORG_NUMEMPLOYEES, 
                @ORG_NUMSUBSIDIARIES = @ORG_NUMSUBSIDIARIES, 
                @ORG_PARENTCORPID = @ORG_PARENTCORPID, 
                @MARITALSTATUSCODEID = @MARITALSTATUSCODEID,
                @SPOUSE_ID = @SPOUSE_ID, 
                @SPOUSE_BIRTHDATE = @SPOUSE_BIRTHDATE,
                @SPOUSE_FIRSTNAME = @SPOUSE_FIRSTNAME,
                @SPOUSE_GENDERCODE = @SPOUSE_GENDERCODE,
                @SPOUSE_LASTNAME = @SPOUSE_LASTNAME, 
                @SPOUSE_LOOKUPID = @SPOUSE_LOOKUPID,
                @SPOUSE_MAIDENNAME = @SPOUSE_MAIDENNAME,
                @SPOUSE_MIDDLENAME = @SPOUSE_MIDDLENAME, 
                @SPOUSE_NICKNAME = @SPOUSE_NICKNAME, 
                @SPOUSE_SUFFIXCODEID = @SPOUSE_SUFFIXCODEID,
                @SPOUSE_TITLECODEID = @SPOUSE_TITLECODEID,
                @SPOUSE_RELATIONSHIPTYPECODEID = @SPOUSE_RELATIONSHIPTYPECODEID,
                @SPOUSE_RECIPROCALTYPECODEID = @SPOUSE_RECIPROCALTYPECODEID,
                @BUSINESS_ADDRESSBLOCK = @BUSINESS_ADDRESSBLOCK, 
                @BUSINESS_ADDRESSTYPECODEID = @BUSINESS_ADDRESSTYPECODEID,
                @BUSINESS_CART = @BUSINESS_CART,
                @BUSINESS_CITY = @BUSINESS_CITY, 
                @BUSINESS_COUNTRYID = @BUSINESS_COUNTRYID, 
                @BUSINESS_DONOTMAIL = @BUSINESS_DONOTMAIL,
                @BUSINESS_DONOTMAILREASONCODEID = @BUSINESS_DONOTMAILREASONCODEID, 
                @BUSINESS_DPC = @BUSINESS_DPC, 
                @BUSINESS_EMAILADDRESS = @BUSINESS_EMAILADDRESS, 
                @BUSINESS_EMAILADDRESSTYPECODEID = @BUSINESS_EMAILADDRESSTYPECODEID,
                @BUSINESS_INDUSTRYCODEID = @BUSINESS_INDUSTRYCODEID, 
                @BUSINESS_LOOKUPID = @BUSINESS_LOOKUPID, 
                @BUSINESS_LOT = @BUSINESS_LOT,
                @BUSINESS_ID = @BUSINESS_ID, 
                @BUSINESS_NAME = @BUSINESS_NAME, 
                @BUSINESS_NUMEMPLOYEES = @BUSINESS_NUMEMPLOYEES,
                @BUSINESS_NUMSUBSIDIARIES = @BUSINESS_NUMSUBSIDIARIES, 
                @BUSINESS_PARENTCORPID = @BUSINESS_PARENTCORPID, 
                @BUSINESS_PHONENUMBER = @BUSINESS_PHONENUMBER, 
                @BUSINESS_PHONE_COUNTRYID = @BUSINESS_PHONE_COUNTRYID,
                @BUSINESS_PHONETYPECODEID = @BUSINESS_PHONETYPECODEID,
                @BUSINESS_RELATIONSHIPTYPECODEID = @BUSINESS_RELATIONSHIPTYPECODEID,
                @BUSINESS_RECIPROCALTYPECODEID = @BUSINESS_RECIPROCALTYPECODEID,
                @BUSINESS_STATEID = @BUSINESS_STATEID,
                @BUSINESS_WEBADDRESS = @BUSINESS_WEBADDRESS, 
                @BUSINESS_POSTCODE = @BUSINESS_POSTCODE,
                @CURRENTAPPUSERID = @CURRENTAPPUSERID,
                @VALIDATEONLY = @VALIDATEONLY,
                @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST = @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST,
                @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST = @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST,
                @BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST = @BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST,
                @BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST = @BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST,
                @BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS = @BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
                @BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR = @BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR,
                @BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS = @BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
                @BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR = @BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR,
                @BUSINESS_PRIMARYRECOGNITIONTYPECODEID = @BUSINESS_PRIMARYRECOGNITIONTYPECODEID,
                @BUSINESS_RECIPROCALRECOGNITIONTYPECODEID = @BUSINESS_RECIPROCALRECOGNITIONTYPECODEID,
                @BUSINESS_EMAILADDRESSSTARTDATE = @BUSINESS_EMAILADDRESSSTARTDATE,
                @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS = @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
                @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR = @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR,
                @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS = @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
                @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR = @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR,
                @SPOUSE_PRIMARYRECOGNITIONTYPECODEID = @SPOUSE_PRIMARYRECOGNITIONTYPECODEID,
                @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID = @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID,
                @CONSTITUENT_SITES = @CONSTITUENT_SITES,
                @BATCHOWNERID = @BATCHOWNERID,
                @BATCHROWID = @BATCHROWID,
                @SPOUSE_ALTERNATELOOKUPIDS = @SPOUSE_ALTERNATELOOKUPIDS,
                @SPOUSE_IMPORTLOOKUPID = @SPOUSE_IMPORTLOOKUPID,
                @ROWFROMBATCHUI = @ROWFROMBATCHUI, 
                @BBNCTRANID = @BBNCTRANID,
                @REMOVESPOUSE = @REMOVESPOUSE,
                @SOCIALMEDIAACCOUNTS = @SOCIALMEDIAACCOUNTS,
                @RELATIONSHIPS = @RELATIONSHIPS,
                @NETCOMMUNITYTRANSACTIONPROCESSORID = @NETCOMMUNITYTRANSACTIONPROCESSORID,
                @NEWADDRESSENDDATECODE = @NEWADDRESSENDDATECODE,
                @CREATEHISTORICALNAMECODE = @CREATEHISTORICALNAMECODE,
                @NEWPHONEENDDATECODE = @NEWPHONEENDDATECODE,
                @NEWEMAILENDDATECODE = @NEWEMAILENDDATECODE,
                @NAMEFORMATS = @NAMEFORMATS,
                @REQUESTSNOEMAIL = @REQUESTSNOEMAIL,
                @SOLICITCODES = @SOLICITCODES,
                @GENDERCODEID = @GENDERCODEID,
                @SPOUSE_GENDERCODEID = @SPOUSE_GENDERCODEID

        end try
        begin catch
                exec.dbo.USP_RAISE_ERROR;
                return 1;
        end catch

return 0;