USP_DATAFORMTEMPLATE_EDITLOAD_REGISTRANTBATCHROW_2

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN
@DATALOADED bit INOUT
@REGISTRANTROLECODE int INOUT
@EVENTID uniqueidentifier INOUT
@SEQUENCE int INOUT
@TSLONG bigint INOUT
@USERID nvarchar(100) INOUT
@PASSWORD nvarchar(20) INOUT
@FIRSTNAME nvarchar(100) INOUT
@LASTNAME nvarchar(100) INOUT
@EMAILADDRESS UDT_EMAILADDRESS INOUT
@ADDRESSTYPECODEID uniqueidentifier INOUT
@COUNTRYID uniqueidentifier INOUT
@ADDRESS nvarchar(300) INOUT
@CITY nvarchar(100) INOUT
@STATEID uniqueidentifier INOUT
@POSTCODE nvarchar(24) INOUT
@MIDDLENAME nvarchar(100) INOUT
@TITLECODEID uniqueidentifier INOUT
@SUFFIXCODEID uniqueidentifier INOUT
@NICKNAME nvarchar(100) INOUT
@MAIDENNAME nvarchar(200) INOUT
@BIRTHDATE UDT_FUZZYDATE INOUT
@GENDERCODE int INOUT
@MARITALSTATUSCODEID uniqueidentifier INOUT
@PHONETYPECODEID uniqueidentifier INOUT
@PHONENUMBER nvarchar(200) INOUT
@DONOTMAIL bit INOUT
@DONOTMAILREASONCODEID uniqueidentifier INOUT
@FUNDRAISINGGROUPNAME nvarchar(200) INOUT
@TEAMFUNDRAISINGTEAMID uniqueidentifier INOUT
@SAVETRIBUTEEASCONSTITUENT bit INOUT
@TRIBUTEEFIRSTNAME nvarchar(400) INOUT
@TRIBUTEELASTNAME nvarchar(400) INOUT
@TRIBUTEEEMAIL UDT_EMAILADDRESS INOUT
@TRIBUTEEADDRESS nvarchar(600) INOUT
@TRIBUTEECITY nvarchar(200) INOUT
@TRIBUTEEPOSTCODE nvarchar(48) INOUT
@TRIBUTEESTATEID uniqueidentifier INOUT
@TRIBUTETYPECODEID uniqueidentifier INOUT
@TRIBUTETEXT nvarchar(510) INOUT
@TRIBUTEANONYMOUS bit INOUT
@SAVEASDEFAULTTRIBUTEE bit INOUT
@SENDTOACKNOWLEDGEE bit INOUT
@ACKNOWLEDGEEFIRSTNAME nvarchar(400) INOUT
@ACKNOWLEDGEELASTNAME nvarchar(400) INOUT
@ACKNOWLEDGEEEMAIL UDT_EMAILADDRESS INOUT
@MESSAGETOACKNOWLEDGEE nvarchar(2000) INOUT
@PARTICIPANTPAGEURL nvarchar(200) INOUT
@TEAMPAGEURL nvarchar(200) INOUT
@COMPANYPAGEURL nvarchar(200) INOUT
@HOUSEHOLDPAGEURL nvarchar(200) INOUT
@REGISTRATIONOPTIONID uniqueidentifier INOUT
@WAIVERACCEPTED bit INOUT
@FUNDRAISINGGOAL money INOUT
@TARGETFUNDRAISINGGOAL money INOUT
@PARTICIPANTGOAL int INOUT
@DONORRETENTIONGOAL decimal(7, 4) INOUT
@COMMUNICATIONGOAL int INOUT
@TEAMFUNDRAISINGGOAL money INOUT
@TEAMMEMBERGOAL int INOUT
@TEAMMEMBERRETENTIONGOAL decimal(7, 4) INOUT
@TEAMCOMMUNICATIONGOAL int INOUT
@TEAMPARTICIPANTGOAL int INOUT
@COFUNDRAISINGGOAL money INOUT
@COTEAMSGOAL int INOUT
@COTEAMRETENTIONGOAL decimal(7, 4) INOUT
@COMEMBERGOAL int INOUT
@COMEMBERRETENTIONGOAL decimal(7, 4) INOUT
@COPARTICIPANTGOAL int INOUT
@COCOMMUNICATIONGOAL int INOUT
@HOFUNDRAISINGGOAL money INOUT
@HOTARGETFUNDRAISINGGOAL money INOUT
@HOPARTICIPANTGOAL int INOUT
@HODONORRETENTIONGOAL decimal(7, 4) INOUT
@HOCOMMUNICATIONGOAL int INOUT
@ADDITIONALDONATIONAMOUNT money INOUT
@PAYMENTMETHODCODE nvarchar(20) INOUT
@CREDITCARDHOLDER nvarchar(200) INOUT
@CREDITCARDNUMBER nvarchar(20) INOUT
@CREDITCARDTYPE uniqueidentifier INOUT
@EXPIRATIONDATE UDT_FUZZYDATE INOUT
@CREDITCARDTOKEN uniqueidentifier INOUT
@CREDITCARDID uniqueidentifier INOUT
@CHECKDATE UDT_FUZZYDATE INOUT
@CHECKNUMBER nvarchar(20) INOUT
@BANKACCOUNTTYPECODE nvarchar(20) INOUT
@BANKACCOUNTHOLDER nvarchar(200) INOUT
@BANKACCOUNTNUMBER nvarchar(200) INOUT
@BANKACCOUNTROUTINGCODE nvarchar(200) INOUT
@SAMEASPRIMARYADDRESS bit INOUT
@BILLING_COUNTRYID uniqueidentifier INOUT
@BILLING_ADDRESSBLOCK nvarchar(300) INOUT
@BILLING_CITY nvarchar(50) INOUT
@BILLING_STATEID uniqueidentifier INOUT
@BILLING_POSTCODE nvarchar(24) INOUT
@SUBSCRIBEDNEWSLETTERIDS xml INOUT
@MERCHANTACCOUNTID uniqueidentifier INOUT
@ISORGANIZATION bit INOUT
@ORGANIZATIONID uniqueidentifier INOUT
@ORGANIZATION_NAME nvarchar(100) INOUT
@ORGANIZATION_WEBADDRESS nvarchar(500) INOUT
@ORGANIZATION_ADDRESSTYPECODEID uniqueidentifier INOUT
@ORGANIZATION_COUNTRYID uniqueidentifier INOUT
@ORGANIZATION_ADDRESSBLOCK nvarchar(150) INOUT
@ORGANIZATION_CITY nvarchar(50) INOUT
@ORGANIZATION_STATEID uniqueidentifier INOUT
@ORGANIZATION_POSTCODE nvarchar(12) INOUT
@ORGANIZATION_DONOTMAIL bit INOUT
@ORGANIZATION_DONOTMAILREASONCODEID uniqueidentifier INOUT
@ORGANIZATION_PHONETYPECODEID uniqueidentifier INOUT
@ORGANIZATION_NUMBER nvarchar(100) INOUT
@ORGANIZATION_EMAILADDRESS UDT_EMAILADDRESS INOUT
@ORIGINALCLIENTUSERID int INOUT
@ORIGINALCONSTITUENTID uniqueidentifier INOUT
@PHONEID uniqueidentifier INOUT
@ADDRESSID uniqueidentifier INOUT
@EMAILADDRESSID uniqueidentifier INOUT
@AUTHORIZATIONCODE nvarchar(20) INOUT
@TRANSACTIONID uniqueidentifier INOUT
@REJECTIONMESSAGE nvarchar(250) INOUT
@TYPECODE tinyint INOUT
@AMOUNT money INOUT
@CONSTITUENTID uniqueidentifier INOUT
@BILLING_STATE nvarchar(10) INOUT
@BILLING_COUNTRY nvarchar(4) INOUT
@HOMEMBERGOAL int INOUT
@HOMEMBERRETENTIONGOAL decimal(7, 4) INOUT
@SENDNOTIFICATIONS bit INOUT
@DECLINEBENEFITS bit INOUT
@BENEFITS xml INOUT
@BNUMBER nvarchar(100) INOUT
@VENDORID nvarchar(50) INOUT

Definition

Copy 

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REGISTRANTBATCHROW_2
(
  @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,
  @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(20) = 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,

  @DECLINEBENEFITS bit = null output,
  @BENEFITS xml = null output,
  @BNUMBER nvarchar(100) = null output,
  @VENDORID nvarchar(50) = 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, 
        @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,

    @DECLINEBENEFITS = DECLINEBENEFITS,
    @BENEFITS = BENEFITS,
    @BNUMBER = BATCH.BATCHNUMBER,
    @VENDORID = REGISTRANTBATCH.VENDORID

    from dbo.REGISTRANTBATCH (nolock)
  inner join dbo.BATCH (nolock) on REGISTRANTBATCH.BATCHID = BATCH.ID
  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;