Summary of the "lyrActiveRecips" columns in ListManager
The lyrActiveRecips table holds recipient rows for mail sending.
Each recipient has a row in this table while mail is being delivered to them. Once no more attempts will be made to deliver this recipient the mail message, the row is moved from this table in lyrCompletedRecips.
Primary key: RecipientID
|
Field Name |
Description |
Version Added |
|---|---|---|
|
RecipientID |
A unique, auto-incrementing identifier for this row (big int, NOT NULL) | |
| Domain |
The domain part of the recipient's email address. (varchar(250), NOT NULL) |
|
| FirstAttempt |
The date and time that the first attempt was made to deliver to this recipient. (smalldatetime, NULL) |
|
| FullName |
The recipient's full name, if known. Copied from the members table for efficiency in mail merging. (varchar (100), NULL) |
|
| MailingID |
The mailing that this recipient should receive, from the outmail_ table. (int, NOT NULL) |
|
| MailStreamID_ |
The MailStream associated with this Recipient (int, NULL) |
|
| MemberID |
If this recipient is a member their identifier from the members_ table. (int, NULL) |
|
| NextAttempt |
When the next attempt should be made to deliver to this recipient. (smalldatetime, NOT NULL) |
|
| NodeID |
The idetifier of the node that is currently sending this recipient. For clustering purposes. (int, NULL) |
|
| NodeSequence |
An incrementing value used to ensure locking between nodes works properly. (int, NOT NULL) |
|
| SendTry |
The number of attempt that have been made to deliver mail for this recipient. (tinyint, NOT NULL) |
|
| TransactionLog |
The textual details of the attempt to send to this recipient. Populated based on list settings. (text, NULL) |
|
| UserName |
The user name portion of the recipient's email address. (varchar(100), NOT NULL) |