USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_1_3
The save procedure used by the edit dataform template "NetCommunity Default Code Map Edit Form 1.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 | Blackbaud Internet Solutions link page |
| @CONTACTTYPECODEID | uniqueidentifier | IN | Contact relationship type |
| @CHANNELCODEID | uniqueidentifier | IN | Channel |
| @MGALIASTYPECODEID | uniqueidentifier | IN | Matchfinder Online alias type |
| @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 |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_1_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,
@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
)
as
set nocount on;
declare @CURRENTDATE datetime;
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
set @CURRENTDATE = getdate();
begin try
if not exists (select ID from dbo.NETCOMMUNITYDEFAULTCODEMAP where ID=@ID)
insert into dbo.NETCOMMUNITYDEFAULTCODEMAP
(
ID,
BUSINESSPHONECODEID,
FAXPHONECODEID,
RELATIONSHIPTYPECODEID,
SPOUSEREMOVEDRELATIONSHIPTYPECODEID,
PRIMARYBUSINESSRELATIONSHIPTYPECODEID,
PRIMARYBUSINESSRECIPROCALTYPECODEID,
PRIMARYADDRESSTYPECODEID,
BUSINESSADDRESSTYPECODEID,
ORGANIZATIONPRIMARYADDRESSTYPECODEID,
MGCONDITIONTYPECODEID,
REVENUENOTETYPECODEID,
CONSTITUENTLINKPAGEID,
CONTACTTYPECODEID,
CHANNELCODEID,
MGALIASTYPECODEID,
AUTOMATCHUSELASTNAME,
AUTOMATCHUSEFIRSTNAME,
AUTOMATCHUSEMAIDENNAME,
AUTOMATCHUSEBIRTHDATE,
AUTOMATCHUSEGENDER,
AUTOMATCHUSEMIDDLENAME,
AUTOMATCHUSEADDRESS,
AUTOMATCHUSECITY,
AUTOMATCHUSECOUNTRY,
AUTOMATCHUSECOUNTY,
AUTOMATCHUSENZCITY,
AUTOMATCHUSENZSUBURB,
AUTOMATCHUSESTATE,
AUTOMATCHUSEZIP,
AUTOMATCHUSEPHONE,
AUTOMATCHUSELOOKUPID,
AUTOMATCHEXACTMATCHONLY,
AUTOMATCHINCLUDEINACTIVE,
AUTOMATCHINCLUDEDECEASED,
ADDEDBYID,
CHANGEDBYID,
DATEADDED,
DATECHANGED
)
values
(
@ID,
@BUSINESSPHONECODEID,
@FAXPHONECODEID,
@RELATIONSHIPTYPECODEID,
@SPOUSEREMOVEDRELATIONSHIPTYPECODEID,
@PRIMARYBUSINESSRELATIONSHIPTYPECODEID,
@PRIMARYBUSINESSRECIPROCALTYPECODEID,
@PRIMARYADDRESSTYPECODEID,
@BUSINESSADDRESSTYPECODEID,
@ORGANIZATIONPRIMARYADDRESSTYPECODEID,
@MGCONDITIONTYPECODEID,
@REVENUENOTETYPECODEID,
@CONSTITUENTLINKPAGEID,
@CONTACTTYPECODEID,
@CHANNELCODEID,
@MGALIASTYPECODEID,
@AUTOMATCHUSELASTNAME,
@AUTOMATCHUSEFIRSTNAME,
@AUTOMATCHUSEMAIDENNAME,
@AUTOMATCHUSEBIRTHDATE,
@AUTOMATCHUSEGENDER,
@AUTOMATCHUSEMIDDLENAME,
@AUTOMATCHUSEADDRESS,
@AUTOMATCHUSECITY,
@AUTOMATCHUSECOUNTRY,
@AUTOMATCHUSECOUNTY,
@AUTOMATCHUSENZCITY,
@AUTOMATCHUSENZSUBURB,
@AUTOMATCHUSESTATE,
@AUTOMATCHUSEZIP,
@AUTOMATCHUSEPHONE,
@AUTOMATCHUSELOOKUPID,
@AUTOMATCHEXACTMATCHONLY,
@AUTOMATCHINCLUDEINACTIVE,
@AUTOMATCHINCLUDEDECEASED,
@CHANGEAGENTID,
@CHANGEAGENTID,
@CURRENTDATE,
@CURRENTDATE
);
else
update
dbo.[NETCOMMUNITYDEFAULTCODEMAP]
set
[BUSINESSPHONECODEID] = @BUSINESSPHONECODEID,
[FAXPHONECODEID] = @FAXPHONECODEID,
[RELATIONSHIPTYPECODEID] = @RELATIONSHIPTYPECODEID,
[SPOUSEREMOVEDRELATIONSHIPTYPECODEID] = @SPOUSEREMOVEDRELATIONSHIPTYPECODEID,
[PRIMARYBUSINESSRELATIONSHIPTYPECODEID] = @PRIMARYBUSINESSRELATIONSHIPTYPECODEID,
[PRIMARYBUSINESSRECIPROCALTYPECODEID] = @PRIMARYBUSINESSRECIPROCALTYPECODEID,
[PRIMARYADDRESSTYPECODEID] = @PRIMARYADDRESSTYPECODEID,
[BUSINESSADDRESSTYPECODEID] = @BUSINESSADDRESSTYPECODEID,
[ORGANIZATIONPRIMARYADDRESSTYPECODEID] = @ORGANIZATIONPRIMARYADDRESSTYPECODEID,
[MGCONDITIONTYPECODEID] = @MGCONDITIONTYPECODEID,
[REVENUENOTETYPECODEID] = @REVENUENOTETYPECODEID,
[CONSTITUENTLINKPAGEID] = @CONSTITUENTLINKPAGEID,
[CONTACTTYPECODEID] = @CONTACTTYPECODEID,
[CHANNELCODEID] = @CHANNELCODEID,
[MGALIASTYPECODEID] = @MGALIASTYPECODEID,
[AUTOMATCHUSELASTNAME] = @AUTOMATCHUSELASTNAME,
[AUTOMATCHUSEFIRSTNAME] = @AUTOMATCHUSEFIRSTNAME,
[AUTOMATCHUSEMAIDENNAME] = @AUTOMATCHUSEMAIDENNAME,
[AUTOMATCHUSEBIRTHDATE] = @AUTOMATCHUSEBIRTHDATE,
[AUTOMATCHUSEGENDER] = @AUTOMATCHUSEGENDER,
[AUTOMATCHUSEMIDDLENAME] = @AUTOMATCHUSEMIDDLENAME,
[AUTOMATCHUSEADDRESS] = @AUTOMATCHUSEADDRESS,
[AUTOMATCHUSECITY] = @AUTOMATCHUSECITY,
[AUTOMATCHUSECOUNTRY] = @AUTOMATCHUSECOUNTRY,
[AUTOMATCHUSECOUNTY] = @AUTOMATCHUSECOUNTY,
[AUTOMATCHUSENZCITY] = @AUTOMATCHUSENZCITY,
[AUTOMATCHUSENZSUBURB] = @AUTOMATCHUSENZSUBURB,
[AUTOMATCHUSESTATE] = @AUTOMATCHUSESTATE,
[AUTOMATCHUSEZIP] = @AUTOMATCHUSEZIP,
[AUTOMATCHUSEPHONE] = @AUTOMATCHUSEPHONE,
[AUTOMATCHUSELOOKUPID] = @AUTOMATCHUSELOOKUPID,
[AUTOMATCHEXACTMATCHONLY] = @AUTOMATCHEXACTMATCHONLY,
[AUTOMATCHINCLUDEINACTIVE] = @AUTOMATCHINCLUDEINACTIVE,
[AUTOMATCHINCLUDEDECEASED] = @AUTOMATCHINCLUDEDECEASED,
[DATECHANGED] = @CURRENTDATE,
[CHANGEDBYID] = @CHANGEAGENTID
where
[NETCOMMUNITYDEFAULTCODEMAP].ID = @ID;
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;