USP_DATAFORMTEMPLATE_EDIT_REVENUEBATCHCONSTITUENT_3

The save procedure used by the edit dataform template "Revenue Batch Constituent Edit Form 3".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@LASTNAME	nvarchar(100)	IN	Last name
@ORGANIZATIONNAME	nvarchar(100)	IN	Name
@FIRSTNAME	nvarchar(50)	IN	First name
@MIDDLENAME	nvarchar(50)	IN	Middle name
@MAIDENNAME	nvarchar(100)	IN	Maiden name
@NICKNAME	nvarchar(50)	IN	Nickname
@TITLECODEID	uniqueidentifier	IN	Title
@SUFFIXCODEID	uniqueidentifier	IN	Suffix
@GENDERCODE	tinyint	IN	Gender
@BIRTHDATE	UDT_FUZZYDATE	IN	Birth date
@ADDRESS_ADDRESSTYPECODEID	uniqueidentifier	IN	Address type
@ADDRESS_DONOTMAIL	bit	IN	Do not send mail to this address
@ADDRESS_DONOTMAILREASONCODEID	uniqueidentifier	IN	Reason
@ADDRESS_COUNTRYID	uniqueidentifier	IN	Country
@ADDRESS_STATEID	uniqueidentifier	IN	State
@ADDRESS_ADDRESSBLOCK	nvarchar(150)	IN	Address
@ADDRESS_CITY	nvarchar(50)	IN	City
@ADDRESS_POSTCODE	nvarchar(12)	IN	ZIP
@ADDRESS_UPDATEMATCHINGHOUSEHOLDADDRESSES	bit	IN	Update matching addresses in household
@ADDRESS_OMITFROMVALIDATION	bit	IN	Omit from validation
@ADDRESS_CART	nvarchar(10)	IN
@ADDRESS_DPC	nvarchar(8)	IN
@ADDRESS_LOT	nvarchar(5)	IN
@ADDRESS_COUNTYCODEID	uniqueidentifier	IN
@ADDRESS_CONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN
@ADDRESS_LASTVALIDATIONATTEMPTDATE	datetime	IN
@ADDRESS_VALIDATIONMESSAGE	nvarchar(200)	IN
@ADDRESS_CERTIFICATIONDATA	int	IN
@PHONE_PHONETYPECODEID	uniqueidentifier	IN	Phone type
@PHONE_NUMBER	nvarchar(100)	IN	Phone number
@EMAILADDRESS_EMAILADDRESSTYPECODEID	uniqueidentifier	IN	Email type
@EMAILADDRESS_EMAILADDRESS	UDT_EMAILADDRESS	IN	Email address
@MARITALSTATUSCODEID	uniqueidentifier	IN	Marital status
@ORGANIZATION_ADDRESSTYPECODEID	uniqueidentifier	IN	Address type
@ORGANIZATION_DONOTMAIL	bit	IN	Do not send mail to this address
@ORGANIZATION_DONOTMAILREASONCODEID	uniqueidentifier	IN	Reason
@ORGANIZATION_COUNTRYID	uniqueidentifier	IN	Country
@ORGANIZATION_STATEID	uniqueidentifier	IN	State
@ORGANIZATION_ADDRESSBLOCK	nvarchar(150)	IN	Address
@ORGANIZATION_CITY	nvarchar(50)	IN	City
@ORGANIZATION_POSTCODE	nvarchar(12)	IN	ZIP
@ORGANIZATION_OMITFROMVALIDATION	bit	IN	Omit this address
@ORGANIZATION_CART	nvarchar(10)	IN
@ORGANIZATION_DPC	nvarchar(8)	IN
@ORGANIZATION_LOT	nvarchar(5)	IN
@ORGANIZATION_COUNTYCODEID	uniqueidentifier	IN
@ORGANIZATION_CONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN
@ORGANIZATION_LASTVALIDATIONATTEMPTDATE	datetime	IN
@ORGANIZATION_VALIDATIONMESSAGE	nvarchar(200)	IN
@ORGANIZATION_CERTIFICATIONDATA	int	IN
@ORGANIZATION_PHONETYPECODEID	uniqueidentifier	IN	Phone type
@ORGANIZATION_NUMBER	nvarchar(100)	IN	Phone number
@ORGANIZATION_EMAILADDRESSTYPECODEID	uniqueidentifier	IN	Email type
@ORGANIZATION_EMAILADDRESS	UDT_EMAILADDRESS	IN	Email address
@WEBADDRESS	UDT_WEBADDRESS	IN	Website
@INDUSTRYCODEID	uniqueidentifier	IN	Industry
@NUMEMPLOYEES	int	IN	Number of employees
@NUMSUBSIDIARIES	int	IN	Number of subsidiaries
@PARENTCORPID	uniqueidentifier	IN	Parent org
@BATCHSPOUSEID	uniqueidentifier	IN	Batch spouse id
@BATCHSPOUSERELATIONID	uniqueidentifier	IN	Batch spouse relation id
@SPOUSEID	uniqueidentifier	IN	Full name
@EXISTINGSPOUSE	bit	IN	Existing constituent
@SPOUSE_LASTNAME	nvarchar(100)	IN	Last Name
@SPOUSE_FIRSTNAME	nvarchar(50)	IN	First Name
@SPOUSE_MIDDLENAME	nvarchar(50)	IN	Middle Name
@SPOUSE_MAIDENNAME	nvarchar(100)	IN	Maiden Name
@SPOUSE_NICKNAME	nvarchar(50)	IN	Nickname
@SPOUSE_TITLECODEID	uniqueidentifier	IN	Title
@SPOUSE_SUFFIXCODEID	uniqueidentifier	IN	Suffix
@SPOUSE_GENDERCODE	tinyint	IN	Gender
@SPOUSE_BIRTHDATE	UDT_FUZZYDATE	IN	Birth date
@SPOUSE_RECIPROCALTYPECODEID	uniqueidentifier	IN	Reciprocal relationship type
@SPOUSE_RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Relationship type
@COPYPRIMARYINFORMATION	bit	IN	Copy primary information
@SPOUSE_STARTDATE	datetime	IN	Start date
@ISSPOUSERELATIONSHIP	bit	IN	Is spouse relationship
@BATCHBUSINESSID	uniqueidentifier	IN	Batch organization id
@BATCHBUSINESSRELATIONID	uniqueidentifier	IN	Batch organization relation id
@BUSINESSID	uniqueidentifier	IN	Org name
@EXISTINGBUSINESS	bit	IN	Existing constituent
@BUSINESS_NAME	nvarchar(100)	IN	Org name
@BUSINESS_ADDRESSTYPECODEID	uniqueidentifier	IN	Address type
@BUSINESS_COUNTRYID	uniqueidentifier	IN	Country
@BUSINESS_STATEID	uniqueidentifier	IN	State
@BUSINESS_ADDRESSBLOCK	nvarchar(150)	IN	Address
@BUSINESS_CITY	nvarchar(50)	IN	City
@BUSINESS_POSTCODE	nvarchar(12)	IN	ZIP
@BUSINESS_DONOTMAIL	bit	IN	Do not send mail to this address
@BUSINESS_DONOTMAILREASONCODEID	uniqueidentifier	IN	Reason
@BUSINESS_OMITFROMVALIDATION	bit	IN	Omit this address
@BUSINESS_CART	nvarchar(10)	IN
@BUSINESS_DPC	nvarchar(8)	IN
@BUSINESS_LOT	nvarchar(5)	IN
@BUSINESS_COUNTYCODEID	uniqueidentifier	IN
@BUSINESS_CONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN
@BUSINESS_LASTVALIDATIONATTEMPTDATE	datetime	IN
@BUSINESS_VALIDATIONMESSAGE	nvarchar(200)	IN
@BUSINESS_CERTIFICATIONDATA	int	IN
@BUSINESS_PHONETYPECODEID	uniqueidentifier	IN	Phone type
@BUSINESS_NUMBER	nvarchar(100)	IN	Phone number
@BUSINESS_RECIPROCALTYPECODEID	uniqueidentifier	IN	Reciprocal relationship type
@BUSINESS_RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Relationship type
@BUSINESS_STARTDATE	datetime	IN	Start date
@ISCONTACT	bit	IN	Is contact
@ISPRIMARYCONTACT	bit	IN	Primary contact
@CONTACTTYPECODEID	uniqueidentifier	IN	Contact type
@POSITION	nvarchar(100)	IN	Job title
@ISMATCHINGGIFTRELATIONSHIP	bit	IN	This organization will match individual's contributions
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@GROUP_NAME	nvarchar(100)	IN	Name
@GROUP_DESCRIPTION	nvarchar(300)	IN	Description
@GROUP_GIVESANONYMOUSLY	bit	IN	Group gives anonymously
@GROUP_ADDRESSTYPECODEID	uniqueidentifier	IN	Address type
@GROUP_COUNTRYID	uniqueidentifier	IN	Country
@GROUP_ADDRESSBLOCK	nvarchar(150)	IN	Address
@GROUP_CITY	nvarchar(50)	IN	City
@GROUP_STATEID	uniqueidentifier	IN	State
@GROUP_OMITFROMVALIDATION	bit	IN	Omit this address from validation
@GROUP_CART	nvarchar(10)	IN
@GROUP_DPC	nvarchar(8)	IN
@GROUP_LOT	nvarchar(5)	IN
@GROUP_COUNTYCODEID	uniqueidentifier	IN
@GROUP_CONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN
@GROUP_LASTVALIDATIONATTEMPTDATE	datetime	IN
@GROUP_VALIDATIONMESSAGE	nvarchar(200)	IN
@GROUP_CERTIFICATIONDATA	int	IN
@GROUP_POSTCODE	nvarchar(12)	IN	ZIP
@GROUP_PHONETYPECODEID	uniqueidentifier	IN	Phone type
@GROUP_NUMBER	nvarchar(100)	IN	Phone number
@GROUP_EMAILADDRESSTYPECODEID	uniqueidentifier	IN	Email type
@GROUP_EMAILADDRESS	UDT_EMAILADDRESS	IN	Email address
@GROUP_WEBADDRESS	UDT_WEBADDRESS	IN	Website
@GROUP_DONOTMAIL	bit	IN	Do not send mail to this address
@GROUP_DONOTMAILREASONCODEID	uniqueidentifier	IN	Reason
@GROUP_UPDATEMATCHINGHOUSEHOLDADDRESSES	bit	IN	Update matching addresses in household
@GROUP_GROUPTYPEID	uniqueidentifier	IN	Group type
@GROUP_PRIMARYCONTACTID	uniqueidentifier	IN	Primary contact
@GROUP_MEMBERS	xml	IN	Members
@GROUP_NEWMEMBERSEARCHID	uniqueidentifier	IN	Search for constituents to include in the group
@GROUP_STARTDATE	datetime	IN	Start date
@HOUSEHOLD_PRIMARYCONTACTID	uniqueidentifier	IN	Full name
@HOUSEHOLD_PRIMARYCONTACT_KEYNAME	nvarchar(100)	IN	Last name
@HOUSEHOLD_PRIMARYCONTACT_FIRSTNAME	nvarchar(50)	IN	First name
@HOUSEHOLD_PRIMARYCONTACT_MIDDLENAME	nvarchar(50)	IN	Middle name
@HOUSEHOLD_PRIMARYCONTACT_TITLECODEID	uniqueidentifier	IN	Title
@HOUSEHOLD_PRIMARYCONTACT_SUFFIXCODEID	uniqueidentifier	IN	Suffix
@HOUSEHOLD_PRIMARYCONTACT_COPYHOUSEHOLDCONTACT	bit	IN	Copy household contact information
@HOUSEHOLD_SECONDMEMBERID	uniqueidentifier	IN	Full name
@HOUSEHOLD_SECONDMEMBER_KEYNAME	nvarchar(100)	IN	Last name
@HOUSEHOLD_SECONDMEMBER_FIRSTNAME	nvarchar(50)	IN	First name
@HOUSEHOLD_SECONDMEMBER_MIDDLENAME	nvarchar(50)	IN	Middle name
@HOUSEHOLD_SECONDMEMBER_TITLECODEID	uniqueidentifier	IN	Title
@HOUSEHOLD_SECONDMEMBER_SUFFIXCODEID	uniqueidentifier	IN	Suffix
@HOUSEHOLD_SECONDMEMBER_COPYHOUSEHOLDCONTACT	bit	IN	Copy household contact information
@HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_RECIPROCALTYPECODEID	uniqueidentifier	IN	Reciprocal relationship type
@HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Relationship type
@HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_STARTDATE	datetime	IN	Start date
@HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_ISSPOUSE	bit	IN	This is the spouse relationship
@HOUSEHOLDCOPYPRIMARYCONTACTINFO	bit	IN	Copy primary contact information to household
@JOBCATEGORYCODEID	uniqueidentifier	IN	Category
@CAREERLEVELCODEID	uniqueidentifier	IN	Career level
@GROUP_DONOTCALL	bit	IN	Do not call this phone number
@GROUP_DONOTEMAIL	bit	IN	Do not send email to this address

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEBATCHCONSTITUENT_3
(

    @ID                                            uniqueidentifier,
    @CHANGEAGENTID                                uniqueidentifier,
    @LASTNAME                                    nvarchar(100),
    @ORGANIZATIONNAME                            nvarchar(100),
    @FIRSTNAME                                    nvarchar(50),
    @MIDDLENAME                                    nvarchar(50),
    @MAIDENNAME                                    nvarchar(100),
    @NICKNAME                                    nvarchar(50),
    @TITLECODEID                                uniqueidentifier,
    @SUFFIXCODEID                                uniqueidentifier,
    @GENDERCODE                                    tinyint,
    @BIRTHDATE                                    dbo.UDT_FUZZYDATE,
    @ADDRESS_ADDRESSTYPECODEID                    uniqueidentifier,
    @ADDRESS_DONOTMAIL                            bit,
    @ADDRESS_DONOTMAILREASONCODEID                uniqueidentifier,
    @ADDRESS_COUNTRYID                            uniqueidentifier,
    @ADDRESS_STATEID                            uniqueidentifier,
    @ADDRESS_ADDRESSBLOCK                        nvarchar(150),
    @ADDRESS_CITY                                nvarchar(50),
    @ADDRESS_POSTCODE                            nvarchar(12),
    @ADDRESS_UPDATEMATCHINGHOUSEHOLDADDRESSES    bit,

    -- Address Validation

    @ADDRESS_OMITFROMVALIDATION                bit,
    @ADDRESS_CART                            nvarchar(10),
    @ADDRESS_DPC                            nvarchar(8),
    @ADDRESS_LOT                            nvarchar(5),
    @ADDRESS_COUNTYCODEID                    uniqueidentifier,
    @ADDRESS_CONGRESSIONALDISTRICTCODEID    uniqueidentifier,
    @ADDRESS_LASTVALIDATIONATTEMPTDATE        datetime,
    @ADDRESS_VALIDATIONMESSAGE                nvarchar(200),
    @ADDRESS_CERTIFICATIONDATA                integer,
    @PHONE_PHONETYPECODEID                    uniqueidentifier,
    @PHONE_NUMBER                            nvarchar(100),
    @EMAILADDRESS_EMAILADDRESSTYPECODEID    uniqueidentifier,
    @EMAILADDRESS_EMAILADDRESS                dbo.UDT_EMAILADDRESS,
    @MARITALSTATUSCODEID                    uniqueidentifier,
    @ORGANIZATION_ADDRESSTYPECODEID            uniqueidentifier,
    @ORGANIZATION_DONOTMAIL                    bit,
    @ORGANIZATION_DONOTMAILREASONCODEID        uniqueidentifier,
    @ORGANIZATION_COUNTRYID                    uniqueidentifier,
    @ORGANIZATION_STATEID                    uniqueidentifier,
    @ORGANIZATION_ADDRESSBLOCK                nvarchar(150),
    @ORGANIZATION_CITY                        nvarchar(50),
    @ORGANIZATION_POSTCODE                    nvarchar(12),

    -- Address Validation

    @ORGANIZATION_OMITFROMVALIDATION            bit,
    @ORGANIZATION_CART                            nvarchar(10),
    @ORGANIZATION_DPC                            nvarchar(8),
    @ORGANIZATION_LOT                            nvarchar(5),
    @ORGANIZATION_COUNTYCODEID                    uniqueidentifier,
    @ORGANIZATION_CONGRESSIONALDISTRICTCODEID    uniqueidentifier,
    @ORGANIZATION_LASTVALIDATIONATTEMPTDATE        datetime,
    @ORGANIZATION_VALIDATIONMESSAGE                nvarchar(200),
    @ORGANIZATION_CERTIFICATIONDATA                integer,
    @ORGANIZATION_PHONETYPECODEID                uniqueidentifier,
    @ORGANIZATION_NUMBER                        nvarchar(100),
    @ORGANIZATION_EMAILADDRESSTYPECODEID        uniqueidentifier,
    @ORGANIZATION_EMAILADDRESS                    dbo.UDT_EMAILADDRESS,
    @WEBADDRESS                                    dbo.UDT_WEBADDRESS,
    @INDUSTRYCODEID                                uniqueidentifier,
    @NUMEMPLOYEES                                int,
    @NUMSUBSIDIARIES                            int,
    @PARENTCORPID                                uniqueidentifier,

    --Individual's relationship Variables

    @BATCHSPOUSEID                        uniqueidentifier,
    @BATCHSPOUSERELATIONID                uniqueidentifier,
    @SPOUSEID                            uniqueidentifier,
    @EXISTINGSPOUSE                        bit,
    @SPOUSE_LASTNAME                    nvarchar(100),
    @SPOUSE_FIRSTNAME                    nvarchar(50),
    @SPOUSE_MIDDLENAME                    nvarchar(50),
    @SPOUSE_MAIDENNAME                    nvarchar(100),
    @SPOUSE_NICKNAME                    nvarchar(50),
    @SPOUSE_TITLECODEID                    uniqueidentifier,
    @SPOUSE_SUFFIXCODEID                uniqueidentifier,
    @SPOUSE_GENDERCODE                    tinyint,
    @SPOUSE_BIRTHDATE                    dbo.UDT_FUZZYDATE,
    @SPOUSE_RECIPROCALTYPECODEID        uniqueidentifier,
    @SPOUSE_RELATIONSHIPTYPECODEID        uniqueidentifier,
    @COPYPRIMARYINFORMATION                bit,
    @SPOUSE_STARTDATE                    datetime,
    @ISSPOUSERELATIONSHIP                bit,

    --Organization variables

    @BATCHBUSINESSID                uniqueidentifier,
    @BATCHBUSINESSRELATIONID        uniqueidentifier,
    @BUSINESSID                        uniqueidentifier,
    @EXISTINGBUSINESS                bit,
    @BUSINESS_NAME                    nvarchar(100),
    @BUSINESS_ADDRESSTYPECODEID        uniqueidentifier,
    @BUSINESS_COUNTRYID                uniqueidentifier,
    @BUSINESS_STATEID                uniqueidentifier,
    @BUSINESS_ADDRESSBLOCK            nvarchar(150),
    @BUSINESS_CITY                    nvarchar(50),
    @BUSINESS_POSTCODE                nvarchar(12),
    @BUSINESS_DONOTMAIL                bit,
    @BUSINESS_DONOTMAILREASONCODEID uniqueidentifier,

    -- Address Validation

    @BUSINESS_OMITFROMVALIDATION                bit,
    @BUSINESS_CART                            nvarchar(10),
    @BUSINESS_DPC                            nvarchar(8),
    @BUSINESS_LOT                            nvarchar(5),
    @BUSINESS_COUNTYCODEID                    uniqueidentifier,
    @BUSINESS_CONGRESSIONALDISTRICTCODEID    uniqueidentifier,
    @BUSINESS_LASTVALIDATIONATTEMPTDATE        datetime,
    @BUSINESS_VALIDATIONMESSAGE                nvarchar(200),
    @BUSINESS_CERTIFICATIONDATA                integer,
    @BUSINESS_PHONETYPECODEID            uniqueidentifier,
    @BUSINESS_NUMBER                    nvarchar(100),
    @BUSINESS_RECIPROCALTYPECODEID        uniqueidentifier,
    @BUSINESS_RELATIONSHIPTYPECODEID    uniqueidentifier,
    @BUSINESS_STARTDATE                    datetime,                        
    @ISCONTACT                                bit,
    @ISPRIMARYCONTACT                        bit,
    @CONTACTTYPECODEID                        uniqueidentifier,
    @POSITION                                nvarchar(100),
    @ISMATCHINGGIFTRELATIONSHIP                bit,

    @CURRENTAPPUSERID uniqueidentifier,

    -- Group/Household variables

    @GROUP_NAME nvarchar(100),
    @GROUP_DESCRIPTION nvarchar(300),
    @GROUP_GIVESANONYMOUSLY bit,
    @GROUP_ADDRESSTYPECODEID uniqueidentifier,
    @GROUP_COUNTRYID uniqueidentifier,
    @GROUP_ADDRESSBLOCK nvarchar(150),
    @GROUP_CITY nvarchar(50),
    @GROUP_STATEID uniqueidentifier,
    @GROUP_OMITFROMVALIDATION                bit,
    @GROUP_CART                            nvarchar(10),
    @GROUP_DPC                            nvarchar(8),
    @GROUP_LOT                            nvarchar(5),
    @GROUP_COUNTYCODEID                    uniqueidentifier,
    @GROUP_CONGRESSIONALDISTRICTCODEID    uniqueidentifier,
    @GROUP_LASTVALIDATIONATTEMPTDATE        datetime,
    @GROUP_VALIDATIONMESSAGE                nvarchar(200),
    @GROUP_CERTIFICATIONDATA                integer,
    @GROUP_POSTCODE nvarchar(12),
    @GROUP_PHONETYPECODEID uniqueidentifier,
    @GROUP_NUMBER nvarchar(100),
    @GROUP_EMAILADDRESSTYPECODEID uniqueidentifier,
    @GROUP_EMAILADDRESS dbo.UDT_EMAILADDRESS,
    @GROUP_WEBADDRESS    dbo.UDT_WEBADDRESS,
    @GROUP_DONOTMAIL bit,
    @GROUP_DONOTMAILREASONCODEID uniqueidentifier,
    @GROUP_UPDATEMATCHINGHOUSEHOLDADDRESSES bit,

    -- Group variables

    @GROUP_GROUPTYPEID uniqueidentifier,
    @GROUP_PRIMARYCONTACTID uniqueidentifier,
    @GROUP_MEMBERS xml,
    @GROUP_NEWMEMBERSEARCHID uniqueidentifier, -- Not used in save operation, only exists to setup new member lookup control.

    @GROUP_STARTDATE datetime,

    -- Household Primary Member variables

    @HOUSEHOLD_PRIMARYCONTACTID uniqueidentifier,
    @HOUSEHOLD_PRIMARYCONTACT_KEYNAME nvarchar(100),
    @HOUSEHOLD_PRIMARYCONTACT_FIRSTNAME nvarchar(50),
    @HOUSEHOLD_PRIMARYCONTACT_MIDDLENAME nvarchar(50),
    @HOUSEHOLD_PRIMARYCONTACT_TITLECODEID uniqueidentifier,
    @HOUSEHOLD_PRIMARYCONTACT_SUFFIXCODEID uniqueidentifier,
    @HOUSEHOLD_PRIMARYCONTACT_COPYHOUSEHOLDCONTACT bit,

    -- Household Second Member variables

    @HOUSEHOLD_SECONDMEMBERID uniqueidentifier,
    @HOUSEHOLD_SECONDMEMBER_KEYNAME nvarchar(100),
    @HOUSEHOLD_SECONDMEMBER_FIRSTNAME nvarchar(50),
    @HOUSEHOLD_SECONDMEMBER_MIDDLENAME nvarchar(50),
    @HOUSEHOLD_SECONDMEMBER_TITLECODEID uniqueidentifier,
    @HOUSEHOLD_SECONDMEMBER_SUFFIXCODEID uniqueidentifier,
    @HOUSEHOLD_SECONDMEMBER_COPYHOUSEHOLDCONTACT bit,

    -- Household Second Member Relationship variables

    @HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_RECIPROCALTYPECODEID uniqueidentifier,
    @HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_RELATIONSHIPTYPECODEID uniqueidentifier,
    @HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_STARTDATE datetime,
    @HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_ISSPOUSE bit,

    -- Individual's household fields

    @HOUSEHOLDCOPYPRIMARYCONTACTINFO bit,

    @JOBCATEGORYCODEID uniqueidentifier,
    @CAREERLEVELCODEID uniqueidentifier,
    @GROUP_DONOTCALL bit,
    @GROUP_DONOTEMAIL bit
  )
