V_SEARCHLIST_CONSTITUENTNONVOLUNTEER

This search is for finding constituents who are not members of the volunteer.

Fields

Field	Field Type	Null
ID	uniqueidentifier
LOOKUPID	nvarchar(100)	yes
NAME	nvarchar(154)	yes
FIRSTNAME	nvarchar(50)
MIDDLENAME	nvarchar(50)
NICKNAME	nvarchar(50)
KEYNAME	nvarchar(100)
ISORGANIZATION	bit

Definition

Copy

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



                select ID, 
                    LOOKUPID, 
                    [NAME], 
                    FIRSTNAME, 
                    MIDDLENAME, 
                    NICKNAME, 
                    KEYNAME, 
                    ISORGANIZATION 
                from dbo.CONSTITUENT;