Oracle ATG Web Commerce - Event Message Tables

Event Message Tables

The Scenarios module uses the following tables to store event messages:

dss_das_event

This table contains information used by the DAS Event SQL mapper to capture atg.das.Startup and atg.das.Shutdown messages.

Column	Data Type	Constraint	Description
`id`	VARCHAR(32)	NOT NULL	The ID associated with the dataset.
`timestamp`	TIMESTAMP	NULL	The time the event occurred.
`sessionid`	VARCHAR(32)	NULL	The session ID of the session generating the event.

dss_audit_trail

This table contains information used by the DSS Audit Trail mapper to capture audit trail event messages.

Column	Data Type	Constraint	Description
`id`	VARCHAR(32)	NOT NULL	The ID associated with the dataset.
`timestamp`	TIMESTAMP	NULL	The time the event occurred.
`label`	WVARCHAR(255)	NULL	The audit trail label.
`profileid`	VARCHAR(25)	NULL	The profile ID of the user generating the event.

dss_dps_event

This table contains information used by the DPS Event SQL mapper to capture atg.dps.Login, atg.dps.Logout, atg.dps.Register, atg.dps.StartSession and atg.dps.EndSession messages.

Column	Data Type	Constraint	Description
`id`	VARCHAR(32)	NOT NULL	The ID associated with the dataset.
`timestamp`	TIMESTAMP	NULL	The time the event occurred.
`sessionid`	VARCHAR(32)	NULL	The session ID of the session generating the event.
`profileid`	VARCHAR(25)	NULL	The profile ID of the user generating the event.

dss_dps_page_visit

This table contains information used by the Page Visit SQL mapper to capture atg.dps.PageVisit messages.

Column	Data Type	Constraint	Description
`id`	VARCHAR(32)	NOT NULL	The ID associated with the dataset.
`timestamp`	TIMESTAMP	NULL	The time the event occurred.
`sessionid`	VARCHAR(32)	NULL	The session ID of the session generating the event.
`path`	VARCHAR(255)	NULL	The path of the page being viewed.
`profileid`	VARCHAR(25)	NULL	The profile ID of the user generating the event.

dss_dps_view_item

This table is used by the View Item SQL mapper to capture atg.dps.ViewItem messages.

Column	Data Type	Constraint	Description
`id`	VARCHAR(32)	NOT NULL	The ID associated with the dataset.
`timestamp`	TIMESTAMP	NULL	The time the event occurred.
`sessionid`	VARCHAR(32)	NULL	The session ID of the session generating the event.
`repositoryname`	WVARCHAR(255)	NULL	The name of the repository that contains the item.
`folder`	VARCHAR(255)	NULL	The repository folder that contains the item.
`itemtype`	VARCHAR(255)	NULL	The type of the item.
`repositoryid`	VARCHAR(255)	NULL	The repository ID of the item.
`itemdescriptor`	VARCHAR(255)	NULL	The item descriptor type of the item.
`page`	VARCHAR(255)	NULL	The path of the page that contains the item.
`profileid`	VARCHAR(25)	NULL	The profile ID of the user generating the event.

dss_dps_click

This table is used by the ClickThrough SQL mapper to capture atg.dps.clickThrough messages.

Column	Data Type	Constraint	Description
`id`	VARCHAR(32)	NOT NULL	The ID associated with the dataset.
`timestamp`	TIMESTAMP	NULL	The time the event occurred.
`sessionid`	VARCHAR(32)	NULL	The session ID of the session generating the event.
`destinationpath`	VARCHAR(255)	NULL	The path name of the page that contains the `dsource` parameter.
`sourcenames`	VARCHAR(255)	NULL	A string of all of the `sourceName` values separated by a comma.
`sourcepath`	VARCHAR(255)	NULL	The path name of the page that is requested when the link is clicked.
`profileid`	VARCHAR(25)	NULL	The profile ID of the user generating the event.

dss_dps_referrer

This table is used by the Referrer SQL mapper to capture atg.dps.Referrer messages.

