EMAILSTATUSTRANSACTIONAL
Holds live and historical information on emails that have are or were in the EMAILQUEUETRANSACTIONAL table. Allowing auditing so that change history is preserved.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| 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) |
yes |
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 |
yes |
|
Contains email header. |
| INTERNALJOBIDENTITY |
uniqueidentifier |
yes |
|
The guid of the instance id of the global change that processed this email. Used for reporting. |
| STATUSMESSAGE |
xml |
yes |
|
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 |
yes |
|
The consumer start date passed in by the calling application. |
| CONSUMERENDDATE |
datetime |
yes |
|
The consumer end date passed in by the calling application. |
| CLIENTPROCESSSTARTDATE |
datetime |
yes |
|
A timestamp indicating when processing started on the email job. |
| CLIENTPROCESSENDDATE |
datetime |
yes |
|
A timestamp indicating when processing ended on the email job. |
| RECIPIENTADDRESS |
nvarchar(255) |
|
Default = '' |
|
| SERVERMODIFIEDDATE |
datetime |
yes |
|
|
| EXTERNALSERVICESTATUS |
tinyint |
|
Default = 0 |
|
Foreign Keys
| Foreign Key |
Field Type |
Null |
Notes |
Description |
| EMAILQUEUETRANSACTIONALID |
uniqueidentifier |
yes |
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. |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_EMAILSTATUSTRANSACTIONAL_DATEADDED |
DATEADDED |
|
|
yes |
| IX_EMAILSTATUSTRANSACTIONAL_DATECHANGED |
DATECHANGED |
|
|
|
| IX_EMAILSTATUSTRANSACTIONAL_EMAILQUEUETRANSACTIONALID_EXTERNALJOBIDENTITY |
EMAILQUEUETRANSACTIONALID, EXTERNALJOBIDENTITY |
|
|
|
| PK_EMAILSTATUSTRANSACTIONAL |
ID |
yes |
yes |
|
Triggers