V_QUERY_MKTMEMBERSHIPMAILINGEXPORTROOT
Export definitions used with membership effort exports are based on this query view.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| FINDERNUMBER | nvarchar(20) | yes | Finder number |
| UNIFIEDSEGMENTATIONSEGMENTID | uniqueidentifier | yes | Unified marketing effort segment ID |
| SOURCECODE | nvarchar(50) | yes | Source code |
| APPEALSYSTEMID | nvarchar(36) | yes | Appeal system ID |
| APPEALID | nvarchar(100) | yes | Appeal ID |
| APPEALDESCRIPTION | nvarchar(255) | yes | Appeal description |
| ASKLADDERENTRYAMOUNT | money | yes | Entry amount |
| ASKLADDERNAME | nvarchar(100) | yes | Ask ladder |
| ASKLADDERASK1 | money | yes | Ask 1 |
| ASKLADDERASK2 | money | yes | Ask 2 |
| ASKLADDERASK3 | money | yes | Ask 3 |
| ASKLADDERASK4 | money | yes | Ask 4 |
| ASKLADDERASK5 | money | yes | Ask 5 |
| ASKLADDERWRITEINPROMPT | nvarchar(255) | yes | Write in prompt |
| ISMEMBER | bit | yes | Is member |
| BASECURRENCYID | uniqueidentifier | yes | Base currency ID |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 2/6/2025 8:50:55 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_MKTMEMBERSHIPMAILINGEXPORTROOT AS
select
cast('' as nvarchar(20)) as [FINDERNUMBER],
cast(null as uniqueidentifier) as [UNIFIEDSEGMENTATIONSEGMENTID],
cast('' as nvarchar(50)) as [SOURCECODE],
cast('' as nvarchar(36)) as [APPEALSYSTEMID],
cast('' as nvarchar(100)) as [APPEALID],
cast('' as nvarchar(255)) as [APPEALDESCRIPTION],
cast(0 as money) as [ASKLADDERENTRYAMOUNT],
cast('' as nvarchar(100)) as [ASKLADDERNAME],
cast(0 as money) as [ASKLADDERASK1],
cast(0 as money) as [ASKLADDERASK2],
cast(0 as money) as [ASKLADDERASK3],
cast(0 as money) as [ASKLADDERASK4],
cast(0 as money) as [ASKLADDERASK5],
cast('' as nvarchar(255)) as [ASKLADDERWRITEINPROMPT],
cast(0 as bit) as [ISMEMBER],
cast(null as uniqueidentifier) as [BASECURRENCYID]