USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATION_4

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CODE	nvarchar(10)	IN	Code
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@SITEID	uniqueidentifier	IN	Site
@SOURCECODEID	uniqueidentifier	IN	Source code
@ITEMLIST	xml	IN	Items
@MAILDATE	datetime	IN	Date
@HOUSEHOLDINGTYPECODE	tinyint	IN	Include
@EXCLUSIONDATETYPECODE	tinyint	IN	Consider exclusions as of
@EXCLUSIONASOFDATE	datetime	IN	Consider exclusions as of
@EXCLUDEDECEASED	bit	IN	Exclude deceased constituents
@EXCLUDEINACTIVE	bit	IN	Exclude inactive constituents
@EXCLUSIONS	xml	IN	Exclusions
@USEADDRESSPROCESSING	bit	IN	Use address processing?
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	IN	Address processing options
@NAMEFORMATPARAMETERID	uniqueidentifier	IN	Name format options
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE	tinyint	IN	Consider seasonal addresses as of
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATE	datetime	IN	Consider seasonal addresses as of
@ACTIVATIONKPIS	xml	IN	Activation KPIs
@USEKPISASDEFAULT	bit	IN	Use the chosen KPIs as the default for future marketing efforts
@APPEALINFORMATION	xml	IN	Appeal information including the appeal searchlist and record source.
@RUNACTIVATEANDEXPORT	bit	IN	Export marketing effort when activation completes
@EXPORTDESCRIPTION	nvarchar(255)	IN	Export description
@MAILEXPORTDEFINITIONID	uniqueidentifier	IN	Mail export definition
@EMAILEXPORTDEFINITIONID	uniqueidentifier	IN	Email export definition
@PHONEEXPORTDEFINITIONID	uniqueidentifier	IN	Phone export definition
@CODEVALUEID	uniqueidentifier	IN	Code value ID
@RUNSEGMENTATIONSEGMENTREFRESHPROCESS	bit	IN	Refresh segment selections and filters
@CACHESOURCEANALYSISRULEDATA	bit	IN	Capture source analysis rule data

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATION_4]
(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @CODE nvarchar(10),
  @NAME nvarchar(100),
  @DESCRIPTION nvarchar(255),
  @SITEID uniqueidentifier,
  @SOURCECODEID uniqueidentifier,
  @ITEMLIST xml,
  @MAILDATE datetime,
  @HOUSEHOLDINGTYPECODE tinyint,
  @EXCLUSIONDATETYPECODE tinyint,
  @EXCLUSIONASOFDATE datetime,
  @EXCLUDEDECEASED bit,
  @EXCLUDEINACTIVE bit,
  @EXCLUSIONS xml,
  @USEADDRESSPROCESSING bit,
  @ADDRESSPROCESSINGOPTIONID uniqueidentifier,
  @NAMEFORMATPARAMETERID uniqueidentifier,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE tinyint,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE datetime,
  @ACTIVATIONKPIS xml,
  @USEKPISASDEFAULT bit,
  @APPEALINFORMATION xml,
  @RUNACTIVATEANDEXPORT bit,
  @EXPORTDESCRIPTION nvarchar(255),
  @MAILEXPORTDEFINITIONID uniqueidentifier,
  @EMAILEXPORTDEFINITIONID uniqueidentifier,
  @PHONEEXPORTDEFINITIONID uniqueidentifier,
  @CODEVALUEID uniqueidentifier,
  @RUNSEGMENTATIONSEGMENTREFRESHPROCESS bit,
  @CACHESOURCEANALYSISRULEDATA bit
)
as
begin
  set nocount on;
  declare @BUSINESSUNITS xml;
  declare @OVERRIDEBUSINESSUNITS bit;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MKTSEGMENTATION_4
  @ID=@ID,
  @CURRENTAPPUSERID =@CURRENTAPPUSERID,
  @ACTIVE= null,
  @CODE=@CODE,
  @NAME =@NAME,
  @DESCRIPTION =@DESCRIPTION,
  @SITEID=@SITEID,
  @SOURCECODEID=@SOURCECODEID,
  @ITEMLIST=@ITEMLIST,
  @ISTESTMAILING=null,
  @MAILDATE=@MAILDATE,
  @PLANPATH=null,
  @HOUSEHOLDINGTYPECODE=@HOUSEHOLDINGTYPECODE,
  @ENABLEHOUSEHOLDING=null,
  @SITEREQUIRED=null,
  @SITECANBECHANGED=null,
  @MAILINGTYPECODE=null,
  @ISBBEC=null,
  @OWNERID=null,
  @EXCLUSIONDATETYPECODE =@EXCLUSIONDATETYPECODE,
  @EXCLUSIONASOFDATE=null,
  @EXCLUDEDECEASED =@EXCLUDEDECEASED,
  @EXCLUDEINACTIVE=@EXCLUDEINACTIVE,
  @EXCLUSIONS=@EXCLUSIONS,
  @USEADDRESSPROCESSING=@USEADDRESSPROCESSING,
  @ADDRESSPROCESSINGOPTIONID=@ADDRESSPROCESSINGOPTIONID,
  @NAMEFORMATPARAMETERID=@NAMEFORMATPARAMETERID,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE=@ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE=@ADDRESSPROCESSINGOPTIONSEASONALASOFDATE,
  @CANUPDATEEXCLUDEDECEASED=null,
  @CANUPDATEEXCLUDEINACTIVE=null,
  @ACTIVATIONKPIS=@ACTIVATIONKPIS,
  @USEKPISASDEFAULT=@USEKPISASDEFAULT,
  @APPEALINFORMATION=@APPEALINFORMATION,
  @RUNACTIVATEANDEXPORT=@RUNACTIVATEANDEXPORT,
  @EXPORTDESCRIPTION=@EXPORTDESCRIPTION,
  @MAILEXPORTDEFINITIONID=@MAILEXPORTDEFINITIONID,
  @EMAILEXPORTDEFINITIONID=@EMAILEXPORTDEFINITIONID,
  @PHONEEXPORTDEFINITIONID=@PHONEEXPORTDEFINITIONID,
  @CODEVALUEID=@CODEVALUEID,
  @RUNSEGMENTATIONSEGMENTREFRESHPROCESS=@RUNSEGMENTATIONSEGMENTREFRESHPROCESS,
  @CACHESOURCEANALYSISRULEDATA=@CACHESOURCEANALYSISRULEDATA,
  @BUSINESSUNITS=@BUSINESSUNITS output,
  @OVERRIDEBUSINESSUNITS=@OVERRIDEBUSINESSUNITS output

 exec [dbo].[USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATION_5] 
   @ID
  ,@CURRENTAPPUSERID
  ,@CHANGEAGENTID
  ,@CODE
  ,@NAME
  ,@DESCRIPTION
  ,@SITEID
  ,@SOURCECODEID
  ,@ITEMLIST
  ,@MAILDATE
  ,@HOUSEHOLDINGTYPECODE
  ,@EXCLUSIONDATETYPECODE
  ,@EXCLUSIONASOFDATE
  ,@EXCLUDEDECEASED
  ,@EXCLUDEINACTIVE
  ,@EXCLUSIONS
  ,@USEADDRESSPROCESSING
  ,@ADDRESSPROCESSINGOPTIONID
  ,@NAMEFORMATPARAMETERID
  ,@ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE
  ,@ADDRESSPROCESSINGOPTIONSEASONALASOFDATE
  ,@ACTIVATIONKPIS
  ,@USEKPISASDEFAULT
  ,@APPEALINFORMATION
  ,@RUNACTIVATEANDEXPORT
  ,@EXPORTDESCRIPTION
  ,@MAILEXPORTDEFINITIONID
  ,@EMAILEXPORTDEFINITIONID
  ,@PHONEEXPORTDEFINITIONID
  ,@CODEVALUEID
  ,@RUNSEGMENTATIONSEGMENTREFRESHPROCESS
  ,@CACHESOURCEANALYSISRULEDATA
  ,@BUSINESSUNITS
  ,@OVERRIDEBUSINESSUNITS

end