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)