Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 BBNCMAPID int   Default = 0 NetCommunity email job recipient ID.
 EMAILBBNCMAPID int   Default = 0 NetCommunity email ID.
 EMAILTEMPLATEBBNCMAPID int   Default = 0 NetCommunity email template ID.
 EMAILNAME nvarchar(255)   Default = '' Name given to the NetCommunity email.
 EMAILSUBJECT nvarchar(255)   Default = '' Subject of the NetCommunity email.
 SENTDATE datetime Time the NetCommunity email job sent the email to the recipient.
 BOUNCED bit   Default = 0 Indicates that the email was bounced for the recipient.
 BOUNCETEXT nvarchar(1000)   Default = '' Status message associated with an email bounce.
 OPENED bit   Default = 0 Indicates that the email was opened by the recipient.
 UPDATEDATE datetime Time the NetCommunity email job recipient was updated.
 EMAILADDRESS nvarchar(255)   Default = '' Recipient's email address.
 CLICKEDTHROUGH bit   Default = 0 Indicates that the email was clicked-through by the recipient.
 DONATED bit   Default = 0 Indicates that the email resulted in a donation.
 URL UDT_WEBADDRESS   Default = '' URL of the email in NetCommunity.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.

Foreign Key Field Type Null Notes Description
 CONSTITUENTID uniqueidentifier CONSTITUENT.LOCALID Recipient of the email.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_NETCOMMUNITYEMAILJOBRECIPIENT_CONSTITUENTID CONSTITUENTID      
 IX_NETCOMMUNITYEMAILJOBRECIPIENT_DATEADDED DATEADDED    
 IX_NETCOMMUNITYEMAILJOBRECIPIENT_DATECHANGED DATECHANGED      
 IX_NETCOMMUNITYEMAILJOBRECIPIENT_SENTDATE SENTDATE      
 PK_NETCOMMUNITYEMAILJOBRECIPIENT ID  
 UIX_NETCOMMUNITYEMAILJOBRECIPIENT_BBNCMAPID BBNCMAPID    

Trigger Name Description
 TR_NETCOMMUNITYEMAILJOBRECIPIENT_AUDIT_UPDATE
 TR_NETCOMMUNITYEMAILJOBRECIPIENT_AUDIT_DELETE

Referenced by Field
 NETCOMMUNITYNEWSLETTERSUBSCRIPTION LATESTEMAILJOBRECIPIENTID

Entity-Relationship diagram of this table