V_QUERY_RE7_GIFTATTRIBUTE

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



select 
  [GA].[LOCALID],
  [ATC].[NAME] as [ATTRIBUTECATEGORY],
  [GA].[ATTRIBUTEDATE],
  case [ATC].[TYPEOFDATA]
    when 1 then isnull([GA].[TEXT], '')
    when 2 then isnull(cast([GA].[NUM] as nvarchar(255)), '')
    when 3 then isnull(cast([GA].[DATETIME] as nvarchar(255)), '')
    when 4 then isnull(cast([GA].[CURRENCY] as nvarchar(255)), '')
    when 5 then
    case [GA].[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([GA].[TEXT], '')
    else ''
  end as [ATTRIBUTEDESCRIPTION],
  [GA].[COMMENTS],
  [ATC].[MUSTBEUNIQUE],
  [ATC].[ISREQUIRED],
  [GA].[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],
  [GA].[REVENUE_LOCALID],
  [GA].[IMPORTID]
from dbo.[RE7_REVENUEATTRIBUTES] [GA]
left outer join dbo.[RE7_ATTRIBUTETYPECODE] [ATC] on [GA].[ATTRIBUTETYPECODE_LOCALID] = [ATC].[LOCALID]
left outer join dbo.[RE7_REVENUEATTRIBUTESTABLEENTRIESCODE] [TE] on [GA].[TABLEENTRIESCODE_LOCALID] = [TE].[LOCALID]
left outer join dbo.[RE7_CONSTITUENT] [C] on [GA].[ATTRIBUTECONSTITUENT_LOCALID] = [C].[LOCALID];