V_QUERY_RESEARCHGROUPADDMEMBERS_PHILANTHROPICGIFT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| WEALTHID | uniqueidentifier | ||
| PHILANTHROPICGIFTCATEGORY | nvarchar(200) | yes | |
| PHILANTHROPICGIFTTYPE | nvarchar(75) | ||
| PHILANTHROPICGIFTLOCATION | nvarchar(100) | ||
| PHILANTHROPICGIFTLO | money | ||
| PHILANTHROPICGIFTHI | money | ||
| PHILANTHROPICGIFTYEAR | UDT_YEAR |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:10:11 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RESEARCHGROUPADDMEMBERS_PHILANTHROPICGIFT AS
select
WPPHILANTHROPICGIFT.ID,
WPPHILANTHROPICGIFT.WEALTHID,
PHILANTHROPICGIFTCATEGORY.DESCRIPTION PHILANTHROPICGIFTCATEGORY,
WPPHILANTHROPICGIFT.TYPE PHILANTHROPICGIFTTYPE,
WPPHILANTHROPICGIFT.LOCATION PHILANTHROPICGIFTLOCATION,
WPPHILANTHROPICGIFT.LO PHILANTHROPICGIFTLO,
WPPHILANTHROPICGIFT.HI PHILANTHROPICGIFTHI,
WPPHILANTHROPICGIFT.GIFTYEAR PHILANTHROPICGIFTYEAR
from dbo.WPPHILANTHROPICGIFT
left join dbo.WPPHILANTHROPICGIFTCATEGORY on WPPHILANTHROPICGIFTCATEGORY.WPPHILANTHROPICGIFTID = WPPHILANTHROPICGIFT.ID
left join dbo.PHILANTHROPICGIFTCATEGORY on WPPHILANTHROPICGIFTCATEGORY.PHILANTHROPICGIFTCATEGORYID = PHILANTHROPICGIFTCATEGORY.ID