USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_3

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
@FAXPHONECODEID	uniqueidentifier	IN	Fax phone
@RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Spouse relationship type
@SPOUSEREMOVEDRELATIONSHIPTYPECODEID	uniqueidentifier	IN	Removed spouse relationship type
@PRIMARYBUSINESSRELATIONSHIPTYPECODEID	uniqueidentifier	IN	Organization relationship type
@PRIMARYBUSINESSRECIPROCALTYPECODEID	uniqueidentifier	IN	Individual 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	NetCommunity 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
@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

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_3
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @BUSINESSPHONECODEID uniqueidentifier,
    @FAXPHONECODEID 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
)
as
    set nocount on;

    declare @INFOSOURCECODEID uniqueidentifier;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BBNCDEFAULTCODEMAP_3
        @ID = @ID,
        @INFOSOURCECODEID = @INFOSOURCECODEID output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_4 @ID, @CHANGEAGENTID, @BUSINESSPHONECODEID, @FAXPHONECODEID, @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;

    return 0;