V_QUERY_RE7_CONSTITUENTEDUCATIONATTRIBUTE

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



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