V_QUERY_INTERACTIONBATCHEXCEPTIONREPORT

View used for output for Interaction Batch Exception Report.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
CONSTITUENTNAME	nvarchar(154)	yes	Constituent name
OWNERNAME	nvarchar(154)	yes	Owner
OBJECTIVE	nvarchar(100)		Summary
STATUS	nvarchar(9)	yes	Status
CONTACTMETHOD	nvarchar(100)	yes	Contact method
DATE	date	yes	Date

Definition

Copy

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



                select
                    BATCHINTERACTION.ID,
                    dbo.UFN_CONSTITUENT_BUILDNAME(BATCHINTERACTION.CONSTITUENTID) as CONSTITUENTNAME,
                    dbo.UFN_CONSTITUENT_BUILDNAME(BATCHINTERACTION.FUNDRAISERID) as OWNERNAME,
                    BATCHINTERACTION.OBJECTIVE,
                    BATCHINTERACTION.STATUS,
                    dbo.UFN_INTERACTIONTYPECODE_GETDESCRIPTION(BATCHINTERACTION.INTERACTIONTYPECODEID) as CONTACTMETHOD,
                    coalesce(BATCHINTERACTION.ACTUALDATE, BATCHINTERACTION.EXPECTEDDATE) as DATE
                from 
                    dbo.BATCHINTERACTION