V_QUERY_CONSTITUENTADDRESSUPDATEBATCHEXCEPTIONREPORT

View used for output for Constituent Address Update Batch Exception Report.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
ISORGANIZATION	bit		Is organization
CONSTITUENTNAME	nvarchar(700)	yes	Constituent name
ADDRESSBLOCK	nvarchar(150)		Address
CITY	nvarchar(50)		City
STATE	nvarchar(50)	yes	State
ISGROUP	bit		Is group

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:35:29 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_CONSTITUENTADDRESSUPDATEBATCHEXCEPTIONREPORT AS



            select 
                BATCHCONSTITUENTADDRESSUPDATE.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,
                BATCHCONSTITUENTADDRESSUPDATE.ADDRESSBLOCK,
                BATCHCONSTITUENTADDRESSUPDATE.CITY,
                (select ABBREVIATION from dbo.STATE where STATE.ID = BATCHCONSTITUENTADDRESSUPDATE.STATEID) as STATE,
                CONSTITUENT.ISGROUP
            from 
                dbo.BATCHCONSTITUENTADDRESSUPDATE
            inner join
                dbo.ADDRESS
            on
                ADDRESS.ID = BATCHCONSTITUENTADDRESSUPDATE.ADDRESSID
            inner join
                dbo.CONSTITUENT
            on
                CONSTITUENT.ID = ADDRESS.CONSTITUENTID