V_QUERY_PEOPLEFINDERBATCHEXCEPTIONREPORT
View used for output for PeopleFinder batch exception report.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| NAME | nvarchar(154) | yes | Name |
| NEWADDRESSBLOCK | nvarchar(150) | New address | |
| NEWCITY | nvarchar(50) | New city | |
| ABBREVIATION | nvarchar(50) | New state | |
| NEWPOSTCODE | nvarchar(12) | New zip | |
| NEWPHONENUMBER | nvarchar(100) | New phone | |
| OTHERLASTNAME | nvarchar(100) | New last name | |
| ISDECEASED | varchar(3) | Deceased | |
| DECEASEDYEAR | varchar(4) | yes | Deceased year |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:35:59 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_PEOPLEFINDERBATCHEXCEPTIONREPORT AS
select
BATCH.ID,
CONSTITUENT.NAME,
BATCH.NEWADDRESSBLOCK,
BATCH.NEWCITY,
STATE.ABBREVIATION,
BATCH.NEWPOSTCODE,
BATCH.NEWPHONENUMBER,
BATCH.OTHERLASTNAME,
case ISDECEASED when 1 then 'Yes'
else 'No'
end as ISDECEASED,
BATCH.DECEASEDYEARDISPLAY as DECEASEDYEAR
from
dbo.BATCHPEOPLEFINDER BATCH
left join
dbo.CONSTITUENT on CONSTITUENT.ID = BATCH.CONSTITUENTID
inner join
dbo.STATE on STATE.ID = BATCH.NEWSTATEID
left join
dbo.DECEASEDCONSTITUENT on DECEASEDCONSTITUENT.ID = CONSTITUENT.ID