Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key (where the term is used loosely to indicate a surrogate key reference to a field in another table, not a formal constraint)
  • DV = Default value

Table SDR_ACTIVITIES_FACT

Description

Introduced: 8.5.007. Supported in Genesys Cloud deployments only.
Modified: 8.5.010.16 (UPDATE_AUDIT_KEY added)

In partitioned databases, this table is partitioned.


This fact table contains a record of the activities that the user encountered while the call was being processed by the Application. A new row is added for each activity (for example, booking an airline ticket).

Column List

Legend

Column Data Type P M F DV

SESSION_ID

VARCHAR2(50 CHAR) X X

START_DATE_TIME_KEY

NUMBER(10) X X X

SEQUENCE_ID

NUMBER(10) X X

START_TS_MS

NUMBER(19) X

END_TS_MS

NUMBER(19) X

SDR_ACTIVITY_KEY

NUMBER(10) X -2

CREATE_AUDIT_KEY

NUMBER(19) X X

UPDATE_AUDIT_KEY

NUMBER(19) X

SESSION_ID

The ID as assigned to the session by Orchestration Server. In combination with SEQUENCE_ID, the SESSION_ID forms a value of the composite primary key for this table. You can use the SESSION_ID to link the SDR_ACTIVITIES_FACT record with an SDR_SESSION_FACT.

START_DATE_TIME_KEY

Identifies the start of a 15-minute interval in which the activity started. Use this value as a key to join the fact tables to any configured DATE_TIME dimension, in order to group the facts that are related to the same interval and/or convert the START_TS timestamp to an appropriate time zone.

SEQUENCE_ID

The unique identifier of the activity within the SDR. In combination with SESSION_ID, the SEQUENCE_ID forms a value of the composite primary key for this table.

START_TS_MS

The UTC-equivalent value, in milliseconds, of the date and time at which the activity started.

END_TS_MS

The UTC-equivalent value, in milliseconds, of the date and time at which the activity ended.

SDR_ACTIVITY_KEY

The surrogate key that is used to join the SDR_ACTIVITY dimension to the fact tables.

CREATE_AUDIT_KEY

The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools — that is, applications that need to identify newly added data.

UPDATE_AUDIT_KEY

Introduced: Release 8.5.010.16
The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data update. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools — that is, applications that need to identify recently modified data.


Index List

CODE U C Description

I_SDR_ACTIVITIES_FACT_SDT

Improves access time, based on the Start Date Time key.

Index I_SDR_ACTIVITIES_FACT_SDT

Field Sort Comment
START_DATE_TIME_KEY Ascending

No subject area information available.

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 28 March 2017, at 22:20.