V_QUERY_CONSTITUENTBATCHEXCEPTIONREPORT

View used for output for Constituent 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

Definition

Copy

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



            select 
                BATCHCONSTITUENT.ID,
                BATCHCONSTITUENT.ISORGANIZATION,
                dbo.UFN_NAMEFORMATFUNCTION_SIMPLE(BATCHCONSTITUENT.ID, BATCHCONSTITUENT.KEYNAME, BATCHCONSTITUENT.FIRSTNAME, BATCHCONSTITUENT.MIDDLENAME, (select DESCRIPTION from dbo.TITLECODE where ID = BATCHCONSTITUENT.TITLECODEID), (select DESCRIPTION from dbo.SUFFIXCODE where ID = BATCHCONSTITUENT.SUFFIXCODEID),'','','','','') as CONSTITUENTNAME,
                BATCHCONSTITUENT.ADDRESS_ADDRESSBLOCK as ADDRESSBLOCK,
                BATCHCONSTITUENT.ADDRESS_CITY as CITY,
                (select ABBREVIATION from dbo.STATE where STATE.ID = BATCHCONSTITUENT.ADDRESS_STATEID) as STATE
            from 
                dbo.BATCHCONSTITUENT