V_QUERY_ADDRESSVALIDATIONBATCHEXCEPTIONREPORT
View used for output for address validation batch exception report.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| NAME | nvarchar(154) | yes | Name |
| ORIGINALADDRESS | nvarchar(300) | yes | Original address |
| VALIDATEDADDRESS | nvarchar(300) | yes | Validated 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_ADDRESSVALIDATIONBATCHEXCEPTIONREPORT AS
select BATCH.ID,
CONSTITUENT.NAME as NAME,
dbo.UFN_BUILDFULLADDRESS(ADDRESS.ID, ADDRESS.ADDRESSBLOCK, ADDRESS.CITY, ADDRESS.STATEID, ADDRESS.POSTCODE, ADDRESS.COUNTRYID) as ORIGINALADDRESS,
dbo.UFN_BUILDFULLADDRESS(null, BATCH.NEWADDRESSBLOCK, BATCH.NEWCITY, BATCH.NEWSTATEID, BATCH.NEWPOSTCODE, ADDRESS.COUNTRYID) as VALIDATEDADDRESS
from dbo.BATCHADDRESSVALIDATION BATCH
left join dbo.ADDRESS on ADDRESS.ID = BATCH.ADDRESSID
left join dbo.CONSTITUENT on CONSTITUENT.ID = BATCH.CONSTITUENTID