USP_GENERATECONSTITUENTUPDATEBATCH
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITUENTID | uniqueidentifier | IN | |
| @BATCHID | uniqueidentifier | IN | |
| @SEQUENCE | int | IN | |
| @CURRENTAPPUSERID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_GENERATECONSTITUENTUPDATEBATCH
(
@CONSTITUENTID uniqueidentifier,
@BATCHID uniqueidentifier,
@SEQUENCE int,
@CURRENTAPPUSERID uniqueidentifier
)
as
begin
set nocount on;
declare @ID uniqueidentifier;
declare @DATALOADED bit = 0;
declare @VALIDATEONLY bit = null;
declare @CONSTITUENTTYPECODE tinyint = 0;
declare @BIRTHDATE dbo.UDT_FUZZYDATE = '00000000';
declare @FIRSTNAME nvarchar(50) = '';
declare @GENDERCODE tinyint = 0;
declare @GIVESANONYMOUSLY bit = 0;
declare @KEYNAME nvarchar(100) = null;
declare @LOOKUP_ID nvarchar(100) = null;
declare @MAIDENNAME nvarchar(100) = null;
declare @MIDDLENAME nvarchar(50) = null;
declare @NICKNAME nvarchar(50) = null;
declare @SUFFIXCODEID uniqueidentifier = null;
declare @TITLECODEID uniqueidentifier = null;
declare @WEBADDRESS dbo.UDT_WEBADDRESS = null;
declare @ALTERNATELOOKUPIDS xml = null;
declare @SECURITYATTRIBUTES xml = null;
declare @DECEASED bit = 0;
declare @DECEASEDDATE dbo.UDT_FUZZYDATE = '00000000';
declare @CONSTITUENT_SITEID uniqueidentifier = null;
declare @INTERESTS xml = null;
declare @PROSPECTMANAGERFUNDRAISERID uniqueidentifier = null;
declare @ADDRESSES xml = null;
declare @EMAILADDRESSES xml = null;
declare @PHONES xml = null;
declare @CONSTITUENCIES xml = null;
declare @GROUPTYPEID uniqueidentifier = null;
declare @GROUPDESCRIPTION nvarchar(300) = null;
declare @GROUPSTARTDATE date = null;
declare @ORG_INDUSTRYCODEID uniqueidentifier = null;
declare @ORG_NUMEMPLOYEES int = 0;
declare @ORG_NUMSUBSIDIARIES int = 0;
declare @ORG_PARENTCORPID uniqueidentifier = null;
declare @MARITALSTATUSCODEID uniqueidentifier = null;
declare @SPOUSE_ID uniqueidentifier = null;
declare @SPOUSE_BIRTHDATE dbo.UDT_FUZZYDATE = '00000000';
declare @SPOUSE_FIRSTNAME nvarchar(50) = null;
declare @SPOUSE_GENDERCODE tinyint = null;
declare @SPOUSE_LASTNAME nvarchar(100) = null;
declare @SPOUSE_LOOKUPID nvarchar(100) = null;
declare @SPOUSE_MAIDENNAME nvarchar(100) = null;
declare @SPOUSE_MIDDLENAME nvarchar(50) = null;
declare @SPOUSE_NICKNAME nvarchar(50) = null;
declare @SPOUSE_SUFFIXCODEID uniqueidentifier = null;
declare @SPOUSE_TITLECODEID uniqueidentifier = null;
declare @SPOUSE_RELATIONSHIPTYPECODEID uniqueidentifier = null;
declare @SPOUSE_RECIPROCALTYPECODEID uniqueidentifier = null;
declare @BUSINESS_ADDRESSBLOCK nvarchar(150) = null;
declare @BUSINESS_ADDRESSTYPECODEID uniqueidentifier = null;
declare @BUSINESS_CART nvarchar(10) = null;
declare @BUSINESS_CITY nvarchar(50) = null;
declare @BUSINESS_COUNTRYID uniqueidentifier = null;
declare @BUSINESS_DONOTMAIL bit = null;
declare @BUSINESS_DONOTMAILREASONCODEID uniqueidentifier = null;
declare @BUSINESS_DPC nvarchar(8) = null;
declare @BUSINESS_EMAILADDRESS dbo.UDT_EMAILADDRESS = null;
declare @BUSINESS_EMAILADDRESSTYPECODEID uniqueidentifier = null;
declare @BUSINESS_INDUSTRYCODEID uniqueidentifier = null;
declare @BUSINESS_LOOKUPID nvarchar(100) = null;
declare @BUSINESS_LOT nvarchar(5) = null;
declare @BUSINESS_ID uniqueidentifier = null;
declare @BUSINESS_NAME nvarchar(100) = null;
declare @BUSINESS_NUMEMPLOYEES int = null;
declare @BUSINESS_NUMSUBSIDIARIES int = null;
declare @BUSINESS_PARENTCORPID uniqueidentifier = null;
declare @BUSINESS_PHONENUMBER nvarchar(100) = null;
declare @BUSINESS_PHONE_COUNTRYID uniqueidentifier = null;
declare @BUSINESS_PHONETYPECODEID uniqueidentifier = null;
declare @BUSINESS_RELATIONSHIPTYPECODEID uniqueidentifier = null;
declare @BUSINESS_RECIPROCALTYPECODEID uniqueidentifier = null;
declare @BUSINESS_STATEID uniqueidentifier = null;
declare @BUSINESS_WEBADDRESS dbo.UDT_WEBADDRESS = '';
declare @BUSINESS_POSTCODE nvarchar(12) = null;
declare @TSLONG bigint = 0;
declare @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST uniqueidentifier = null;
declare @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST uniqueidentifier = null;
declare @BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST uniqueidentifier = null;
declare @BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST uniqueidentifier = null;
declare @BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit = 0;
declare @BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR decimal(5,2) = 100;
declare @BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit = 0;
declare @BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR decimal(5,2) = 100;
declare @BUSINESS_PRIMARYRECOGNITIONTYPECODEID uniqueidentifier = null;
declare @BUSINESS_RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier = null;
declare @BUSINESS_EMAILADDRESSSTARTDATE date = null;
declare @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit = 0;
declare @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR decimal(5,2) = 100;
declare @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit = 0;
declare @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR decimal(5,2) = 100;
declare @SPOUSE_PRIMARYRECOGNITIONTYPECODEID uniqueidentifier = null;
declare @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier = null;
declare @CONSTITUENT_SITES xml = null;
declare @BATCHOWNERID uniqueidentifier = null;
declare @BATCHROWID uniqueidentifier = null;
declare @SPOUSE_ALTERNATELOOKUPIDS xml = null;
declare @SPOUSE_IMPORTLOOKUPID nvarchar(100) = null;
declare @ROWFROMBATCHUI bit = null;
declare @BBNCTRANID int= 0;
declare @REMOVESPOUSE bit = 0;
declare @SOCIALMEDIAACCOUNTS xml = null;
declare @RELATIONSHIPS xml = null;
declare @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier = null;
declare @NEWADDRESSENDDATECODE tinyint = 0;
declare @CREATEHISTORICALNAMECODE tinyint = 1;
declare @NEWPHONEENDDATECODE tinyint = 0;
declare @NEWEMAILENDDATECODE tinyint = 0;
declare @NAMEFORMATS xml = null;
declare @REQUESTSNOEMAIL bit = null;
declare @SOLICITCODES xml = null;
declare @CHANGEAGENTID uniqueidentifier = null;
declare @PAGEID int = 0;
declare @PAGENAME nvarchar(100) = '';
declare @BBNCID int = 0;
declare @BBNCUSERID int = 0;
declare @NAMECODE tinyint = 1;
declare @SIMILARADDRESSCODE tinyint = 3;
declare @UNSIMILARADDRESSCODE tinyint = 3;
declare @NEWADDRESSPRIMARYCODE tinyint = 1;
declare @BIRTHDATERULECODE tinyint = 1;
declare @DIFFERENTPHONECODE tinyint = 3;
declare @NEWPHONEPRIMARYCODE tinyint = 1;
declare @DIFFERENTEMAILCODE tinyint = 3;
declare @NEWEMAILPRIMARYCODE tinyint = 1;
declare @USEGLOBALSETTINGS bit = 1;
declare @DOMANUALREVIEWFORAUTOMATCH bit = 0;
declare @ORIGINAL_KEYNAME nvarchar(100) = '';
declare @ORIGINAL_FIRSTNAME nvarchar(50) = '';
declare @SUBMITTEDLOOKUPID nvarchar(100) = '';
declare @SUBMITTEDCLASSYEAR nvarchar(4) = '';
declare @SUBMITTEDEDUCATIONALINSTITUTION nvarchar(100) = '';
declare @GENDERCODEID uniqueidentifier = null;
declare @SPOUSE_GENDERCODEID uniqueidentifier = null;
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
--Loading values
exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTUPDATEBATCHTEMPLATE
@ID = @CONSTITUENTID,
@DATALOADED = @DATALOADED output,
@CONSTITUENTTYPECODE = @CONSTITUENTTYPECODE output,
@BIRTHDATE = @BIRTHDATE output,
@FIRSTNAME = @FIRSTNAME output,
@GENDERCODE = @GENDERCODE output,
@GIVESANONYMOUSLY = @GIVESANONYMOUSLY output,
@KEYNAME = @KEYNAME output,
@LOOKUPID = @LOOKUP_ID output,
@MAIDENNAME = @MAIDENNAME output,
@MIDDLENAME = @MIDDLENAME output,
@NICKNAME = @NICKNAME output,
@SUFFIXCODEID = @SUFFIXCODEID output,
@TITLECODEID = @TITLECODEID output,
@WEBADDRESS = @WEBADDRESS output,
@ALTERNATELOOKUPIDS = @ALTERNATELOOKUPIDS output,
@SECURITYATTRIBUTES = @SECURITYATTRIBUTES output,
@DECEASED = @DECEASED output,
@DECEASEDDATE = @DECEASEDDATE output,
@CONSTITUENT_SITEID = @CONSTITUENT_SITEID output,
@INTERESTS = @INTERESTS output,
@PROSPECTMANAGERFUNDRAISERID = @PROSPECTMANAGERFUNDRAISERID output,
@ADDRESSES = @ADDRESSES output,
@EMAILADDRESSES = @EMAILADDRESSES output,
@PHONES = @PHONES output,
@CONSTITUENCIES = @CONSTITUENCIES output,
@GROUPTYPEID = @GROUPTYPEID output,
@GROUPDESCRIPTION = @GROUPDESCRIPTION output,
@GROUPSTARTDATE = @GROUPSTARTDATE output,
@ORG_INDUSTRYCODEID = @ORG_INDUSTRYCODEID output,
@ORG_NUMEMPLOYEES = @ORG_NUMEMPLOYEES output,
@ORG_NUMSUBSIDIARIES = @ORG_NUMSUBSIDIARIES output,
@ORG_PARENTCORPID = @ORG_PARENTCORPID output,
@MARITALSTATUSCODEID = @MARITALSTATUSCODEID output,
@SPOUSE_ID = @SPOUSE_ID output,
@SPOUSE_BIRTHDATE = @SPOUSE_BIRTHDATE output,
@SPOUSE_FIRSTNAME = @SPOUSE_FIRSTNAME output,
@SPOUSE_GENDERCODE = @SPOUSE_GENDERCODE output,
@SPOUSE_LASTNAME = @SPOUSE_LASTNAME output,
@SPOUSE_LOOKUPID = @SPOUSE_LOOKUPID output,
@SPOUSE_MAIDENNAME = @SPOUSE_MAIDENNAME output,
@SPOUSE_MIDDLENAME = @SPOUSE_MIDDLENAME output,
@SPOUSE_NICKNAME = @SPOUSE_NICKNAME output,
@SPOUSE_SUFFIXCODEID = @SPOUSE_SUFFIXCODEID output,
@SPOUSE_TITLECODEID = @SPOUSE_TITLECODEID output,
@SPOUSE_RELATIONSHIPTYPECODEID = @SPOUSE_RELATIONSHIPTYPECODEID output,
@SPOUSE_RECIPROCALTYPECODEID = @SPOUSE_RECIPROCALTYPECODEID output,
@BUSINESS_ADDRESSBLOCK = @BUSINESS_ADDRESSBLOCK output,
@BUSINESS_ADDRESSTYPECODEID = @BUSINESS_ADDRESSTYPECODEID output,
@BUSINESS_CART = @BUSINESS_CART output,
@BUSINESS_CITY = @BUSINESS_CITY output,
@BUSINESS_COUNTRYID = @BUSINESS_COUNTRYID output,
@BUSINESS_DONOTMAIL = @BUSINESS_DONOTMAIL output,
@BUSINESS_DONOTMAILREASONCODEID = @BUSINESS_DONOTMAILREASONCODEID output,
@BUSINESS_DPC = @BUSINESS_DPC output,
@BUSINESS_EMAILADDRESS = @BUSINESS_EMAILADDRESS output,
@BUSINESS_EMAILADDRESSTYPECODEID = @BUSINESS_EMAILADDRESSTYPECODEID output,
@BUSINESS_INDUSTRYCODEID = @BUSINESS_INDUSTRYCODEID output,
@BUSINESS_LOOKUPID = @BUSINESS_LOOKUPID output,
@BUSINESS_LOT = @BUSINESS_LOT output,
@BUSINESS_ID = @BUSINESS_ID output,
@BUSINESS_NAME = @BUSINESS_NAME output,
@BUSINESS_NUMEMPLOYEES = @BUSINESS_NUMEMPLOYEES output,
@BUSINESS_NUMSUBSIDIARIES = @BUSINESS_NUMSUBSIDIARIES output,
@BUSINESS_PARENTCORPID = @BUSINESS_PARENTCORPID output,
@BUSINESS_PHONENUMBER = @BUSINESS_PHONENUMBER output,
@BUSINESS_PHONETYPECODEID = @BUSINESS_PHONETYPECODEID output,
@BUSINESS_RELATIONSHIPTYPECODEID = @BUSINESS_RELATIONSHIPTYPECODEID output,
@BUSINESS_RECIPROCALTYPECODEID = @BUSINESS_RECIPROCALTYPECODEID output,
@BUSINESS_STATEID = @BUSINESS_STATEID output,
@BUSINESS_WEBADDRESS = @BUSINESS_WEBADDRESS output,
@BUSINESS_POSTCODE = @BUSINESS_POSTCODE output,
@TSLONG = @TSLONG output,
@SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST = @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST output,
@SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST = @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST output,
@BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST = @BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST output,
@BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST = @BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST output,
@BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS = @BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS output,
@BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR = @BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR output,
@BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS = @BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS output,
@BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR = @BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR output,
@BUSINESS_PRIMARYRECOGNITIONTYPECODEID = @BUSINESS_PRIMARYRECOGNITIONTYPECODEID output,
@BUSINESS_RECIPROCALRECOGNITIONTYPECODEID = @BUSINESS_RECIPROCALRECOGNITIONTYPECODEID output,
@BUSINESS_EMAILADDRESSSTARTDATE = @BUSINESS_EMAILADDRESSSTARTDATE output,
@SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS = @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS output,
@SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR = @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR output,
@SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS = @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS output,
@SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR = @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR output,
@SPOUSE_PRIMARYRECOGNITIONTYPECODEID = @SPOUSE_PRIMARYRECOGNITIONTYPECODEID output,
@SPOUSE_RECIPROCALRECOGNITIONTYPECODEID = @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID output,
@CONSTITUENT_SITES = @CONSTITUENT_SITES output,
@SPOUSE_ALTERNATELOOKUPIDS = @SPOUSE_ALTERNATELOOKUPIDS output,
@BBNCTRANID = @BBNCTRANID output,
@REMOVESPOUSE = @REMOVESPOUSE output,
@SOCIALMEDIAACCOUNTS = @SOCIALMEDIAACCOUNTS output,
@RELATIONSHIPS = @RELATIONSHIPS output,
@NETCOMMUNITYTRANSACTIONPROCESSORID = @NETCOMMUNITYTRANSACTIONPROCESSORID output,
@NEWADDRESSENDDATECODE = @NEWADDRESSENDDATECODE output,
@CREATEHISTORICALNAMECODE = @CREATEHISTORICALNAMECODE output,
@NEWPHONEENDDATECODE = @NEWPHONEENDDATECODE output,
@NEWEMAILENDDATECODE = @NEWEMAILENDDATECODE output,
@NAMEFORMATS = @NAMEFORMATS output,
@REQUESTSNOEMAIL = @REQUESTSNOEMAIL output,
@SOLICITCODES = @SOLICITCODES output,
@GENDERCODEID = @GENDERCODEID output,
@SPOUSE_GENDERCODEID = @SPOUSE_GENDERCODEID output;
-- Special handling for NULL
SET @DECEASEDDATE = COALESCE(@DECEASEDDATE,'00000000');
SET @SPOUSE_BIRTHDATE = COALESCE(@SPOUSE_BIRTHDATE,'00000000');
SET @BUSINESS_LOOKUPID = COALESCE(@BUSINESS_LOOKUPID,'');
SET @BUSINESS_WEBADDRESS = COALESCE(@BUSINESS_WEBADDRESS,'');
--Deleting ID node since it was giving error when running process multiple times
if @ALTERNATELOOKUPIDS is not null
set @ALTERNATELOOKUPIDS.modify('delete (/ALTERNATELOOKUPIDS/ITEM/ID)')
--Getting SPOUSE LookupID
set @SPOUSE_ALTERNATELOOKUPIDS = dbo.UFN_CONSTITUENT_GETSPOUSEALTERNATELOOKUPIDS_FORUPDATEBATCH_TOITEMLISTXML(@SPOUSE_ID);
--Deleting ID node since it was giving error when running process multiple times
if @SPOUSE_ALTERNATELOOKUPIDS is not null
set @SPOUSE_ALTERNATELOOKUPIDS.modify('delete (/SPOUSE_ALTERNATELOOKUPIDS/ITEM/ID)')
--Adding values to staging tables
exec dbo.USP_ADD_BATCHCONSTITUENTUPDATEBATCHROW
@ID output, @BATCHID, @CHANGEAGENTID, @SEQUENCE, @CONSTITUENTID, @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, @CONSTITUENTID,@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,
@SOLICITCODES,
@GENDERCODEID,
@SPOUSE_GENDERCODEID;
return 0;
end