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
This fact table contains a record of the milestones that the user encountered while the call was being processed by the Application. A new row is added for each milestone.
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.
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_USER_MILESTONE_FACT record with an SDR_SESSION_FACT.
Identifies the start of a 15-minute interval in which the milestone was reached. 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 milestone 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 milestone was reached.
The surrogate key that is used to join the SDR_MILESTONE dimension to the fact tables.
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.