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 |
|