This page was last edited on November 13, 2020, at 23:36.
Comments or questions about this documentation? Contact us for support!
In the Column List:
Introduced: 8.5.0
In partitioned databases, this table is not partitioned.
This 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. The same columns and column descriptions apply to other AGT_SDR_ACTIVITY_* tables.
Column | Data Type | P | M | F | DV |
---|---|---|---|---|---|
DATE_TIME_KEY | int | X | -1 | ||
SDR_ACTIVITY_KEY | int | -1 | |||
COMPLETED | int | -1 | |||
SDR_CALL_DISPOSITION_KEY | int | X | -1 | ||
ACTIVITIES | int | -1 | |||
DURATION | int | -1 | |||
AGR_SET_KEY | int | X | X |
Introduced: Release 9.0.011
The surrogate key that is used to join this aggregate table to the DATE_TIME dimension table to identify the calendar date and 15-minute interval at which the caller's participation in the interaction began.
The surrogate key that is used to join the SDR_ACTIVITY dimension to the fact tables.
Introduced: Release 9.0.011
The total number of activities that were completed during the reporting interval.
Introduced: Release 9.0.011
The key that is used to join the SDR_CALL_DISPOSITION dimension to the fact tables.
Introduced: Release 9.0.011
The total number of activities that began during the reporting interval.
Introduced: Release 9.0.011
The total amount of time (in seconds) spent in Designer applications during the reporting period.
The surrogate key that is used to join this aggregate table to the AGR_SET table.
No subject area information available.