USP_DATAFORMTEMPLATE_ADD_BATCHCONSTITUENTUPDATEBATCHCOMMIT

The save procedure used by the add dataform template "Constituent Update Batch Row Commit Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@VALIDATEONLY	bit	IN	Validate only
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CONSTITUENTTYPECODE	tinyint	IN	Constituent type
@BIRTHDATE	UDT_FUZZYDATE	IN	Birth date
@FIRSTNAME	nvarchar(50)	IN	First name
@GENDERCODE	tinyint	IN	Gender
@GIVESANONYMOUSLY	bit	IN	Gives anonymously
@KEYNAME	nvarchar(100)	IN	Last name
@LOOKUP_ID	nvarchar(100)	IN	Lookup ID
@MAIDENNAME	nvarchar(100)	IN	Maiden name
@MIDDLENAME	nvarchar(50)	IN	Middle name
@NICKNAME	nvarchar(50)	IN	Nickname
@SUFFIXCODEID	uniqueidentifier	IN	Suffix
@TITLECODEID	uniqueidentifier	IN	Title
@WEBADDRESS	UDT_WEBADDRESS	IN	Website
@ALTERNATELOOKUPIDS	xml	IN	Alternate lookup IDs
@SECURITYATTRIBUTES	xml	IN	Security attributes
@DECEASED	bit	IN	Deceased
@DECEASEDDATE	UDT_FUZZYDATE	IN	Deceased date
@CONSTITUENT_SITEID	uniqueidentifier	IN	Constituent site
@INTERESTS	xml	IN	Interests
@PROSPECTMANAGERFUNDRAISERID	uniqueidentifier	IN	Prospect manager
@ADDRESSES	xml	IN	Addresses
@PHONES	xml	IN	Phones
@EMAILADDRESSES	xml	IN	Email addresses
@CONSTITUENCIES	xml	IN	Constituencies
@GROUPTYPEID	uniqueidentifier	IN	Group type
@GROUPDESCRIPTION	nvarchar(300)	IN	Group description
@GROUPSTARTDATE	datetime	IN	Group consolidation date
@ORG_INDUSTRYCODEID	uniqueidentifier	IN	Constituent's industry
@ORG_NUMEMPLOYEES	int	IN	Number of employees
@ORG_NUMSUBSIDIARIES	int	IN	Number of subsidiaries
@ORG_PARENTCORPID	uniqueidentifier	IN	Parent corporation
@MARITALSTATUSCODEID	uniqueidentifier	IN	Marital status
@SPOUSE_ID	uniqueidentifier	IN	Spouse
@SPOUSE_TITLECODEID	uniqueidentifier	IN	Spouse title
@SPOUSE_FIRSTNAME	nvarchar(50)	IN	Spouse first name
@SPOUSE_NICKNAME	nvarchar(50)	IN	Spouse nickname
@SPOUSE_MIDDLENAME	nvarchar(50)	IN	Spouse middle name
@SPOUSE_MAIDENNAME	nvarchar(100)	IN	Spouse maiden name
@SPOUSE_LASTNAME	nvarchar(100)	IN	Spouse last name
@SPOUSE_SUFFIXCODEID	uniqueidentifier	IN	Spouse suffix
@SPOUSE_BIRTHDATE	UDT_FUZZYDATE	IN	Spouse birth date
@SPOUSE_GENDERCODE	tinyint	IN	Spouse gender
@SPOUSE_LOOKUPID	nvarchar(100)	IN	Spouse lookup ID
@SPOUSE_RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Relation to spouse
@SPOUSE_RECIPROCALTYPECODEID	uniqueidentifier	IN	Spouse's relation to constituent
@BUSINESS_ID	uniqueidentifier	IN	Business
@BUSINESS_ADDRESSBLOCK	nvarchar(150)	IN	Business address
@BUSINESS_ADDRESSTYPECODEID	uniqueidentifier	IN	Business address type
@BUSINESS_CART	nvarchar(10)	IN	Business CART
@BUSINESS_CITY	nvarchar(50)	IN	Business city
@BUSINESS_COUNTRYID	uniqueidentifier	IN	Business country
@BUSINESS_DONOTMAIL	bit	IN	Business do not mail
@BUSINESS_DONOTMAILREASONCODEID	uniqueidentifier	IN	Business do not mail reason
@BUSINESS_DPC	nvarchar(8)	IN	Business DPC
@BUSINESS_EMAILADDRESS	UDT_EMAILADDRESS	IN	Business email address
@BUSINESS_EMAILADDRESSTYPECODEID	uniqueidentifier	IN	Business email type
@BUSINESS_INDUSTRYCODEID	uniqueidentifier	IN	Industry
@BUSINESS_LOOKUPID	nvarchar(100)	IN	Business lookup ID
@BUSINESS_LOT	nvarchar(5)	IN	Business LOT
@BUSINESS_NAME	nvarchar(100)	IN	Business name
@BUSINESS_NUMEMPLOYEES	int	IN	Business number of employees
@BUSINESS_NUMSUBSIDIARIES	int	IN	Business number of subsidiaries
@BUSINESS_PARENTCORPID	uniqueidentifier	IN	Business parent organization
@BUSINESS_PHONENUMBER	nvarchar(100)	IN	Business phone number
@BUSINESS_PHONE_COUNTRYID	uniqueidentifier	IN	Business phone number country
@BUSINESS_PHONETYPECODEID	uniqueidentifier	IN	Business phone type
@BUSINESS_RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Relation to business
@BUSINESS_RECIPROCALTYPECODEID	uniqueidentifier	IN	Business's relation to constituent
@BUSINESS_STATEID	uniqueidentifier	IN	Business state
@BUSINESS_WEBADDRESS	UDT_WEBADDRESS	IN	Business website
@BUSINESS_POSTCODE	nvarchar(12)	IN	Business ZIP
@SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST	uniqueidentifier	IN	Spouse relationship type
@SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST	uniqueidentifier	IN	Spouse reciprocal type
@BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST	uniqueidentifier	IN	Business relationship type
@BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST	uniqueidentifier	IN	Business reciprocal type
@BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS	bit	IN	Apply recognition from business
@BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN	Recognition from business match percent
@BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS	bit	IN	Apply recognition to business
@BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN	Recognition to business match percent
@BUSINESS_PRIMARYRECOGNITIONTYPECODEID	uniqueidentifier	IN	Recognition from business type
@BUSINESS_RECIPROCALRECOGNITIONTYPECODEID	uniqueidentifier	IN	Recognition to business type
@BUSINESS_EMAILADDRESSSTARTDATE	date	IN	Business email start date
@SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS	bit	IN	Apply recognition from spouse
@SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN	Recognition from spouse match percent
@SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS	bit	IN	Apply recognition to spouse
@SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN	Recognition to spouse match percent
@SPOUSE_PRIMARYRECOGNITIONTYPECODEID	uniqueidentifier	IN	Recognition from spouse type
@SPOUSE_RECIPROCALRECOGNITIONTYPECODEID	uniqueidentifier	IN	Recognition to spouse type
@CONSTITUENT_SITES	xml	IN	Constituent sites
@BATCHOWNERID	uniqueidentifier	IN	Batch owner ID
@SPOUSE_ALTERNATELOOKUPIDS	xml	IN	Spouse alternate lookup IDs
@SPOUSE_IMPORTLOOKUPID	nvarchar(100)	IN	Spouse lookup ID
@ROWFROMBATCHUI	bit	IN
@BBNCTRANID	int	IN
@REMOVESPOUSE	bit	IN
@DUPLICATERECORDID	uniqueidentifier	IN
@SOCIALMEDIAACCOUNTS	xml	IN
@RELATIONSHIPS	xml	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
@SOLICITCODES	xml	IN
@GENDERCODEID	uniqueidentifier	IN
@SPOUSE_GENDERCODEID	uniqueidentifier	IN

