Description
Contains information on the messages sent in a batch.
Dependencies
Columns
DateCreated : datetime, allows null: no
The date and time when the item was created.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateSent : datetime, allows null: yes
The date and time when the message was sent.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateSubmitted : datetime, allows null: no
The date and time when the message was submitted.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateUpdated : datetime, allows null: no
The date and time when the item was updated.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DeptId : int, allows null: no
The ID of the related department.
EmailBatchId : int, allows null: no
The unique identifier of the item.
EmailSendFrom : varchar (max 255 chars), allows null: no
The address from which the message was sent.
EmailSentTo : text (max 2,147,483,647 chars), allows null: yes
A list of addresses for email distribution.
EmailSubject : varchar (max 255 chars), allows null: no
The subject of the email message created with a template.
EmailType : varchar (max 30 chars), allows null: yes
The type of the sent message (Alert or Template).
FormName : varchar (max 100 chars), allows null: no
The name of the related screen.
NbrRecipients : int, allows null: no
The number of recipients.
ScheduledSendDate : datetime, allows null: yes
The date and time the message is scheduled to be sent.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
SendToFilter : varchar (max 255 chars), allows null: no
The name of the filter that was used to select recipients.
SentToFilterSQL : varchar (max 8000 chars), allows null: yes
The SQL representation of the used filter.
StatusCode : varchar (max 255 chars), allows null: no
The status of the delivering email.
UpdateUserId : int, allows null: no
The ID of the user who last updated the item.
UserName : varchar (max 78 chars), allows null: yes
The name of the user who last updated the item.
This is a helper table that stores the messages sent in email alerts.