V_SEARCHLIST_ORGANIZATION

This search is used for finding organizations.

Fields

Field	Field Type	Null
ID	uniqueidentifier
NAME	nvarchar(154)	yes
ADDRESS	nvarchar(150)	yes
CITY	nvarchar(50)	yes
STATE	nvarchar(100)	yes
POSTCODE	nvarchar(12)	yes
LOOKUPID	nvarchar(100)	yes

Definition

Copy

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



        select CONSTITUENT.ID, 
          [NAME], 
          [ADDRESS].ADDRESSBLOCK [ADDRESS],
          [ADDRESS].CITY,
          [STATE].DESCRIPTION [STATE],
          [ADDRESS].POSTCODE,
          CONSTITUENT.LOOKUPID
        from dbo.CONSTITUENT
        left join dbo.[ADDRESS] on CONSTITUENT.ID = [ADDRESS].CONSTITUENTID
        left join dbo.[STATE] on [ADDRESS].STATEID = [STATE].ID
          where CONSTITUENT.ISCONSTITUENT = 1 and CONSTITUENT.ISORGANIZATION = 1;