V_SEARCHLIST_TRIBUTEEACKNOWLEDGEE
A search list of tributee/acknowledgee
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| NAME | nvarchar(154) | yes | |
| FIRSTNAME | nvarchar(50) | ||
| KEYNAME | nvarchar(100) | ||
| ADDRESSBLOCK | nvarchar(150) | yes | |
| CITY | nvarchar(50) | yes | |
| STATEID | uniqueidentifier | yes | |
| STATE | nvarchar(100) | yes | |
| POSTCODE | nvarchar(12) | yes | |
| LOOKUPID | nvarchar(100) | yes | |
| EMAILADDRESS | UDT_EMAILADDRESS | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:24:28 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCHLIST_TRIBUTEEACKNOWLEDGEE AS
select CONSTITUENT.ID, [NAME],
[FIRSTNAME], [KEYNAME],
[ADDRESS].ADDRESSBLOCK [ADDRESSBLOCK],
[ADDRESS].CITY,
[STATE].ID [STATEID],
[STATE].DESCRIPTION [STATE],
[ADDRESS].POSTCODE,
CONSTITUENT.LOOKUPID,
[EMAILADDRESS].EMAILADDRESS
from dbo.CONSTITUENT
left join dbo.[ADDRESS] on CONSTITUENT.ID = [ADDRESS].CONSTITUENTID
left join dbo.[STATE] on [ADDRESS].STATEID = [STATE].ID
left join dbo.[EMAILADDRESS] on CONSTITUENT.ID = [EMAILADDRESS].CONSTITUENTID
where (CONSTITUENT.ISCONSTITUENT = 1)
and (CONSTITUENT.ISORGANIZATION = 0)
and ([EMAILADDRESS].ISPRIMARY = 1 or [EMAILADDRESS].ISPRIMARY is null)
and ([ADDRESS].ISPRIMARY = 1);