V_QUERY_PEOPLEFINDERBATCHCONTROLREPORT
View used for output for the PeopleFinder batch control report.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| NAME | nvarchar(154) | yes | Name |
| ID | uniqueidentifier | System record ID | |
| ADDRESSBLOCK | nvarchar(150) | Address block | |
| CITY | nvarchar(50) | City | |
| POSTCODE | nvarchar(12) | Zip | |
| ABBREVIATION | nvarchar(50) | State | |
| DECEASED | varchar(3) | Deceased |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 4/29/2010 7:37:36 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.6.1444.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_PEOPLEFINDERBATCHCONTROLREPORT AS
select
CONSTITUENT.NAME,
ADDRESS.ID,
ADDRESS.ADDRESSBLOCK,
ADDRESS.CITY,
ADDRESS.POSTCODE,
STATE.ABBREVIATION,
case when DECEASEDDATE is null then 'No'
else 'Yes'
end as DECEASED
from
dbo.CONSTITUENT
inner join
dbo.ADDRESS on ADDRESS.CONSTITUENTID = CONSTITUENT.ID
inner join
dbo.STATE on STATE.ID = ADDRESS.STATEID
left join
dbo.DECEASEDCONSTITUENT on DECEASEDCONSTITUENT.ID = CONSTITUENT.ID