Summary of the "lyrCompletedRecips" columns in ListManager
The lyrCompletedRecips table holds recipient rows for completed email, and notes whether mail was delivered successfully or unsuccessfully. Once no more attempts will be made to deliver this message to individual recipients, the row is moved from lyrActiveRecips to this table.
Primary key: RecipientID
|
Field Name |
Description |
Version Added |
|
RecipientID |
A unique, auto-incrementing identifier for this row (big int, NOT NULL) |
|
|
BounceMailingID |
The identifier for the row in inmail_ that holds the bounce message for this recipient. (int, NULL) |
|
|
CompletionStatusID |
The recipients final completion status, from the lyrLookupCompletionStatus table. (int, NOT NULL) |
|
|
Domain |
The domain part of the recipient's email address. (varchar(250), NOT NULL) |
|
|
FinalAttempt |
The time and date of the last attempt to deliver mail for this recipient. May be the same as FirstAttempt if only one attempt was made. (smalldatetime, NULL) |
|
|
FirstAttempt |
The date and time that the first attempt was made to deliver to this recipient. (smalldatetime, NULL) |
|
|
MailingID |
The mailing that this recipient should receive, from the outmail_ table. (int, NOT NULL) |
|
|
MailStreamID |
The Mail Stream associated with this Recipient (int, NULL) | |
|
MemberID |
If this recipient is a member their identifier from the members_ table. (int, NULL) |
|
|
RecordCount |
Support for lyrReportSummaryData (SmallInt/Default 1) |
|
|
SendTry |
The number of attempts 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) |
|