V_QUERY_MKTMARKETINGPLANPACKAGE
All marketing plan effort package fields.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| NAME | nvarchar(100) | Name | |
| PACKAGEID | uniqueidentifier | yes | Package system record ID |
| MARKETINGPLANID | uniqueidentifier | yes | Marketing plan ID |
| MARKETINGPLANITEMID | uniqueidentifier | yes | Marketing plan marketing effort ID |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:11:54 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_MKTMARKETINGPLANPACKAGE AS
select distinct
[MKTPACKAGE].[NAME],
/* System fields */
[MKTMARKETINGPLANBRIEF].[PACKAGEID],
[MKTMARKETINGPLANBRIEF].[MARKETINGPLANID],
[MKTMARKETINGPLANBRIEF].[MARKETINGPLANITEMID]
/*#EXTENSION*/
from dbo.[MKTMARKETINGPLANBRIEF]
inner join dbo.[MKTPACKAGE] on [MKTPACKAGE].[ID] = [MKTMARKETINGPLANBRIEF].[PACKAGEID]
left outer join dbo.[CHANGEAGENT] as [ADDEDBY] on [ADDEDBY].[ID] = [MKTMARKETINGPLANBRIEF].[ADDEDBYID]
left outer join dbo.[CHANGEAGENT] as [CHANGEDBY] on [CHANGEDBY].[ID] = [MKTMARKETINGPLANBRIEF].[CHANGEDBYID];