V_QUERY_RE7_EVENTREGISTRANTATTRIBUTES

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



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