V_QUERY_GIVINGSUMMARYUPDATEBATCHEXCEPTIONREPORT

View used for output for Giving Summary Update Batch Exception Report.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
CONSTITUENTNAME	nvarchar(700)	yes	Constituent name
LOOKUPID	nvarchar(100)		Lookup ID
TOTALGIFTSGIVEN	int		Total number of gifts
TOTALGIFTAMOUNT	money		Total giving

Definition

Copy

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



                select
                    BGS.ID,
                    coalesce(nullif(dbo.UFN_NAMEFORMATFUNCTION_SIMPLE(C.ID, C.KEYNAME, C.FIRSTNAME, C.MIDDLENAME, (select DESCRIPTION from dbo.TITLECODE where ID = C.TITLECODEID), (select DESCRIPTION from dbo.SUFFIXCODE where ID = C.SUFFIXCODEID),'','','','',''), ''), BGS.FIRSTNAME + ' ' + BGS.KEYNAME) as CONSTITUENTNAME,
                    BGS.LOOKUP_ID as LOOKUPID,
                    BGS.TOTALGIFTSGIVEN,
                    BGS.TOTALGIFTAMOUNT
                from 
                    dbo.BATCHGIVINGSUMMARYUPDATE BGS
                    left join dbo.RE7INTEGRATIONGIVINGSUMMARY GS on GS.ID = BGS.PRIMARYRECORDID
                    left join dbo.CONSTITUENT C on C.ID = BGS.PRIMARYRECORDID