EmailBatches View

Applies to QAComplete 14.3, last modified on February 19, 2024

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.

See Also

EmailTemplates Table
Crossmodules

Highlight search results