USP_DATAFORMTEMPLATE_EDITLOAD_BATCHCONSTITUENTUPDATEBATCHCOMMIT

The load procedure used by the edit dataform template "Constituent Update Batch Row Commit 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.
@VALIDATEONLY	bit	INOUT	Validate only
@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 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	Security attributes
@DECEASED	bit	INOUT	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	Constituent's industry
@ORG_NUMEMPLOYEES	int	INOUT	Number of employees
@ORG_NUMSUBSIDIARIES	int	INOUT	Number of subsidiaries
@ORG_PARENTCORPID	uniqueidentifier	INOUT	Parent corporation
@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	Relation to spouse
@SPOUSE_RECIPROCALTYPECODEID	uniqueidentifier	INOUT	Spouse's relation to constituent
@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	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 number of employees
@BUSINESS_NUMSUBSIDIARIES	int	INOUT	Business number of subsidiaries
@BUSINESS_PARENTCORPID	uniqueidentifier	INOUT	Business parent organization
@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	Relation to business
@BUSINESS_RECIPROCALTYPECODEID	uniqueidentifier	INOUT	Business's relation to constituent
@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
@BATCHOWNERID	uniqueidentifier	INOUT	Batch owner ID
@BATCHROWID	uniqueidentifier	INOUT	Batch row ID
@SPOUSE_ALTERNATELOOKUPIDS	xml	INOUT	Spouse alternate lookup IDs
@SPOUSE_IMPORTLOOKUPID	nvarchar(100)	INOUT	Spouse lookup ID
@ROWFROMBATCHUI	bit	INOUT
@BBNCTRANID	int	INOUT
@REMOVESPOUSE	bit	INOUT
@DUPLICATERECORDID	uniqueidentifier	INOUT
@SOCIALMEDIAACCOUNTS	xml	INOUT
@RELATIONSHIPS	xml	INOUT
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	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
@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_BATCHCONSTITUENTUPDATEBATCHCOMMIT(
        @ID uniqueidentifier,
        @DATALOADED bit = 0 output,
        @TSLONG bigint = 0 output, 
        @VALIDATEONLY bit = 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,
    @BATCHOWNERID uniqueidentifier = null output,
    @BATCHROWID uniqueidentifier = null output,
        @SPOUSE_ALTERNATELOOKUPIDS xml = null output,
        @SPOUSE_IMPORTLOOKUPID nvarchar(100) = null output,
    @ROWFROMBATCHUI bit = null output, 
    @BBNCTRANID int= null output,
    @REMOVESPOUSE bit = null output,
    @DUPLICATERECORDID uniqueidentifier = null output,
    @SOCIALMEDIAACCOUNTS xml = null output,
    @RELATIONSHIPS xml = null output,
    @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier = 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,
        @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;

        set @DATALOADED = 0;
        set @TSLONG = 0;

        declare @USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTUPDATEBATCHTEMPLATE_DATALOADED bit;
        declare @USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTUPDATEBATCHTEMPLATE_TSLONG bigint;

        exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTUPDATEBATCHTEMPLATE 
        @ID = @ID, 
        @DATALOADED = @USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTUPDATEBATCHTEMPLATE_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 = @USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTUPDATEBATCHTEMPLATE_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

        set @DATALOADED = @DATALOADED | @USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTUPDATEBATCHTEMPLATE_DATALOADED;
        select @TSLONG = convert(bigint,((@TSLONG + @USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTUPDATEBATCHTEMPLATE_TSLONG) + ABS(@TSLONG - @USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTUPDATEBATCHTEMPLATE_TSLONG))/2);


return 0;