V_QUERY_MKTSEGMENTATIONSEGMENTUNIFIED
Includes marketing effort fields for use with export.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| UNIFIEDSEGMENTATIONSEGMENTID | uniqueidentifier | Unified marketing effort segment ID | |
| SEGMENTATIONID | uniqueidentifier | Marketing effort ID | |
| SEGMENTATIONSEGMENTID | uniqueidentifier | Marketing effort segment ID | |
| SEGMENTATIONTESTSEGMENTID | uniqueidentifier | yes | Marketing effort test segment ID |
| SEGMENTATIONSEGMENTPACKAGEID | uniqueidentifier | Marketing effort segment package ID | |
| SEGMENTATIONTESTSEGMENTPACKAGEID | uniqueidentifier | yes | Marketing effort test segment package ID |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:14:09 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_MKTSEGMENTATIONSEGMENTUNIFIED AS
select
[MKTSEGMENTATIONSEGMENT].[ID] as [UNIFIEDSEGMENTATIONSEGMENTID],
[MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID],
[MKTSEGMENTATIONSEGMENT].[ID] as [SEGMENTATIONSEGMENTID],
null as [SEGMENTATIONTESTSEGMENTID],
[MKTSEGMENTATIONSEGMENTPACKAGE].[ID] as [SEGMENTATIONSEGMENTPACKAGEID],
null as [SEGMENTATIONTESTSEGMENTPACKAGEID]
from dbo.[MKTSEGMENTATIONSEGMENT]
inner join dbo.[MKTSEGMENTATIONPACKAGE] as [MKTSEGMENTATIONSEGMENTPACKAGE] on [MKTSEGMENTATIONSEGMENTPACKAGE].[SEGMENTATIONID] = [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID] and [MKTSEGMENTATIONSEGMENTPACKAGE].[PACKAGEID] = [MKTSEGMENTATIONSEGMENT].[PACKAGEID]
union all
select
[MKTSEGMENTATIONTESTSEGMENT].[ID] as [UNIFIEDSEGMENTATIONSEGMENTID],
[MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID],
[MKTSEGMENTATIONSEGMENT].[ID] as [SEGMENTATIONSEGMENTID],
[MKTSEGMENTATIONTESTSEGMENT].[ID] as [SEGMENTATIONTESTSEGMENTID],
[MKTSEGMENTATIONSEGMENTPACKAGE].[ID] as [SEGMENTATIONSEGMENTPACKAGEID],
[MKTSEGMENTATIONTESTSEGMENTPACKAGE].[ID] as [SEGMENTATIONTESTSEGMENTPACKAGEID]
from dbo.[MKTSEGMENTATIONTESTSEGMENT]
inner join dbo.[MKTSEGMENTATIONSEGMENT] on [MKTSEGMENTATIONSEGMENT].[ID] = [MKTSEGMENTATIONTESTSEGMENT].[SEGMENTID]
inner join dbo.[MKTSEGMENTATIONPACKAGE] as [MKTSEGMENTATIONSEGMENTPACKAGE] on [MKTSEGMENTATIONSEGMENTPACKAGE].[SEGMENTATIONID] = [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID] and [MKTSEGMENTATIONSEGMENTPACKAGE].[PACKAGEID] = [MKTSEGMENTATIONSEGMENT].[PACKAGEID]
inner join dbo.[MKTSEGMENTATIONPACKAGE] as [MKTSEGMENTATIONTESTSEGMENTPACKAGE] on [MKTSEGMENTATIONTESTSEGMENTPACKAGE].[SEGMENTATIONID] = [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID] and [MKTSEGMENTATIONTESTSEGMENTPACKAGE].[PACKAGEID] = [MKTSEGMENTATIONTESTSEGMENT].[PACKAGEID]