USP_DATAFORMTEMPLATE_ADD_CONTEXTLESSAPPEALMAILING

The save procedure used by the add dataform template "Contextless Appeal Mailing Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@APPEALID	uniqueidentifier	IN	Appeal
@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.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@MAILDATE	datetime	IN	Mail date
@FIXEDCOST	money	IN	Fixed cost
@MKTPACKAGEID	uniqueidentifier	IN	Package
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@HOUSEHOLDINGTYPECODE	tinyint	IN	Householding
@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
@LABELFILENAME	nvarchar(255)	IN	Label template
@LABELFILE	varbinary	IN	LABELFILE
@CREATEOUTPUTIDSET	bit	IN	Create selection from results
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing selection
@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
@SEGMENTATIONGENERATORID	uniqueidentifier	IN	Segmentation generator
@UNIVERSEIDSETREGISTERID	uniqueidentifier	IN	Selection
@SEGMENTATIONGENERATORPACKAGEID	uniqueidentifier	IN	Default package
@USEKPISASDEFAULT	bit	IN	Use the chosen KPIs as the default for future mailings
@ACTIVATIONKPIS	xml	IN	Activation KPIs
@MAILINGBUDGET	money	IN	Budget
@RECENCYEXCLUSIONDATEINTERVAL	int	IN
@RECENCYEXCLUSIONDESIGNATIONS	xml	IN
@RECENCYEXCLUSIONREVENUETYPECODES	xml	IN
@RECENCYEXCLUSIONINUSE	bit	IN	Giving in the past

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_CONTEXTLESSAPPEALMAILING]
(
  @ID uniqueidentifier = null output,
  @APPEALID uniqueidentifier = null,
  @CURRENTAPPUSERID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @NAME nvarchar(100),
  @DESCRIPTION nvarchar(255) = '',
  @MAILDATE datetime = null,
  @FIXEDCOST money = 0,
  @MKTPACKAGEID uniqueidentifier = null,
  @IDSETREGISTERID uniqueidentifier = null,
  @HOUSEHOLDINGTYPECODE tinyint = 0,
  @EXCLUSIONDATETYPECODE tinyint = 0,
  @EXCLUSIONASOFDATE datetime = null,
  @EXCLUDEDECEASED bit = 1,
  @EXCLUDEINACTIVE bit = 1,
  @EXCLUSIONS xml = null,
  @LABELFILENAME nvarchar(255) = '',
  @LABELFILE varbinary(max) = null,
  @CREATEOUTPUTIDSET bit = 0,
  @OUTPUTIDSETNAME nvarchar(100) = '',
  @OVERWRITEOUTPUTIDSET bit = 0,
  @USEADDRESSPROCESSING bit = 0,
  @ADDRESSPROCESSINGOPTIONID uniqueidentifier = null,
  @NAMEFORMATPARAMETERID uniqueidentifier = null,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE tinyint = 0,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE datetime = null,
  @SEGMENTATIONGENERATORID uniqueidentifier = null,
  @UNIVERSEIDSETREGISTERID uniqueidentifier = null,
  @SEGMENTATIONGENERATORPACKAGEID uniqueidentifier = null,
  @USEKPISASDEFAULT bit = null,
  @ACTIVATIONKPIS xml = null,
  @MAILINGBUDGET money = 0,
  @RECENCYEXCLUSIONDATEINTERVAL integer = 0,
  @RECENCYEXCLUSIONDESIGNATIONS xml = null,
  @RECENCYEXCLUSIONREVENUETYPECODES xml = null,
  @RECENCYEXCLUSIONINUSE bit = 0
)
as
begin
  set nocount on;

  begin try

    if @CHANGEAGENTID is null
      exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

    exec [dbo].[USP_DATAFORMTEMPLATE_ADD_APPEALMAILING] 
       @ID OUTPUT
      ,@APPEALID
      ,@CURRENTAPPUSERID
      ,@CHANGEAGENTID
      ,@NAME
      ,@DESCRIPTION
      ,@MAILDATE
      ,@FIXEDCOST
      ,@MKTPACKAGEID
      ,@IDSETREGISTERID
      ,@HOUSEHOLDINGTYPECODE
      ,@EXCLUSIONDATETYPECODE
      ,@EXCLUSIONASOFDATE
      ,@EXCLUDEDECEASED
      ,@EXCLUDEINACTIVE
      ,@EXCLUSIONS
      ,@LABELFILENAME
      ,@LABELFILE
      ,@CREATEOUTPUTIDSET
      ,@OUTPUTIDSETNAME
      ,@OVERWRITEOUTPUTIDSET
      ,@USEADDRESSPROCESSING
      ,@ADDRESSPROCESSINGOPTIONID
      ,@NAMEFORMATPARAMETERID
      ,@ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE
      ,@ADDRESSPROCESSINGOPTIONSEASONALASOFDATE
      ,@SEGMENTATIONGENERATORID
      ,@UNIVERSEIDSETREGISTERID
      ,@SEGMENTATIONGENERATORPACKAGEID
      ,@USEKPISASDEFAULT
      ,@ACTIVATIONKPIS
      ,@MAILINGBUDGET
      ,@RECENCYEXCLUSIONDATEINTERVAL 
      ,@RECENCYEXCLUSIONDESIGNATIONS
      ,@RECENCYEXCLUSIONREVENUETYPECODES
      ,@RECENCYEXCLUSIONINUSE;

  end try

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

  return 0;
end