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)