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
- In the Data Type column, varchar/nvarchar means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. (The Info Mart database in Cloud deployments is not multi-language.)
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).
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.
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.
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.
The UTC-equivalent value, in milliseconds, of the date and time at which the activity started.
The UTC-equivalent value, in milliseconds, of the date and time at which the activity ended.
The surrogate key that is used to join the SDR_ACTIVITY dimension to the fact tables.
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.
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.
|Improves access time, based on the Start Date Time key.|
No subject area information available.