as
begin
  declare 
    @GENDERCODEID uniqueidentifier,
    @SPOUSE_GENDERCODEID uniqueidentifier;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REVENUEBATCHCONSTITUENT_3 
        @ID = @ID,
        @CURRENTAPPUSERID = @CURRENTAPPUSERID,
        @GENDERCODEID = @GENDERCODEID output,
        @SPOUSE_GENDERCODEID = @SPOUSE_GENDERCODEID output;

    exec  dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEBATCHCONSTITUENT_4
        @ID,
        @CHANGEAGENTID,
        @LASTNAME,
        @ORGANIZATIONNAME,
        @FIRSTNAME,
        @MIDDLENAME,
        @MAIDENNAME,
        @NICKNAME,
        @TITLECODEID,
        @SUFFIXCODEID,
        @GENDERCODE,
        @BIRTHDATE,
        @ADDRESS_ADDRESSTYPECODEID,
        @ADDRESS_DONOTMAIL,
        @ADDRESS_DONOTMAILREASONCODEID,
        @ADDRESS_COUNTRYID,
        @ADDRESS_STATEID,
        @ADDRESS_ADDRESSBLOCK,
        @ADDRESS_CITY,
        @ADDRESS_POSTCODE,
        @ADDRESS_UPDATEMATCHINGHOUSEHOLDADDRESSES,

        -- Address Validation

        @ADDRESS_OMITFROMVALIDATION,
        @ADDRESS_CART,
        @ADDRESS_DPC,
        @ADDRESS_LOT,
        @ADDRESS_COUNTYCODEID,
        @ADDRESS_CONGRESSIONALDISTRICTCODEID,
        @ADDRESS_LASTVALIDATIONATTEMPTDATE,
        @ADDRESS_VALIDATIONMESSAGE,
        @ADDRESS_CERTIFICATIONDATA,
        @PHONE_PHONETYPECODEID,
        @PHONE_NUMBER,
        @EMAILADDRESS_EMAILADDRESSTYPECODEID,
        @EMAILADDRESS_EMAILADDRESS,
        @MARITALSTATUSCODEID,
        @ORGANIZATION_ADDRESSTYPECODEID,
        @ORGANIZATION_DONOTMAIL,
        @ORGANIZATION_DONOTMAILREASONCODEID,
        @ORGANIZATION_COUNTRYID,
        @ORGANIZATION_STATEID,
        @ORGANIZATION_ADDRESSBLOCK,
        @ORGANIZATION_CITY,
        @ORGANIZATION_POSTCODE,

        -- Address Validation

        @ORGANIZATION_OMITFROMVALIDATION,
        @ORGANIZATION_CART,
        @ORGANIZATION_DPC,
        @ORGANIZATION_LOT,
        @ORGANIZATION_COUNTYCODEID,
        @ORGANIZATION_CONGRESSIONALDISTRICTCODEID,
        @ORGANIZATION_LASTVALIDATIONATTEMPTDATE,
        @ORGANIZATION_VALIDATIONMESSAGE,
        @ORGANIZATION_CERTIFICATIONDATA,
        @ORGANIZATION_PHONETYPECODEID,
        @ORGANIZATION_NUMBER,
        @ORGANIZATION_EMAILADDRESSTYPECODEID,
        @ORGANIZATION_EMAILADDRESS,
        @WEBADDRESS,
        @INDUSTRYCODEID,
        @NUMEMPLOYEES,
        @NUMSUBSIDIARIES,
        @PARENTCORPID,

        --Individual's relationship Variables

        @BATCHSPOUSEID,
        @BATCHSPOUSERELATIONID,
        @SPOUSEID,
        @EXISTINGSPOUSE,
        @SPOUSE_LASTNAME,
        @SPOUSE_FIRSTNAME,
        @SPOUSE_MIDDLENAME,
        @SPOUSE_MAIDENNAME,
        @SPOUSE_NICKNAME,
        @SPOUSE_TITLECODEID,
        @SPOUSE_SUFFIXCODEID,
        @SPOUSE_GENDERCODE,
        @SPOUSE_BIRTHDATE,
        @SPOUSE_RECIPROCALTYPECODEID,
        @SPOUSE_RELATIONSHIPTYPECODEID,
        @COPYPRIMARYINFORMATION,
        @SPOUSE_STARTDATE,
        @ISSPOUSERELATIONSHIP,

        --Organization variables

        @BATCHBUSINESSID,
        @BATCHBUSINESSRELATIONID,
        @BUSINESSID,
        @EXISTINGBUSINESS,
        @BUSINESS_NAME,
        @BUSINESS_ADDRESSTYPECODEID,
        @BUSINESS_COUNTRYID,
        @BUSINESS_STATEID,
        @BUSINESS_ADDRESSBLOCK,
        @BUSINESS_CITY,
        @BUSINESS_POSTCODE,
        @BUSINESS_DONOTMAIL,
        @BUSINESS_DONOTMAILREASONCODEID,

        -- Address Validation

        @BUSINESS_OMITFROMVALIDATION,
        @BUSINESS_CART,
        @BUSINESS_DPC,
        @BUSINESS_LOT,
        @BUSINESS_COUNTYCODEID,
        @BUSINESS_CONGRESSIONALDISTRICTCODEID,
        @BUSINESS_LASTVALIDATIONATTEMPTDATE,
        @BUSINESS_VALIDATIONMESSAGE,
        @BUSINESS_CERTIFICATIONDATA,
        @BUSINESS_PHONETYPECODEID,
        @BUSINESS_NUMBER,
        @BUSINESS_RECIPROCALTYPECODEID,
        @BUSINESS_RELATIONSHIPTYPECODEID,
        @BUSINESS_STARTDATE,
        @ISCONTACT,
        @ISPRIMARYCONTACT,
        @CONTACTTYPECODEID,
        @POSITION,
        @ISMATCHINGGIFTRELATIONSHIP,
        @CURRENTAPPUSERID,

        -- Group/Household variables

        @GROUP_NAME,
        @GROUP_DESCRIPTION,
        @GROUP_GIVESANONYMOUSLY,
        @GROUP_ADDRESSTYPECODEID,
        @GROUP_COUNTRYID,
  @GROUP_ADDRESSBLOCK,
        @GROUP_CITY,
        @GROUP_STATEID,
        @GROUP_OMITFROMVALIDATION,
        @GROUP_CART,
        @GROUP_DPC,
        @GROUP_LOT,
        @GROUP_COUNTYCODEID,
        @GROUP_CONGRESSIONALDISTRICTCODEID,
        @GROUP_LASTVALIDATIONATTEMPTDATE,
        @GROUP_VALIDATIONMESSAGE,
        @GROUP_CERTIFICATIONDATA,
        @GROUP_POSTCODE,
        @GROUP_PHONETYPECODEID,
        @GROUP_NUMBER,
        @GROUP_EMAILADDRESSTYPECODEID,
        @GROUP_EMAILADDRESS,
        @GROUP_WEBADDRESS,
        @GROUP_DONOTMAIL,
        @GROUP_DONOTMAILREASONCODEID,
        @GROUP_UPDATEMATCHINGHOUSEHOLDADDRESSES,

        -- Group variables

        @GROUP_GROUPTYPEID,
        @GROUP_PRIMARYCONTACTID,
        @GROUP_MEMBERS,
        @GROUP_NEWMEMBERSEARCHID,
        @GROUP_STARTDATE,

        -- Household Primary Member variables

        @HOUSEHOLD_PRIMARYCONTACTID,
        @HOUSEHOLD_PRIMARYCONTACT_KEYNAME,
        @HOUSEHOLD_PRIMARYCONTACT_FIRSTNAME,
        @HOUSEHOLD_PRIMARYCONTACT_MIDDLENAME,
        @HOUSEHOLD_PRIMARYCONTACT_TITLECODEID,
        @HOUSEHOLD_PRIMARYCONTACT_SUFFIXCODEID,
        @HOUSEHOLD_PRIMARYCONTACT_COPYHOUSEHOLDCONTACT,

        -- Household Second Member variables

        @HOUSEHOLD_SECONDMEMBERID,
        @HOUSEHOLD_SECONDMEMBER_KEYNAME,
        @HOUSEHOLD_SECONDMEMBER_FIRSTNAME,
        @HOUSEHOLD_SECONDMEMBER_MIDDLENAME,
        @HOUSEHOLD_SECONDMEMBER_TITLECODEID,
        @HOUSEHOLD_SECONDMEMBER_SUFFIXCODEID,
        @HOUSEHOLD_SECONDMEMBER_COPYHOUSEHOLDCONTACT,

        -- Household Second Member Relationship variables

        @HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_RECIPROCALTYPECODEID,
        @HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_RELATIONSHIPTYPECODEID,
        @HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_STARTDATE,
        @HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_ISSPOUSE,

        -- Individual's household fields

        @HOUSEHOLDCOPYPRIMARYCONTACTINFO,
        @JOBCATEGORYCODEID,
        @CAREERLEVELCODEID,
        @GROUP_DONOTCALL,
        @GROUP_DONOTEMAIL,
        @GENDERCODEID,
        @SPOUSE_GENDERCODEID
end