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 |
---|---|---|---|
| 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 | Description |
---|---|---|---|
| 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 | Description |
---|---|---|---|
| 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 | Description |
---|---|---|---|
| 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 | Description |
---|---|---|---|
| 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 | Description |
---|---|---|---|
| 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 | Description |
---|---|---|---|
| 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 | Description |
---|---|---|---|
| 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 e-mail 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 e-mail 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 e-mail 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 e-mail. |
| VARCHAR(255) | NULL | A String property indicating why the message was bounced. |
| 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 |
---|---|---|---|
| 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 | Description |
---|---|---|---|
| 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 | Description |
---|---|---|---|
| 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 | Description |
---|---|---|---|
| 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 | Description |
---|---|---|---|
| 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. |