V_QUERY_WEALTHCAPACITY
Provides the ability to query wealth capacity.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| ESTIMATEDWEALTH | nvarchar(100) | yes | Estimated wealth |
| MAJORGIVINGCAPACITY | nvarchar(100) | yes | Major giving capacity |
| MAJORGIVINGCAPACITYVALUE | money | Major giving capacity value | |
| OVERALLRATING | nvarchar(100) | yes | Overall rating |
| CONFIRMED | bit | Confirmed | |
| 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 |
| ESTIMATEDWEALTHVALUE | money | Estimated wealth value | |
| WEALTHCAPACITYFORMULA | nvarchar(100) | yes | Wealth capacity formula |
| ESTIMATEDWEALTHID | uniqueidentifier | yes | |
| MAJORGIVINGCAPACITYID | uniqueidentifier | yes | |
| WEALTHCAPACITYFORMULAID | uniqueidentifier | yes | |
| OVERALLRATINGCODEID | uniqueidentifier | yes | |
| MAJORGIVINGCAPACITYBASISVALUE | nvarchar(250) |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 7/27/2018 10:10:30 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.182.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_WEALTHCAPACITY AS
select
WC.ID,
ESTIMATEDWEALTH.RANGE as ESTIMATEDWEALTH,
MAJORGIVINGCAPACITY.RANGE as MAJORGIVINGCAPACITY,
WC.MAJORGIVINGCAPACITYVALUE,
OVERALLRATINGCODE.DESCRIPTION as OVERALLRATING,
WC.CONFIRMED,
WC.DATEADDED,
WC.DATECHANGED,
WC.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
WC.ESTIMATEDWEALTHVALUE as ESTIMATEDWEALTHVALUE,
WCF.NAME as WEALTHCAPACITYFORMULA,
[WC].[ESTIMATEDWEALTHID],
[WC].[MAJORGIVINGCAPACITYID],
[WC].[WEALTHCAPACITYFORMULAID],
[WC].[OVERALLRATINGCODEID],
[WC].[MAJORGIVINGCAPACITYBASISVALUE]
from
dbo.WEALTHCAPACITY WC
left join dbo.OVERALLRATINGCODE on WC.OVERALLRATINGCODEID = OVERALLRATINGCODE.ID
left join dbo.CONSTITUENT C on C.ID = WC.ID
left join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = WC.ADDEDBYID
left join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = WC.CHANGEDBYID
left join dbo.UFN_ESTIMATEDWEALTH_GETFORMATTEDRANGES() ESTIMATEDWEALTH on WC.ESTIMATEDWEALTHID = ESTIMATEDWEALTH.ID
left join dbo.UFN_MAJORGIVINGCAPACITY_GETFORMATTEDRANGES() MAJORGIVINGCAPACITY on WC.MAJORGIVINGCAPACITYID = MAJORGIVINGCAPACITY.ID
left join dbo.WEALTHCAPACITYFORMULA WCF on WCF.ID = WC.WEALTHCAPACITYFORMULAID