USP_DATAFORMTEMPLATE_ADD_MKTSPONSORSHIPMAILINGSEGMENT

The save procedure used by the add dataform template "Sponsorship Effort Segment Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SEGMENTATIONIDMARKETINGPLANBRIEFIDSEQUENCE	nvarchar(100)	IN	Input parameter indicating the context ID for the record being added.
@MARKETINGPLANBRIEFID	uniqueidentifier	IN	Marketing plan brief ID
@SEGMENTID	uniqueidentifier	IN	Segment
@CODE	nvarchar(10)	IN	Code
@TESTSEGMENTCODE	nvarchar(10)	IN	Test segment code
@PACKAGEID	uniqueidentifier	IN	Package
@PACKAGECODE	nvarchar(10)	IN	Package code
@RESPONSERATE	decimal(5, 2)	IN	Response rate
@GIFTAMOUNT	money	IN	Gift amount
@SAMPLESIZE	int	IN	Sample size
@SAMPLESIZETYPECODE	tinyint	IN	Sample size type
@SAMPLESIZEMETHODCODE	tinyint	IN	Sample size method
@SEQUENCE	int	IN	Sequence
@ASKLADDERID	uniqueidentifier	IN	Ask ladder
@SAMPLESIZEEXCLUDEREMAINDER	bit	IN	Exclude remaining records from the marketing effort
@OVERRIDEADDRESSPROCESSING	bit	IN	Override address processing / name format rules
@USEADDRESSPROCESSING	bit	IN	Use address processing?
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	IN	Address processing options
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE	tinyint	IN	Consider seasonal addresses as of
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATE	datetime	IN	Consider seasonal addresses as of
@NAMEFORMATPARAMETERID	uniqueidentifier	IN	Name format options
@CODEVALUEID	uniqueidentifier	IN	Code value ID
@TESTSEGMENTCODEVALUEID	uniqueidentifier	IN	Test segment code value ID
@PACKAGECODEVALUEID	uniqueidentifier	IN	Package code value ID
@ITEMLIST	xml	IN	Items
@CHANNELSOURCECODE	nvarchar(10)	IN	Channel source code
@CHANNELSOURCECODEVALUEID	uniqueidentifier	IN	Channel code value ID
@EXCLUDESPOUSE	bit	IN	Exclude spouse (wording)
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@EXCLUDE	bit	IN	Exclude from effort but show counts

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTSPONSORSHIPMAILINGSEGMENT]
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,    
  @SEGMENTATIONIDMARKETINGPLANBRIEFIDSEQUENCE nvarchar(100),
  @MARKETINGPLANBRIEFID uniqueidentifier = null,
  @SEGMENTID uniqueidentifier,
  @CODE nvarchar(10) = '',
  @TESTSEGMENTCODE nvarchar(10) = '',
  @PACKAGEID uniqueidentifier = null,
  @PACKAGECODE nvarchar(10) = '',
  @RESPONSERATE decimal(5,2) = 5,
  @GIFTAMOUNT money,
  @SAMPLESIZE int = 100,
  @SAMPLESIZETYPECODE tinyint = 0,
  @SAMPLESIZEMETHODCODE tinyint = 0,
  @SEQUENCE int,
  @ASKLADDERID uniqueidentifier = null,
  @SAMPLESIZEEXCLUDEREMAINDER bit = 1,
  @OVERRIDEADDRESSPROCESSING bit = 0,
  @USEADDRESSPROCESSING bit = 0,
  @ADDRESSPROCESSINGOPTIONID uniqueidentifier = null,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE tinyint = 0,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE datetime = null,
  @NAMEFORMATPARAMETERID uniqueidentifier = null,
  @CODEVALUEID uniqueidentifier = null,
  @TESTSEGMENTCODEVALUEID uniqueidentifier = null,
  @PACKAGECODEVALUEID uniqueidentifier = null,
  @ITEMLIST xml = null,
  @CHANNELSOURCECODE nvarchar(10) = '',
  @CHANNELSOURCECODEVALUEID uniqueidentifier = null,
  @EXCLUDESPOUSE bit = 0,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @EXCLUDE bit = 0
)
as
  set nocount on;

  begin try
    exec dbo.[USP_DATAFORMTEMPLATE_ADD_MKTSEGMENTATIONSEGMENT]
      @ID output,
      @CHANGEAGENTID,    
      @SEGMENTATIONIDMARKETINGPLANBRIEFIDSEQUENCE,
      @MARKETINGPLANBRIEFID,
      @SEGMENTID,
      @CODE,
      @TESTSEGMENTCODE,
      @PACKAGEID,
      @PACKAGECODE,
      @RESPONSERATE,
      @GIFTAMOUNT,
      @SAMPLESIZE,
      @SAMPLESIZETYPECODE,
      @SAMPLESIZEMETHODCODE,
      @SEQUENCE,
      @ASKLADDERID,
      @SAMPLESIZEEXCLUDEREMAINDER,
      @OVERRIDEADDRESSPROCESSING,
      @USEADDRESSPROCESSING,
      @ADDRESSPROCESSINGOPTIONID,
      @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE,
      @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE,
      @NAMEFORMATPARAMETERID,
      @CODEVALUEID,
      @TESTSEGMENTCODEVALUEID,
      @PACKAGECODEVALUEID,
      @ITEMLIST,
      @CHANNELSOURCECODE,
      @CHANNELSOURCECODEVALUEID,
      0,-- Exclude spouse bit

      0,
      null,
      @CURRENTAPPUSERID,
      @EXCLUDE;
  end try

  begin catch
    exec dbo.[USP_RAISE_ERROR];
    return 1;
  end catch

  return 0;