USP_DATAFORMTEMPLATE_ADD_REGISTRANTBATCHROW

The save procedure used by the add dataform template "Registrant Batch Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@REGISTRANTROLECODE	int	IN	Registrant role
@BATCHID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@EVENTID	uniqueidentifier	IN	Event
@SEQUENCE	int	IN	Sequence
@USERID	nvarchar(100)	IN	Username
@PASSWORD	nvarchar(20)	IN	Password
@FIRSTNAME	nvarchar(100)	IN	First name
@LASTNAME	nvarchar(100)	IN	Last name
@EMAILADDRESS	UDT_EMAILADDRESS	IN	Email address
@ADDRESSTYPECODEID	uniqueidentifier	IN	Address type
@COUNTRYID	uniqueidentifier	IN	Country
@ADDRESS	nvarchar(300)	IN	Address
@CITY	nvarchar(100)	IN	City
@STATEID	uniqueidentifier	IN	State/Province
@POSTCODE	nvarchar(24)	IN	Postcode
@MIDDLENAME	nvarchar(100)	IN	Middle name
@TITLECODEID	uniqueidentifier	IN	Title
@SUFFIXCODEID	uniqueidentifier	IN	Suffix
@NICKNAME	nvarchar(100)	IN	Nickname
@MAIDENNAME	nvarchar(200)	IN	Maiden name
@BIRTHDATE	UDT_FUZZYDATE	IN	Birth date
@GENDERCODE	int	IN	Gender
@MARITALSTATUSCODEID	uniqueidentifier	IN	Marital status
@PHONETYPECODEID	uniqueidentifier	IN	Phone type
@PHONENUMBER	nvarchar(200)	IN	Phone number
@DONOTMAIL	bit	IN	Do not send mail to this address
@DONOTMAILREASONCODEID	uniqueidentifier	IN	Reason
@FUNDRAISINGGROUPNAME	nvarchar(200)	IN	Group name
@TEAMFUNDRAISINGTEAMID	uniqueidentifier	IN	Parent group
@SAVETRIBUTEEASCONSTITUENT	bit	IN	Save tributee as constituent
@TRIBUTEEFIRSTNAME	nvarchar(400)	IN	Tributee first name
@TRIBUTEELASTNAME	nvarchar(400)	IN	Tributee last name
@TRIBUTEEEMAIL	UDT_EMAILADDRESS	IN	Tributee email address
@TRIBUTEEADDRESS	nvarchar(600)	IN	Tributee address
@TRIBUTEECITY	nvarchar(200)	IN	Tributee city
@TRIBUTEEPOSTCODE	nvarchar(48)	IN	Tributee postcode
@TRIBUTEESTATEID	uniqueidentifier	IN	Tributee state
@TRIBUTETYPECODEID	uniqueidentifier	IN	Tribute type
@TRIBUTETEXT	nvarchar(510)	IN	Tribute message
@TRIBUTEANONYMOUS	bit	IN	Do not display tribute information
@SAVEASDEFAULTTRIBUTEE	bit	IN	Save tributee as default tributee
@SENDTOACKNOWLEDGEE	bit	IN	Send email to acknowledgee
@ACKNOWLEDGEEFIRSTNAME	nvarchar(400)	IN	Acknowledgee first name
@ACKNOWLEDGEELASTNAME	nvarchar(400)	IN	Acknowledgee last name
@ACKNOWLEDGEEEMAIL	UDT_EMAILADDRESS	IN	Acknowledgee email address
@MESSAGETOACKNOWLEDGEE	nvarchar(2000)	IN	Message about my donation
@PARTICIPANTPAGEURL	nvarchar(200)	IN	Participant page url
@TEAMPAGEURL	nvarchar(200)	IN	Team page url
@COMPANYPAGEURL	nvarchar(200)	IN	Company page url
@HOUSEHOLDPAGEURL	nvarchar(200)	IN	Household page url
@REGISTRATIONOPTIONID	uniqueidentifier	IN	Registration option
@DECLINEBENEFITS	bit	IN
@BENEFITS	xml	IN
@WAIVERACCEPTED	bit	IN	Waiver accepted
@FUNDRAISINGGOAL	money	IN	Minimum fundraising goal
@TARGETFUNDRAISINGGOAL	money	IN	Target fundraising goal
@PARTICIPANTGOAL	int	IN	Number of participants to recruit
@DONORRETENTIONGOAL	decimal(7, 4)	IN	Percentage of donors to retain
@COMMUNICATIONGOAL	int	IN	Number of communications to send
@TEAMFUNDRAISINGGOAL	money	IN	Team: Fundraising total amount
@TEAMMEMBERGOAL	int	IN	Team: Number of team members
@TEAMMEMBERRETENTIONGOAL	decimal(7, 4)	IN	Team: Percentage of team members to retain
@TEAMCOMMUNICATIONGOAL	int	IN	Team: Number of communications to send
@TEAMPARTICIPANTGOAL	int	IN	Team: Number of participants to recruit
@COFUNDRAISINGGOAL	money	IN	Company: Fundraising total amount
@COTEAMSGOAL	int	IN	Company: Number of teams
@COTEAMRETENTIONGOAL	decimal(7, 4)	IN	Company: Percentage of teams to retain
@COMEMBERGOAL	int	IN	Company: Number of team members
@COMEMBERRETENTIONGOAL	decimal(7, 4)	IN	Company: Percentage of team members to retain
@COPARTICIPANTGOAL	int	IN	Company: Number of participants to recruit
@COCOMMUNICATIONGOAL	int	IN	Company: Number of communications to send
@HOFUNDRAISINGGOAL	money	IN	Household: Minimum fundraising goal
@HOTARGETFUNDRAISINGGOAL	money	IN	Household: Target fundraising goal
@HOPARTICIPANTGOAL	int	IN	Household: Number of participants to recruit
@HODONORRETENTIONGOAL	decimal(7, 4)	IN	Household: Percentage of donors to retain
@HOCOMMUNICATIONGOAL	int	IN	Household: Number of communications to send
@ADDITIONALDONATIONAMOUNT	money	IN	Additional donation amount
@PAYMENTMETHODCODE	nvarchar(20)	IN	Payment method
@CREDITCARDHOLDER	nvarchar(200)	IN	Card holder name
@CREDITCARDNUMBER	nvarchar(200)	IN	Credit card number
@CREDITCARDTYPE	uniqueidentifier	IN	Credit card type
@EXPIRATIONDATE	UDT_FUZZYDATE	IN	Credit card expiration
@CREDITCARDTOKEN	uniqueidentifier	IN	Credit card token
@CREDITCARDID	uniqueidentifier	IN	Credit card ID
@CHECKDATE	UDT_FUZZYDATE	IN	Check date
@CHECKNUMBER	nvarchar(20)	IN	Check number
@BANKACCOUNTTYPECODE	nvarchar(20)	IN	Bank account type
@BANKACCOUNTHOLDER	nvarchar(200)	IN	Bank account holder
@BANKACCOUNTNUMBER	nvarchar(200)	IN	Bank account number
@BANKACCOUNTROUTINGCODE	nvarchar(200)	IN	Bank account routing code
@SAMEASPRIMARYADDRESS	bit	IN	Billing address same as primary
@BILLING_COUNTRYID	uniqueidentifier	IN	Billing country
@BILLING_ADDRESSBLOCK	nvarchar(300)	IN	Billing address
@BILLING_CITY	nvarchar(50)	IN	Billing city
@BILLING_STATEID	uniqueidentifier	IN	Billing state
@BILLING_POSTCODE	nvarchar(24)	IN	Billing postcode
@SUBSCRIBEDNEWSLETTERIDS	xml	IN	eNewsletter
@MERCHANTACCOUNTID	uniqueidentifier	IN	Merchant Account ID
@ISORGANIZATION	bit	IN	This is an organization registration
@ORGANIZATIONID	uniqueidentifier	IN	Search existing organizations
@ORGANIZATION_NAME	nvarchar(100)	IN	Organization name
@ORGANIZATION_WEBADDRESS	nvarchar(500)	IN	Organization website
@ORGANIZATION_ADDRESSTYPECODEID	uniqueidentifier	IN	Organization address type
@ORGANIZATION_COUNTRYID	uniqueidentifier	IN	Organization country
@ORGANIZATION_ADDRESSBLOCK	nvarchar(150)	IN	Organization address
@ORGANIZATION_CITY	nvarchar(50)	IN	Organization city
@ORGANIZATION_STATEID	uniqueidentifier	IN	Organization state
@ORGANIZATION_POSTCODE	nvarchar(12)	IN	Organization postcode
@ORGANIZATION_DONOTMAIL	bit	IN	Organization: Do not send mail to this address
@ORGANIZATION_DONOTMAILREASONCODEID	uniqueidentifier	IN	Organization: Reason
@ORGANIZATION_PHONETYPECODEID	uniqueidentifier	IN	Organization phone type
@ORGANIZATION_NUMBER	nvarchar(100)	IN	Organization phone number
@ORGANIZATION_EMAILADDRESS	UDT_EMAILADDRESS	IN	Organization email address
@ORIGINALCLIENTUSERID	int	IN	Original client user id
@ORIGINALCONSTITUENTID	uniqueidentifier	IN	Search existing constituents
@PHONEID	uniqueidentifier	IN	Phone id
@ADDRESSID	uniqueidentifier	IN	Address id
@EMAILADDRESSID	uniqueidentifier	IN	Email address id
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@AUTHORIZATIONCODE	nvarchar(20)	IN	Authorization code
@TRANSACTIONID	uniqueidentifier	IN	Transaction ID
@REJECTIONMESSAGE	nvarchar(250)	IN	Rejection message
@TYPECODE	tinyint	IN	Type code
@AMOUNT	money	IN	Amount
@CONSTITUENTID	uniqueidentifier	IN	Constituent ID
@BILLING_STATE	nvarchar(10)	IN	Billing state
@BILLING_COUNTRY	nvarchar(4)	IN	Billing country
@HOMEMBERGOAL	int	IN	Household: Number of household members
@HOMEMBERRETENTIONGOAL	decimal(7, 4)	IN	Household: Percentage of household members to retain
@SENDNOTIFICATIONS	bit	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_REGISTRANTBATCHROW
(
  @ID uniqueidentifier = null output,
  @REGISTRANTROLECODE int,
  @BATCHID uniqueidentifier,
  @EVENTID uniqueidentifier = null,
  @SEQUENCE int = null,
  @USERID nvarchar(100),
  @PASSWORD nvarchar(20),
  @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,
  @DECLINEBENEFITS bit = 0,
  @BENEFITS xml = null,
  @WAIVERACCEPTED bit = 1,

  @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,
  @CREDITCARDID 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) = '',

  @SUBSCRIBEDNEWSLETTERIDS xml = null,
  @MERCHANTACCOUNTID uniqueidentifier = null,

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

  @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) = '',
  @TYPECODE tinyint = 0,
  @AMOUNT money = 0,
  @CONSTITUENTID uniqueidentifier = null,
  @BILLING_STATE nvarchar(10) = null,
  @BILLING_COUNTRY nvarchar(4) = null,

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

  @SENDNOTIFICATIONS bit = 1



  )
