USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_5

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	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
@INFOSOURCECODEID	uniqueidentifier	IN	Contact information source

Definition

Copy



        CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_5]
            (
                @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   
            )
            as
                set nocount on;

                declare @FORMERADDRESSTYPECODEID uniqueidentifier = null;

                exec dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_BBNCDEFAULTCODEMAP_4]
                    @FORMERADDRESSTYPECODEID = @FORMERADDRESSTYPECODEID

                exec dbo.[USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_6]
                    @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

                return 0;