USP_REGISTRANTBATCH_ADD_EDIT_2

CREATE procedure dbo.USP_REGISTRANTBATCH_ADD_EDIT_2
(
  @ID uniqueidentifier = null output,
  @REGISTRANTROLECODE int,
  @BATCHID uniqueidentifier = null,
  @EVENTID uniqueidentifier = null,
  @SEQUENCE int = null,
  @USERID nvarchar(100),
  @PASSWORD nvarchar(510),
  @FIRSTNAME nvarchar(100),
  @LASTNAME nvarchar(100),
  @EMAILADDRESS UDT_EMAILADDRESS = '',
  @ADDRESSTYPECODEID uniqueidentifier = null,
  @COUNTRYID uniqueidentifier = null,
  @ADDRESS nvarchar(300) = '',
  @CITY nvarchar(100) = '',
  @STATEID uniqueidentifier = null,
  @POSTCODE nvarchar(24) = '',
  @MIDDLENAME nvarchar(100) = '',
  @TITLECODEID uniqueidentifier = null,
  @SUFFIXCODEID uniqueidentifier = null,
  @NICKNAME nvarchar(100) = '',
  @MAIDENNAME nvarchar(200) = '',
  @BIRTHDATE UDT_FUZZYDATE = '00000000',

  @GENDERCODE int = 0,
  @MARITALSTATUSCODEID uniqueidentifier = null,
  @PHONETYPECODEID uniqueidentifier = null,
  @PHONENUMBER nvarchar(200) = '',
  @DONOTMAIL bit = 0,
  @DONOTMAILREASONCODEID uniqueidentifier = null,
  @FUNDRAISINGGROUPNAME nvarchar(200) = '',
  @TEAMFUNDRAISINGTEAMID uniqueidentifier = null,

  @SAVETRIBUTEEASCONSTITUENT bit = 0,
  @TRIBUTEEFIRSTNAME nvarchar(400) = '',
  @TRIBUTEELASTNAME nvarchar(400) = '',
  @TRIBUTEEEMAIL UDT_EMAILADDRESS = null,
  @TRIBUTEEADDRESS nvarchar(600) = '',
  @TRIBUTEECITY nvarchar(200) = '',
  @TRIBUTEEPOSTCODE nvarchar(48) = '',
  @TRIBUTEESTATEID uniqueidentifier = null,
  @TRIBUTETYPECODEID uniqueidentifier = null,
  @TRIBUTETEXT nvarchar(510) = '  ',
  @TRIBUTEANONYMOUS bit = 0,
  @SAVEASDEFAULTTRIBUTEE bit = 0,
  @SENDTOACKNOWLEDGEE bit = 0,
  @ACKNOWLEDGEEFIRSTNAME  nvarchar(400) = '',
  @ACKNOWLEDGEELASTNAME nvarchar(400) = '',
  @ACKNOWLEDGEEEMAIL UDT_EMAILADDRESS = null,
  @MESSAGETOACKNOWLEDGEE  nvarchar(2000) = '',

  @PARTICIPANTPAGEURL nvarchar(200) = '',
  @TEAMPAGEURL nvarchar(200) = '',
  @COMPANYPAGEURL nvarchar(200) = '',
  @HOUSEHOLDPAGEURL nvarchar(200) = '',
  @REGISTRATIONOPTIONID uniqueidentifier = null,
  @WAIVERACCEPTED bit = 0,

  @FUNDRAISINGGOAL money = 0,
  @TARGETFUNDRAISINGGOAL money = 0,
  @PARTICIPANTGOAL    int = 0,
  @DONORRETENTIONGOAL    decimal(7,4) = 0.0,
  @COMMUNICATIONGOAL    int = 0,
  @TEAMFUNDRAISINGGOAL    money = 0,
  @TEAMMEMBERGOAL    int = 0,
  @TEAMMEMBERRETENTIONGOAL decimal(7,4) = 0.0,
  @TEAMCOMMUNICATIONGOAL    int = 0,
  @TEAMPARTICIPANTGOAL    int = 0,
  @COFUNDRAISINGGOAL    money = 0,
  @COTEAMSGOAL    int = 0,
  @COTEAMRETENTIONGOAL decimal(7,4) = 0.0,
  @COMEMBERGOAL    int = 0,
  @COMEMBERRETENTIONGOAL decimal(7,4) = 0.0,
  @COPARTICIPANTGOAL    int = 0,
  @COCOMMUNICATIONGOAL    int = 0,
  @HOFUNDRAISINGGOAL    money = 0,
  @HOTARGETFUNDRAISINGGOAL    money = 0,
  @HOPARTICIPANTGOAL    int = 0,
  @HODONORRETENTIONGOAL decimal(7,4) = 0.0,
  @HOCOMMUNICATIONGOAL    int = 0,  
  @ADDITIONALDONATIONAMOUNT money = 0,
  @PAYMENTMETHODCODE nvarchar(20) = '0',  
  @CREDITCARDHOLDER nvarchar(200) = '',
  @CREDITCARDNUMBER nvarchar(200) = '',
  @CREDITCARDTYPE uniqueidentifier = null,
  @EXPIRATIONDATE UDT_FUZZYDATE = '00000000',
  @CREDITCARDTOKEN uniqueidentifier = null,
  @CHECKDATE UDT_FUZZYDATE = '00000000',
  @CHECKNUMBER nvarchar(20) = '',
  @BANKACCOUNTTYPECODE nvarchar(20) = '0',
  @BANKACCOUNTHOLDER nvarchar(200) = '',
  @BANKACCOUNTNUMBER nvarchar(200) = '',
  @BANKACCOUNTROUTINGCODE nvarchar(200) = '',

  @SAMEASPRIMARYADDRESS bit = 0,
  @BILLING_COUNTRYID uniqueidentifier = null,
  @BILLING_ADDRESSBLOCK nvarchar(300) = '',
  @BILLING_CITY nvarchar(50) = '',
  @BILLING_STATEID uniqueidentifier = null,
  @BILLING_POSTCODE nvarchar(24) = '',

  @ISORGANIZATION bit = null,
  @ORGANIZATIONID uniqueidentifier = null,
  @ORGANIZATION_NAME nvarchar(100) = null,
  @ORGANIZATION_WEBADDRESS nvarchar(500) = null,
  @ORGANIZATION_ADDRESSTYPECODEID uniqueidentifier = null,
  @ORGANIZATION_COUNTRYID uniqueidentifier = null,
  @ORGANIZATION_ADDRESSBLOCK nvarchar(150) = null,
  @ORGANIZATION_CITY nvarchar(50) = null,
  @ORGANIZATION_STATEID uniqueidentifier = null,
  @ORGANIZATION_POSTCODE nvarchar(12) = null,
  @ORGANIZATION_DONOTMAIL bit = null,
  @ORGANIZATION_DONOTMAILREASONCODEID uniqueidentifier = null,
  @ORGANIZATION_PHONETYPECODEID uniqueidentifier = null,
  @ORGANIZATION_NUMBER nvarchar(100) = null,
  @ORGANIZATION_EMAILADDRESS UDT_EMAILADDRESS = null,

  @ORIGINALCLIENTUSERID integer = null,
  @ORIGINALCONSTITUENTID uniqueidentifier = null,
  @PHONEID uniqueidentifier = null,
  @ADDRESSID uniqueidentifier = null,
  @EMAILADDRESSID uniqueidentifier = null,

  @CHANGEAGENTID uniqueidentifier = null,
  @AUTHORIZATIONCODE nvarchar(20) = '',
  @TRANSACTIONID uniqueidentifier = null,
  @REJECTIONMESSAGE nvarchar(250) = '',

  @HOMEMBERGOAL    int = 0,
  @HOMEMBERRETENTIONGOAL decimal(7,4) = 0.0,

  @SENDNOTIFICATIONS bit = 1,

  @DECLINEBENEFITS bit = 0,
  @BENEFITS xml = null,
  @VENDORID nvarchar(50) = ''
)
as

    set nocount on;
    if @ID is null
        set @ID = newid()

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    declare @CURRENTDATE datetime    
    set @CURRENTDATE = getdate()    

  if @PAYMENTMETHODCODE is null
    set @PAYMENTMETHODCODE = '0'

  if @BANKACCOUNTTYPECODE is null
    set @BANKACCOUNTTYPECODE = '0'

  if @PAYMENTMETHODCODE = 2 
  begin
    if coalesce(@CREDITCARDHOLDER, '') = ''
      begin
          raiserror('CREDITCARDHOLDERREQUIRED', 13, 1)
          return 1
      end 
    else if coalesce(@CREDITCARDNUMBER, '') = ''
      begin
          raiserror('CREDITCARDNUMBERREQUIRED', 13, 1)
          return 1
      end
    else if @CREDITCARDTYPE IS NULL
      begin
          raiserror('CREDITCARDTYPEREQUIRED', 13, 1)
          return 1
      end
    else if @EXPIRATIONDATE = '00000000'
      begin
          raiserror('EXPIRATIONDATEREQUIRED', 13, 1)
          return 1
      end
    else if convert(date, @EXPIRATIONDATE, 112) < convert(date, getdate())
      begin
          raiserror('INVALIDEXPIRATIONDATE', 13, 1)
          return 1
      end 
  end

    begin try

  declare @CREDITCARDID uniqueidentifier
  if @PAYMENTMETHODCODE = 2
  begin
    exec dbo.USP_CREDITCARD_SAVE
      @ID = @CREDITCARDID output,
      @CREDITCARDTOKEN = @CREDITCARDTOKEN,
      @CARDHOLDERNAME = @CREDITCARDHOLDER,
      @CREDITCARDPARTIALNUMBER = @CREDITCARDNUMBER,
      @CREDITTYPECODEID = null,
      @EXPIRESON = @EXPIRATIONDATE,
      @CHANGEAGENTID = @CHANGEAGENTID,
      @CURRENTDATE = @CURRENTDATE
  end

    IF NOT EXISTS (SELECT * FROM dbo.REGISTRANTBATCH (NOLOCK) WHERE ID= @ID) 
    begin   
      INSERT INTO dbo.REGISTRANTBATCH    
      (ID, BATCHID, REGISTRANTROLECODE, EVENTID, SEQUENCE, USERID, PASSWORD, FIRSTNAME, LASTNAME, EMAILADDRESS, ADDRESSTYPECODEID,
      COUNTRYID, ADDRESS, CITY, STATEID, POSTCODE, MIDDLENAME, TITLECODEID, SUFFIXCODEID, NICKNAME, MAIDENNAME, BIRTHDATE,
      GENDERCODE, MARITALSTATUSCODEID, PHONETYPECODEID, PHONENUMBER, DONOTMAIL, DONOTMAILREASONCODEID, FUNDRAISINGGROUPNAME, TEAMFUNDRAISINGTEAMID,
      SAVETRIBUTEEASCONSTITUENT, TRIBUTEEFIRSTNAME, TRIBUTEELASTNAME, TRIBUTEEEMAIL, TRIBUTEEADDRESS, TRIBUTEECITY, TRIBUTEEPOSTCODE,
      TRIBUTEESTATEID, TRIBUTETYPECODEID, TRIBUTETEXT, TRIBUTEANONYMOUS, SAVEASDEFAULTTRIBUTEE, SENDTOACKNOWLEDGEE,
      ACKNOWLEDGEEFIRSTNAME, ACKNOWLEDGEELASTNAME, ACKNOWLEDGEEEMAIL, MESSAGETOACKNOWLEDGEE, 

      PARTICIPANTPAGEURL, TEAMPAGEURL, COMPANYPAGEURL, HOUSEHOLDPAGEURL, REGISTRATIONOPTIONID, WAIVERACCEPTED, 

      FUNDRAISINGGOAL, TARGETFUNDRAISINGGOAL, PARTICIPANTGOAL, DONORRETENTIONGOAL, COMMUNICATIONGOAL, 
      TEAMFUNDRAISINGGOAL, TEAMMEMBERGOAL, TEAMMEMBERRETENTIONGOAL, TEAMCOMMUNICATIONGOAL, TEAMPARTICIPANTGOAL,
      COFUNDRAISINGGOAL, COTEAMSGOAL, COTEAMRETENTIONGOAL, COMEMBERGOAL, COMEMBERRETENTIONGOAL, COPARTICIPANTGOAL, COCOMMUNICATIONGOAL,
      HOFUNDRAISINGGOAL, HOMEMBERGOAL, HOMEMBERRETENTIONGOAL, HOCOMMUNICATIONGOAL, HOPARTICIPANTGOAL,

      ADDITIONALDONATIONAMOUNT, PAYMENTMETHODCODE, CREDITCARDTYPE, CREDITCARDID, AUTHORIZATIONCODE, TRANSACTIONID, REJECTIONMESSAGE,
      CHECKDATE, CHECKNUMBER, BANKACCOUNTTYPECODE, BANKACCOUNTHOLDER, BANKACCOUNTNUMBER, 
      BANKACCOUNTROUTINGCODE, SAMEASPRIMARYADDRESS, 
      BILLING_COUNTRYID, BILLING_ADDRESSBLOCK, BILLING_CITY, BILLING_STATEID, BILLING_POSTCODE,
        ISORGANIZATION, ORGANIZATIONID, ORGANIZATION_NAME, ORGANIZATION_WEBADDRESS, ORGANIZATION_ADDRESSTYPECODEID, ORGANIZATION_COUNTRYID,
        ORGANIZATION_ADDRESSBLOCK, ORGANIZATION_CITY, ORGANIZATION_STATEID, ORGANIZATION_POSTCODE, ORGANIZATION_DONOTMAIL, ORGANIZATION_DONOTMAILREASONCODEID,
      ORGANIZATION_PHONETYPECODEID, ORGANIZATION_NUMBER, ORGANIZATION_EMAILADDRESS,

      ORIGINALCLIENTUSERID, ORIGINALCONSTITUENTID, PHONEID, ADDRESSID, EMAILADDRESSID,

        ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED,SENDNOTIFICATIONS, DECLINEBENEFITS, BENEFITS, VENDORID)    
      VALUES    
      (@ID, @BATCHID, @REGISTRANTROLECODE, @EVENTID, @SEQUENCE, @USERID, @PASSWORD, @FIRSTNAME, @LASTNAME, isnull(@EMAILADDRESS,''), @ADDRESSTYPECODEID,
      @COUNTRYID, isnull(@ADDRESS,''), isnull(@CITY,''), @STATEID, isnull(@POSTCODE,''), isnull(@MIDDLENAME,''), @TITLECODEID, @SUFFIXCODEID, isnull(@NICKNAME,''), isnull(@MAIDENNAME,''), isnull(@BIRTHDATE,'00000000'),
      isnull(@GENDERCODE,0), @MARITALSTATUSCODEID, @PHONETYPECODEID, isnull(@PHONENUMBER,''), isnull(@DONOTMAIL,0), @DONOTMAILREASONCODEID, isnull(@FUNDRAISINGGROUPNAME,''), @TEAMFUNDRAISINGTEAMID,
      isnull(@SAVETRIBUTEEASCONSTITUENT,0), isnull(@TRIBUTEEFIRSTNAME,''), isnull(@TRIBUTEELASTNAME,''), isnull(@TRIBUTEEEMAIL,''), isnull(@TRIBUTEEADDRESS,''), isnull(@TRIBUTEECITY,''), isnull(@TRIBUTEEPOSTCODE,''),
      @TRIBUTEESTATEID, @TRIBUTETYPECODEID, isnull(@TRIBUTETEXT,''), isnull(@TRIBUTEANONYMOUS,0), isnull(@SAVEASDEFAULTTRIBUTEE,0), isnull(@SENDTOACKNOWLEDGEE,0),
      isnull(@ACKNOWLEDGEEFIRSTNAME,''), isnull(@ACKNOWLEDGEELASTNAME,''), isnull(@ACKNOWLEDGEEEMAIL,''), isnull(@MESSAGETOACKNOWLEDGEE,''), 

      isnull(@PARTICIPANTPAGEURL,''), isnull(@TEAMPAGEURL,''), isnull(@COMPANYPAGEURL,''), isnull(@HOUSEHOLDPAGEURL,''), @REGISTRATIONOPTIONID, isnull(@WAIVERACCEPTED,0), 

      isnull(@FUNDRAISINGGOAL,0), isnull(@TARGETFUNDRAISINGGOAL,0), isnull(@PARTICIPANTGOAL,0), isnull(@DONORRETENTIONGOAL,0.0)/100, isnull(@COMMUNICATIONGOAL,0), 
      isnull(@TEAMFUNDRAISINGGOAL,0), isnull(@TEAMMEMBERGOAL,0), isnull(@TEAMMEMBERRETENTIONGOAL,0.0)/100, isnull(@TEAMCOMMUNICATIONGOAL,0), isnull(@TEAMPARTICIPANTGOAL,0),
      isnull(@COFUNDRAISINGGOAL,0), isnull(@COTEAMSGOAL,0), isnull(@COTEAMRETENTIONGOAL,0.0)/100, isnull(@COMEMBERGOAL,0), isnull(@COMEMBERRETENTIONGOAL,0.0)/100, isnull(@COPARTICIPANTGOAL,0), isnull(@COCOMMUNICATIONGOAL,0),
      isnull(@HOFUNDRAISINGGOAL,0), isnull(@HOMEMBERGOAL,0), isnull(@HOMEMBERRETENTIONGOAL,0.0)/100, isnull(@HOCOMMUNICATIONGOAL,0), isnull(@HOPARTICIPANTGOAL,0),

      isnull(@ADDITIONALDONATIONAMOUNT,0), @PAYMENTMETHODCODE, @CREDITCARDTYPE, @CREDITCARDID, isnull(@AUTHORIZATIONCODE,''), @TRANSACTIONID, isnull(@REJECTIONMESSAGE,''),
      isnull(@CHECKDATE,'00000000'), isnull(@CHECKNUMBER,''), @BANKACCOUNTTYPECODE, isnull(@BANKACCOUNTHOLDER,''), isnull(@BANKACCOUNTNUMBER,''),
      isnull(@BANKACCOUNTROUTINGCODE,''), isnull(@SAMEASPRIMARYADDRESS,0), 
      @BILLING_COUNTRYID, isnull(@BILLING_ADDRESSBLOCK,''), isnull(@BILLING_CITY,''), @BILLING_STATEID, isnull(@BILLING_POSTCODE,''),
        isnull(@ISORGANIZATION,0), @ORGANIZATIONID, isnull(@ORGANIZATION_NAME,''), isnull(@ORGANIZATION_WEBADDRESS,''), @ORGANIZATION_ADDRESSTYPECODEID, @ORGANIZATION_COUNTRYID,
        isnull(@ORGANIZATION_ADDRESSBLOCK,''), isnull(@ORGANIZATION_CITY,''), @ORGANIZATION_STATEID, isnull(@ORGANIZATION_POSTCODE,''), isnull(@ORGANIZATION_DONOTMAIL,0), @ORGANIZATION_DONOTMAILREASONCODEID,
      @ORGANIZATION_PHONETYPECODEID, isnull(@ORGANIZATION_NUMBER,''), isnull(@ORGANIZATION_EMAILADDRESS,''),

      @ORIGINALCLIENTUSERID, @ORIGINALCONSTITUENTID, @PHONEID, @ADDRESSID, @EMAILADDRESSID,

      @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE,isnull(@SENDNOTIFICATIONS,1), isnull(@DECLINEBENEFITS,0), @BENEFITS, isnull(@VENDORID, ''))  

    end
    ELSE
      UPDATE dbo.REGISTRANTBATCH
    SET
      REGISTRANTROLECODE = @REGISTRANTROLECODE,
      EVENTID = @EVENTID,
      SEQUENCE = @SEQUENCE,
      USERID = @USERID,
      PASSWORD = @PASSWORD,
      FIRSTNAME = @FIRSTNAME,
      LASTNAME = @LASTNAME,
      EMAILADDRESS = @EMAILADDRESS,
      ADDRESSTYPECODEID = @ADDRESSTYPECODEID,
      COUNTRYID = @COUNTRYID,
      ADDRESS = @ADDRESS,
      CITY = @CITY,
      STATEID = @STATEID,
      POSTCODE = @POSTCODE,
      MIDDLENAME = @MIDDLENAME,
      TITLECODEID = @TITLECODEID,
      SUFFIXCODEID = @SUFFIXCODEID,
      NICKNAME = @NICKNAME,
      MAIDENNAME = @MAIDENNAME,
      BIRTHDATE = @BIRTHDATE,

      GENDERCODE = @gendercode, 
      MARITALSTATUSCODEID = @MARITALSTATUSCODEID,
      PHONETYPECODEID = @PHONETYPECODEID, 
      PHONENUMBER = @PHONENUMBER, 
      DONOTMAIL = @DONOTMAIL, 
      DONOTMAILREASONCODEID = @DONOTMAILREASONCODEID,

      FUNDRAISINGGROUPNAME = @FUNDRAISINGGROUPNAME,
      TEAMFUNDRAISINGTEAMID = @TEAMFUNDRAISINGTEAMID,

      SAVETRIBUTEEASCONSTITUENT = @SAVETRIBUTEEASCONSTITUENT, 
      TRIBUTEEFIRSTNAME = @TRIBUTEEFIRSTNAME, 
      TRIBUTEELASTNAME = @TRIBUTEELASTNAME, 
      TRIBUTEEEMAIL = @TRIBUTEEEMAIL, 
      TRIBUTEEADDRESS = @TRIBUTEEADDRESS,
      TRIBUTEECITY = @TRIBUTEECITY, 
      TRIBUTEEPOSTCODE = @TRIBUTEEPOSTCODE,
      TRIBUTEESTATEID = @TRIBUTEESTATEID, 
      TRIBUTETYPECODEID = @TRIBUTETYPECODEID, 
      TRIBUTETEXT = @TRIBUTETEXT, 
      TRIBUTEANONYMOUS = @TRIBUTEANONYMOUS, 
      SAVEASDEFAULTTRIBUTEE = @SAVEASDEFAULTTRIBUTEE, 
      SENDTOACKNOWLEDGEE = @SENDTOACKNOWLEDGEE,
      ACKNOWLEDGEEFIRSTNAME = @ACKNOWLEDGEEFIRSTNAME, 
      ACKNOWLEDGEELASTNAME = @ACKNOWLEDGEELASTNAME, 
      ACKNOWLEDGEEEMAIL = @ACKNOWLEDGEEEMAIL, 
      MESSAGETOACKNOWLEDGEE = @MESSAGETOACKNOWLEDGEE,

      PARTICIPANTPAGEURL = @PARTICIPANTPAGEURL,
      TEAMPAGEURL = @TEAMPAGEURL,
      COMPANYPAGEURL = @COMPANYPAGEURL,
      HOUSEHOLDPAGEURL = @HOUSEHOLDPAGEURL,
      REGISTRATIONOPTIONID = @REGISTRATIONOPTIONID,
      WAIVERACCEPTED = @WAIVERACCEPTED,

      FUNDRAISINGGOAL = @FUNDRAISINGGOAL, 
      TARGETFUNDRAISINGGOAL = @TARGETFUNDRAISINGGOAL, 
      PARTICIPANTGOAL = @PARTICIPANTGOAL, 
      DONORRETENTIONGOAL = @DONORRETENTIONGOAL/100, 
      COMMUNICATIONGOAL = @COMMUNICATIONGOAL, 
      TEAMFUNDRAISINGGOAL = @TEAMFUNDRAISINGGOAL, 
      TEAMMEMBERGOAL = @TEAMMEMBERGOAL, 
      TEAMMEMBERRETENTIONGOAL = @TEAMMEMBERRETENTIONGOAL/100, 
      TEAMCOMMUNICATIONGOAL = @TEAMCOMMUNICATIONGOAL, 
      TEAMPARTICIPANTGOAL = @TEAMPARTICIPANTGOAL,
      COFUNDRAISINGGOAL = @COFUNDRAISINGGOAL, 
      COTEAMSGOAL = @COTEAMSGOAL, 
      COTEAMRETENTIONGOAL = @COTEAMRETENTIONGOAL/100, 
      COMEMBERGOAL = @COMEMBERGOAL, 
      COMEMBERRETENTIONGOAL = @COMEMBERRETENTIONGOAL/100, 
      COPARTICIPANTGOAL = @COPARTICIPANTGOAL, 
      COCOMMUNICATIONGOAL = @COCOMMUNICATIONGOAL,
      HOFUNDRAISINGGOAL = @HOFUNDRAISINGGOAL, 
      HOMEMBERGOAL = @HOMEMBERGOAL, 
      HOMEMBERRETENTIONGOAL = @HOMEMBERRETENTIONGOAL/100, 
      HOCOMMUNICATIONGOAL = @HOCOMMUNICATIONGOAL, 
      HOPARTICIPANTGOAL = @HOPARTICIPANTGOAL,

      ADDITIONALDONATIONAMOUNT = @ADDITIONALDONATIONAMOUNT,
      PAYMENTMETHODCODE = @PAYMENTMETHODCODE,
      CREDITCARDTYPE = @CREDITCARDTYPE,
      CREDITCARDID = @CREDITCARDID,
      AUTHORIZATIONCODE = @AUTHORIZATIONCODE, 
      TRANSACTIONID = @TRANSACTIONID, 
      REJECTIONMESSAGE = @REJECTIONMESSAGE,
      CHECKDATE = @CHECKDATE,
      CHECKNUMBER = @CHECKNUMBER,
      BANKACCOUNTTYPECODE = @BANKACCOUNTTYPECODE,
      BANKACCOUNTHOLDER = @BANKACCOUNTHOLDER,
      BANKACCOUNTNUMBER = @BANKACCOUNTNUMBER,
      BANKACCOUNTROUTINGCODE = @BANKACCOUNTROUTINGCODE,
      SAMEASPRIMARYADDRESS = @SAMEASPRIMARYADDRESS,
      BILLING_COUNTRYID = @BILLING_COUNTRYID,
      BILLING_ADDRESSBLOCK = @BILLING_ADDRESSBLOCK,
      BILLING_CITY = @BILLING_CITY,
      BILLING_STATEID = @BILLING_STATEID,
      BILLING_POSTCODE = @BILLING_POSTCODE,
        ISORGANIZATION = @ISORGANIZATION,
        ORGANIZATIONID = @ORGANIZATIONID, 
        ORGANIZATION_NAME = @ORGANIZATION_NAME, 
        ORGANIZATION_WEBADDRESS = @ORGANIZATION_WEBADDRESS, 
        ORGANIZATION_ADDRESSTYPECODEID = @ORGANIZATION_ADDRESSTYPECODEID, 
        ORGANIZATION_COUNTRYID = @ORGANIZATION_COUNTRYID,
        ORGANIZATION_ADDRESSBLOCK = @ORGANIZATION_ADDRESSBLOCK, 
        ORGANIZATION_CITY = @ORGANIZATION_CITY, 
        ORGANIZATION_STATEID = @ORGANIZATION_STATEID, 
        ORGANIZATION_POSTCODE = @ORGANIZATION_POSTCODE, 
        ORGANIZATION_DONOTMAIL = @ORGANIZATION_DONOTMAIL, 
        ORGANIZATION_DONOTMAILREASONCODEID = @ORGANIZATION_DONOTMAILREASONCODEID,
      ORGANIZATION_PHONETYPECODEID = @ORGANIZATION_PHONETYPECODEID, 
      ORGANIZATION_NUMBER = @ORGANIZATION_NUMBER, 
      ORGANIZATION_EMAILADDRESS = @ORGANIZATION_EMAILADDRESS,
      ORIGINALCLIENTUSERID = @ORIGINALCLIENTUSERID,
      ORIGINALCONSTITUENTID = @ORIGINALCONSTITUENTID,
      PHONEID = @PHONEID,
      ADDRESSID = @ADDRESSID,
      EMAILADDRESSID = @EMAILADDRESSID,

          CHANGEDBYID = @CHANGEAGENTID,
          DATECHANGED = @CURRENTDATE,

      SENDNOTIFICATIONS = @SENDNOTIFICATIONS,

      DECLINEBENEFITS = @DECLINEBENEFITS,
      BENEFITS = @BENEFITS,
      VENDORID = isnull(@VENDORID, '')

      WHERE ID= @ID

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;