USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_7

The save procedure used by the edit dataform template "NetCommunity Default Code Map Edit Form 4.0".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@BUSINESSPHONECODEID	uniqueidentifier	IN	Business phone
@RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Spouse relationship type
@SPOUSEREMOVEDRELATIONSHIPTYPECODEID	uniqueidentifier	IN	Removed spouse relationship type
@PRIMARYBUSINESSRELATIONSHIPTYPECODEID	uniqueidentifier	IN	Individual relationship type
@PRIMARYBUSINESSRECIPROCALTYPECODEID	uniqueidentifier	IN	Organization relationship type
@PRIMARYADDRESSTYPECODEID	uniqueidentifier	IN	Primary address type
@BUSINESSADDRESSTYPECODEID	uniqueidentifier	IN	Business address type
@ORGANIZATIONPRIMARYADDRESSTYPECODEID	uniqueidentifier	IN	Organization primary address type
@MGCONDITIONTYPECODEID	uniqueidentifier	IN	Matching gift condition type
@REVENUENOTETYPECODEID	uniqueidentifier	IN	Donation note type
@CONSTITUENTLINKPAGEID	uniqueidentifier	IN	Blackbaud Internet Solutions link page
@CONTACTTYPECODEID	uniqueidentifier	IN	Contact relationship type
@CHANNELCODEID	uniqueidentifier	IN	Channel
@MGALIASTYPECODEID	uniqueidentifier	IN	Matchfinder Online alias type
@DONOTEMAILSOLICITCODEID	uniqueidentifier	IN	Do not email solicit code
@AUTOMATCHUSELASTNAME	bit	IN	Last name/Organization name/Educational institution
@AUTOMATCHUSEFIRSTNAME	bit	IN	First name
@AUTOMATCHUSEMAIDENNAME	bit	IN	Maiden name
@AUTOMATCHUSEBIRTHDATE	bit	IN	Birth date
@AUTOMATCHUSEGENDER	bit	IN	Gender
@AUTOMATCHUSEMIDDLENAME	bit	IN	Middle name
@AUTOMATCHUSEADDRESS	bit	IN	Address
@AUTOMATCHUSECITY	bit	IN	City
@AUTOMATCHUSECOUNTRY	bit	IN	Country
@AUTOMATCHUSECOUNTY	bit	IN	County
@AUTOMATCHUSENZCITY	bit	IN	NZ City
@AUTOMATCHUSENZSUBURB	bit	IN	NZ Suburb
@AUTOMATCHUSESTATE	bit	IN	State
@AUTOMATCHUSEZIP	bit	IN	ZIP
@AUTOMATCHUSEPHONE	bit	IN	Any phone
@AUTOMATCHUSELOOKUPID	bit	IN	Lookup ID
@AUTOMATCHEXACTMATCHONLY	bit	IN	Exact match only
@AUTOMATCHINCLUDEINACTIVE	bit	IN	Include inactive
@AUTOMATCHINCLUDEDECEASED	bit	IN	Include deceased
@PLUGINSERVICEURL	UDT_WEBADDRESS	IN	Plugin service URL
@INFOSOURCECODEID	uniqueidentifier	IN	Contact information source
@FORMERADDRESSTYPECODEID	uniqueidentifier	IN	Former address type
@AUTOMATCHUSEEMAIL	bit	IN	Any email

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_7
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @BUSINESSPHONECODEID uniqueidentifier,
    @RELATIONSHIPTYPECODEID uniqueidentifier,
    @SPOUSEREMOVEDRELATIONSHIPTYPECODEID uniqueidentifier,
    @PRIMARYBUSINESSRELATIONSHIPTYPECODEID uniqueidentifier,
    @PRIMARYBUSINESSRECIPROCALTYPECODEID uniqueidentifier,
    @PRIMARYADDRESSTYPECODEID uniqueidentifier,
    @BUSINESSADDRESSTYPECODEID uniqueidentifier,
    @ORGANIZATIONPRIMARYADDRESSTYPECODEID uniqueidentifier,
    @MGCONDITIONTYPECODEID uniqueidentifier,
    @REVENUENOTETYPECODEID uniqueidentifier,
    @CONSTITUENTLINKPAGEID uniqueidentifier,
    @CONTACTTYPECODEID uniqueidentifier,
    @CHANNELCODEID uniqueidentifier,
    @MGALIASTYPECODEID uniqueidentifier,
    @DONOTEMAILSOLICITCODEID uniqueidentifier,
    @AUTOMATCHUSELASTNAME bit,
    @AUTOMATCHUSEFIRSTNAME bit,
    @AUTOMATCHUSEMAIDENNAME bit,
    @AUTOMATCHUSEBIRTHDATE bit,
    @AUTOMATCHUSEGENDER bit,
    @AUTOMATCHUSEMIDDLENAME bit,
    @AUTOMATCHUSEADDRESS bit,
    @AUTOMATCHUSECITY bit,
    @AUTOMATCHUSECOUNTRY bit,
    @AUTOMATCHUSECOUNTY bit,
  @AUTOMATCHUSENZCITY bit,
  @AUTOMATCHUSENZSUBURB bit,
    @AUTOMATCHUSESTATE bit,
    @AUTOMATCHUSEZIP bit,
    @AUTOMATCHUSEPHONE bit,
    @AUTOMATCHUSELOOKUPID bit,
    @AUTOMATCHEXACTMATCHONLY bit,
    @AUTOMATCHINCLUDEINACTIVE bit,
    @AUTOMATCHINCLUDEDECEASED bit,
    @PLUGINSERVICEURL dbo.UDT_WEBADDRESS,
    @INFOSOURCECODEID uniqueidentifier,
    @FORMERADDRESSTYPECODEID uniqueidentifier,
    @AUTOMATCHUSEEMAIL bit
)

