USP_DATAFORMTEMPLATE_EDIT_REVENUEBATCHCONSTITUENTINBATCH_2

Parameters

Parameter Parameter Type Mode Description
@ID nvarchar(110) IN
@CHANGEAGENTID uniqueidentifier IN
@LASTNAME nvarchar(100) IN
@ORGANIZATIONNAME nvarchar(100) IN
@FIRSTNAME nvarchar(50) IN
@MIDDLENAME nvarchar(50) IN
@MAIDENNAME nvarchar(100) IN
@NICKNAME nvarchar(50) IN
@TITLECODEID uniqueidentifier IN
@SUFFIXCODEID uniqueidentifier IN
@GENDERCODE tinyint IN
@BIRTHDATE UDT_FUZZYDATE IN
@ADDRESS_ADDRESSTYPECODEID uniqueidentifier IN
@ADDRESS_DONOTMAIL bit IN
@ADDRESS_DONOTMAILREASONCODEID uniqueidentifier IN
@ADDRESS_COUNTRYID uniqueidentifier IN
@ADDRESS_STATEID uniqueidentifier IN
@ADDRESS_ADDRESSBLOCK nvarchar(150) IN
@ADDRESS_CITY nvarchar(50) IN
@ADDRESS_POSTCODE nvarchar(12) IN
@ADDRESS_UPDATEMATCHINGHOUSEHOLDADDRESSES bit IN
@ADDRESS_OMITFROMVALIDATION bit IN
@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(100) IN
@ADDRESS_CERTIFICATIONDATA int IN
@PHONE_PHONETYPECODEID uniqueidentifier IN
@PHONE_NUMBER nvarchar(100) IN
@EMAILADDRESS_EMAILADDRESSTYPECODEID uniqueidentifier IN
@EMAILADDRESS_EMAILADDRESS UDT_EMAILADDRESS IN
@MARITALSTATUSCODEID uniqueidentifier IN
@ORGANIZATION_ADDRESSTYPECODEID uniqueidentifier IN
@ORGANIZATION_DONOTMAIL bit IN
@ORGANIZATION_DONOTMAILREASONCODEID uniqueidentifier IN
@ORGANIZATION_COUNTRYID uniqueidentifier IN
@ORGANIZATION_STATEID uniqueidentifier IN
@ORGANIZATION_ADDRESSBLOCK nvarchar(150) IN
@ORGANIZATION_CITY nvarchar(50) IN
@ORGANIZATION_POSTCODE nvarchar(12) IN
@ORGANIZATION_OMITFROMVALIDATION bit IN
@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(100) IN
@ORGANIZATION_CERTIFICATIONDATA int IN
@ORGANIZATION_PHONETYPECODEID uniqueidentifier IN
@ORGANIZATION_NUMBER nvarchar(100) IN
@ORGANIZATION_EMAILADDRESSTYPECODEID uniqueidentifier IN
@ORGANIZATION_EMAILADDRESS UDT_EMAILADDRESS IN
@WEBADDRESS UDT_WEBADDRESS IN
@INDUSTRYCODEID uniqueidentifier IN
@NUMEMPLOYEES int IN
@NUMSUBSIDIARIES int IN
@PARENTCORPID uniqueidentifier IN
@BATCHSPOUSEID uniqueidentifier IN
@BATCHSPOUSERELATIONID uniqueidentifier IN
@SPOUSEID uniqueidentifier IN
@EXISTINGSPOUSE bit IN
@SPOUSE_LASTNAME nvarchar(100) IN
@SPOUSE_FIRSTNAME nvarchar(50) IN
@SPOUSE_MIDDLENAME nvarchar(50) IN
@SPOUSE_MAIDENNAME nvarchar(100) IN
@SPOUSE_NICKNAME nvarchar(50) IN
@SPOUSE_TITLECODEID uniqueidentifier IN
@SPOUSE_SUFFIXCODEID uniqueidentifier IN
@SPOUSE_GENDERCODE tinyint IN
@SPOUSE_BIRTHDATE UDT_FUZZYDATE IN
@SPOUSE_RECIPROCALTYPECODEID uniqueidentifier IN
@SPOUSE_RELATIONSHIPTYPECODEID uniqueidentifier IN
@COPYPRIMARYINFORMATION bit IN
@SPOUSE_STARTDATE datetime IN
@ISSPOUSERELATIONSHIP bit IN
@BATCHBUSINESSID uniqueidentifier IN
@BATCHBUSINESSRELATIONID uniqueidentifier IN
@BUSINESSID uniqueidentifier IN
@EXISTINGBUSINESS bit IN
@BUSINESS_NAME nvarchar(100) IN
@BUSINESS_ADDRESSTYPECODEID uniqueidentifier IN
@BUSINESS_COUNTRYID uniqueidentifier IN
@BUSINESS_STATEID uniqueidentifier IN
@BUSINESS_ADDRESSBLOCK nvarchar(150) IN
@BUSINESS_CITY nvarchar(50) IN
@BUSINESS_POSTCODE nvarchar(12) IN
@BUSINESS_DONOTMAIL bit IN
@BUSINESS_DONOTMAILREASONCODEID uniqueidentifier IN
@BUSINESS_OMITFROMVALIDATION bit IN
@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(100) IN
@BUSINESS_CERTIFICATIONDATA int IN
@BUSINESS_PHONETYPECODEID uniqueidentifier IN
@BUSINESS_NUMBER nvarchar(100) IN
@BUSINESS_RECIPROCALTYPECODEID uniqueidentifier IN
@BUSINESS_RELATIONSHIPTYPECODEID uniqueidentifier IN
@BUSINESS_STARTDATE datetime IN
@ISCONTACT bit IN
@ISPRIMARYCONTACT bit IN
@CONTACTTYPECODEID uniqueidentifier IN
@POSITION nvarchar(100) IN
@ISMATCHINGGIFTRELATIONSHIP bit IN
@CURRENTAPPUSERID uniqueidentifier IN
@GROUP_NAME nvarchar(100) IN
@GROUP_DESCRIPTION nvarchar(300) IN
@GROUP_GIVESANONYMOUSLY bit IN
@GROUP_ADDRESSTYPECODEID uniqueidentifier IN
@GROUP_COUNTRYID uniqueidentifier IN
@GROUP_ADDRESSBLOCK nvarchar(150) IN
@GROUP_CITY nvarchar(50) IN
@GROUP_STATEID uniqueidentifier IN
@GROUP_OMITFROMVALIDATION bit IN
@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(100) IN
@GROUP_CERTIFICATIONDATA int IN
@GROUP_POSTCODE nvarchar(12) IN
@GROUP_PHONETYPECODEID uniqueidentifier IN
@GROUP_NUMBER nvarchar(100) IN
@GROUP_EMAILADDRESSTYPECODEID uniqueidentifier IN
@GROUP_EMAILADDRESS UDT_EMAILADDRESS IN
@GROUP_WEBADDRESS UDT_WEBADDRESS IN
@GROUP_DONOTMAIL bit IN
@GROUP_DONOTMAILREASONCODEID uniqueidentifier IN
@GROUP_UPDATEMATCHINGHOUSEHOLDADDRESSES bit IN
@GROUP_GROUPTYPEID uniqueidentifier IN
@GROUP_PRIMARYCONTACTID uniqueidentifier IN
@GROUP_MEMBERS xml IN
@GROUP_NEWMEMBERSEARCHID uniqueidentifier IN
@GROUP_STARTDATE datetime IN
@HOUSEHOLD_PRIMARYCONTACTID uniqueidentifier IN
@HOUSEHOLD_PRIMARYCONTACT_KEYNAME nvarchar(100) IN
@HOUSEHOLD_PRIMARYCONTACT_FIRSTNAME nvarchar(50) IN
@HOUSEHOLD_PRIMARYCONTACT_MIDDLENAME nvarchar(50) IN
@HOUSEHOLD_PRIMARYCONTACT_TITLECODEID uniqueidentifier IN
@HOUSEHOLD_PRIMARYCONTACT_SUFFIXCODEID uniqueidentifier IN
@HOUSEHOLD_PRIMARYCONTACT_COPYHOUSEHOLDCONTACT bit IN
@HOUSEHOLD_SECONDMEMBERID uniqueidentifier IN
@HOUSEHOLD_SECONDMEMBER_KEYNAME nvarchar(100) IN
@HOUSEHOLD_SECONDMEMBER_FIRSTNAME nvarchar(50) IN
@HOUSEHOLD_SECONDMEMBER_MIDDLENAME nvarchar(50) IN
@HOUSEHOLD_SECONDMEMBER_TITLECODEID uniqueidentifier IN
@HOUSEHOLD_SECONDMEMBER_SUFFIXCODEID uniqueidentifier IN
@HOUSEHOLD_SECONDMEMBER_COPYHOUSEHOLDCONTACT bit IN
@HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_RECIPROCALTYPECODEID uniqueidentifier IN
@HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_RELATIONSHIPTYPECODEID uniqueidentifier IN
@HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_STARTDATE datetime IN
@HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_ISSPOUSE bit IN
@HOUSEHOLDCOPYPRIMARYCONTACTINFO bit IN
@JOBCATEGORYCODEID uniqueidentifier IN
@CAREERLEVELCODEID uniqueidentifier IN
@GROUP_DONOTCALL bit IN
@GROUP_DONOTEMAIL bit IN
@ADDRESSID uniqueidentifier IN
@PHONEID uniqueidentifier IN
@EMAILADDRESSID uniqueidentifier IN
@SITEID uniqueidentifier IN
@CONSTITUENTSECURITYGROUPID uniqueidentifier IN
@CONSTITUENCYCODEID uniqueidentifier IN
@INFOSOURCECODEID uniqueidentifier IN
@NAMEFORMATS xml IN
@PHONE_COUNTRYID uniqueidentifier IN
@SPOUSE_LOOKUPID nvarchar(100) IN

