V_QUERY_REVENUESPLITCAMPAIGN
Provides the ability to query revenue split campaigns.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| REVENUESPLITID | uniqueidentifier | Revenue split ID | |
| CAMPAIGNID | uniqueidentifier | Campaign ID | |
| CAMPAIGNNAME | nvarchar(100) | yes | Campaign name |
| CAMPAIGNSUBPRIORITYNAMECODEID_TRANSLATION | nvarchar(100) | yes | Campaign subpriority name |
| CAMPAIGNSUBPRIORITYGOAL | money | yes | Campaign subpriority goal |
| 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 |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
| CAMPAIGNBASECURRENCYID | uniqueidentifier | yes | Campaign base currency ID |
| CAMPAIGNSUBPRIORITYID | uniqueidentifier | yes | Campaign subpriority ID |
| CAMPAIGNSUBPRIORITYNAMECODEID | uniqueidentifier | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/30/2015 1:01:50 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_REVENUESPLITCAMPAIGN AS
select
REVENUESPLITCAMPAIGN.ID,
REVENUESPLITCAMPAIGN.REVENUESPLITID,
REVENUESPLITCAMPAIGN.CAMPAIGNID,
CAMPAIGN.NAME as CAMPAIGNNAME,
CAMPAIGNSUBPRIORITYNAMECODE.DESCRIPTION as [CAMPAIGNSUBPRIORITYNAMECODEID_TRANSLATION],
CAMPAIGNSUBPRIORITY.GOAL as CAMPAIGNSUBPRIORITYGOAL,
[ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
[ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
[CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
[CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
REVENUESPLITCAMPAIGN.DATEADDED,
REVENUESPLITCAMPAIGN.DATECHANGED,
REVENUESPLITCAMPAIGN.TSLONG,
CAMPAIGN.BASECURRENCYID as CAMPAIGNBASECURRENCYID,
REVENUESPLITCAMPAIGN.CAMPAIGNSUBPRIORITYID,
[CAMPAIGNSUBPRIORITY].[CAMPAIGNSUBPRIORITYNAMECODEID]
/*#EXTENSION*/
from
dbo.REVENUESPLITCAMPAIGN
left join dbo.CAMPAIGN on REVENUESPLITCAMPAIGN.CAMPAIGNID = CAMPAIGN.ID
left join dbo.CAMPAIGNSUBPRIORITY on REVENUESPLITCAMPAIGN.CAMPAIGNSUBPRIORITYID = CAMPAIGNSUBPRIORITY.ID
left join dbo.CAMPAIGNSUBPRIORITYNAMECODE on CAMPAIGNSUBPRIORITYNAMECODE.ID = CAMPAIGNSUBPRIORITY.CAMPAIGNSUBPRIORITYNAMECODEID
left join dbo.CHANGEAGENT as [ADDEDBY] on ADDEDBY.ID = REVENUESPLITCAMPAIGN.ADDEDBYID
left join dbo.CHANGEAGENT as [CHANGEDBY] on CHANGEDBY.ID = REVENUESPLITCAMPAIGN.CHANGEDBYID