USP_DATAFORMTEMPLATE_VIEW_SEGMENTATIONSEGMENTS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@ACTIVE	bit	INOUT
@ISACTIVATING	bit	INOUT
@MAILINGTYPECODE	tinyint	INOUT
@EVENTINSTANCEID	uniqueidentifier	INOUT
@GIFTSOURCESDEFINED	bit	INOUT
@ISCALCULATING	bit	INOUT
@HASAPPEAL	bit	INOUT
@HASASKLADDEROVERRIDES	bit	INOUT
@BASECURRENCYID	uniqueidentifier	INOUT
@ISHISTORICAL	bit	INOUT
@SEGMENTATIONSEGMENTCALCULATEPROCESSID	uniqueidentifier	INOUT
@LASTCALCULATEDATE	datetime	INOUT
@LASTTESTSEGMENTADDEDDATE	datetime	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_SEGMENTATIONSEGMENTS
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @ACTIVE bit = null output,
  @ISACTIVATING bit = null output,
  @MAILINGTYPECODE tinyint = null output,
  @EVENTINSTANCEID uniqueidentifier = null output,
  @GIFTSOURCESDEFINED bit = null output,
  @ISCALCULATING bit = null output,
  @HASAPPEAL bit = null output,
  @HASASKLADDEROVERRIDES bit = null output,
  @BASECURRENCYID uniqueidentifier = null output,
  @ISHISTORICAL bit = null output,
  @SEGMENTATIONSEGMENTCALCULATEPROCESSID uniqueidentifier = null output,
  @LASTCALCULATEDATE datetime = null output,
  @LASTTESTSEGMENTADDEDDATE datetime = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  select
    @DATALOADED = 1,
    @ACTIVE = [MKTSEGMENTATION].[ACTIVE],
    @ISACTIVATING = dbo.[UFN_MKTSEGMENTATION_ISACTIVATING]([MKTSEGMENTATION].[ID]),
    @MAILINGTYPECODE = [MKTSEGMENTATION].[MAILINGTYPECODE],
    @EVENTINSTANCEID = newid(),
    @GIFTSOURCESDEFINED = dbo.[UFN_MKTSEGMENTATION_GETREQUIREDFIELDSSET]([MKTSEGMENTATION].[ID]),
    @ISCALCULATING = dbo.[UFN_MKTSEGMENTATION_ISCALCULATING]([MKTSEGMENTATION].[ID]),
    @HASAPPEAL = (case when exists(select * from dbo.[MKTSEGMENTATIONACTIVATE] where [SEGMENTATIONID] = @ID) then 1 else 0 end),
    @HASASKLADDEROVERRIDES = (case when (select dbo.[UFN_MKTSEGMENTATIONASKLADDEROVERRIDE_GETITEMLIST_TOITEMLISTXML](@ID)) is not null then 1 else 0 end),
    @BASECURRENCYID = [MKTSEGMENTATION].[BASECURRENCYID],
    @ISHISTORICAL = [MKTSEGMENTATION].[ISHISTORICAL],
    @SEGMENTATIONSEGMENTCALCULATEPROCESSID = [EFFORTSTATUS].[CALCULATEPROCESSID],
    @LASTCALCULATEDATE = [EFFORTSTATUS].[CALCULATEDATE],
    @LASTTESTSEGMENTADDEDDATE = (select max([MKTSEGMENTATIONTESTSEGMENT].[DATEADDED])
                                from dbo.[MKTSEGMENTATIONSEGMENT] 
                                inner join dbo.[MKTSEGMENTATIONTESTSEGMENT] on [MKTSEGMENTATIONTESTSEGMENT].[SEGMENTID] = [MKTSEGMENTATIONSEGMENT].[ID]
                                where [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID] = [MKTSEGMENTATION].[ID])
  from dbo.[MKTSEGMENTATION]
  left join dbo.[UFN_MKTCOMMUNICATIONEFFORT_GETSTATUSINFO_BULK]() as [EFFORTSTATUS] on [EFFORTSTATUS].[SEGMENTATIONID] = [MKTSEGMENTATION].[ID]
  where [MKTSEGMENTATION].[ID] = @ID

  return 0;