Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 MERGEROWSPERCHUNK int   Default = 0 The number of merge rows being processed per chunk.
 LASTMERGEROWPROCESSED int   Default = 0 The sequentialid of the last merge row processed.
 RETRYNUMBER tinyint   Default = 0 The retry number currently being processed. Written to this table for historical purposes.
 STATUS tinyint   Default = 0 Contains a status represented by an enum in the Email Services code
 EXTERNALJOBIDENTITY uniqueidentifier   Contains a guid that can be used to reference the job in an external email system.
 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.
 UNIQUEIDFIELDNAME nvarchar(128)   Default = '' Name of field that identifies the unique field of the view data.
 EMAILADDRESSFIELDNAME nvarchar(128)   Default = '' Name of field that identifies the email address field of the view data.
 EMAILDISPLAYNAMEFIELDNAME nvarchar(128)   Default = '' Name of field that identifies the email display name field of the view data.
 MERGETOKEN nvarchar(3)   Default = '' Array of characters that signify the merge fields in the message content.
 PRIORITY int   Default = 0 This priority is calculated based off the source, type, and date of the email. Stored here for reporting purposes.
 REQUESTEDSENT int   Default = 0 The number of email requested to be sent.
 ACTUALSENT int   Default = 0 The number of emails actually sent.
 EMAILHEADER xml Contains xml with email header.
 INTERNALJOBIDENTITY uniqueidentifier The guid of the instance id of the global change that processed this email. Used for reporting.
 STATUSMESSAGE xml Contains xml with detail status information either from Email Services code or Shared Services code.
 CONSUMERSTARTDATE datetime
 CONSUMERENDDATE datetime
 CLIENTPROCESSSTARTDATE datetime
 CLIENTPROCESSENDDATE datetime
 SERVERMODIFIEDDATE datetime
 PROCESSAFTERDATE datetime
 EXTERNALSERVICESTATUS tinyint   Default = 0

Foreign Key Field Type Null Notes Description
 EMAILQUEUEGENERALPURPOSEID uniqueidentifier EMAILQUEUEGENERALPURPOSE.ID This references the email in the EMAILQUEUEGENERALPURPOSE table. Once the record has been removed from the queue, it will remain in the EMAILSTATUSGENERALPURPOSE table, so this field will be set to null.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_EMAILSTATUSGENERALPURPOSE_DATEADDED DATEADDED    
 IX_EMAILSTATUSGENERALPURPOSE_DATECHANGED DATECHANGED      
 IX_EMAILSTATUSGENERALPURPOSE_EMAILQUEUEGENERALPURPOSEID_EXTERNALJOBIDENTITY EMAILQUEUEGENERALPURPOSEID, EXTERNALJOBIDENTITY      
 PK_EMAILSTATUSGENERALPURPOSE ID  

Trigger Name Description
 TR_EMAILSTATUSGENERALPURPOSE_AUDIT_UPDATE
 TR_EMAILSTATUSGENERALPURPOSE_AUDIT_DELETE

Referenced by Field
 COMMUNICATIONLETTER EMAILSTATUSID

Entity-Relationship diagram of this table