Contents

IO_Activity

Table Name	Column Name	CX Insights Name	CX Insights Type	Data Type	Description	Folder
IO_Activity	ActivityCodeID	Activity Code ID	attribute	char	Activity code ID is unique random number for the created Activity Code.	Optimizer
IO_Activity	ActivityID	Activity ID	attribute	char	Activity ID is unique random number for the created activity.	Optimizer
IO_Activity	ActivityTypeID	Activity Type ID	attribute	char	Activity type ID is unique value to identify the type of activity.	Optimizer
IO_Activity	AgentID	Agent ID	attribute	char	Agent ID of table Agent rank data of Interaction Optimizer.	Optimizer
IO_Activity	AttendanceReqType	Attendance Requirement Type	attribute	int	Attendance requirement types. 0 - Unspecified, 1 - Required, 2 - Optional, 3 - Ignore	Optimizer
IO_Activity	ContiguousTime	Contiguous Time	attribute	tinyint	Contiguous time of IO_SUDetailView table.	Optimizer
IO_Activity	DailyConstraintsID	Daily Constraints ID	attribute	char	Daily constraints id of IO_DailyConstraints table.	Optimizer
IO_Activity	Description	Description	attribute	nvarchar	Description of given table elements.	Optimizer
IO_Activity	EarliestStartTimeUTC	Earliest Start Time UTC	attribute	datetime	Earliest start time UTC of IO_DailyConstraints table.	Optimizer
IO_Activity	IsPlanned	Is Planned	attribute	tinyint	Is planned of IO_ScheduleInterval table.	Optimizer
IO_Activity	LatestStartTimeUTC	Latest Start Time UTC	attribute	datetime	Latest start time UTC of IO_DailyConstraints table.	Optimizer
IO_Activity	Length	Length	fact	int	Length of the call in seconds. The length column in the Call History table does not always match the call duration. The callplacedtimeUTC and calldisconnectedtimeUTC accumulators are tracked internally by Dialer and may not match Interaction Summary information for the call. The length field is calculated from the Completed time minus the Start time. The completed time is set when the call is completed and the wrapup code is written. That happens after policy evaluations and agent finalization. The start time occurs when the call is placed. The length field can match the (Disconnected - Placed) time when the disconnect was a result of the wrapup and finalization of the interaction. This can occur if you disposition an interaction while the call is still live.	Optimizer
IO_Activity	ModifierUserID	Modifier User ID	attribute	nvarchar	Modifier user id of IO_AIForecastRpt table.	Optimizer
IO_Activity	ModifyDateTimeUTC	Modify Date Time UTC	attribute	datetime	Modify date time UTC of IO_AIServiceLevel table.	Optimizer
IO_Activity	PaidTime	Paid Time	attribute	tinyint	Paid time of IO_TimeOffRequest table.	Optimizer
IO_Activity	RelativeTimes	Relative Times	attribute	tinyint	Relative times of IO_Activity table.	Optimizer
IO_Activity	ReplaceShiftActivity	Replace Shift Activity	attribute	tinyint	Replace activity of IO_Activity table.	Optimizer
IO_Activity	StartTimeIncrement	Start Time Increment	fact	int	Start time increment of IO_SUDetailView table.	Optimizer
IO_Activity	TimeOffRequestID	Time Off Request ID	attribute	char	Time off request id of IO_TimeOffRequest table.	Optimizer
IO_Activity	Version	Version	attribute	int	A common field for different module/object version.	Optimizer