V_QUERY_EMAILFINDERBATCHEXCEPTIONREPORT

View used for output for EmailFinder batch exception report.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
NAME	nvarchar(154)	yes	Name
EMAILADDRESS	UDT_EMAILADDRESS		Email
OPTOUT	bit		Opt out

Definition

Copy

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



                select
                    BATCH.ID,
                    CONSTITUENT.NAME,
                    BATCH.EMAILADDRESS,
                    BATCH.OPTOUT
                from 
                    dbo.BATCHEMAILFINDER BATCH
                left join 
                    dbo.CONSTITUENT on CONSTITUENT.ID = BATCH.CONSTITUENTID