V_QUERY_RE7_CAMPAIGNATTRIBUTE

/*
Generated by Blackbaud AppFx Platform
Date:  2/6/2025 8:50:22 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RE7_CAMPAIGNATTRIBUTE AS



select 
  [CA].[LOCALID],
  [ATC].[NAME] as [ATTRIBUTECATEGORY],
  [CA].[ATTRIBUTEDATE],
  case [ATC].[TYPEOFDATA]
    when 1 then isnull([CA].[TEXT], '')
    when 2 then isnull(cast([CA].[NUM] as nvarchar(255)), '')
    when 3 then isnull(cast([CA].[DATETIME] as nvarchar(255)), '')
    when 4 then isnull(cast([CA].[CURRENCY] as nvarchar(255)), '')
    when 5 then
    case [CA].[BOOLEAN]
      when 0 then 'No'
      when 1 then 'Yes'
      else ''
    end
    when 6 then isnull([TE].[DESCRIPTION], '')
    when 7 then isnull([C].[FULLNAME], '')
    when 8 then isnull([CA].[TEXT], '')
    else ''
  end as [ATTRIBUTEDESCRIPTION],
  [CA].[COMMENTS],
  [ATC].[MUSTBEUNIQUE],
  [ATC].[ISREQUIRED],
  [CA].[SEQUENCE],
  case [ATC].[TYPEOFDATA]
    when 1 then 'Text'
    when 2 then 'Numeric'
    when 3 then 'Date'
    when 4 then 'Currency'
    when 5 then 'Yes/No'
    when 6 then 'Table'
    when 7 then 'Constituent'
    when 8 then 'Fuzzy Date'
    else 'Unknown'
  end as [TYPEOFDATA],
  [CA].[CAMPAIGN_LOCALID],
  [CA].[IMPORTID]
from dbo.[RE7_CAMPAIGNATTRIBUTES] [CA]
left outer join dbo.[RE7_ATTRIBUTETYPECODE] [ATC] on [CA].[ATTRIBUTETYPECODE_LOCALID] = [ATC].[LOCALID]
left outer join dbo.[RE7_CAMPAIGNATTRIBUTESTABLEENTRIESCODE] [TE] on [CA].[TABLEENTRIESCODE_LOCALID] = [TE].[LOCALID]
left outer join dbo.[RE7_CONSTITUENT] [C] on [CA].[ATTRIBUTECONSTITUENT_LOCALID] = [C].[LOCALID];