Column	Data Type	Constraint	Description
`id`	VARCHAR(32)	NOT NULL	The ID associated with the dataset.
`timestamp`	TIMESTAMP	NULL	The time the event occurred.
`sessionid`	VARCHAR(32)	NULL	The session ID of the session generating the event.
`referrerpath`	VARCHAR(255)	NULL	The path of the referring page relative to the Web application (or document root).
`referrersite`	VARCHAR(255)	NULL	The URL of the referring page minus the protocol and path.
`referrerpage`	VARCHAR(255)	NULL	The fully qualified URL of the referring page.
`profileid`	VARCHAR(25)	NULL	The profile ID of the user generating the event.

dss_dps_inbound

This table is used by the Inbound Email SQL mapper to capture atg.dps.InboundEmail messages.

Column	Data Type	Constraint	Description
`id`	VARCHAR(32)	NOT NULL	The name of the dataset that is recording the event.
`timestamp`	TIMESTAMP	NULL	The time of the event.
`messagesubject`	VARCHAR(255)	NULL	The text in the subject line of the email.
`originalsubject`	VARCHAR(255)	NULL	The original subject of the email, without “Re:” if present.
`messagefrom`	VARCHAR(64)	NULL	The e-mail address of the sender.
`messageto`	VARCHAR(255)	NULL	A comma-separated list of all of the recipients in the “To:” field of the e-mail.
`messagecc`	VARCHAR(255)	NULL	A comma-separated list of all of the recipients in the “Cc:” field of the e-mail.
`messagereplyto`	VARCHAR(64)	NULL	The email address in the “Reply-To:” header of the e-mail.
`receiveddate`	NUMERIC(19)	NULL	The date that the e-mail was received. This is set to the value of the “Delivery-date:” header if it is present. Otherwise, it uses the `MimeMessage. getReceivedDate()` method. The date is represented in milliseconds since Jan 1, 1970.
`bounced`	VARCHAR(6)	NULL	True if the e-mail was returned as undeliverable. False otherwise.
`bounceemailaddr`	VARCHAR(64)	NULL	The e-mail address of the bounced message.
`bouncereplycode`	VARCHAR(10)	NULL	The RFC 821 reply code of the bounced e-mail.
`bounceerrormess`	VARCHAR(255)	NULL	A String property indicating why the message was bounced.
`bouncestatuscode`	VARCHAR(10)	NULL	The enhanced RFC 1893 status code of the bounced e-mail.

dss_dps_admin_reg

This table is used by the Admin Register SQL mapper to capture atg.dps.AdminRegister messages.

Column	Data Type	Constraint	Description
`id`	VARCHAR(32)	NOT NULL	The ID associated with the dataset.
`clocktime`	TIMESTAMP	NULL	The time the batch registration event occurred.
`sessionid`	VARCHAR(32)	NULL	The session ID of the session generating the batch registration event.
`adminprofileid`	VARCHAR(25)	NULL	The profile ID of the admin generating the batch registration event.
`profileid`	VARCHAR(25)	NULL	The profile IDs of the users who were registered.

dss_dps_property

This table is used by the Profile Property Update SQL mapper to capture atg.dps.ProfilePropertyUpdate messages.

Column	Data Type	Constraint	Description
`id`	VARCHAR(32)	NOT NULL	The ID associated with the dataset.
`clocktime`	TIMESTAMP	NULL	The time the event occurred.
`sessionid`	VARCHAR(32)	NULL	The session ID of the session generating the event.
`propertypath`	VARCHAR(254)	NULL	The path of each property that has changed.
`oldvalue`	VARCHAR(254)	NULL	The old property values before they were changed.
`newvalue`	VARCHAR(254)	NULL	The new property values after they were changed.
`changesign`	VARCHAR(16)	NULL	If the property is a Comparable type, this column indicates if the value has increased or decreased. 0 indicates either “no change” or “not comparable.” A positive value indicates an increase. A negative value indicates a decrease.
`changeamount`	NUMERIC(19, 7)	NULL	If the property is a Number type, this column indicates the absolute value of the difference between the old value and the new value.
`changepercentage`	NUMERIC(19, 7)	NULL	If the property is a Number type, this column indicates the absolute value of the percent difference between the old value and the new value.
`elementsadded`	VARCHAR(254)	NULL	If the property is an array or Collection type, this column indicates the elements that were added as part of the profile update (elements that are members of `newvalue` but not members of `oldvalue`).
`elementsremoved`	VARCHAR(254)	NULL	If the property is an array or Collection type, this column indicates the elements that were removed as part of the profile update (elements that are members of `oldvalue` but not members of `newvalue`).
`profileid`	VARCHAR(25)	NULL	The profile ID of the user whose profile was changed.