as
  if @CHANGEAGENTID is null
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

  if @TEAMCOMMUNICATIONGOAL is null
    set @TEAMCOMMUNICATIONGOAL = 0

  if @TEAMFUNDRAISINGGOAL is null
    set @TEAMFUNDRAISINGGOAL = 0

  if @TEAMMEMBERGOAL is null
    set @TEAMMEMBERGOAL = 0

  if @TEAMMEMBERRETENTIONGOAL is null
    set @TEAMMEMBERRETENTIONGOAL = 0

  if @TEAMPARTICIPANTGOAL is null
    set @TEAMPARTICIPANTGOAL = 0

  if @ADDITIONALDONATIONAMOUNT is null
    set @ADDITIONALDONATIONAMOUNT = 0

  if @COCOMMUNICATIONGOAL is null
    set @COCOMMUNICATIONGOAL = 0

  if @COFUNDRAISINGGOAL is null
    set @COFUNDRAISINGGOAL = 0

  if @COMEMBERGOAL is null
    set @COMEMBERGOAL = 0

  if @COMEMBERRETENTIONGOAL is null
    set @COMEMBERRETENTIONGOAL = 0

  if @COMMUNICATIONGOAL is null
    set @COMMUNICATIONGOAL = 0

  if @COPARTICIPANTGOAL is null
    set @COPARTICIPANTGOAL = 0

  if @COTEAMRETENTIONGOAL is null
    set @COTEAMRETENTIONGOAL = 0

  if @COTEAMSGOAL is null
    set @COTEAMSGOAL = 0

  if @DONORRETENTIONGOAL is null
    set @DONORRETENTIONGOAL = 0

  if @FUNDRAISINGGOAL is null
    set @FUNDRAISINGGOAL = 0

  if @HOCOMMUNICATIONGOAL is null
    set @HOCOMMUNICATIONGOAL = 0

  if @HOFUNDRAISINGGOAL is null
    set @HOFUNDRAISINGGOAL = 0

  if @HOMEMBERGOAL is null
    set @HOMEMBERGOAL = 0

  if @HODONORRETENTIONGOAL is null
    set @HODONORRETENTIONGOAL = 0

  if @HOTARGETFUNDRAISINGGOAL is null
    set @HOTARGETFUNDRAISINGGOAL = 0

  if @HOMEMBERRETENTIONGOAL is null
    set @HOMEMBERRETENTIONGOAL = 0

  if @HOPARTICIPANTGOAL is null
    set @HOPARTICIPANTGOAL = 0

  if @PARTICIPANTGOAL is null
    set @PARTICIPANTGOAL = 0

  if @TARGETFUNDRAISINGGOAL is null
    set @TARGETFUNDRAISINGGOAL = 0

  if @ORIGINALCLIENTUSERID = 0
    set @ORIGINALCLIENTUSERID = null

  if @PHONEID = '00000000-0000-0000-0000-000000000000'
    set @PHONEID = null

  if @ADDRESSID = '00000000-0000-0000-0000-000000000000'
    set @ADDRESSID = null

  if @EMAILADDRESSID = '00000000-0000-0000-0000-000000000000'
    set @EMAILADDRESSID = null

