V_SIMPLEDATALIST_MKTCOMMUNICATIONTEMPLATEKPI

/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:25:57 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SIMPLEDATALIST_MKTCOMMUNICATIONTEMPLATEKPI AS



  select
    [KPICATALOG].[ID] as [VALUE],
    case when [KPICATALOG].[NAME] like '% for Marketing Effort'
         then left([KPICATALOG].[NAME], len([KPICATALOG].[NAME]) - len(' for Marketing Effort'))
         when [KPICATALOG].[NAME] like '% for Membership Renewal Effort'
         then left([KPICATALOG].[NAME], len([KPICATALOG].[NAME]) - len(' for Membership Renewal Effort'))
         else [KPICATALOG].[NAME] 
    end as [LABEL]
  from dbo.[KPICATALOG]
  where [KPICATALOG].[CONTEXTRECORDTYPEID] = dbo.[UFN_RECORDTYPE_GETIDBYNAME]('Marketing Effort');