V_SEARCH_TRIBUTE

Search for tributes.

Fields

Field	Field Type	Null
ID	uniqueidentifier
TRIBUTETEXT	nvarchar(255)
TYPE	nvarchar(100)
TRIBUTEE	nvarchar(154)	yes
SITENAME	nvarchar(250)	yes

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  9/1/2024 11:53:38 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3800.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_TRIBUTE AS



                select 
                    TRIBUTE.ID,
                    TRIBUTE.TRIBUTETEXT,
                    TRIBUTETYPECODE.DESCRIPTION as [TYPE], 
                    CONSTITUENT.NAME as TRIBUTEE,
                    SITE.NAME as SITENAME
                from dbo.TRIBUTE
                inner join dbo.TRIBUTETYPECODE on TRIBUTE.TRIBUTETYPECODEID = TRIBUTETYPECODE.ID
                left join dbo.CONSTITUENT on TRIBUTE.TRIBUTEEID = CONSTITUENT.ID
                left join dbo.TRIBUTESITE on TRIBUTESITE.TRIBUTEID = TRIBUTE.ID
                left join dbo.SITE on TRIBUTESITE.SITEID = SITE.ID;