USP_DATAFORMTEMPLATE_ADD_BATCHCONSTITUENTUPDATEBATCHROW

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

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@BATCHID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SEQUENCE	int	IN	Sequence
@PRIMARYRECORDID	uniqueidentifier	IN	Constituent
@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/Org/Group/Household 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	Constituent security attribute
@DECEASED	bit	IN	Is 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	Industry
@ORG_NUMEMPLOYEES	int	IN	No. of employees
@ORG_NUMSUBSIDIARIES	int	IN	No. of subsidiary orgs
@ORG_PARENTCORPID	uniqueidentifier	IN	Parent org
@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	Spouse relationship type
@SPOUSE_RECIPROCALTYPECODEID	uniqueidentifier	IN	Spouse reciprocal type
@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	Business 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 no. of employees
@BUSINESS_NUMSUBSIDIARIES	int	IN	Business no. of subsidiary orgs
@BUSINESS_PARENTCORPID	uniqueidentifier	IN	Business parent org
@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	Business relationship type
@BUSINESS_RECIPROCALTYPECODEID	uniqueidentifier	IN	Business reciprocal type
@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
@SPOUSE_ALTERNATELOOKUPIDS	xml	IN	Spouse alternate lookup IDs
@SPOUSE_IMPORTLOOKUPID	nvarchar(100)	IN	Spouse lookup ID
@ROWFROMBATCHUI	bit	IN
@BBNCTRANID	int	IN
@PAGEID	int	IN
@PAGENAME	nvarchar(100)	IN
@BBNCUSERID	int	IN
@REMOVESPOUSE	bit	IN
@DUPLICATERECORDID	uniqueidentifier	IN
@SOCIALMEDIAACCOUNTS	xml	IN
@RELATIONSHIPS	xml	IN
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	IN
@BBNCID	int	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
@SUBMITTEDLOOKUPID	nvarchar(100)	IN
@SUBMITTEDCLASSYEAR	nvarchar(4)	IN
@SUBMITTEDEDUCATIONALINSTITUTION	nvarchar(100)	IN
@DOMANUALREVIEWFORAUTOMATCH	bit	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_ADD_BATCHCONSTITUENTUPDATEBATCHROW(
        @ID uniqueidentifier = null output,
        @BATCHID uniqueidentifier,
        @CHANGEAGENTID uniqueidentifier,
        @SEQUENCE int,
        @PRIMARYRECORDID uniqueidentifier = null,
        @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,
        @SPOUSE_ALTERNATELOOKUPIDS xml = null,
        @SPOUSE_IMPORTLOOKUPID nvarchar(100) = '',
    @ROWFROMBATCHUI bit = 0, 
        @BBNCTRANID int = 0, @PAGEID int = 0, @PAGENAME nvarchar(100) = '',
        @BBNCUSERID int = 0,
        @REMOVESPOUSE bit = 0,  
        @DUPLICATERECORDID uniqueidentifier = null,
        @SOCIALMEDIAACCOUNTS xml = null,
    @RELATIONSHIPS xml = null,
        @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier = null,
        @BBNCID int = 0,
        @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,
    @SUBMITTEDLOOKUPID nvarchar(100) = '',
    @SUBMITTEDCLASSYEAR nvarchar(4) = '',
    @SUBMITTEDEDUCATIONALINSTITUTION nvarchar(100) = '',
        @DOMANUALREVIEWFORAUTOMATCH bit = 0,
        @REQUESTSNOEMAIL bit = 0,
        @ORIGINAL_KEYNAME nvarchar(100) = '',
        @ORIGINAL_FIRSTNAME nvarchar(50) = '',
        @SOLICITCODES xml = null,
        @GENDERCODEID uniqueidentifier = null,
        @SPOUSE_GENDERCODEID uniqueidentifier = null
) as
set nocount on;

-- enhanced revenue batch will be calling this as well

exec dbo.USP_ADD_BATCHCONSTITUENTUPDATEBATCHROW
        @ID output, @BATCHID, @CHANGEAGENTID, @SEQUENCE, @PRIMARYRECORDID, @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, @DUPLICATERECORDID,@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;

        -- if import apply business rules

        if @ROWFROMBATCHUI = 0 and @PRIMARYRECORDID is not null
             begin

                exec dbo.USP_BATCHCONSTITUENTAPPLYRULES_FORIMPORT 
                                @ID, 
                                @PRIMARYRECORDID, 
                                @CHANGEAGENTID, 
                                @SIMILARADDRESSCODE, 
                                @UNSIMILARADDRESSCODE, 
                                @NEWADDRESSPRIMARYCODE, 
                                @DOMANUALREVIEWFORAUTOMATCH output, 
                                @DIFFERENTPHONECODE,
                                @NEWPHONEPRIMARYCODE,
                                @DIFFERENTEMAILCODE,
                                @NEWEMAILPRIMARYCODE,
                                1;                

                -- Check for 'generate manual review' exception and don't apply the rules

                if @DOMANUALREVIEWFORAUTOMATCH = 1 
                    insert into dbo.BATCHCONSTITUENTUPDATEBATCHSYSTEMMESSAGES(BATCHCONSTITUENTUPDATEID, MESSAGETEXT, MESSAGETYPECODE, SEVERITYCODE, ORIGINCODE,ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                    values (@ID, 'Data in batch is different from data for this constituent. Click here to review.', 1, 0, 1, @CHANGEAGENTID, @CHANGEAGENTID, getdate(), getdate())   
             end

return 0;