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 dimension table enables Session Detail Record (SDR) facts to be described based on milestones that the user reached during the call. Each row describes a combination of milestones that are defined in the Application.
The primary key of this table.
Indicates the milestone that the caller passed, including the last milestone. Possible values are:
Indicates the paths taken by callers as they move through the application flows.
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.
|X||Ensures that the combinations of values that are stored in the dimension table are unique.|
No subject area information available.