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 MailStream 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)