V_QUERY_PLANNEDGIFTDESIGNATION
Enables query on planned gift designation records.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| PLANNEDGIFTID | uniqueidentifier | Planned gift ID | |
| DESIGNATIONID | uniqueidentifier | yes | Designation ID |
| AMOUNT | money | Amount | |
| 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 |
| USECODE | nvarchar(100) | yes | Use code |
| CATEGORY | nvarchar(100) | yes | Category |
| DATE | datetime | yes | Date |
| BASECURRENCYID | uniqueidentifier | yes | Base currency ID |
| BASEEXCHANGERATEID | uniqueidentifier | yes | Base exchange rate |
| ORGANIZATIONAMOUNT | money | Amount (organization currency) | |
| ORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | Organization exchange rate |
| TRANSACTIONAMOUNT | money | Amount (transaction currency) | |
| TRANSACTIONCURRENCYID | uniqueidentifier | yes | Transaction currency ID |
| CAMPAIGNID | uniqueidentifier | yes | CAMPAIGNID |
| DESIGNATIONNAME | nvarchar(512) | yes | Designation |
| ODTCNAME | nvarchar(100) | yes | Type |
| NETPRESENTVALUE | money | yes | Net present value |
| TRANSACTIONNETPRESENTVALUE | money | yes | Net present value (transaction currency) |
| ORGANIZATIONNETPRESENTVALUE | money | yes | Net present value (organization currency) |
| CAMPAIGNSUBPRIORITYID | uniqueidentifier | yes | |
| USECODEID | uniqueidentifier | yes | |
| CATEGORYCODEID | uniqueidentifier | yes | |
| TYPECODEID | uniqueidentifier | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/30/2015 1:01:49 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_PLANNEDGIFTDESIGNATION AS
select
PLANNEDGIFTDESIGNATION.ID,
PLANNEDGIFTDESIGNATION.PLANNEDGIFTID,
PLANNEDGIFTDESIGNATION.DESIGNATIONID,
PLANNEDGIFTDESIGNATION.AMOUNT,
PLANNEDGIFTDESIGNATION.DATEADDED,
PLANNEDGIFTDESIGNATION.DATECHANGED,
PLANNEDGIFTDESIGNATION.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
DESIGNATIONUSECODE.DESCRIPTION as USECODE,
PLANNEDGIFTDESCATEGORYCODE.DESCRIPTION as CATEGORY,
PLANNEDGIFTDESIGNATION.DATE,
PLANNEDGIFTDESIGNATION.BASECURRENCYID,
PLANNEDGIFTDESIGNATION.BASEEXCHANGERATEID,
PLANNEDGIFTDESIGNATION.ORGANIZATIONAMOUNT,
PLANNEDGIFTDESIGNATION.ORGANIZATIONEXCHANGERATEID,
PLANNEDGIFTDESIGNATION.TRANSACTIONAMOUNT,
PLANNEDGIFTDESIGNATION.TRANSACTIONCURRENCYID,
PLANNEDGIFTDESIGNATIONCAMPAIGN.CAMPAIGNID,
DG.USERID DESIGNATIONNAME,
ODTC.DESCRIPTION ODTCNAME,
dbo.UFN_PLANNEDGIFTDESIGNATION_GETNETPRESENTVALUE_SINGLE(PLANNEDGIFTDESIGNATION.PLANNEDGIFTID,PLANNEDGIFTDESIGNATION.ID) NETPRESENTVALUE,
dbo.UFN_PLANNEDGIFTDESIGNATION_GETNETPRESENTVALUE_SINGLE_TRANSACTION(PLANNEDGIFTDESIGNATION.PLANNEDGIFTID,PLANNEDGIFTDESIGNATION.ID) TRANSACTIONNETPRESENTVALUE,
dbo.UFN_PLANNEDGIFTDESIGNATION_GETNETPRESENTVALUE_SINGLE_ORGANIZATION(PLANNEDGIFTDESIGNATION.PLANNEDGIFTID,PLANNEDGIFTDESIGNATION.ID) ORGANIZATIONNETPRESENTVALUE,
PLANNEDGIFTDESIGNATIONCAMPAIGN.CAMPAIGNSUBPRIORITYID,
[PLANNEDGIFTDESIGNATION].[USECODEID],
[PLANNEDGIFTDESIGNATION].[CATEGORYCODEID],
[PLANNEDGIFTDESIGNATION].[TYPECODEID]
/*#EXTENSION*/
from dbo.PLANNEDGIFTDESIGNATION
left join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = PLANNEDGIFTDESIGNATION.ADDEDBYID
left join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = PLANNEDGIFTDESIGNATION.CHANGEDBYID
left join dbo.DESIGNATION DG ON DG.ID = PLANNEDGIFTDESIGNATION.DESIGNATIONID
left join dbo.DESIGNATIONUSECODE on DESIGNATIONUSECODE.ID = PLANNEDGIFTDESIGNATION.USECODEID
left join dbo.PLANNEDGIFTDESCATEGORYCODE on PLANNEDGIFTDESCATEGORYCODE.ID = PLANNEDGIFTDESIGNATION.CATEGORYCODEID
left join dbo.PLANNEDGIFTDESIGNATIONCAMPAIGN on PLANNEDGIFTDESIGNATION.ID = PLANNEDGIFTDESIGNATIONCAMPAIGN.PLANNEDGIFTDESIGNATIONID
left join dbo.OPPORTUNITYDESIGNATIONTYPECODE ODTC ON ODTC.ID = PLANNEDGIFTDESIGNATION.TYPECODEID