USP_DATAFORMTEMPLATE_VIEW_APPEALPAGEEXPRESSION

The load procedure used by the view dataform template "Appeal Page Expression View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(100)	INOUT	NAME
@ISACTIVE	bit	INOUT	ISACTIVE
@EVENTID	uniqueidentifier	INOUT	EVENTID
@EVENTNAME	nvarchar(100)	INOUT	EVENTNAME
@HASEVENT	bit	INOUT	HASEVENT
@HASGLMAPPING	bit	INOUT	HASGLMAPPING
@HASAPPEALMAILINGS	bit	INOUT	HASAPPEALMAILINGS
@HASMARKETINGEFFORTS	bit	INOUT	HASMARKETINGEFFORTS
@HASEVENTAPPEAL	bit	INOUT	HASEVENTAPPEAL
@HASAPPEALREVENUEKPIS	bit	INOUT	HASAPPEALREVENUEKPIS
@ISBBFR8ADEPLOYED	bit	INOUT	ISBBFR8ADEPLOYED
@ISBBDWDEPLOYED	bit	INOUT	ISBBDWDEPLOYED
@HASCOMMUNICATIONTEMPLATES	bit	INOUT
@ATTRIBUTEDEFINED	bit	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



      CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_APPEALPAGEEXPRESSION
        (
        @ID uniqueidentifier,
        @DATALOADED bit = 0 output,
        @NAME nvarchar(100)= null output,
        @ISACTIVE bit = null output,
        @EVENTID uniqueidentifier = null output,
        @EVENTNAME nvarchar(100) = null output,
        @HASEVENT bit = null output,
        @HASGLMAPPING bit = null output,
        @HASAPPEALMAILINGS bit = null output,
        @HASMARKETINGEFFORTS bit = null output,
        @HASEVENTAPPEAL bit = null output,
        @HASAPPEALREVENUEKPIS bit = null output,
        @ISBBFR8ADEPLOYED bit = null output,
        @ISBBDWDEPLOYED bit = null output,
        @HASCOMMUNICATIONTEMPLATES bit = null output,
        @ATTRIBUTEDEFINED bit = null output,
        @CURRENTAPPUSERID uniqueidentifier = null
        )
      as
      begin
        set nocount on;

        set @DATALOADED = 0;

        select top (1)
          @DATALOADED = 1,
          @NAME = APPEAL.NAME,
          @ISACTIVE = APPEAL.ISACTIVE,
          @EVENTID = EVENT.ID,
          @EVENTNAME = EVENT.NAME,
          @HASEVENT = case when EVENT.ID is null then 0 else 1 end
        from 
          dbo.APPEAL
          left join dbo.EVENT on EVENT.APPEALID = APPEAL.ID
        where
          APPEAL.ID = @ID
        order by
          EVENT.DATEADDED;

        --if exists(select ID from PDACCOUNTSTRUCTURE where PDACCOUNTTABLESAVAILABLEFORSEGMENTID = '428D6D21-4482-44E5-A293-6AB5BA085662')

          --set @HASGLMAPPING = 1


        if (select count(ID) from dbo.PDACCOUNTSTRUCTURE where PDACCOUNTTABLESAVAILABLEFORSEGMENTID = '428D6D21-4482-44E5-A293-6AB5BA085662') = 1 
          set @HASGLMAPPING = 1

        if exists(select APPEALMAILING.ID from APPEAL inner join APPEALMAILING on APPEAL.ID = APPEALMAILING.APPEALID
where APPEALMAILING.APPEALID = @ID)
          set @HASAPPEALMAILINGS = 1

        if exists(select 1 from dbo.[MKTSEGMENTATIONACTIVATE] where [APPEALSYSTEMID] = cast(@ID as nvarchar(36)))
          set @HASMARKETINGEFFORTS = 1;

        if exists (select 1 from dbo.EVENTAPPEAL where EVENTAPPEAL.APPEALID = @ID)
        set @HASEVENTAPPEAL = 1;

        with XMLNAMESPACES ('bb_appfx_dataforms' as DFI)
        select @HASAPPEALREVENUEKPIS = 1
          from 
            dbo.KPIINSTANCE 
          where 
            KPIINSTANCE.KPICATALOGID = '1FFA6EF5-A1EA-4257-B7ED-C3A24CF9BEBE'
          and
            KPIINSTANCE.PARAMETERSXML.value('data(/DFI:DataFormItem/DFI:Values/DFI:fv[@ID="APPEALID"]/DFI:Value)[1]','varchar(36)') = cast(@ID as varchar(36))

        if exists (select 1 from dbo.[OLAPDATASOURCE] where [ID] = '7B704DFA-64D8-4FE2-BBD4-196A499C61AC')
          set @ISBBFR8ADEPLOYED = 1;
        else
          set @ISBBFR8ADEPLOYED = 0;

        if exists (select 1 from dbo.[OLAPDATASOURCE] where [ID] = '75A36279-8531-4A5F-AFD6-483FE5D26037')
          set @ISBBDWDEPLOYED = 1;
        else
          set @ISBBDWDEPLOYED = 0;

        if exists(select 1 from dbo.[MKTCOMMUNICATIONTEMPLATEDEFAULTAPPEAL] where [APPEALSYSTEMID] = cast(@ID as nvarchar(36)))
          set @HASCOMMUNICATIONTEMPLATES = 1;

        set @ATTRIBUTEDEFINED = dbo.UFN_ATTRIBUTECATEGORY_DEFINEDFORRECORDTYPE_FORAPPUSER('APPEAL', @CURRENTAPPUSERID);

        return 0;
      end