V_QUERY_RE7GIVINGSUMMARY
Provides the ability to query RE7 Integration Giving Summary.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ID | |
| FIRSTGIFTAMOUNT | money | First gift amount | |
| FIRSTGIFTDATE | datetime | yes | First gift date |
| FIRSTGIFTTYPE | nvarchar(100) | First gift type | |
| FIRSTGIFTDESIGNATION | nvarchar(100) | First gift designation | |
| LARGESTGIFTAMOUNT | money | Largest gift amount | |
| LARGESTGIFTDATE | datetime | yes | Largest gift date |
| LARGESTGIFTTYPE | nvarchar(100) | Largest gift type | |
| LARGESTGIFTDESIGNATION | nvarchar(100) | Largest gift designation | |
| LATESTGIFTAMOUNT | money | Latest gift amount | |
| LATESTGIFTDATE | datetime | yes | Latest gift date |
| LATESTGIFTTYPE | nvarchar(100) | Latest gift type | |
| LATESTGIFTDESIGNATION | nvarchar(100) | Latest gift designation | |
| TOTALGIFTSGIVEN | int | Total number of gifts | |
| TOTALGIFTAMOUNT | money | Total giving | |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | Added by application |
| ADDEDBY_USERNAME | nvarchar(128) | yes | Added by user name |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | Changed by application |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | Changed by user name |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:21:43 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RE7GIVINGSUMMARY AS
select
GS.ID,
GS.FIRSTGIFTAMOUNT,
GS.FIRSTGIFTDATE,
GS.FIRSTGIFTTYPE,
GS.FIRSTGIFTDESIGNATION,
GS.LARGESTGIFTAMOUNT,
GS.LARGESTGIFTDATE,
GS.LARGESTGIFTTYPE,
GS.LARGESTGIFTDESIGNATION,
GS.LATESTGIFTAMOUNT,
GS.LATESTGIFTDATE,
GS.LATESTGIFTTYPE,
GS.LATESTGIFTDESIGNATION,
GS.TOTALGIFTSGIVEN,
GS.TOTALGIFTAMOUNT,
GS.DATEADDED,
GS.DATECHANGED,
GS.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME
from
dbo.RE7INTEGRATIONGIVINGSUMMARY GS
left join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = GS.ADDEDBYID
left join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = GS.CHANGEDBYID