USP_DATAFORMTEMPLATE_EDITLOAD_REGISTRANTBATCHROW

The load procedure used by the edit dataform template "Registrant Batch Edit Data Form"

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REGISTRANTBATCHROW
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @REGISTRANTROLECODE int = null output,
  @EVENTID uniqueidentifier = null output,
  @SEQUENCE int = null output,
  @TSLONG bigint = 0 output,
  @USERID nvarchar(100) = null output,
  @PASSWORD nvarchar(20) = null output,
  @FIRSTNAME nvarchar(100) = null output,
  @LASTNAME nvarchar(100) = null output,
  @EMAILADDRESS UDT_EMAILADDRESS = null output,
  @ADDRESSTYPECODEID uniqueidentifier = null output,
  @COUNTRYID uniqueidentifier = null output,
  @ADDRESS nvarchar(300) = null output,
  @CITY nvarchar(100) = null output,
  @STATEID uniqueidentifier = null output,
  @POSTCODE nvarchar(24) = null output,
  @MIDDLENAME nvarchar(100) = null output,
  @TITLECODEID uniqueidentifier = null output,
  @SUFFIXCODEID uniqueidentifier = null output,
  @NICKNAME nvarchar(100) = null output,
  @MAIDENNAME nvarchar(200) = null output,
  @BIRTHDATE UDT_FUZZYDATE = null output,

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

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

  @PARTICIPANTPAGEURL nvarchar(200) = null output,
  @TEAMPAGEURL nvarchar(200) = null output,
  @COMPANYPAGEURL nvarchar(200) = null output,
  @HOUSEHOLDPAGEURL nvarchar(200) = null output,
  @REGISTRATIONOPTIONID uniqueidentifier = null output,
  @DECLINEBENEFITS bit = null output,
  @BENEFITS xml = null output,
  @WAIVERACCEPTED bit = null output,

  @FUNDRAISINGGOAL money = null output,
  @TARGETFUNDRAISINGGOAL money = null output,
  @PARTICIPANTGOAL    int = null output,
  @DONORRETENTIONGOAL    decimal(7,4) = null output,
  @COMMUNICATIONGOAL    int = null output,
  @TEAMFUNDRAISINGGOAL    money = null output,
  @TEAMMEMBERGOAL    int = null output,
  @TEAMMEMBERRETENTIONGOAL decimal(7,4) = null output,
  @TEAMCOMMUNICATIONGOAL int = null output,
  @TEAMPARTICIPANTGOAL    int = null output,
  @COFUNDRAISINGGOAL    money = null output,
  @COTEAMSGOAL    int = null output,
  @COTEAMRETENTIONGOAL decimal(7,4) = null output,
  @COMEMBERGOAL    int = null output,
  @COMEMBERRETENTIONGOAL decimal(7,4) = null output,
  @COPARTICIPANTGOAL    int = null output,
  @COCOMMUNICATIONGOAL    int = null output,
  @HOFUNDRAISINGGOAL    money = null output,
  @HOTARGETFUNDRAISINGGOAL    money = null output,
  @HOPARTICIPANTGOAL    int = null output,
  @HODONORRETENTIONGOAL decimal(7,4) = null output,
  @HOCOMMUNICATIONGOAL    int = null output,  
  @ADDITIONALDONATIONAMOUNT money = null output,
  @PAYMENTMETHODCODE nvarchar(20) = null output,  
  @CREDITCARDHOLDER nvarchar(200) = null output,
  @CREDITCARDNUMBER nvarchar(200) = null output,
  @CREDITCARDTYPE uniqueidentifier = null output,
  @EXPIRATIONDATE UDT_FUZZYDATE = null output,
  @CREDITCARDTOKEN uniqueidentifier = null output,
  @CREDITCARDID uniqueidentifier = null output,

  @CHECKDATE UDT_FUZZYDATE = null output,
  @CHECKNUMBER nvarchar(20) = null output,
  @BANKACCOUNTTYPECODE nvarchar(20) = null output,
  @BANKACCOUNTHOLDER nvarchar(200) = null output,
  @BANKACCOUNTNUMBER nvarchar(200) = null output,
  @BANKACCOUNTROUTINGCODE nvarchar(200) = null output,

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

  @SUBSCRIBEDNEWSLETTERIDS xml = null output,

  @MERCHANTACCOUNTID uniqueidentifier = null output,
  @ISORGANIZATION bit = null output,
  @ORGANIZATIONID uniqueidentifier = null output,
  @ORGANIZATION_NAME nvarchar(100) = null output,
  @ORGANIZATION_WEBADDRESS nvarchar(500) = null output,
  @ORGANIZATION_ADDRESSTYPECODEID uniqueidentifier = null output,
  @ORGANIZATION_COUNTRYID uniqueidentifier = null output,
  @ORGANIZATION_ADDRESSBLOCK nvarchar(150) = null output,
  @ORGANIZATION_CITY nvarchar(50) = null output,
  @ORGANIZATION_STATEID uniqueidentifier = null output,
  @ORGANIZATION_POSTCODE nvarchar(12) = null output,
  @ORGANIZATION_DONOTMAIL bit = null output,
  @ORGANIZATION_DONOTMAILREASONCODEID uniqueidentifier = null output,
  @ORGANIZATION_PHONETYPECODEID uniqueidentifier = null output,
  @ORGANIZATION_NUMBER nvarchar(100) = null output,
  @ORGANIZATION_EMAILADDRESS UDT_EMAILADDRESS = null output,
  @ORIGINALCLIENTUSERID integer = null output,
  @ORIGINALCONSTITUENTID uniqueidentifier = null output,
  @PHONEID uniqueidentifier = null output,
  @ADDRESSID uniqueidentifier = null output,
  @EMAILADDRESSID uniqueidentifier = null output,
  @AUTHORIZATIONCODE nvarchar(20) = null output,
  @TRANSACTIONID uniqueidentifier = null output,
  @REJECTIONMESSAGE nvarchar(250) = null output,
  @TYPECODE tinyint = null output,
  @AMOUNT money = null output,
  @CONSTITUENTID uniqueidentifier = null output,
  @BILLING_STATE nvarchar(10) = null output,
  @BILLING_COUNTRY nvarchar(4) = null output,

  @HOMEMBERGOAL    int = null output,
  @HOMEMBERRETENTIONGOAL decimal(7,4) = null output,

  @SENDNOTIFICATIONS bit = null output



)
as
    set @DATALOADED = 0;
    set @TSLONG = 0;

    select
        @DATALOADED = 1,
        @REGISTRANTROLECODE = REGISTRANTROLECODE, 
        @EVENTID = REGISTRANTBATCH.EVENTID, 
        @SEQUENCE = REGISTRANTBATCH.SEQUENCE, 
        @USERID = USERID, 
        @PASSWORD = [PASSWORD], 
        @FIRSTNAME = FIRSTNAME, 
        @LASTNAME = LASTNAME, 
        @EMAILADDRESS = EMAILADDRESS, 
        @ADDRESSTYPECODEID = ADDRESSTYPECODEID,
        @COUNTRYID = REGISTRANTBATCH.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 * 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, 
        @CREDITCARDHOLDER = CREDITCARD.CARDHOLDERNAME,
        @CREDITCARDNUMBER = CREDITCARD.CREDITCARDPARTIALNUMBER, 
        @CREDITCARDTYPE = CREDITCARDTYPE, 
        @EXPIRATIONDATE = CREDITCARD.EXPIRESON, 
        @CREDITCARDTOKEN = CREDITCARD.CREDITCARDTOKEN,
    @CREDITCARDID = CREDITCARDID,
    @AUTHORIZATIONCODE = AUTHORIZATIONCODE,
    @TRANSACTIONID = TRANSACTIONID,
    @REJECTIONMESSAGE = REJECTIONMESSAGE,
    @TYPECODE = 0,
    @AMOUNT = isnull(ADDITIONALDONATIONAMOUNT, 0) + isnull(EVENTPRICE.AMOUNT, 0),
    @CONSTITUENTID = null,

        @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,
    @BILLING_STATE = STATE.ABBREVIATION,
    @BILLING_COUNTRY = COUNTRY.ISO3166,

    -- @SUBSCRIBEDNEWSLETTERIDS = dbo.UFN_REGISTRANTBATCH_GETEMAILLIST_TOITEMLISTXML(REGISTRANTBATCH.ID),

    @MERCHANTACCOUNTID = null,
    @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,

    @SENDNOTIFICATIONS = SENDNOTIFICATIONS




    from dbo.REGISTRANTBATCH (nolock)
  left outer join dbo.CREDITCARD (nolock) on REGISTRANTBATCH.CREDITCARDID = CREDITCARD.ID
  left outer join dbo.EVENTPRICE (nolock) on EVENTPRICE.ID = REGISTRANTBATCH.REGISTRATIONOPTIONID
  left join dbo.STATE (nolock) on REGISTRANTBATCH.BILLING_STATEID = STATE.ID  
  left join dbo.COUNTRY (nolock) on REGISTRANTBATCH.BILLING_COUNTRYID = COUNTRY.ID  
  where REGISTRANTBATCH.ID = @ID

    return 0;