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 |
---|---|---|
| VARCHAR(32) | NOT NULL |
The ID associated with the dataset. | ||
| TIMESTAMP | NULL |
The time the event occurred. | ||
| 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 |
---|---|---|
| VARCHAR(32) | NOT NULL |
The ID associated with the dataset. | ||
| TIMESTAMP | NULL |
The time the event occurred. | ||
| WVARCHAR(255) | NULL |
The audit trail label. | ||
| 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 |
---|---|---|
| VARCHAR(32) | NOT NULL |
The ID associated with the dataset. | ||
| TIMESTAMP | NULL |
The time the event occurred. | ||
| VARCHAR(32) | NULL |
The session ID of the session generating the event. | ||
| 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 |
---|---|---|
| VARCHAR(32) | NOT NULL |
The ID associated with the dataset. | ||
| TIMESTAMP | NULL |
The time the event occurred. | ||
| VARCHAR(32) | NULL |
The session ID of the session generating the event. | ||
| VARCHAR(255) | NULL |
The path of the page being viewed. | ||
| 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 |
---|---|---|
| VARCHAR(32) | NOT NULL |
The ID associated with the dataset. | ||
| TIMESTAMP | NULL |
The time the event occurred. | ||
| VARCHAR(32) | NULL |
The session ID of the session generating the event. | ||
| WVARCHAR(255) | NULL |
The name of the repository that contains the item. | ||
| VARCHAR(255) | NULL |
The repository folder that contains the item. | ||
| VARCHAR(255) | NULL |
The type of the item. | ||
| VARCHAR(255) | NULL |
The repository ID of the item. | ||
| VARCHAR(255) | NULL |
The item descriptor type of the item. | ||
| VARCHAR(255) | NULL |
The path of the page that contains the item. | ||
| 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 |
---|---|---|
| VARCHAR(32) | NOT NULL |
The ID associated with the dataset. | ||
| TIMESTAMP | NULL |
The time the event occurred. | ||
| VARCHAR(32) | NULL |
The session ID of the session generating the event. | ||
| VARCHAR(255) | NULL |
The path name of the page that contains the | ||
| VARCHAR(255) | NULL |
A string of all of the | ||
| VARCHAR(255) | NULL |
The path name of the page that is requested when the link is clicked. | ||
| 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 |
---|---|---|
| VARCHAR(32) | NOT NULL |
The ID associated with the dataset. | ||
| TIMESTAMP | NULL |
The time the event occurred. | ||
| VARCHAR(32) | NULL |
The session ID of the session generating the event. | ||
| VARCHAR(255) | NULL |
The path of the referring page relative to the Web application (or document root). | ||
| VARCHAR(255) | NULL |
The URL of the referring page minus the protocol and path. | ||
| VARCHAR(255) | NULL |
The fully qualified URL of the referring page. | ||
| 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 |
---|---|---|
| VARCHAR(32) | NOT NULL |
The name of the dataset that is recording the event. | ||
| TIMESTAMP | NULL |
The time of the event. | ||
| VARCHAR(255) | NULL |
The text in the subject line of the email. | ||
| VARCHAR(255) | NULL |
The original subject of the email, without “Re:” if present. | ||
| VARCHAR(64) | NULL |
The email address of the sender. | ||
| VARCHAR(255) | NULL |
A comma-separated list of all of the recipients in the “To:” field of the e-mail. | ||
| VARCHAR(255) | NULL |
A comma-separated list of all of the recipients in the “Cc:” field of the e-mail. | ||
| VARCHAR(64) | NULL |
The email address in the “Reply-To:” header of the e-mail. | ||
| NUMERIC(19) | NULL |
The date that the email was received. This is set to the value of the “Delivery-date:” header if it is present. Otherwise, it uses the The date is represented in milliseconds since Jan 1, 1970. | ||
| VARCHAR(6) | NULL |
True if the email was returned as undeliverable. False otherwise. | ||
| VARCHAR(64) | NULL |
The e-mail address of the bounced message. | ||
| VARCHAR(10) | NULL |
The RFC 821 reply code of the bounced email. | ||
| VARCHAR(255) | NULL |
A String property indicating why the message was bounced. | ||
| VARCHAR(10) | NULL |
The enhanced RFC 1893 status code of the bounced email. |
dss_dps_admin_reg
This table is used by the Admin Register SQL mapper to capture atg.dps.AdminRegister
messages.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(32) | NOT NULL |
The ID associated with the dataset. | ||
| TIMESTAMP | NULL |
The time the batch registration event occurred. | ||
| VARCHAR(32) | NULL |
The session ID of the session generating the batch registration event. | ||
| VARCHAR(25) | NULL |
The profile ID of the admin generating the batch registration event. | ||
| 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 |
---|---|---|
| VARCHAR(32) | NOT NULL |
The ID associated with the dataset. | ||
| TIMESTAMP | NULL |
The time the event occurred. | ||
| VARCHAR(32) | NULL |
The session ID of the session generating the event. | ||
| VARCHAR(254) | NULL |
The path of each property that has changed. | ||
| VARCHAR(254) | NULL |
The old property values before they were changed. | ||
| VARCHAR(254) | NULL |
The new property values after they were changed. | ||
| 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. | ||
| 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. | ||
| 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. | ||
| 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 | ||
| 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 | ||
| 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 |
---|---|---|
| VARCHAR(32) | NOT NULL |
The ID associated with the dataset. | ||
| TIMESTAMP | NULL |
The time the event occurred. | ||
| VARCHAR(32) | NULL |
The session ID of the session generating the event. | ||
| VARCHAR(254) | NULL |
The path of each property that has changed. | ||
| VARCHAR(254) | NULL |
The old property values before they were changed. | ||
| VARCHAR(254) | NULL |
The new property values after they were changed. | ||
| 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. | ||
| 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. | ||
| 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. | ||
| 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 | ||
| 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 | ||
| VARCHAR(25) | NULL |
The profile ID of the admin who made the change. | ||
| 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 |
---|---|---|
| VARCHAR(32) | NOT NULL |
The ID associated with the dataset. | ||
| TIMESTAMP | NULL |
The time the event occurred. | ||
| VARCHAR(32) | NULL |
The session ID of the session generating the event. | ||
| LONG VARCHAR | NULL |
The properties that were changed. | ||
| LONG VARCHAR | NULL |
The old property values before they were changed. | ||
| LONG VARCHAR | NULL |
The new property values after they were changed. | ||
| 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 |
---|---|---|
| VARCHAR(32) | NOT NULL |
The ID associated with the dataset. | ||
| TIMESTAMP | NULL |
The time the event occurred. | ||
| VARCHAR(32) | NULL |
The session ID of the session generating the event. | ||
| LONG VARCHAR | NULL |
The properties that were changed. | ||
| LONG VARCHAR | NULL |
The old property values before they were changed. | ||
| LONG VARCHAR | NULL |
The new property values after they were changed. | ||
| VARCHAR(25) | NULL |
The profile ID of the admin who updated the profiles. | ||
| VARCHAR(25) | NULL |
The profile ID of the user whose profile was changed. |