V_QUERY_CONSTITUENTADDRESSUPDATEBATCHCONTROLREPORT
View used for output for Constituent Address Update Batch Control Report.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| ISORGANIZATION | bit | yes | Is organization |
| CONSTITUENTNAME | nvarchar(700) | yes | Constituent name |
| ADDRESSBLOCK | nvarchar(150) | Address | |
| CITY | nvarchar(50) | City | |
| STATE | nvarchar(50) | yes | State |
| ISGROUP | bit | yes | Is group |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:14:44 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_CONSTITUENTADDRESSUPDATEBATCHCONTROLREPORT AS
select
ADDRESS.ID,
CONSTITUENT.ISORGANIZATION,
dbo.UFN_NAMEFORMATFUNCTION_SIMPLE(CONSTITUENT.ID, CONSTITUENT.KEYNAME, CONSTITUENT.FIRSTNAME, CONSTITUENT.MIDDLENAME, (select DESCRIPTION from dbo.TITLECODE where ID = CONSTITUENT.TITLECODEID), (select DESCRIPTION from dbo.SUFFIXCODE where ID = CONSTITUENT.SUFFIXCODEID),'','','','','') as CONSTITUENTNAME,
ADDRESS.ADDRESSBLOCK,
ADDRESS.CITY,
STATE.ABBREVIATION as STATE,
CONSTITUENT.ISGROUP
from
dbo.ADDRESS
left join dbo.CONSTITUENT on CONSTITUENT.ID = ADDRESS.CONSTITUENTID
left join dbo.STATE on ADDRESS.STATEID = STATE.ID