V_QUERY_BBNCEVENTREGISTRATIONBATCHEXCEPTIONREPORT

View used for output by the Blackbaud Internet Solutions Event Registration Batch Exception Report.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
DONORNAME	nvarchar(154)	yes	Donor name

Definition

Copy

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



                select 
                    BATCHBBNCEVENTREGISTRATION.ID,
                    case when [DONORID] is null then [BBNCDONORNAME] else dbo.UFN_CONSTITUENT_BUILDNAME([DONORID]) end as [DONORNAME]
                from 
                    dbo.BATCHBBNCEVENTREGISTRATION