Definition

Copy



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

declare @CURRENTDATE datetime;

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

set @CURRENTDATE = getdate();

begin try
                exec dbo.USP_SKIPSEARCHCONSTITUENTUPDATES;

     exec dbo.USP_DATAFORMTEMPLATE_ADD_CONSTITUENTUPDATEBATCHTEMPLATE 
    @ID = @ID output, 
    @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, 
    @PHONES = @PHONES, 
    @EMAILADDRESSES = @EMAILADDRESSES, 
    @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_TITLECODEID = @SPOUSE_TITLECODEID, 
    @SPOUSE_FIRSTNAME = @SPOUSE_FIRSTNAME, 
    @SPOUSE_NICKNAME = @SPOUSE_NICKNAME, 
    @SPOUSE_MIDDLENAME = @SPOUSE_MIDDLENAME, 
    @SPOUSE_MAIDENNAME = @SPOUSE_MAIDENNAME, 
    @SPOUSE_LASTNAME = @SPOUSE_LASTNAME, 
    @SPOUSE_SUFFIXCODEID = @SPOUSE_SUFFIXCODEID, 
    @SPOUSE_BIRTHDATE = @SPOUSE_BIRTHDATE, 
    @SPOUSE_GENDERCODE = @SPOUSE_GENDERCODE, 
    @SPOUSE_LOOKUPID = @SPOUSE_LOOKUPID, 
    @SPOUSE_RELATIONSHIPTYPECODEID = @SPOUSE_RELATIONSHIPTYPECODEID, 
    @SPOUSE_RECIPROCALTYPECODEID = @SPOUSE_RECIPROCALTYPECODEID, 
    @BUSINESS_ID = @BUSINESS_ID, 
    @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_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,
        @SPOUSE_ALTERNATELOOKUPIDS = @SPOUSE_ALTERNATELOOKUPIDS,  
    @BBNCTRANID = @BBNCTRANID, 
    @REMOVESPOUSE = @REMOVESPOUSE,
    @SOCIALMEDIAACCOUNTS = @SOCIALMEDIAACCOUNTS,
    @RELATIONSHIPS = @RELATIONSHIPS,
    @NAMEFORMATS = @NAMEFORMATS,
        @REQUESTSNOEMAIL = @REQUESTSNOEMAIL,
        @SOLICITCODES = @SOLICITCODES,
        @GENDERCODEID = @GENDERCODEID,
        @SPOUSE_GENDERCODEID = @SPOUSE_GENDERCODEID

    set @DUPLICATERECORDID = @ID;

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