V_QUERY_GIVINGSUMMARYUPDATEBATCHCONTROLREPORT

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

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
CONSTITUENTNAME	nvarchar(700)	yes	Constituent name
LOOKUPID	nvarchar(100)	yes	Lookup ID
TOTALGIFTSGIVEN	int	yes	Total number of gifts
TOTALGIFTAMOUNT	money	yes	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_GIVINGSUMMARYUPDATEBATCHCONTROLREPORT AS



                select
                    C.ID,
                    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),'','','','','') as CONSTITUENTNAME,
                    C.LOOKUPID,
                    GS.TOTALGIFTSGIVEN,
                    GS.TOTALGIFTAMOUNT
                from 
                    dbo.CONSTITUENT C
                    left join dbo.RE7INTEGRATIONGIVINGSUMMARY GS on GS.ID = C.ID