exec dbo.USP_REGISTRANTBATCH_ADD_EDIT
    @ID = @ID output,
    @REGISTRANTROLECODE = @REGISTRANTROLECODE,
    @BATCHID = @BATCHID,
    @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,
    @DECLINEBENEFITS = @DECLINEBENEFITS,
    @BENEFITS = @BENEFITS,
    @WAIVERACCEPTED = @WAIVERACCEPTED,

    @FUNDRAISINGGOAL = @FUNDRAISINGGOAL,
    @TARGETFUNDRAISINGGOAL = @TARGETFUNDRAISINGGOAL,
    @PARTICIPANTGOAL = @PARTICIPANTGOAL,
    @DONORRETENTIONGOAL    = @DONORRETENTIONGOAL,
    @COMMUNICATIONGOAL = @COMMUNICATIONGOAL,
    @TEAMFUNDRAISINGGOAL = @TEAMFUNDRAISINGGOAL,
    @TEAMMEMBERGOAL    = @TEAMMEMBERGOAL,
    @TEAMMEMBERRETENTIONGOAL = @TEAMMEMBERRETENTIONGOAL,
    @TEAMCOMMUNICATIONGOAL = @TEAMCOMMUNICATIONGOAL,
    @TEAMPARTICIPANTGOAL = @TEAMPARTICIPANTGOAL,
    @COFUNDRAISINGGOAL = @COFUNDRAISINGGOAL,
    @COTEAMSGOAL = @COTEAMSGOAL,
    @COTEAMRETENTIONGOAL = @COTEAMRETENTIONGOAL,
    @COMEMBERGOAL = @COMEMBERGOAL,
    @COMEMBERRETENTIONGOAL = @COMEMBERRETENTIONGOAL,
    @COPARTICIPANTGOAL = @COPARTICIPANTGOAL,
    @COCOMMUNICATIONGOAL = @COCOMMUNICATIONGOAL,
    @HOFUNDRAISINGGOAL = @HOFUNDRAISINGGOAL,
    @HOMEMBERGOAL    = @HOMEMBERGOAL,
    @HOMEMBERRETENTIONGOAL = @HOMEMBERRETENTIONGOAL,
    @HOCOMMUNICATIONGOAL = @HOCOMMUNICATIONGOAL,
    @HOPARTICIPANTGOAL = @HOPARTICIPANTGOAL,
    @ADDITIONALDONATIONAMOUNT = @ADDITIONALDONATIONAMOUNT,
    @PAYMENTMETHODCODE = @PAYMENTMETHODCODE, 
    @CREDITCARDHOLDER = @CREDITCARDHOLDER,
    @CREDITCARDNUMBER = @CREDITCARDNUMBER,
    @CREDITCARDTYPE = @CREDITCARDTYPE,
    @EXPIRATIONDATE = @EXPIRATIONDATE,
    @CREDITCARDTOKEN = @CREDITCARDTOKEN,
    @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,

    @CHANGEAGENTID = @CHANGEAGENTID,

    @SENDNOTIFICATIONS = @SENDNOTIFICATIONS




  -- exec dbo.USP_REGISTRANTBATCH_EMAILLIST_ADDFROMXML @ID, @SUBSCRIBEDNEWSLETTERIDS, @CHANGEAGENTID;



return 0;