V_QUERY_COAUPDATEBATCHEXCEPTIONREPORT
View used for output for AddressFinder batch exception report.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| NAME | nvarchar(154) | yes | Name |
| SUBMITTEDADDRESS | nvarchar(300) | yes | Submitted address |
| STDADDRESS | nvarchar(300) | yes | Standardized address |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:39:22 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_COAUPDATEBATCHEXCEPTIONREPORT AS
select BATCH.ID,
CONSTITUENT.NAME as NAME,
dbo.UFN_BUILDFULLADDRESS(null, BATCH.ADDRESSBLOCK, BATCH.CITY, BATCH.STATEID, BATCH.POSTCODE, (select ID from dbo.COUNTRY where USEFORCOAUPDATE = 1)) as SUBMITTEDADDRESS,
dbo.UFN_BUILDFULLADDRESS(null, BATCH.STDADDRESSBLOCK, BATCH.STDCITY, BATCH.STDSTATEID, BATCH.STDPOSTCODE, (select ID from dbo.COUNTRY where USEFORCOAUPDATE = 1)) as STDADDRESS
from dbo.BATCHCOAUPDATE BATCH
left join dbo.CONSTITUENT on CONSTITUENT.ID = BATCH.CONSTITUENTID