EMAILSTATUSGENERALPURPOSE
Holds live and historical information on emails that have are or were in the EMAILQUEUEGENERALPURPOSE table. Allowing auditing so that change history is preserved.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| 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) |
yes |
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 |
yes |
|
Contains xml with 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. |
| 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. |
| SERVERMODIFIEDDATE |
datetime |
yes |
|
|
| PROCESSAFTERDATE |
datetime |
yes |
|
|
| EXTERNALSERVICESTATUS |
tinyint |
|
Default = 0 |
|
Foreign Keys
| Foreign Key |
Field Type |
Null |
Notes |
Description |
| EMAILQUEUEGENERALPURPOSEID |
uniqueidentifier |
yes |
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. |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_EMAILSTATUSGENERALPURPOSE_DATEADDED |
DATEADDED |
|
|
yes |
| IX_EMAILSTATUSGENERALPURPOSE_DATECHANGED |
DATECHANGED |
|
|
|
| IX_EMAILSTATUSGENERALPURPOSE_EMAILQUEUEGENERALPURPOSEID_EXTERNALJOBIDENTITY |
EMAILQUEUEGENERALPURPOSEID, EXTERNALJOBIDENTITY |
|
|
|
| PK_EMAILSTATUSGENERALPURPOSE |
ID |
yes |
yes |
|
Triggers
Referenced by