V_QUERY_ADDRESSVALIDATIONBATCHCONTROLREPORT
View used for output for the address validation batch control report.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| NAME | nvarchar(154) | yes | Name |
| ADDRESS | nvarchar(300) | yes | Address |
| VALIDATIONMESSAGE | nvarchar(200) | yes | Validation message |
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_ADDRESSVALIDATIONBATCHCONTROLREPORT AS
select ADDRESS.ID as ID,
CONSTITUENT.NAME as NAME,
dbo.UFN_BUILDFULLADDRESS(ADDRESS.ID, ADDRESS.ADDRESSBLOCK, ADDRESS.CITY, ADDRESS.STATEID, ADDRESS.POSTCODE, ADDRESS.COUNTRYID) as ADDRESS,
ADDRESSVALIDATIONUPDATE.VALIDATIONMESSAGE as VALIDATIONMESSAGE
from dbo.ADDRESS
left join dbo.ADDRESSVALIDATIONUPDATE on ADDRESS.ID = ADDRESSVALIDATIONUPDATE.ID
left join dbo.CONSTITUENT on CONSTITUENT.ID = ADDRESS.CONSTITUENTID