USP_DATAFORMTEMPLATE_EDIT_REVENUEBATCHCONSTITUENTINBATCH_4

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
@SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit IN
@SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR decimal(5, 2) IN
@SPOUSE_PRIMARYRECOGNITIONTYPECODEID uniqueidentifier IN
@SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit IN
@SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR decimal(5, 2) IN
@SPOUSE_RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier IN
@BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit IN
@BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR decimal(5, 2) IN
@BUSINESS_PRIMARYRECOGNITIONTYPECODEID uniqueidentifier IN
@BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit IN
@BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR decimal(5, 2) IN
@BUSINESS_RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier IN
@ORIGINAL_KEYNAME nvarchar(100) IN
@ORIGINAL_FIRSTNAME nvarchar(50) IN

Definition

Copy 


  CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEBATCHCONSTITUENTINBATCH_4 (
    @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),
    @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,
    @ORIGINAL_KEYNAME nvarchar(100),
    @ORIGINAL_FIRSTNAME nvarchar(50)
  )
  as
  begin
    declare     
      @GENDERCODEID uniqueidentifier,
      @SPOUSE_GENDERCODEID uniqueidentifier

      exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REVENUEBATCHCONSTITUENTINBATCH
          @ID = @ID,
          @CURRENTAPPUSERID = @CURRENTAPPUSERID,
          @GENDERCODEID = @GENDERCODEID,
          @SPOUSE_GENDERCODEID = @SPOUSE_GENDERCODEID

      exec dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEBATCHCONSTITUENTINBATCH_5
          @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,
          @ORIGINAL_KEYNAME,
          @ORIGINAL_FIRSTNAME,
          @GENDERCODEID,
          @SPOUSE_GENDERCODEID
  end