as
  set nocount on;

    declare @EMAILADDRESSTYPECODEID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BBNCDEFAULTCODEMAP_4
        @ID = @ID,
        @EMAILADDRESSTYPECODEID = @EMAILADDRESSTYPECODEID output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_8
        @ID,
        @CHANGEAGENTID,
        @BUSINESSPHONECODEID,
        @RELATIONSHIPTYPECODEID,
        @SPOUSEREMOVEDRELATIONSHIPTYPECODEID,
        @PRIMARYBUSINESSRELATIONSHIPTYPECODEID,
        @PRIMARYBUSINESSRECIPROCALTYPECODEID,
        @PRIMARYADDRESSTYPECODEID,
        @BUSINESSADDRESSTYPECODEID,
        @ORGANIZATIONPRIMARYADDRESSTYPECODEID,
        @MGCONDITIONTYPECODEID,
        @REVENUENOTETYPECODEID,
        @CONSTITUENTLINKPAGEID,
        @CONTACTTYPECODEID,
        @CHANNELCODEID,
        @MGALIASTYPECODEID,
        @DONOTEMAILSOLICITCODEID,
        @AUTOMATCHUSELASTNAME,
        @AUTOMATCHUSEFIRSTNAME,
        @AUTOMATCHUSEMAIDENNAME,
        @AUTOMATCHUSEBIRTHDATE,
        @AUTOMATCHUSEGENDER,
        @AUTOMATCHUSEMIDDLENAME,
        @AUTOMATCHUSEADDRESS,
        @AUTOMATCHUSECITY,
        @AUTOMATCHUSECOUNTRY,
        @AUTOMATCHUSECOUNTY,
        @AUTOMATCHUSENZCITY,
        @AUTOMATCHUSENZSUBURB,
        @AUTOMATCHUSESTATE,
        @AUTOMATCHUSEZIP,
        @AUTOMATCHUSEPHONE,
        @AUTOMATCHUSELOOKUPID,
        @AUTOMATCHEXACTMATCHONLY,
        @AUTOMATCHINCLUDEINACTIVE,
        @AUTOMATCHINCLUDEDECEASED,
        @PLUGINSERVICEURL,
        @INFOSOURCECODEID,
        @FORMERADDRESSTYPECODEID,
        @AUTOMATCHUSEEMAIL,
        @EMAILADDRESSTYPECODEID

  return 0;