V_SEARCH_SEGMENTMEDIAOUTLET
Search for a media outlet.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| NAME | nvarchar(100) | ||
| DESCRIPTION | nvarchar(255) | ||
| CODE | nvarchar(10) | ||
| VENDOR | nvarchar(154) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:39:40 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_SEGMENTMEDIAOUTLET AS
select
[MKTSEGMENT].[ID],
[MKTSEGMENT].[NAME],
[MKTSEGMENT].[DESCRIPTION],
[MKTSEGMENT].[CODE],
[VENDOR].[NAME] as [VENDOR]
from dbo.[MKTSEGMENT]
inner join dbo.[MKTSEGMENTPASSIVE] on [MKTSEGMENTPASSIVE].[ID] = [MKTSEGMENT].[ID]
left outer join dbo.[CONSTITUENT] as [VENDOR] on [VENDOR].[ID] = [MKTSEGMENTPASSIVE].[VENDORID]
where [MKTSEGMENT].[SEGMENTTYPECODE] = 5;