Jump to: navigation, search

TASK_CAPT_FACT Aggregate

The task capture aggregate provides measures that are grouped by task process, business value, and capture point over different time intervals. Data is aggregated from the I_TASK_FACT table.

The following subject area diagram shows the dimensions that support the iWD task capture aggregate tables and views.

The TASK_CAPT_FACT Star Schema

The following shows the structure of the TASK_CAPT_FACT aggregate tables.

The TASK_CAPT_FACT Aggregate Tables
Attribute Data Type PK Description
INTERVAL_DATE_KEY int X Key to the EVENT_DATE dimension, indicating the start date of the time interval. In combination with INTERVAL_TIME_KEY, represents the time aggregation axis.
INTERVAL_TIME_KEY int X Key to the EVENT_TIME dimension, indicating the start time of the time interval. This field is present only for sub-day aggregation levels—for example, 15 minutes, 30 minutes, and hourly.
MEDIA_TYPE_KEY int Key to the MEDIA_TYPE dimension, identifying a media type, such as work item, or email.
PROCESS_KEY int X Key to PROCESS dimension.
CAPTURE_POINT_KEY int X Key to CAPTURE_POINT dimension.
CUSTOM_DIM_KEY int X Key to the CUSTOM_DIM dimension, identifying the distinct combination of custom attributes associated with this record.
BUSINESS_VALUE_KEY int X Key to BUSINESS_VALUE dimension.
INTERVAL_KEY int Technical field that is derived from the INTERVAL_DATE_KEY and INTERVAL_TIME_KEY fields for ETL internal use.

[(IDateKey x 1440) + ITimeKey]/15

This field is present only for sub-day aggregation levels.

NEW_TASK_COUNT int Number of new tasks that were submitted to iWD during the given time interval. A task is counted only after it has been classified (where status is at least Queued).
CMPL_TASK_COUNT int Number of tasks that were completed during the given time interval.
COMPLETED_OVERDUE_TASK_COUNT int Number of tasks that were completed during the given time interval that had been overdue; that is, the service-level agreement (SLA) for the task expired, or the due date and time were not met.
CMPL_TASK_AVG_WORK_TIME int Average agent work time, in seconds, for completed tasks during the given time interval (from the finished date and time timestamp – the assigned date and time timestamp for a task). See task history in iWD Manager for examples.
CMPL_TASK_AVG_ASSIGN_TIME int Average time, in seconds, before a task was assigned for the first time. This is calculated as the average from the task-assigned timestamp – the task-creation timestamp for completed tasks during the given time interval. This measure reflects how long, on average, tasks were in backlog before they were assigned to an agent.
CMPL_TASK_AVG_COMPLETE_TIME int Average time, in seconds, before a task was completed. This is derived from the task-completed timestamp – task-created timestamp for completed tasks during the given time interval. Similar to CMPL_TASK_AVG_ASSIGN_TIME, this measure reflects how long a task was in backlog, but it also includes work time.
CMPL_TASK_AVG_SRC_TIME int Average time, in seconds, that a task spent in the preceding system before it was submitted to and created within iWD. This is calculated as the average of the (iWD – source system) task-creation timestamp for completed tasks during the given time interval. The task-creation timestamp from the source system is an extended attribute (sourceCreatedDateTime) that must be provided by the source system.
CMPL_TASK_AVG_PRE_SRC_TIME int Average pre–source system time (source created – first created), in seconds, for completed tasks during the given time interval. Similar to CMPL_TASK_AVG_SRC_TIME except that the beginning time stamp is that of the system before the preceding system to iWD—for example, fax server to workflow to iWD, fax server is the source that was first created.
TOTAL_PENDING_TASK_COUNT int Current number of pending tasks (where the status is Queued, Assigned, or Held) at the end of the given time interval.
TOTAL_OVERDUE_TASK_COUNT int Current number of pending tasks that are overdue at the end of the given time interval. A task is considered overdue when the SLA due date and time have expired.
CMPL_TASK_WORK_TIME int Total agent work time, in seconds, for completed tasks during the given time interval (from the finished date and time timestamp – the assigned date and timestamp for a task). See task history in iWD Manager for examples.
CMPL_TASK_ASSIGN_TIME int Total time, in seconds, before a task was assigned for the first time. This is calculated as the task-assigned timestamp – task-creation timestamp for completed tasks during the given time interval. This measure reflects how long tasks were backlogged before they were assigned to agents.
CMPL_TASK_COMPLETE_TIME int Total time, in seconds, before a task was completed. This is derived from the task-completed timestamp – the task-created timestamp for completed tasks during the given time interval. Similar to CMPL_TASK_AVG_ASSIGN_TIME, this measure reflects how long tasks were backlogged, but it also includes work time.
CMPL_TASK_SRC_TIME int Total time, in seconds, that a task spent in the preceding system before it was submitted to and created within iWD. This is calculated as the (iWD – source system) task-creation timestamp for completed tasks during the given time interval. The task-creation timestamp from the source system is an extended attribute (sourceCreatedDateTime) that must be provided by the source system.
CMPL_TASK_PRE_SRC_TIME int Total pre–source system time (source created – first created), in seconds, for completed tasks during the given time interval. Similar to CMPL_TASK_AVG_SRC_TIME, except that the beginning timestamp is that of the system before the preceding system to iWD. For example, from fax server to workflow to iWD, fax server is the source that was created first.
DATE_TIME_KEY int Key to the DATE_TIME dimension.
This page was last edited on December 23, 2020, at 09:02.
Comments or questions about this documentation? Contact us for support!