Field Name

Data Type

Size

(Precision, Scale)

Nulls

Default

Description

Version Added

id

int

4

Mailing id references outmail, deletes from outmail are not cascaded

Added in 9.0

EarliestPauseID

int

4

X

Id of the first paused completed recipient in last incremental update

Added in 9.0

EarliestSoftFailID

int

4

X

Id of the first soft fail completed recipient in last incremental update

Added in 9.0

FirstRecipientID

int

4

X

First completed recipient to contribute to aggregate stats

Added in 9.0

FirstClickID

int

4

X

First click to contribute to aggregate stats

Added in 9.0

active

int

4

(0)

Number of records for corresponding mailing that were in lyractiverecips last time it was checked

Added in 9.0

paused

int

4

(0)

Number of 309 records in lyrcompletedrecips for this mailing

Added in 9.0

mailed

int

4

(0)

Number of records in lyrcompletedrecips for this mailing, less 309 records.

Added in 9.0

received

int

4

(0)

Number of 300 records in lyrcompletedrecips for this mailing

Added in 9.0

opens

int

4

(0)

Number of opens for this mailing

Added in 9.0

opens_firsts

int

4

(0)

Number of members for whom clicking on this mailing was their first

Added in 9.0

total_clicks

int

4

(0)

Added in 9.0

clicks_firsts

int

4

(0)

Added in 9.0

unique_clicks

int

4

(0)

Number of unique ‘member id/mail id/ click id’ events for this mailing

Added in 9.0

non_ct_trans

int

4

(0)

Not used

Added in 9.0

trans

int

4

(0)

Added in 9.0

trans_firsts

int

4

(0)

Added in 9.0

trans_amt

int

4

(0)

Added in 9.0

soft_fails

int

4

(0)

Number of 301 records in lyrcompletedrecips for this mailing

Added in 9.0

hard_fails

int

4

(0)

Number of 302 records in lyrcompletedrecips for this mailing

Added in 9.0

perm_fails

int

4

(0)

Number of 302 records in lyrcompletedrecips for this mailing

Added in 9.0

dns_temps

int

4

(0)

Number of 303 records in lyrcompletedrecips for this mailing

Added in 9.0

bad_doms

int

4

(0)

Number of 304 records in lyrcompletedrecips for this mailing

Added in 9.0

bounces

int

4

(0)

Number of 305 records in lyrcompletedrecips for this mailing

Added in 9.0

invalids

int

4

(0)

Number of 306 records in lyrcompletedrecips for this mailing

Added in 9.0

mes_missings

int

4

(0)

Number of 307 records in lyrcompletedrecips for this mailing

Added in 9.0

expirations

int

4

(0)

Number of 308 records in lyrcompletedrecips for this mailing

Added in 9.0

skips

int

4

(0)

Number of 310 records in lyrcompletedrecips for this mailing

Added in 9.0

aborts

int

4

(0)

Number of 311 records in lyrcompletedrecips for this mailing

Added in 9.0

unsubs

int

4

(0)

Number of members who have clicked a unsubscribe link, or sent an unsubscribe e-mail

Added in 9.0

forwards      

int

4

(0)

Number of members opening this message from different domains, not counting one domain which would correspond with the original recipient.

Added in 9.0

referrals

int

4

(0)

Number of sender records in the referrals table corresponding to this mailing

Added in 9.0

new_members

int

4

(0)

Number of receiver records in the referral table corresponding to this mailing

Added in 9.0

start_date

datetime

8

X

The date of the first completed recip record

Added in 9.0

Created

datetime

8

X

The created date copied from the outmail_ table

Added in 9.0

DeliverBefore

smalldatetime

4

X

copied from the outmail_ table

Added in 9.0

InmailBodySize

int

4

X

copied from the outmail_ table

Added in 9.0

Priority

tinyint

1

X

copied from the outmail_ table

Added in 9.0

SplitTestID

int

4

X

copied from the outmail_ table

Added in 9.0

SplitPartID

int

4

X

copied from the outmail_ table

Added in 9.0

SubsetID

int

4

X

copied from the outmail_ table

Added in 9.0

ListID

int

4

X

copied from the outmail_ table

Added in 9.0

InmailHdrForm

varchar

238

X

copied from the outmail_ table

Added in 9.0

OutmailFrom

varchar

200

X

copied from the outmail_ table

Added in 9.0

List

varchar

60

X

copied from the outmail_ table

Added in 9.0

Title

varchar

70

X

copied from the outmail_ table

Added in 9.0

 OutmailTo

varchar

200

X

copied from the outmail_ table

Added in 9.0

Subject

varchar

200

X

copied from the outmail_ table

Added in 9.0

DescShort

varchar

200

X

copied from the outmail_ table

Added in 9.0

Type

varchar

50

copied from the outmail_ table

Added in 9.0

unique_opens

int

4

(0)

Added in 9.0

unique_trans

int

4

(0)

Added in 9.0