V_QUERY_OPPORTUNITYDESIGNATION
Designations for an opportunity.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| OPPORTUNITYID | uniqueidentifier | Opportunity 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 |
| CONSTITUENTID | uniqueidentifier | yes | Constituent ID |
| BASECURRENCYID | uniqueidentifier | yes | BASECURRENCYID |
| TRANSACTIONCURRENCYID | uniqueidentifier | yes | TRANSACTIONCURRENCYID |
| ORGANIZATIONAMOUNT | money | Amount (organization currency) | |
| TRANSACTIONAMOUNT | money | Amount (transaction currency) | |
| BASEEXCHANGERATEID | uniqueidentifier | yes | BASEEXCHANGERATEID |
| ORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | ORGANIZATIONEXCHANGERATEID |
| DESIGNATIONNAME | nvarchar(512) | yes | Designation |
| OFMCNAME | nvarchar(100) | yes | Funding Method |
| PGCCNAME | nvarchar(100) | yes | Category |
| ODTCNAME | nvarchar(100) | yes | Type |
| DUCNAME | nvarchar(100) | yes | Use Code |
| FUNDINGMETHODCODEID | uniqueidentifier | yes | |
| CATEGORYCODEID | uniqueidentifier | yes | |
| TYPECODEID | uniqueidentifier | yes | |
| USECODEID | 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_OPPORTUNITYDESIGNATION AS
select
OFP.ID,
OFP.OPPORTUNITYID,
OFP.DESIGNATIONID,
OFP.AMOUNT,
OFP.DATEADDED,
OFP.DATECHANGED,
OFP.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
OFP.CONSTITUENTID,
OFP.BASECURRENCYID,
OFP.TRANSACTIONCURRENCYID,
OFP.ORGANIZATIONAMOUNT,
OFP.TRANSACTIONAMOUNT,
OFP.BASEEXCHANGERATEID,
OFP.ORGANIZATIONEXCHANGERATEID,
DG.USERID DESIGNATIONNAME,
OFMC.DESCRIPTION OFMCNAME,
PGCC.DESCRIPTION PGCCNAME,
ODTC.DESCRIPTION ODTCNAME,
DUC.DESCRIPTION DUCNAME,
[OFP].[FUNDINGMETHODCODEID],
[OFP].[CATEGORYCODEID],
[OFP].[TYPECODEID],
[OFP].[USECODEID]
/*#EXTENSION*/
from dbo.OPPORTUNITYDESIGNATION OFP
left join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = OFP.ADDEDBYID
left join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = OFP.CHANGEDBYID
left join dbo.DESIGNATION DG ON DG.ID = OFP.DESIGNATIONID
left join dbo.OPPORTUNITYDESIGNATIONFMCODE OFMC ON OFMC.ID = OFP.FUNDINGMETHODCODEID
left join dbo.PLANNEDGIFTDESCATEGORYCODE PGCC ON PGCC.ID = OFP.CATEGORYCODEID
left join dbo.OPPORTUNITYDESIGNATIONTYPECODE ODTC ON ODTC.ID = OFP.TYPECODEID
left join dbo.DESIGNATIONUSECODE DUC ON DUC.ID = OFP.USECODEID