Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 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 recipient dataset.
 EMAILADDRESSFIELDNAME nvarchar(128)   Default = '' Name of field that identifies the email address field of the recipient dataset.
 EMAILDISPLAYNAMEFIELDNAME nvarchar(128)   Default = '' Name of field that identifies the email display name field of the recipient dataset.
 MERGETOKEN nvarchar(3)   Default = '' Array of characters that signify the merge fields in the message content.
 EMAILHEADER xml Contains 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.
 REQUESTEDSENT int   Default = 1 The number of email requested to be sent.
 ACTUALSENT int   Default = 0 The number of emails actually sent.
 CONSUMERSTARTDATE datetime
 CONSUMERENDDATE datetime
 CLIENTPROCESSSTARTDATE datetime
 CLIENTPROCESSENDDATE datetime
 RECIPIENTADDRESS nvarchar(255)   Default = ''
 SERVERMODIFIEDDATE datetime
 EXTERNALSERVICESTATUS tinyint   Default = 0

Foreign Key Field Type Null Notes Description
 EMAILQUEUETRANSACTIONALID uniqueidentifier EMAILQUEUETRANSACTIONAL.ID This references the email in the EMAILQUEUETRANSACTIONAL table. Once the record has been removed from the queue, it will remain in the EMAILSTATUSTRANSACTIONAL 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_EMAILSTATUSTRANSACTIONAL_DATEADDED DATEADDED    
 IX_EMAILSTATUSTRANSACTIONAL_DATECHANGED DATECHANGED      
 IX_EMAILSTATUSTRANSACTIONAL_EMAILQUEUETRANSACTIONALID_EXTERNALJOBIDENTITY EMAILQUEUETRANSACTIONALID, EXTERNALJOBIDENTITY      
 PK_EMAILSTATUSTRANSACTIONAL ID  

Trigger Name Description
 TR_EMAILSTATUSTRANSACTIONAL_AUDIT_UPDATE
 TR_EMAILSTATUSTRANSACTIONAL_AUDIT_DELETE

Entity-Relationship diagram of this table