The Personalization module uses the following tables to store information about targeted e-mail. The tables shown here correspond to external users. A parallel set of tables, with the prefix dpi, exists for internal users.

dps_mailing

This table contains information about any targeted e-mail campaigns that are sent to users.

Column

Data Type

Constraint

id

VARCHAR(40)

NOT NULL

(primary key)

The unique identifier associated with this mailing campaign.

name

WVARCHAR(80)

NULL

The name of the mailing campaign.

subject

WVARCHAR(80)

NULL

The subject line of the e-mail.

uniq_server_id

VARCHAR(255)

NULL

The unique ID of the ATG server (IP address: DRP port) that sent out the e-mail.

from_address

WVARCHAR(255)

NULL

The value of the “From” header in the e-mail.

replyto

WVARCHAR(255)

NULL

The value of the “Reply To” header in the e-mail.

template_url

VARCHAR(255)

NULL

The URL of the targeted e-mail template that is used for the e-mails in this campaign.

alt_template_URL

VARCHAR(255)

NULL

The URL of a template containing an alternative text version of an HTML message.

batch_exec_id

VARCHAR(40)

NULL

An ID that distinguishes all mailings created from the same invocation of a SendEmail scenario action. See Identifying Mailings Sent by a Single SendEmail Action.

cc

LONG VARCHAR

NULL

The value of the “CC” header in this e-mail.

bcc

LONG VARCHAR

NULL

The value of the “BCC” header in this e-mail.

send_as_html

INT

NULL

Determines whether or not the e-mail was sent in HTML format.

send_as_text

INT

NULL

Determines whether or not the e-mail was sent in text format.

params

LONG VARBINARY

NULL

Serialized map of template parameters used when rendering the e-mail template for a specific campaign. This is the value of the templateParameters property of the atg.userprofiling.TemplateEmailInfo object.

start_time

TIMESTAMP

NULL

The time at which the SMTP server started sending e-mails.

end_time

TIMESTAMP

NULL

The time at which the SMTP server stopped sending e-mails.

status

INT

NULL

The status of the e-mail campaign, whether PENDING, INPROGRESS, CANCELED, COMPLETE, or FAILED.

num_profiles

INT

NULL

The total number of profiles to which this e-mail was sent.

num_sent

INT

NULL

The total number of e-mails sent.

num_bounces

INT

NULL

The total number of e-mails that bounced back to the server.

num_errors

INT

NULL

The number of errors that occurred while sending the e-mails.

num_skipped

INT

NULL

The number of recipients to whom the mailing could not be sent (for example, because their emailStatus profile property was set to invalid).

fill_from_templ

NUMERIC(1)

NULL

The value of the fillFromTemplate property of the atg.userprofiling.TemplateEmailInfo object. This value is true if information about the e-mail is extracted from the parameter values set in the e-mail template.

is_batched

TINYINT

NULL

Identifies this mailing as a distributed mailing.

batch_size

INT

NULL

The number of messages in this batch.

dps_mail_server

This table is used to identify the servers participating in a distributed mailing.

Column

Data Type

Constraint

uniq_server_id

VARCHAR(254)

NOT NULL

(primary key)

The unique identifier associated with each participating server.

last_updated

TIMESTAMP

NULL

The timestamp set by this server’s batchEmailPeriodicService.

dps_mail_batch

This table is used by the distributed mailing feature.

Column

Data Type

Constraint

mailing_id
(primary key)

VARCHAR(40)

NOT NULL

The unique identifier associated with the batch. References dps_mailing(id).

start_idx
(primary key)

INT

NOT NULL

An index that identifies the first profile in this batch.

uniq_server_id

VARCHAR(254)

NULL

The unique ID of the server (IP address: DRP port) that claimed the batch.

start_time

TIMESTAMP

NULL

The time at which the server started sending the e-mails in this batch.

end_time

TIMESTAMP

NULL

The time at which the server stopped sending the e-mails in this batch.

status

INT

NULL

The status of the batch mailing, whether PENDING, INPROGRESS, CANCELED, COMPLETE, or FAILED.

num_profiles

INT

NULL

The total number of profiles to which this mailing was sent.

num_sent

INT

NULL

The total number of e-mails sent.

num_bounces

INT

NULL

The total number of e-mails that bounced back to the server.

num_errors

INT

NULL

The number of errors that occurred while sending the e-mails.

num_skipped

INT

NULL

The number of recipients to whom the mailing could not be sent (because, for example, their emailStatus profile property was set to invalid).

is_summarized

TINYINT

NULL

Indicates whether the counts for this batch have been merged back into the parent mailing.

dps_user_mailing

This table contains information about users who are receiving e-mail as part of an e-mail campaign.

Column

Data Type

Constraint

mailing_id

VARCHAR(40)

NOT NULL

(primary key)

The unique identifier associated with the e-mail campaign. References dps_mailing(id).

user_id

VARCHAR(40)

NOT NULL

The ID of a user who received an e-mail from the e-mail campaign. References dps_user(id).

idx

INT

NOT NULL

(primary key)

An index used to order the users in this campaign.

dps_email_address

This table stores information that allows you to send e-mail to specific e-mail addresses. A profile is not required.

Column

Data Type

Constraint

mailing_id

VARCHAR(40)

NOT NULL

(primary key)

The unique identifier associated with the e-mail campaign. References dps_mailing(id).

email_address

VARCHAR(255)

NOT NULL

The user’s e-mail address.

idx

INT

NOT NULL

(primary key)

An index used to order the users in this campaign.

 
loading table of contents...