V_QUERY_NETCOMMUNITYEMAILJOBRECIPIENT
Provides the ability to query emails received by community members.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| BBNCMAPID | int | Blackbaud Internet Solutions ID | |
| CONSTITUENTID | uniqueidentifier | yes | Constituent ID |
| EMAILBBNCMAPID | int | Blackbaud Internet Solutions email ID | |
| EMAILTEMPLATEBBNCMAPID | int | Blackbaud Internet Solutions email template ID | |
| EMAILNAME | nvarchar(255) | Email name | |
| EMAILSUBJECT | nvarchar(4000) | Email subject | |
| SENTDATE | datetime | yes | Date sent |
| BOUNCED | bit | Bounced | |
| BOUNCETEXT | nvarchar(1000) | Bounce text | |
| OPENED | bit | Opened | |
| UPDATEDATE | datetime | yes | Date synchronized |
| EMAILADDRESS | nvarchar(255) | Email address | |
| CLICKEDTHROUGH | bit | Clicked through | |
| DONATED | bit | Donated | |
| URL | UDT_WEBADDRESS | URL | |
| 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 |
| SPAMCOMPLAINT | bit | ||
| OPTEDOUT | bit |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 4/26/2019 6:01:15 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2006.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_NETCOMMUNITYEMAILJOBRECIPIENT AS
select
[NETCOMMUNITYEMAILJOBRECIPIENT].[ID],
[NETCOMMUNITYEMAILJOBRECIPIENT].[BBNCMAPID],
[NETCOMMUNITYEMAILJOBRECIPIENT].[CONSTITUENTID],
[NETCOMMUNITYEMAILJOBRECIPIENT].[EMAILBBNCMAPID],
[NETCOMMUNITYEMAILJOBRECIPIENT].[EMAILTEMPLATEBBNCMAPID],
[NETCOMMUNITYEMAILJOBRECIPIENT].[EMAILNAME],
[NETCOMMUNITYEMAILJOBRECIPIENT].[EMAILSUBJECT],
[NETCOMMUNITYEMAILJOBRECIPIENT].[SENTDATE],
[NETCOMMUNITYEMAILJOBRECIPIENT].[BOUNCED],
[NETCOMMUNITYEMAILJOBRECIPIENT].[BOUNCETEXT],
[NETCOMMUNITYEMAILJOBRECIPIENT].[OPENED],
[NETCOMMUNITYEMAILJOBRECIPIENT].[UPDATEDATE],
[NETCOMMUNITYEMAILJOBRECIPIENT].[EMAILADDRESS],
[NETCOMMUNITYEMAILJOBRECIPIENT].[CLICKEDTHROUGH],
[NETCOMMUNITYEMAILJOBRECIPIENT].[DONATED],
[NETCOMMUNITYEMAILJOBRECIPIENT].[URL],
[NETCOMMUNITYEMAILJOBRECIPIENT].[DATEADDED],
[NETCOMMUNITYEMAILJOBRECIPIENT].[DATECHANGED],
[NETCOMMUNITYEMAILJOBRECIPIENT].[TSLONG],
[ADDEDBY].[APPLICATIONNAME] as [ADDEDBY_APPLICATION],
[ADDEDBY].[USERNAME] as [ADDEDBY_USERNAME],
[CHANGEDBY].[APPLICATIONNAME] as [CHANGEDBY_APPLICATION],
[CHANGEDBY].[USERNAME] as [CHANGEDBY_USERNAME],
[NETCOMMUNITYEMAILJOBRECIPIENT].[SPAMCOMPLAINT] as [SPAMCOMPLAINT],
[NETCOMMUNITYEMAILJOBRECIPIENT].[OPTEDOUT] as [OPTEDOUT]
/*#EXTENSION*/
from
dbo.NETCOMMUNITYEMAILJOBRECIPIENT
left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].[ID] = [NETCOMMUNITYEMAILJOBRECIPIENT].[ADDEDBYID]
left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].[ID] = [NETCOMMUNITYEMAILJOBRECIPIENT].[CHANGEDBYID]