V_QUERY_EXCHANGEEMAILBATCHCONTROLREPORT

View used for output of the exchange email batch control report.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
CONSTITUENTNAME	nvarchar(154)	yes	Constituent name
KEYNAME	nvarchar(100)		Key name
FIRSTNAME	nvarchar(50)		First name
MIDDLENAME	nvarchar(50)		Middle name
INTERACTIONID	uniqueidentifier		INTERACTIONID
OBJECTIVE	nvarchar(100)		Subject
EXPECTEDDATE	varchar(30)	yes	Date
USERNAME	nvarchar(128)	yes	User

Definition

Copy

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



                select distinct
                    CONSTITUENT.ID,
                    dbo.UFN_CONSTITUENT_BUILDNAME(CONSTITUENT.ID) as CONSTITUENTNAME,
                    CONSTITUENT.KEYNAME,
                    CONSTITUENT.FIRSTNAME,
                    CONSTITUENT.MIDDLENAME,                                   
                    INTERACTION.ID as INTERACTIONID,
                    INTERACTION.OBJECTIVE, 
                    convert(varchar, INTERACTION.EXPECTEDDATE, 101) as EXPECTEDDATE,
                    COALESCE(APPUSER.USERNAME, '') as USERNAME
                from
                    dbo.CONSTITUENT inner join dbo.INTERACTION on CONSTITUENT.ID = INTERACTION.CONSTITUENTID
                        left outer join dbo.APPUSER on INTERACTION.FUNDRAISERID = APPUSER.CONSTITUENTID