V_QUERY_EXCHANGECALENDARITEMBATCHEXCEPTIONREPORT

View used for output of the Exchange calendar item batch exception 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

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_EXCHANGECALENDARITEMBATCHEXCEPTIONREPORT AS



                select distinct
                    EXCHANGECALENDARITEMBATCH.ID,
                    dbo.UFN_CONSTITUENT_BUILDNAME(CONSTITUENT.ID) as CONSTITUENTNAME,
                    CONSTITUENT.KEYNAME,
                    CONSTITUENT.FIRSTNAME,
                    CONSTITUENT.MIDDLENAME                         
                from
                    dbo.EXCHANGECALENDARITEMBATCH
                    inner join dbo.CONSTITUENT on CONSTITUENT.ID = EXCHANGECALENDARITEMBATCH.CONSTITUENTID