V_QUERY_RE7_UNRESTRICTEDGIVINGSUMMARY
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENT_LOCALID | int | ||
| TOTALAMOUNT | money | yes | |
| AVGAMOUNT | money | yes | |
| MAXSPLITAMOUNT | money | yes | |
| MINSPLITAMOUNT | money | yes | |
| MAXGIFTAMOUNT | money | yes | |
| MINGIFTAMOUNT | money | yes | |
| GIFTSPLITCOUNT | int | yes | |
| GIFTCOUNT | int | yes | |
| FIRSTGIFTDATE | datetime | yes | |
| YEARSSINCEFIRSTGIVEN | int | ||
| MONTHSSINCEFIRSTGIVEN | int | ||
| DAYSSINCEFIRSTGIVEN | int | ||
| LASTGIFTDATE | datetime | yes | |
| YEARSSINCELASTGIVEN | int | ||
| MONTHSSINCELASTGIVEN | int | ||
| DAYSSINCELASTGIVEN | int | ||
| GIVINGYEARS | int | yes | |
| DISTINCTCALENDARYEARS | int | yes | |
| DISTINCTFISCALYEARS | int | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 6/23/2025 4:35:31 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.4000.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RE7_UNRESTRICTEDGIVINGSUMMARY AS
select
[CONSTITUENT_LOCALID],
[TOTALAMOUNT],
[AVGAMOUNT],
[MAXSPLITAMOUNT],
[MINSPLITAMOUNT],
[MAXGIFTAMOUNT],
[MINGIFTAMOUNT],
[GIFTSPLITCOUNT],
[GIFTCOUNT],
[FIRSTGIFTDATE],
isnull(case when current_timestamp < dateadd(year, datediff(year, [FIRSTGIFTDATE], current_timestamp), [FIRSTGIFTDATE]) then datediff(year, [FIRSTGIFTDATE], current_timestamp) - 1 else datediff(year, [FIRSTGIFTDATE], current_timestamp) end,0) [YEARSSINCEFIRSTGIVEN],
isnull(case when current_timestamp < dateadd(month, datediff(month, [FIRSTGIFTDATE], current_timestamp), [FIRSTGIFTDATE]) then datediff(month, [FIRSTGIFTDATE], current_timestamp) - 1 else datediff(month, [FIRSTGIFTDATE], current_timestamp) end,0) [MONTHSSINCEFIRSTGIVEN],
isnull(datediff(dd, [FIRSTGIFTDATE], current_timestamp),0) [DAYSSINCEFIRSTGIVEN],
[LASTGIFTDATE],
isnull(case when current_timestamp < dateadd(year, datediff(year, [LASTGIFTDATE], current_timestamp), [LASTGIFTDATE]) then datediff(year, [LASTGIFTDATE], current_timestamp) - 1 else datediff(year, [LASTGIFTDATE], current_timestamp) end,0) [YEARSSINCELASTGIVEN],
isnull(case when current_timestamp < dateadd(month, datediff(month, [LASTGIFTDATE], current_timestamp), [LASTGIFTDATE]) then datediff(month, [LASTGIFTDATE], current_timestamp) - 1 else datediff(month, [LASTGIFTDATE], current_timestamp) end,0) [MONTHSSINCELASTGIVEN],
isnull(datediff(dd, [LASTGIFTDATE], current_timestamp),0) [DAYSSINCELASTGIVEN],
[GIVINGYEARS],
[DISTINCTCALENDARYEARS],
[DISTINCTFISCALYEARS]
from dbo.[RE7_CONSTITUENTLTRESTRICTED]
where [RESTRICTED] = 'Unrestricted';