USP_DATAFORMTEMPLATE_EDIT_REGISTRANTBATCHROW_3
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 | |
| @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_3
(
@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,
@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
set nocount on;
exec dbo.USP_DATAFORMTEMPLATE_EDIT_REGISTRANTBATCHROW_4
@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,
0,
null,
@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