V_QUERY_INTERACTIONBATCHCONTROLREPORT

View used for output for Interaction Batch Control 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(12)	yes	Status
CONTACTMETHOD	nvarchar(100)	yes	Contact method
DATE	datetime	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_INTERACTIONBATCHCONTROLREPORT AS



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