USP_DATAFORMTEMPLATE_EDIT_REGISTRANTBATCHROW

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@REGISTRANTROLECODE	int	IN	Registrant role
@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
@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.

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REGISTRANTBATCHROW
(
  @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,
  @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
)
as
begin
  set nocount on;

  declare @AUTHORIZATIONCODE nvarchar(20);
  declare @TRANSACTIONID uniqueidentifier;
  declare @REJECTIONMESSAGE nvarchar(250);
  declare @TYPECODE tinyint;
  declare @AMOUNT money;
  declare @CONSTITUENTID uniqueidentifier;
  declare @BILLING_STATE nvarchar(10);
  declare @BILLING_COUNTRY nvarchar(4);


  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REGISTRANTBATCHROW
        @ID = @ID,
        @AUTHORIZATIONCODE = @AUTHORIZATIONCODE output,
        @TRANSACTIONID = @TRANSACTIONID output,
        @REJECTIONMESSAGE = @REJECTIONMESSAGE output,
        @TYPECODE = @TYPECODE output,
        @AMOUNT = @AMOUNT output,
        @CONSTITUENTID = @CONSTITUENTID output,
        @BILLING_STATE = @BILLING_STATE output,
        @BILLING_COUNTRY = @BILLING_COUNTRY output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_REGISTRANTBATCHROW_2
  @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,
  @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
end