V_SEARCH_SEGMENTATION
Search for marketing efforts.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| MAILINGID | int | ||
| NAME | nvarchar(100) | ||
| DESCRIPTION | nvarchar(255) | ||
| CODE | nvarchar(10) | ||
| STATUS | nvarchar(8) | ||
| SITE | nvarchar(1024) | yes | |
| MAILINGTYPE | nvarchar(25) | yes | |
| MAILINGTYPECODE | tinyint |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/1/2024 11:54:29 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3800.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_SEGMENTATION AS
select
[ID],
[IDINTEGER] as [MAILINGID],
[NAME],
[DESCRIPTION],
[CODE],
case [ACTIVE] when 1 then N'Active' else N'Inactive' end as [STATUS],
dbo.[UFN_TRANSLATIONFUNCTION_SITE_GETNAME]([SITEID]) as [SITE],
[MAILINGTYPE],
[MAILINGTYPECODE]
from dbo.[MKTSEGMENTATION];