USP_REGISTRANTBATCH_ADD_EDIT

USP_REGISTRANTBATCH_ADD_EDIT

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier INOUT
@REGISTRANTROLECODE int IN
@BATCHID uniqueidentifier IN
@EVENTID uniqueidentifier IN
@SEQUENCE int IN
@USERID nvarchar(100) IN
@PASSWORD nvarchar(510) 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
@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
@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
@HOMEMBERGOAL int IN
@HOMEMBERRETENTIONGOAL decimal(7, 4) IN
@SENDNOTIFICATIONS bit IN

Definition

Copy 


CREATE procedure dbo.USP_REGISTRANTBATCH_ADD_EDIT
(
  @ID uniqueidentifier = null output,
  @REGISTRANTROLECODE int,
  @BATCHID uniqueidentifier = null,
  @EVENTID uniqueidentifier = null,
  @SEQUENCE int = null,
  @USERID nvarchar(100),
  @PASSWORD nvarchar(510),
  @FIRSTNAME nvarchar(100),
  @LASTNAME nvarchar(100),
  @EMAILADDRESS UDT_EMAILADDRESS,
  @ADDRESSTYPECODEID uniqueidentifier = null,
  @COUNTRYID uniqueidentifier = null,
  @ADDRESS nvarchar(300) = '',
  @CITY nvarchar(100) = '',
  @STATEID uniqueidentifier = null,
  @POSTCODE nvarchar(24) = '',
  @MIDDLENAME nvarchar(100) = '',
  @TITLECODEID uniqueidentifier = null,
  @SUFFIXCODEID uniqueidentifier = null,
  @NICKNAME nvarchar(100) = '',
  @MAIDENNAME nvarchar(200) = '',
  @BIRTHDATE UDT_FUZZYDATE = '00000000',

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

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

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

  @FUNDRAISINGGOAL money = 0,
  @TARGETFUNDRAISINGGOAL money = 0,
  @PARTICIPANTGOAL    int = 0,
  @DONORRETENTIONGOAL    decimal(7,4) = 0.0,
  @COMMUNICATIONGOAL    int = 0,
  @TEAMFUNDRAISINGGOAL    money = 0,
  @TEAMMEMBERGOAL    int = 0,
  @TEAMMEMBERRETENTIONGOAL decimal(7,4) = 0.0,
  @TEAMCOMMUNICATIONGOAL    int = 0,
  @TEAMPARTICIPANTGOAL    int = 0,
  @COFUNDRAISINGGOAL    money = 0,
  @COTEAMSGOAL    int = 0,
  @COTEAMRETENTIONGOAL decimal(7,4) = 0.0,
  @COMEMBERGOAL    int = 0,
  @COMEMBERRETENTIONGOAL decimal(7,4) = 0.0,
  @COPARTICIPANTGOAL    int = 0,
  @COCOMMUNICATIONGOAL    int = 0,
  @HOFUNDRAISINGGOAL    money = 0,
  @HOTARGETFUNDRAISINGGOAL    money = 0,
  @HOPARTICIPANTGOAL    int = 0,
  @HODONORRETENTIONGOAL decimal(7,4) = 0.0,
  @HOCOMMUNICATIONGOAL    int = 0,  
  @ADDITIONALDONATIONAMOUNT money = 0,
  @PAYMENTMETHODCODE nvarchar(20) = '0',  
  @CREDITCARDHOLDER nvarchar(200) = '',
  @CREDITCARDNUMBER nvarchar(200) = '',
  @CREDITCARDTYPE uniqueidentifier = null,
  @EXPIRATIONDATE UDT_FUZZYDATE = '00000000',
  @CREDITCARDTOKEN uniqueidentifier = null,
  @CHECKDATE UDT_FUZZYDATE = '00000000',
  @CHECKNUMBER nvarchar(20) = '',
  @BANKACCOUNTTYPECODE nvarchar(20) = '0',
  @BANKACCOUNTHOLDER nvarchar(200) = '',
  @BANKACCOUNTNUMBER nvarchar(200) = '',
  @BANKACCOUNTROUTINGCODE nvarchar(200) = '',

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

  @ISORGANIZATION bit = null,
  @ORGANIZATIONID uniqueidentifier = null,
  @ORGANIZATION_NAME nvarchar(100) = null,
  @ORGANIZATION_WEBADDRESS nvarchar(500) = null,
  @ORGANIZATION_ADDRESSTYPECODEID uniqueidentifier = null,
  @ORGANIZATION_COUNTRYID uniqueidentifier = null,
  @ORGANIZATION_ADDRESSBLOCK nvarchar(150) = null,
  @ORGANIZATION_CITY nvarchar(50) = null,
  @ORGANIZATION_STATEID uniqueidentifier = null,
  @ORGANIZATION_POSTCODE nvarchar(12) = null,
  @ORGANIZATION_DONOTMAIL bit = null,
  @ORGANIZATION_DONOTMAILREASONCODEID uniqueidentifier = null,
  @ORGANIZATION_PHONETYPECODEID uniqueidentifier = null,
  @ORGANIZATION_NUMBER nvarchar(100) = null,
  @ORGANIZATION_EMAILADDRESS UDT_EMAILADDRESS = null,

  @ORIGINALCLIENTUSERID integer = null,
  @ORIGINALCONSTITUENTID uniqueidentifier = null,
  @PHONEID uniqueidentifier = null,
  @ADDRESSID uniqueidentifier = null,
  @EMAILADDRESSID uniqueidentifier = null,

  @CHANGEAGENTID uniqueidentifier = null,
  @AUTHORIZATIONCODE nvarchar(20) = '',
  @TRANSACTIONID uniqueidentifier = null,
  @REJECTIONMESSAGE nvarchar(250) = '',

  @HOMEMBERGOAL    int = 0,
  @HOMEMBERRETENTIONGOAL decimal(7,4) = 0.0,

  @SENDNOTIFICATIONS bit = 1

)
as

    set nocount on;
    exec dbo.USP_REGISTRANTBATCH_ADD_EDIT_2
  @ID,
  @REGISTRANTROLECODE,
  @BATCHID,
  @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,
  @CHECKDATE,
  @CHECKNUMBER,
  @BANKACCOUNTTYPECODE,
  @BANKACCOUNTHOLDER,
  @BANKACCOUNTNUMBER,
  @BANKACCOUNTROUTINGCODE,

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

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

  @HOMEMBERGOAL,
  @HOMEMBERRETENTIONGOAL,

  @SENDNOTIFICATIONS,

  0,
  null
return 0;