USP_DATAFORMTEMPLATE_EDIT_REGISTRANTBATCHROW_4

Parameters

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

Definition

Copy 


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REGISTRANTBATCHROW_4
(
  @ID uniqueidentifier,
  @REGISTRANTROLECODE int,
  @EVENTID uniqueidentifier,
  @SEQUENCE int,
  @USERID nvarchar(100),
  @PASSWORD nvarchar(20),
  @FIRSTNAME nvarchar(100),
  @LASTNAME nvarchar(100),
  @EMAILADDRESS UDT_EMAILADDRESS,
  @ADDRESSTYPECODEID uniqueidentifier,
  @COUNTRYID uniqueidentifier,
  @ADDRESS nvarchar(300),
  @CITY nvarchar(100),
  @STATEID uniqueidentifier,
  @POSTCODE nvarchar(24),
  @MIDDLENAME nvarchar(100),
  @TITLECODEID uniqueidentifier,
  @SUFFIXCODEID uniqueidentifier,
  @NICKNAME nvarchar(100),
  @MAIDENNAME nvarchar(200),
  @BIRTHDATE UDT_FUZZYDATE,

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

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

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

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

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

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

  @SUBSCRIBEDNEWSLETTERIDS xml,
  @MERCHANTACCOUNTID uniqueidentifier,
  @ISORGANIZATION bit,
  @ORGANIZATIONID uniqueidentifier,
  @ORGANIZATION_NAME nvarchar(100),
  @ORGANIZATION_WEBADDRESS nvarchar(500),
  @ORGANIZATION_ADDRESSTYPECODEID uniqueidentifier,
  @ORGANIZATION_COUNTRYID uniqueidentifier,
  @ORGANIZATION_ADDRESSBLOCK nvarchar(150),
  @ORGANIZATION_CITY nvarchar(50),
  @ORGANIZATION_STATEID uniqueidentifier,
  @ORGANIZATION_POSTCODE nvarchar(12),
  @ORGANIZATION_DONOTMAIL bit,
  @ORGANIZATION_DONOTMAILREASONCODEID uniqueidentifier,
  @ORGANIZATION_PHONETYPECODEID uniqueidentifier,
  @ORGANIZATION_NUMBER nvarchar(100),
  @ORGANIZATION_EMAILADDRESS UDT_EMAILADDRESS,
  @ORIGINALCLIENTUSERID integer,
  @ORIGINALCONSTITUENTID uniqueidentifier,
  @PHONEID uniqueidentifier,
  @ADDRESSID uniqueidentifier,
  @EMAILADDRESSID uniqueidentifier,

  @CHANGEAGENTID uniqueidentifier = null,
  @AUTHORIZATIONCODE nvarchar(20),
  @TRANSACTIONID uniqueidentifier,
  @REJECTIONMESSAGE nvarchar(250),
  @TYPECODE tinyint,
  @AMOUNT money,
  @CONSTITUENTID uniqueidentifier,
  @BILLING_STATE nvarchar(10),
  @BILLING_COUNTRY nvarchar(4),

  @HOMEMBERGOAL    int,
  @HOMEMBERRETENTIONGOAL decimal(7,4),

  @SENDNOTIFICATIONS bit

)
as
begin
  set nocount on;
  declare @BNUMBER nvarchar(100);

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REGISTRANTBATCHROW
        @ID = @ID,
        @BNUMBER = @BNUMBER output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_REGISTRANTBATCHROW_5
  @ID,
  @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,
  @DECLINEBENEFITS,
  @BENEFITS,
  @WAIVERACCEPTED,

  @FUNDRAISINGGOAL,
  @TARGETFUNDRAISINGGOAL,
  @PARTICIPANTGOAL,
  @DONORRETENTIONGOAL,
  @COMMUNICATIONGOAL,
  @TEAMFUNDRAISINGGOAL,
  @TEAMMEMBERGOAL,
  @TEAMMEMBERRETENTIONGOAL,
  @TEAMCOMMUNICATIONGOAL,
  @TEAMPARTICIPANTGOAL,
  @COFUNDRAISINGGOAL,
  @COTEAMSGOAL,
  @COTEAMRETENTIONGOAL,
  @COMEMBERGOAL,
  @COMEMBERRETENTIONGOAL,
  @COPARTICIPANTGOAL,
  @COCOMMUNICATIONGOAL,
  @HOFUNDRAISINGGOAL,
  @HOTARGETFUNDRAISINGGOAL,
  @HOPARTICIPANTGOAL,
  @HODONORRETENTIONGOAL,
  @HOCOMMUNICATIONGOAL,  
  @ADDITIONALDONATIONAMOUNT,
  @PAYMENTMETHODCODE,  
  @CREDITCARDHOLDER,
  @CREDITCARDNUMBER,
  @CREDITCARDTYPE,
  @EXPIRATIONDATE,
  @CREDITCARDTOKEN,
  @CREDITCARDID,

  @CHECKDATE,
  @CHECKNUMBER,
  @BANKACCOUNTTYPECODE,
  @BANKACCOUNTHOLDER,
  @BANKACCOUNTNUMBER,
  @BANKACCOUNTROUTINGCODE,

  @SAMEASPRIMARYADDRESS,
  @BILLING_COUNTRYID,
  @BILLING_ADDRESSBLOCK,
  @BILLING_CITY,
  @BILLING_STATEID,
  @BILLING_POSTCODE,

  @SUBSCRIBEDNEWSLETTERIDS,
  @MERCHANTACCOUNTID,
  @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,

  @CHANGEAGENTID,
  @AUTHORIZATIONCODE,
  @TRANSACTIONID,
  @REJECTIONMESSAGE,
  @TYPECODE,
  @AMOUNT,
  @CONSTITUENTID,
  @BILLING_STATE,
  @BILLING_COUNTRY,

  @HOMEMBERGOAL,
  @HOMEMBERRETENTIONGOAL,

  @SENDNOTIFICATIONS,
  @BNUMBER

end