V_QUERY_BBNCSIGNUPBATCHEXCEPTIONREPORT

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

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
CONSTITUENTNAME	nvarchar(154)	yes	Constituent name

Definition

Copy

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



                select 
                    BATCHBBNCSIGNUP.ID,
                    case when [LINKID] is null then [BBNCCONSTITNAME] else dbo.UFN_CONSTITUENT_BUILDNAME([LINKID]) end as CONSTITUENTNAME
                from 
                    dbo.BATCHBBNCSIGNUP