V_QUERY_APPEALMAILINGCONSTITUENTAPPEAL
Query view for Constituent Appeal records for a particular Appeal Mailing.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| CONSTITUENTID | uniqueidentifier | Constituent | |
| APPEALID | uniqueidentifier | Appeal | |
| MKTSEGMENTATIONID | uniqueidentifier | yes | MKTSEGMENTATIONID |
| SOURCECODE | nvarchar(50) | Source code | |
| FINDERNUMBER | bigint | Finder number | |
| DATESENT | datetime | yes | Date sent |
| COMMENTS | nvarchar(255) | Comments | |
| MKTPACKAGEID | uniqueidentifier | yes | Package system record ID |
| MKTPACKAGE_DESCRIPTION | nvarchar(100) | yes | Package |
| SEGMENTID | uniqueidentifier | yes | Segment system record ID |
| MKTSEGMENTATIONSEGMENT_DESCRIPTION | nvarchar(100) | yes | Segment |
| TESTSEGMENTID | uniqueidentifier | yes | Test segment system record ID |
| MKTSEGMENTATIONTESTSEGMENT_DESCRIPTION | nvarchar(203) | yes | Test segment |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | Added by application |
| ADDEDBY_USERNAME | nvarchar(128) | yes | Added by user name |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | Changed by application |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | Changed by user name |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:35:23 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_APPEALMAILINGCONSTITUENTAPPEAL AS
select
A.ID,
A.CONSTITUENTID,
A.APPEALID,
A.MKTSEGMENTATIONID,
A.SOURCECODE,
A.FINDERNUMBER,
A.DATESENT,
A.COMMENTS,
A.MKTPACKAGEID,
dbo.UFN_MKTPACKAGE_GETNAME(A.MKTPACKAGEID) as MKTPACKAGE_DESCRIPTION,
(select MKTSEGMENTATIONSEGMENT.SEGMENTID from dbo.MKTSEGMENTATIONSEGMENT where MKTSEGMENTATIONSEGMENT.ID = A.MKTSEGMENTATIONSEGMENTID) as SEGMENTID,
dbo.UFN_MKTSEGMENTATIONSEGMENT_GETNAME(A.MKTSEGMENTATIONSEGMENTID) as MKTSEGMENTATIONSEGMENT_DESCRIPTION,
(select TESTSEGMENT.SEGMENTID from dbo.MKTSEGMENTATIONTESTSEGMENT
left join dbo.MKTSEGMENTATIONSEGMENT TESTSEGMENT on MKTSEGMENTATIONTESTSEGMENT.SEGMENTID = TESTSEGMENT.ID
where MKTSEGMENTATIONTESTSEGMENT.ID = A.MKTSEGMENTATIONTESTSEGMENTID) as TESTSEGMENTID,
dbo.UFN_MKTSEGMENTATIONTESTSEGMENT_GETNAME(A.MKTSEGMENTATIONTESTSEGMENTID) as MKTSEGMENTATIONTESTSEGMENT_DESCRIPTION,
A.DATEADDED,
A.DATECHANGED,
A.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME
/*#EXTENSION*/
from dbo.CONSTITUENTAPPEAL A with (nolock)
left join dbo.CHANGEAGENT ADDEDBY with (nolock) on ADDEDBY.ID = A.ADDEDBYID
left join dbo.CHANGEAGENT CHANGEDBY with (nolock) on CHANGEDBY.ID = A.CHANGEDBYID;