dss_dps_admin_prop

This table is used by the Admin Profile Property Update SQL mapper to capture atg.dps.AdminProfilePropertyUpdate messages.

Column	Data Type	Constraint	Description
`id`	VARCHAR(32)	NOT NULL	The ID associated with the dataset.
`clocktime`	TIMESTAMP	NULL	The time the event occurred.
`sessionid`	VARCHAR(32)	NULL	The session ID of the session generating the event.
`propertypath`	VARCHAR(254)	NULL	The path of each property that has changed.
`oldvalue`	VARCHAR(254)	NULL	The old property values before they were changed.
`newvalue`	VARCHAR(254)	NULL	The new property values after they were changed.
`changesign`	VARCHAR(16)	NULL	If the property is a Comparable type, this column indicates if the value has increased or decreased. 0 indicates either “no change” or “not comparable.” A positive value indicates an increase. A negative value indicates a decrease.
`changeamount`	NUMERIC(19, 7)	NULL	If the property is a Number type, this column indicates the absolute value of the difference between the old value and the new value.
`changepercentage`	NUMERIC(19, 7)	NULL	If the property is a Number type, this column indicates the absolute value of the percent difference between the old value and the new value.
`elementsadded`	VARCHAR(254)	NULL	If the property is an array or Collection type, this column indicates the elements that were added as part of the profile update (elements that are members of `newvalue` but not members of `oldvalue`).
`elementsremoved`	VARCHAR(254)	NULL	If the property is an array or Collection type, this column indicates the elements that were removed as part of the profile update (elements that are members of `oldvalue` but not members of `newvalue`).
`adminprofileid`	VARCHAR(25)	NULL	The profile ID of the admin who made the change.
`profileid`	VARCHAR(25)	NULL	The profile ID of the user whose profile was changed.

dss_dps_update

This table is used by the Profile Update SQL mapper to capture atg.dps.ProfileUpdate messages.

Column	Data Type	Constraint	Description
`id`	VARCHAR(32)	NOT NULL	The ID associated with the dataset.
`clocktime`	TIMESTAMP	NULL	The time the event occurred.
`sessionid`	VARCHAR(32)	NULL	The session ID of the session generating the event.
`changedproperties`	LONG VARCHAR	NULL	The properties that were changed.
`oldvalues`	LONG VARCHAR	NULL	The old property values before they were changed.
`newvalues`	LONG VARCHAR	NULL	The new property values after they were changed.
`profileid`	VARCHAR(25)	NULL	The profile ID of the user who updated his or her profile.

dss_dps_admin_up

This table is used by the Admin Profile Update SQL mapper to capture atg.dps.AdminProfileUpdate messages.

Column	Data Type	Constraint	Description
`id`	VARCHAR(32)	NOT NULL	The ID associated with the dataset.
`clocktime`	TIMESTAMP	NULL	The time the event occurred.
`sessionid`	VARCHAR(32)	NULL	The session ID of the session generating the event.
`changedproperties`	LONG VARCHAR	NULL	The properties that were changed.
`oldvalues`	LONG VARCHAR	NULL	The old property values before they were changed.
`newvalues`	LONG VARCHAR	NULL	The new property values after they were changed.
`adminprofileid`	VARCHAR(25)	NULL	The profile ID of the admin who updated the profiles.
`profileid`	VARCHAR(25)	NULL	The profile ID of the user whose profile was changed.

ATG Personalization Programming Guide