USP_DATAFORMTEMPLATE_EDITLOAD_BATCHCONSTITUENTUPDATEBATCHROW
The load procedure used by the edit dataform template "Constituent Update Batch Row Edit Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | The input ID parameter used to load the fields defined on the form. |
| @DATALOADED | bit | INOUT | Output parameter indicating whether or not data was actually loaded. |
| @TSLONG | bigint | INOUT | Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record. |
| @SEQUENCE | int | INOUT | Sequence |
| @PRIMARYRECORDID | uniqueidentifier | INOUT | Constituent |
| @CONSTITUENTTYPECODE | tinyint | INOUT | Constituent type |
| @BIRTHDATE | UDT_FUZZYDATE | INOUT | Birth date |
| @FIRSTNAME | nvarchar(50) | INOUT | First name |
| @GENDERCODE | tinyint | INOUT | Gender |
| @GIVESANONYMOUSLY | bit | INOUT | Gives anonymously |
| @KEYNAME | nvarchar(100) | INOUT | Last/Org/Group/Household name |
| @LOOKUP_ID | nvarchar(100) | INOUT | Lookup ID |
| @MAIDENNAME | nvarchar(100) | INOUT | Maiden name |
| @MIDDLENAME | nvarchar(50) | INOUT | Middle name |
| @NICKNAME | nvarchar(50) | INOUT | Nickname |
| @SUFFIXCODEID | uniqueidentifier | INOUT | Suffix |
| @TITLECODEID | uniqueidentifier | INOUT | Title |
| @WEBADDRESS | UDT_WEBADDRESS | INOUT | Website |
| @ALTERNATELOOKUPIDS | xml | INOUT | Alternate lookup IDs |
| @SECURITYATTRIBUTES | xml | INOUT | Constituent security attribute |
| @DECEASED | bit | INOUT | Is deceased |
| @DECEASEDDATE | UDT_FUZZYDATE | INOUT | Deceased date |
| @CONSTITUENT_SITEID | uniqueidentifier | INOUT | Constituent site |
| @INTERESTS | xml | INOUT | Interests |
| @PROSPECTMANAGERFUNDRAISERID | uniqueidentifier | INOUT | Prospect manager |
| @ADDRESSES | xml | INOUT | Addresses |
| @PHONES | xml | INOUT | Phones |
| @EMAILADDRESSES | xml | INOUT | Email addresses |
| @CONSTITUENCIES | xml | INOUT | Constituencies |
| @GROUPTYPEID | uniqueidentifier | INOUT | Group type |
| @GROUPDESCRIPTION | nvarchar(300) | INOUT | Group description |
| @GROUPSTARTDATE | datetime | INOUT | Group consolidation date |
| @ORG_INDUSTRYCODEID | uniqueidentifier | INOUT | Industry |
| @ORG_NUMEMPLOYEES | int | INOUT | No. of employees |
| @ORG_NUMSUBSIDIARIES | int | INOUT | No. of subsidiary orgs |
| @ORG_PARENTCORPID | uniqueidentifier | INOUT | Parent org |
| @MARITALSTATUSCODEID | uniqueidentifier | INOUT | Marital status |
| @SPOUSE_ID | uniqueidentifier | INOUT | Spouse |
| @SPOUSE_TITLECODEID | uniqueidentifier | INOUT | Spouse title |
| @SPOUSE_FIRSTNAME | nvarchar(50) | INOUT | Spouse first name |
| @SPOUSE_NICKNAME | nvarchar(50) | INOUT | Spouse nickname |
| @SPOUSE_MIDDLENAME | nvarchar(50) | INOUT | Spouse middle name |
| @SPOUSE_MAIDENNAME | nvarchar(100) | INOUT | Spouse maiden name |
| @SPOUSE_LASTNAME | nvarchar(100) | INOUT | Spouse last name |
| @SPOUSE_SUFFIXCODEID | uniqueidentifier | INOUT | Spouse suffix |
| @SPOUSE_BIRTHDATE | UDT_FUZZYDATE | INOUT | Spouse birth date |
| @SPOUSE_GENDERCODE | tinyint | INOUT | Spouse gender |
| @SPOUSE_LOOKUPID | nvarchar(100) | INOUT | Spouse lookup ID |
| @SPOUSE_RELATIONSHIPTYPECODEID | uniqueidentifier | INOUT | Spouse relationship type |
| @SPOUSE_RECIPROCALTYPECODEID | uniqueidentifier | INOUT | Spouse reciprocal type |
| @BUSINESS_ID | uniqueidentifier | INOUT | Business |
| @BUSINESS_ADDRESSBLOCK | nvarchar(150) | INOUT | Business address |
| @BUSINESS_ADDRESSTYPECODEID | uniqueidentifier | INOUT | Business address type |
| @BUSINESS_CART | nvarchar(10) | INOUT | Business CART |
| @BUSINESS_CITY | nvarchar(50) | INOUT | Business city |
| @BUSINESS_COUNTRYID | uniqueidentifier | INOUT | Business country |
| @BUSINESS_DONOTMAIL | bit | INOUT | Business do not mail |
| @BUSINESS_DONOTMAILREASONCODEID | uniqueidentifier | INOUT | Business do not mail reason |
| @BUSINESS_DPC | nvarchar(8) | INOUT | Business DPC |
| @BUSINESS_EMAILADDRESS | UDT_EMAILADDRESS | INOUT | Business email address |
| @BUSINESS_EMAILADDRESSTYPECODEID | uniqueidentifier | INOUT | Business email type |
| @BUSINESS_INDUSTRYCODEID | uniqueidentifier | INOUT | Business industry |
| @BUSINESS_LOOKUPID | nvarchar(100) | INOUT | Business lookup ID |
| @BUSINESS_LOT | nvarchar(5) | INOUT | Business LOT |
| @BUSINESS_NAME | nvarchar(100) | INOUT | Business name |
| @BUSINESS_NUMEMPLOYEES | int | INOUT | Business no. of employees |
| @BUSINESS_NUMSUBSIDIARIES | int | INOUT | Business no. of subsidiary orgs |
| @BUSINESS_PARENTCORPID | uniqueidentifier | INOUT | Business parent org |
| @BUSINESS_PHONENUMBER | nvarchar(100) | INOUT | Business phone number |
| @BUSINESS_PHONE_COUNTRYID | uniqueidentifier | INOUT | Business phone number country |
| @BUSINESS_PHONETYPECODEID | uniqueidentifier | INOUT | Business phone type |
| @BUSINESS_RELATIONSHIPTYPECODEID | uniqueidentifier | INOUT | Business relationship type |
| @BUSINESS_RECIPROCALTYPECODEID | uniqueidentifier | INOUT | Business reciprocal type |
| @BUSINESS_STATEID | uniqueidentifier | INOUT | Business state |
| @BUSINESS_WEBADDRESS | UDT_WEBADDRESS | INOUT | Business website |
| @BUSINESS_POSTCODE | nvarchar(12) | INOUT | Business ZIP |
| @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST | uniqueidentifier | INOUT | Spouse relationship type |
| @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST | uniqueidentifier | INOUT | Spouse reciprocal type |
| @BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST | uniqueidentifier | INOUT | Business relationship type |
| @BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST | uniqueidentifier | INOUT | Business reciprocal type |
| @BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS | bit | INOUT | Apply recognition from business |
| @BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR | decimal(5, 2) | INOUT | Recognition from business match percent |
| @BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS | bit | INOUT | Apply recognition to business |
| @BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR | decimal(5, 2) | INOUT | Recognition to business match percent |
| @BUSINESS_PRIMARYRECOGNITIONTYPECODEID | uniqueidentifier | INOUT | Recognition from business type |
| @BUSINESS_RECIPROCALRECOGNITIONTYPECODEID | uniqueidentifier | INOUT | Recognition to business type |
| @BUSINESS_EMAILADDRESSSTARTDATE | date | INOUT | Business email start date |
| @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS | bit | INOUT | Apply recognition from spouse |
| @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR | decimal(5, 2) | INOUT | Recognition from spouse match percent |
| @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS | bit | INOUT | Apply recognition to spouse |
| @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR | decimal(5, 2) | INOUT | Recognition to spouse match percent |
| @SPOUSE_PRIMARYRECOGNITIONTYPECODEID | uniqueidentifier | INOUT | Recognition from spouse type |
| @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID | uniqueidentifier | INOUT | Recognition to spouse type |
| @CONSTITUENT_SITES | xml | INOUT | Constituent sites |
| @SPOUSE_ALTERNATELOOKUPIDS | xml | INOUT | Spouse alternate lookup IDs |
| @SPOUSE_IMPORTLOOKUPID | nvarchar(100) | INOUT | Spouse lookup ID |
| @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 | |
| @DOMANUALREVIEWFORAUTOMATCH | bit | 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 | |
| @REQUESTSNOEMAIL | bit | INOUT | |
| @ORIGINAL_KEYNAME | nvarchar(100) | INOUT | |
| @ORIGINAL_FIRSTNAME | nvarchar(50) | INOUT | |
| @SOLICITCODES | xml | INOUT | |
| @GENDERCODEID | uniqueidentifier | INOUT | |
| @SPOUSE_GENDERCODEID | uniqueidentifier | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHCONSTITUENTUPDATEBATCHROW(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@TSLONG bigint = 0 output,
@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,
@DOMANUALREVIEWFORAUTOMATCH bit = 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,
@REQUESTSNOEMAIL bit = null output,
@ORIGINAL_KEYNAME nvarchar(100) = null output,
@ORIGINAL_FIRSTNAME nvarchar(50) = null output,
@SOLICITCODES xml = null output,
@GENDERCODEID uniqueidentifier = null output,
@SPOUSE_GENDERCODEID uniqueidentifier = null output
) as
set nocount on;
-- enhanced revenue batch will be calling this as well
exec dbo.USP_EDITLOAD_BATCHCONSTITUENTUPDATEBATCHROW
@ID, @DATALOADED output, @TSLONG output, @SEQUENCE output, @PRIMARYRECORDID output, @CONSTITUENTTYPECODE output, @BIRTHDATE output,
@FIRSTNAME output, @GENDERCODE output, @GIVESANONYMOUSLY output, @KEYNAME output, @LOOKUP_ID output, @MAIDENNAME output, @MIDDLENAME output,
@NICKNAME output, @SUFFIXCODEID output, @TITLECODEID output, @WEBADDRESS output, @ALTERNATELOOKUPIDS output, @SECURITYATTRIBUTES output,
@DECEASED output, @DECEASEDDATE output, @CONSTITUENT_SITEID output, @INTERESTS output, @PROSPECTMANAGERFUNDRAISERID output, @ADDRESSES output,
@PHONES output, @EMAILADDRESSES output, @CONSTITUENCIES output, @GROUPTYPEID output, @GROUPDESCRIPTION output, @GROUPSTARTDATE output,
@ORG_INDUSTRYCODEID output, @ORG_NUMEMPLOYEES output, @ORG_NUMSUBSIDIARIES output, @ORG_PARENTCORPID output, @MARITALSTATUSCODEID output,
@SPOUSE_ID output, @SPOUSE_TITLECODEID output, @SPOUSE_FIRSTNAME output, @SPOUSE_NICKNAME output, @SPOUSE_MIDDLENAME output, @SPOUSE_MAIDENNAME output,
@SPOUSE_LASTNAME output, @SPOUSE_SUFFIXCODEID output, @SPOUSE_BIRTHDATE output, @SPOUSE_GENDERCODE output, @SPOUSE_LOOKUPID output, @SPOUSE_RELATIONSHIPTYPECODEID output,
@SPOUSE_RECIPROCALTYPECODEID output, @BUSINESS_ID output, @BUSINESS_ADDRESSBLOCK output, @BUSINESS_ADDRESSTYPECODEID output, @BUSINESS_CART output,
@BUSINESS_CITY output, @BUSINESS_COUNTRYID output, @BUSINESS_DONOTMAIL output, @BUSINESS_DONOTMAILREASONCODEID output, @BUSINESS_DPC output,
@BUSINESS_EMAILADDRESS output, @BUSINESS_EMAILADDRESSTYPECODEID output, @BUSINESS_INDUSTRYCODEID output, @BUSINESS_LOOKUPID output, @BUSINESS_LOT output,
@BUSINESS_NAME output, @BUSINESS_NUMEMPLOYEES output, @BUSINESS_NUMSUBSIDIARIES output, @BUSINESS_PARENTCORPID output, @BUSINESS_PHONENUMBER output,
@BUSINESS_PHONE_COUNTRYID output, @BUSINESS_PHONETYPECODEID output, @BUSINESS_RELATIONSHIPTYPECODEID output, @BUSINESS_RECIPROCALTYPECODEID output,
@BUSINESS_STATEID output, @BUSINESS_WEBADDRESS output, @BUSINESS_POSTCODE output, @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST output, @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST output,
@BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST output, @BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST output, @BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS output,
@BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR output, @BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS output, @BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR output,
@BUSINESS_PRIMARYRECOGNITIONTYPECODEID output, @BUSINESS_RECIPROCALRECOGNITIONTYPECODEID output, @BUSINESS_EMAILADDRESSSTARTDATE output,
@SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS output, @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR output, @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS output,
@SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR output, @SPOUSE_PRIMARYRECOGNITIONTYPECODEID output, @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID output, @CONSTITUENT_SITES output,
@SPOUSE_ALTERNATELOOKUPIDS output, @SPOUSE_IMPORTLOOKUPID output, @ROWFROMBATCHUI output, @BBNCTRANID output, @PAGEID output, @PAGENAME output, @BBNCUSERID output,
@REMOVESPOUSE output, @DUPLICATERECORDID output, @SOCIALMEDIAACCOUNTS output, @DOMANUALREVIEWFORAUTOMATCH output, @RELATIONSHIPS output,
@NETCOMMUNITYTRANSACTIONPROCESSORID output, @BBNCID output,
@NAMECODE output, @SIMILARADDRESSCODE output, @UNSIMILARADDRESSCODE output,
@NEWADDRESSENDDATECODE output, @NEWADDRESSPRIMARYCODE output, @BIRTHDATERULECODE output,
@DIFFERENTPHONECODE output, @NEWPHONEENDDATECODE output, @NEWPHONEPRIMARYCODE output, @DIFFERENTEMAILCODE output, @NEWEMAILENDDATECODE output, @NEWEMAILPRIMARYCODE output,
@USEGLOBALSETTINGS output, @CREATEHISTORICALNAMECODE output, @NAMEFORMATS output, @SUBMITTEDLOOKUPID output, @SUBMITTEDCLASSYEAR output, @SUBMITTEDEDUCATIONALINSTITUTION output, @REQUESTSNOEMAIL output,
@ORIGINAL_KEYNAME output, @ORIGINAL_FIRSTNAME output, @SOLICITCODES output, @GENDERCODEID output,@SPOUSE_GENDERCODEID output;
return 0;