Share via


mktg_lm_master_operations Table

The mktg_lm_master_operations table in the marketing lists database contains information about direct mail operations in the Marketing System.

The following table describes the columns in the mktg_lm_master_operations table.

Column name

Type

Allow null

Description

guid_op_id

uniqueidentifier

no

A GUID that uniquely identifies a direct mail operation.

This is the primary key.

i_op_type

int

no

The type of this operation, such as: union, subtract, export, and so on.

guid_main_list_id

uniqueidentifier

no

A GUID that uniquely identifies the main list associated with this operation.

guid_second_list_id

uniqueidentifier

yes

A GUID that uniquely identifies the secondary list associated with this operation.

u_expression_body

ntext

yes

The expression, if any, associated with this direct mail list operation.

u_original_filename

ntext

yes

The file name, if any, associated with this direct mail list operation.

u_op_desc

nvarchar(256)

no

A description of the operation.

i_op_progress

int

no

The percentage complete of this operation.

i_op_status

int

no

The status of this operation, such as: complete, in progress, and so on.

dt_op_started

datetime

no

The date and time at which this direct mail list operation was started.

dt_op_ended

datetime

yes

The date and time at which this direct mail list operation ended.

u_op_username

nvarchar(50)

no

The name of the user who initiated this direct mail list operation.

See Also

Other Resources

Marketing Lists Database Tables

Marketing Database Tables