USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_9
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @BUSINESSPHONECODEID | uniqueidentifier | IN | |
| @RELATIONSHIPTYPECODEID | uniqueidentifier | IN | |
| @SPOUSEREMOVEDRELATIONSHIPTYPECODEID | uniqueidentifier | IN | |
| @PRIMARYBUSINESSRELATIONSHIPTYPECODEID | uniqueidentifier | IN | |
| @PRIMARYBUSINESSRECIPROCALTYPECODEID | uniqueidentifier | IN | |
| @PRIMARYADDRESSTYPECODEID | uniqueidentifier | IN | |
| @BUSINESSADDRESSTYPECODEID | uniqueidentifier | IN | |
| @ORGANIZATIONPRIMARYADDRESSTYPECODEID | uniqueidentifier | IN | |
| @MGCONDITIONTYPECODEID | uniqueidentifier | IN | |
| @REVENUENOTETYPECODEID | uniqueidentifier | IN | |
| @CONSTITUENTLINKPAGEID | uniqueidentifier | IN | |
| @CONTACTTYPECODEID | uniqueidentifier | IN | |
| @CHANNELCODEID | uniqueidentifier | IN | |
| @MGALIASTYPECODEID | uniqueidentifier | IN | |
| @DONOTEMAILSOLICITCODEID | uniqueidentifier | IN | |
| @AUTOMATCHUSELASTNAME | bit | IN | |
| @AUTOMATCHUSEFIRSTNAME | bit | IN | |
| @AUTOMATCHUSEMAIDENNAME | bit | IN | |
| @AUTOMATCHUSEBIRTHDATE | bit | IN | |
| @AUTOMATCHUSEGENDER | bit | IN | |
| @AUTOMATCHUSEMIDDLENAME | bit | IN | |
| @AUTOMATCHUSEADDRESS | bit | IN | |
| @AUTOMATCHUSECITY | bit | IN | |
| @AUTOMATCHUSECOUNTRY | bit | IN | |
| @AUTOMATCHUSECOUNTY | bit | IN | |
| @AUTOMATCHUSENZCITY | bit | IN | |
| @AUTOMATCHUSENZSUBURB | bit | IN | |
| @AUTOMATCHUSESTATE | bit | IN | |
| @AUTOMATCHUSEZIP | bit | IN | |
| @AUTOMATCHUSEPHONE | bit | IN | |
| @AUTOMATCHUSELOOKUPID | bit | IN | |
| @AUTOMATCHEXACTMATCHONLY | bit | IN | |
| @AUTOMATCHINCLUDEINACTIVE | bit | IN | |
| @AUTOMATCHINCLUDEDECEASED | bit | IN | |
| @PLUGINSERVICEURL | UDT_WEBADDRESS | IN | |
| @INFOSOURCECODEID | uniqueidentifier | IN | |
| @FORMERADDRESSTYPECODEID | uniqueidentifier | IN | |
| @AUTOMATCHUSEEMAIL | bit | IN | |
| @EMAILADDRESSTYPECODEID | uniqueidentifier | IN | |
| @AUTOMATCHUSESUFFIX | bit | IN | |
| @DONOTEMAILCONSENTSOLICITCODEID | uniqueidentifier | IN | |
| @DATAPROTECTIONEVIDENCESOURCECODEID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_9]
(
@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,
@EMAILADDRESSTYPECODEID uniqueidentifier,
@AUTOMATCHUSESUFFIX bit,
@DONOTEMAILCONSENTSOLICITCODEID uniqueidentifier,
@DATAPROTECTIONEVIDENCESOURCECODEID uniqueidentifier
)
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 top 1 1 from dbo.[NETCOMMUNITYPLUGINSERVICE])
insert into dbo.[NETCOMMUNITYPLUGINSERVICE]
(
[ID],
[URL],
[ADDEDBYID],
[CHANGEDBYID],
[DATEADDED],
[DATECHANGED]
)
values
(
newid(),
@PLUGINSERVICEURL,
@CHANGEAGENTID,
@CHANGEAGENTID,
@CURRENTDATE,
@CURRENTDATE
);
else
update dbo.[NETCOMMUNITYPLUGINSERVICE] set
[URL] = @PLUGINSERVICEURL,
[DATECHANGED] = @CURRENTDATE,
[CHANGEDBYID] = @CHANGEAGENTID;
if not exists (select top 1 1 from dbo.[NETCOMMUNITYDEFAULTCODEMAP] where [ID] = @ID)
insert into dbo.[NETCOMMUNITYDEFAULTCODEMAP]
(
[ID],
[BUSINESSPHONECODEID],
[RELATIONSHIPTYPECODEID],
[SPOUSEREMOVEDRELATIONSHIPTYPECODEID],
[PRIMARYBUSINESSRELATIONSHIPTYPECODEID],
[PRIMARYBUSINESSRECIPROCALTYPECODEID],
[PRIMARYADDRESSTYPECODEID],
[BUSINESSADDRESSTYPECODEID],
[FORMERADDRESSTYPECODEID],
[ORGANIZATIONPRIMARYADDRESSTYPECODEID],
[MGCONDITIONTYPECODEID],
[REVENUENOTETYPECODEID],
[CONSTITUENTLINKPAGEID],
[CONTACTTYPECODEID],
[CHANNELCODEID],
[MGALIASTYPECODEID],
[DONOTEMAILSOLICITCODEID],
[INFOSOURCECODEID],
[EMAILADDRESSTYPECODEID],
[AUTOMATCHUSELASTNAME],
[AUTOMATCHUSEFIRSTNAME],
[AUTOMATCHUSEMAIDENNAME],
[AUTOMATCHUSEBIRTHDATE],
[AUTOMATCHUSEGENDER],
[AUTOMATCHUSEMIDDLENAME],
[AUTOMATCHUSEADDRESS],
[AUTOMATCHUSECITY],
[AUTOMATCHUSECOUNTRY],
[AUTOMATCHUSECOUNTY],
[AUTOMATCHUSENZCITY],
[AUTOMATCHUSENZSUBURB],
[AUTOMATCHUSESTATE],
[AUTOMATCHUSEZIP],
[AUTOMATCHUSEPHONE],
[AUTOMATCHUSELOOKUPID],
[AUTOMATCHEXACTMATCHONLY],
[AUTOMATCHINCLUDEINACTIVE],
[AUTOMATCHINCLUDEDECEASED],
[ADDEDBYID],
[CHANGEDBYID],
[DATEADDED],
[DATECHANGED],
[AUTOMATCHUSEEMAIL],
[AUTOMATCHUSESUFFIX],
[DONOTEMAILCONSENTSOLICITCODEID],
[DATAPROTECTIONEVIDENCESOURCECODEID]
)
values
(
@ID,
@BUSINESSPHONECODEID,
@RELATIONSHIPTYPECODEID,
@SPOUSEREMOVEDRELATIONSHIPTYPECODEID,
@PRIMARYBUSINESSRELATIONSHIPTYPECODEID,
@PRIMARYBUSINESSRECIPROCALTYPECODEID,
@PRIMARYADDRESSTYPECODEID,
@BUSINESSADDRESSTYPECODEID,
@FORMERADDRESSTYPECODEID,
@ORGANIZATIONPRIMARYADDRESSTYPECODEID,
@MGCONDITIONTYPECODEID,
@REVENUENOTETYPECODEID,
@CONSTITUENTLINKPAGEID,
@CONTACTTYPECODEID,
@CHANNELCODEID,
@MGALIASTYPECODEID,
@DONOTEMAILSOLICITCODEID,
@INFOSOURCECODEID,
@EMAILADDRESSTYPECODEID,
@AUTOMATCHUSELASTNAME,
@AUTOMATCHUSEFIRSTNAME,
@AUTOMATCHUSEMAIDENNAME,
@AUTOMATCHUSEBIRTHDATE,
@AUTOMATCHUSEGENDER,
@AUTOMATCHUSEMIDDLENAME,
@AUTOMATCHUSEADDRESS,
@AUTOMATCHUSECITY,
@AUTOMATCHUSECOUNTRY,
@AUTOMATCHUSECOUNTY,
@AUTOMATCHUSENZCITY,
@AUTOMATCHUSENZSUBURB,
@AUTOMATCHUSESTATE,
@AUTOMATCHUSEZIP,
@AUTOMATCHUSEPHONE,
@AUTOMATCHUSELOOKUPID,
@AUTOMATCHEXACTMATCHONLY,
@AUTOMATCHINCLUDEINACTIVE,
@AUTOMATCHINCLUDEDECEASED,
@CHANGEAGENTID,
@CHANGEAGENTID,
@CURRENTDATE,
@CURRENTDATE,
@AUTOMATCHUSEEMAIL,
@AUTOMATCHUSESUFFIX,
@DONOTEMAILCONSENTSOLICITCODEID,
@DATAPROTECTIONEVIDENCESOURCECODEID
);
else
update
dbo.[NETCOMMUNITYDEFAULTCODEMAP]
set
[BUSINESSPHONECODEID] = @BUSINESSPHONECODEID,
[RELATIONSHIPTYPECODEID] = @RELATIONSHIPTYPECODEID,
[SPOUSEREMOVEDRELATIONSHIPTYPECODEID] = @SPOUSEREMOVEDRELATIONSHIPTYPECODEID,
[PRIMARYBUSINESSRELATIONSHIPTYPECODEID] = @PRIMARYBUSINESSRELATIONSHIPTYPECODEID,
[PRIMARYBUSINESSRECIPROCALTYPECODEID] = @PRIMARYBUSINESSRECIPROCALTYPECODEID,
[PRIMARYADDRESSTYPECODEID] = @PRIMARYADDRESSTYPECODEID,
[BUSINESSADDRESSTYPECODEID] = @BUSINESSADDRESSTYPECODEID,
[ORGANIZATIONPRIMARYADDRESSTYPECODEID] = @ORGANIZATIONPRIMARYADDRESSTYPECODEID,
[FORMERADDRESSTYPECODEID] = @FORMERADDRESSTYPECODEID,
[MGCONDITIONTYPECODEID] = @MGCONDITIONTYPECODEID,
[REVENUENOTETYPECODEID] = @REVENUENOTETYPECODEID,
[CONSTITUENTLINKPAGEID] = @CONSTITUENTLINKPAGEID,
[CONTACTTYPECODEID] = @CONTACTTYPECODEID,
[CHANNELCODEID] = @CHANNELCODEID,
[MGALIASTYPECODEID] = @MGALIASTYPECODEID,
[DONOTEMAILSOLICITCODEID] = @DONOTEMAILSOLICITCODEID,
[INFOSOURCECODEID] = @INFOSOURCECODEID,
[EMAILADDRESSTYPECODEID] = @EMAILADDRESSTYPECODEID,
[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,
[AUTOMATCHUSEEMAIL] = @AUTOMATCHUSEEMAIL,
[AUTOMATCHUSESUFFIX] = @AUTOMATCHUSESUFFIX,
[DONOTEMAILCONSENTSOLICITCODEID] =@DONOTEMAILCONSENTSOLICITCODEID,
[DATAPROTECTIONEVIDENCESOURCECODEID] = @DATAPROTECTIONEVIDENCESOURCECODEID
where
[NETCOMMUNITYDEFAULTCODEMAP].ID = @ID;
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch;
return 0;