USP_DATAFORMTEMPLATE_EDIT_REGISTRANTBATCHROW_5

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
@BNUMBER nvarchar(100) IN

Definition

Copy 


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REGISTRANTBATCHROW_5
(
    @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,
    @BNUMBER nvarchar(100)
)
as
begin
    set nocount on;
    declare @VENDORID nvarchar(50);

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REGISTRANTBATCHROW_2
        @ID = @ID,
        @VENDORID = @VENDORID output;

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