Definition

Copy 


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEBATCHCONSTITUENTINBATCH_2 (
  @ID                                            nvarchar(110),
  @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(100),
  @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(100),
  @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(100),
  @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(100),
  @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,

  -- The records that were shown on the form.

  @ADDRESSID uniqueidentifier,
  @PHONEID uniqueidentifier,
  @EMAILADDRESSID uniqueidentifier,
  -- Fields specific to BBIS created ERB

  @SITEID uniqueidentifier,
  @CONSTITUENTSECURITYGROUPID uniqueidentifier,
  @CONSTITUENCYCODEID uniqueidentifier,
  @INFOSOURCECODEID uniqueidentifier,
  @NAMEFORMATS xml,
  @PHONE_COUNTRYID uniqueidentifier,
  @SPOUSE_LOOKUPID nvarchar(100)
)
as
begin
  declare     
    @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS   bit,
    @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR    decimal(5,2),
    @SPOUSE_PRIMARYRECOGNITIONTYPECODEID    uniqueidentifier,
    @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS    bit,
    @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR   decimal(5,2), 
    @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID   uniqueidentifier,
    @BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS   bit,
    @BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR    decimal(5,2),
    @BUSINESS_PRIMARYRECOGNITIONTYPECODEID    uniqueidentifier,
    @BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS    bit,
    @BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR   decimal(5,2), 
    @BUSINESS_RECIPROCALRECOGNITIONTYPECODEID   uniqueidentifier

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REVENUEBATCHCONSTITUENTINBATCH 
        @ID = @ID,
        @CURRENTAPPUSERID = @CURRENTAPPUSERID,
        @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS = @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS output,
        @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR = @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR output,
        @SPOUSE_PRIMARYRECOGNITIONTYPECODEID = @SPOUSE_PRIMARYRECOGNITIONTYPECODEID output,
        @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS = @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS output,
        @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR = @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR output,
        @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID = @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID output,
        @BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS = @BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS output,
        @BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR = @BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR output,
        @BUSINESS_PRIMARYRECOGNITIONTYPECODEID = @BUSINESS_PRIMARYRECOGNITIONTYPECODEID output,
        @BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS = @BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS output,
        @BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR = @BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR output,
        @BUSINESS_RECIPROCALRECOGNITIONTYPECODEID = @BUSINESS_RECIPROCALRECOGNITIONTYPECODEID output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEBATCHCONSTITUENTINBATCH_3
    @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,
        -- The records that were shown on the form.

        @ADDRESSID,
        @PHONEID,
        @EMAILADDRESSID,
        -- Fields specific to BBIS created ERB

        @SITEID,
        @CONSTITUENTSECURITYGROUPID,
        @CONSTITUENCYCODEID,
        @INFOSOURCECODEID,
        @NAMEFORMATS,
        @PHONE_COUNTRYID,
        @SPOUSE_LOOKUPID,
    @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
    @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR,
    @SPOUSE_PRIMARYRECOGNITIONTYPECODEID,
    @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
    @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR, 
    @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID,
    @BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
    @BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR,
    @BUSINESS_PRIMARYRECOGNITIONTYPECODEID,
    @BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
    @BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR, 
    @BUSINESS_RECIPROCALRECOGNITIONTYPECODEID
end