Sv translation

language	en

Background

CompressedUA contains statistics regarding:

Calls to users with respect to particular ACD groups and hotlines
Transfer calls made by users
Transfer calls received by users
Calls made by users for dialler campaigns
Calls made by users by click to dial

Information such as:

The service number
The ACD group
The dialler campaign
The number of calls
- Direct
- From a transfer
- Transfered by agent
Information on results
- Answered
- Busy
- Caller Hangup
- Rejected
Times
- Ring time
- Talk time

is provided.

Note: because these statistics are aggragated, not quite as much information is available as from the call detail records. However, this aggregated data can be retained for a much longer time.

Parameters

Data is aggregated according to the settings of the parameters:

Parameter	Default Value	Purpose
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.SecondsToWait	7200	The minimum time after the end of a time interval before statistics are aggregated.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.NextTimeSlice	-	The date / time of the next time slice to be calculated. This parameter can be reset to an earlier date / time in which case the system will recalculate all intervals from the given date and time again.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.CustomCompress		The name of a stored procedure, in JTELStats2, which is called after the system statistics discussed below have been aggregated. This can be used to provide additional values in additional tables as required by a custom installation. NOTE: changing the CompressedUA tables themselves is NOT supported.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.CustomCompress.SuppressErrors	0	Set to 1, to suppress errors in the CustomCompress routine. If this flag is set, the system will continue with calculations for the data, even if the custom routine throws errors.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.EndTime	02:50	The end time beyond which the process will not run, and waits for the StartTime to pass before continuing. If empty, the process runs all the time.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.StartTime	22:00	The start time after which the process will start to run until the specified end time. If empty, the process runs all the time.

Query

Two tables are provided, CompressedUA15 (15 minute time slices) and CompressedUADay (day compression), aggregated according to the following queries.

The first query aggregates calls made TO the agent or BY the agent (direct calls from the ACD and calls transferred to the agent, click to dial calls and dialler calls):

Translations Ignore

Code Block

title	CompressedUA Query 1

SELECT      UsersID,
			(Various Aggregations)
FROM		JTELStats.StatisticsPartB b
LEFT JOIN	JTELStats.StatisticsPartA a
	ON		b.StatisticsPartAID = a.ID
WHERE		( b.ClientsID = _ClientsID )
			AND
			( b.dtCallStart BETWEEN _Timeslice_Begin AND Timeslice_End_ );

The second query aggregates calls made BY the agent (calls transferred by the agent):

Translations Ignore

Code Block

title	CompressedUA Query 2

SELECT      OriginUsersID,
			(Various Aggregations)
FROM		JTELStats.StatisticsPartB b
JOIN		JTELStats.StatisticsPartA a
	ON		b.StatisticsPartAID = a.ID
WHERE		( b.ClientsID = _ClientsID )
			AND
			( b.dtCallStart BETWEEN _Timeslice_Begin AND Timeslice_End_ )
			AND
			( b.OriginUsersID IS NOT NULL );

Partitioning and Aggregations

When the data is aggregated, it is divided into several consistent partitions, according to the following logic. The resulting aggregations then either count a call, if a condition is met, or determine the time between two timestamps.

Partitioning Inbound and Outbound

bOutbound	Partitioning
0	Inbound
1	Outbound

Partitioning on CONNRES

All results are partitioned by CONNRES.

CONNRES	Field
1	OK
2	No Answer
3	Busy
4	Caller Hangup
6	Reject
0, 5, 6	Failure

Inbound: Partitioning on calls to UsersID

StatisticsPartBOrigin	Field	Meaning
NULL	Direct_*	Direct call to agent
NOT NULL	FromTransfer_*	Call transferred to agent

Inbound: Partitioning on calls made by OriginUsersID

bTransferExternalNumber	bTransferAgent	Field	Meaning
1		TransferOut_Number_*	Call transferred by agent to external number
	1	TransferOut_Agent_*	Call transferred by agent to another agent
0	0	TransferOut_Group_*	Call transferred by agent to group

Outbound: Partitioning on DiallerCampaignsID

DiallerCampaignsID	Field	Meaning
NULL	ClickToDial_*	Agent performed click to dial
NOT NULL	Dialler_*	Agent working in dialler campaign and dialler performed outdial

Tables

CompressedUA15

This table contains compressed statistics for 15 minute intervals.

CompressedUADay

This table contains compressed statistics for day intervals.

Fields

The field definitions are essentially the same, in both tables, only the aggregation intervals are different.

Field	Type	Contents
ID	INT	A unique ID assigned to each record. Note, that IDs are not re-used, since if an interval is recalculated, the record is added with REPLACE, i.e. the existing record will be delteted and a new record with a new ID will be created in its place.
ClientsID	INT	ID of client from Clients table.
UsersID	INT	The ID of the user from the Users table.
UsersProfilesID	INT	The ID of the user profile from UserProfiles in which the agent was logged in, or 0 if no profile information is available.
ServiceNumbersID	INT	ID of service number from ServiceNumbers table.
DynamicPriorityGroupsID	INT	ID of dynamic priority group from DynamicPriorityGroups table, or 0 if no dynamic priority group was assigned.
RoutingApplicationsID	INT	ID of the routing application from the RoutingApplications Table, or 0 if the application is not available.
AcdGroupsID	INT	ID of the ACD group, from the AcdGroups table, or 0 if no ACD group is available.
DiallerCampaignsID	INT	ID of the dialler campaign, from the DiallerCampaigns table, or 0 if no dialler campaign is available.
dtIntervalStart	DATETIME	Date and Time of the start of the interval.
UsersUID	VARCHAR(64)	The UsersUID field.
UsersName	VARCHAR(64)	The Users Name.
UsersFirstName	VARCHAR(64)	The Users FirstName.
UsersProfilesName	VARCHAR(64)	The UsersProfiles Name.
ServiceNumbersRootNumber	VARCHAR(32)	The RootNumber field of the service number, as configured when the compressed statistics were created.
ServiceNumbersName	VARCHAR(64)	The Name field of the service number, as configured when the compressed statistics were created.
ServiceNumbersName2	VARCHAR(64)	The Name2 field of the service number, as configured when the compressed statistics were created.
DynamicPriorityGroupsName	VARCHAR(64)	The Name field from the DynamicPriorityGroups table, as configured when the compressed statistics were created.
AcdGroupsName	VARCHAR(64)	The Name field from the AcdGroups table, as configured when the compressed statistics were created.
Direct_Count	INT	Inbound calls directly to agent, total offered.
Direct_OK_Count	INT	Inbound calls directly to agent, answered.
Direct_OK_Time_CallStart_CallConnect_Total	BIGINT	Inbound calls directly to agent, answered, total seconds from dtCallStart to dtCallConnect.
Direct_OK_Time_CallStart_CallConnect_Max	INT	Inbound calls directly to agent, answered, max seconds from dtCallStart to dtCallConnect.
Direct_OK_Time_CallConnect_CallEnd_Total	BIGINT	Inbound calls directly to agent, answered, total seconds from dtCallConnect to dtCallEnd.
Direct_OK_Time_CallConnect_CallEnd_Max	INT	Inbound calls directly to agent, answered, max seconds from dtCallConnect to dtCallEnd.
Direct_OK_PostCall_Count	INT	Inbound calls directly to agent, answered, number of calls with post call work.
Direct_OK_PostCall_Time_Total	BIGINT	Inbound calls directly to agent, answered, total time in post call work.
Direct_OK_PostCall_Time_Max	INT	Inbound calls directly to agent, answered, max time in post call work.
Direct_NoAnswer_Count	INT	Inbound calls directly to agent, not answered.
Direct_NoAnswer_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls directly to agent, not answered, total seconds from dtCallStart to dtCallEnd.
Direct_NoAnswer_Time_CallStart_CallEnd_Max	INT	Inbound calls directly to agent, not answered, max seconds from dtCallStart to dtCallEnd.
Direct_Busy_Count	INT	Inbound calls directly to agent, busy.
Direct_CallerHangup_Count	INT	Inbound calls directly to agent, caller hangup.
Direct_CallerHangup_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls directly to agent, caller hangup, total seconds from dtCallStart to dtCallEnd.
Direct_CallerHangup_Time_CallStart_CallEnd_Max	INT	Inbound calls directly to agent, caller hangup, max seconds from dtCallStart to dtCallEnd.
Direct_Reject_Count	INT	Inbound calls directly to agent, rejected.
Direct_Reject_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls directly to agent, rejected, total seconds from dtCallStart to dtCallEnd.
Direct_Reject_Time_CallStart_CallEnd_Max	INT	Inbound calls directly to agent, rejected, max seconds from dtCallStart to dtCallEnd.
Direct_Failure_Count	INT	Inbound calls directly to agent, failed.
FromTransfer_Count	INT	Inbound calls transferred to agent, total offered.
FromTransfer_OK_Count	INT	Inbound calls transferred to agent, answered.
FromTransfer_OK_Time_CallStart_CallConnect_Total	BIGINT	Inbound calls transferred to agent, answered, total seconds from dtCallStart to dtCallConnect.
FromTransfer_OK_Time_CallStart_CallConnect_Max	INT	Inbound calls transferred to agent, answered, max seconds from dtCallStart to dtCallConnect.
FromTransfer_OK_Time_CallConnect_CallEnd_Total	BIGINT	Inbound calls transferred to agent, answered, total seconds from dtCallConnect to dtCallEnd.
FromTransfer_OK_Time_CallConnect_CallEnd_Max	INT	Inbound calls transferred to agent, answered, max seconds from dtCallConnect to dtCallEnd.
FromTransfer_OK_PostCall_Count	INT	Inbound calls transferred to agent, answered, number of calls with post call work.
FromTransfer_OK_PostCall_Time_Total	BIGINT	Inbound calls transferred to agent, answered, total time in post call work.
FromTransfer_OK_PostCall_Time_Max	INT	Inbound calls transferred to agent, answered, max time in post call work.
FromTransfer_NoAnswer_Count	INT	Inbound calls transferred to agent, not answered.
FromTransfer_NoAnswer_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred to agent, not answered, total seconds from dtCallStart to dtCallEnd.
FromTransfer_NoAnswer_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred to agent, not answered, max seconds from dtCallStart to dtCallEnd.
FromTransfer_Busy_Count	INT	Inbound calls transferred to agent, busy.
FromTransfer_CallerHangup_Count	INT	Inbound calls transferred to agent, caller hangup.
FromTransfer_CallerHangup_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred to agent, caller hangup, total seconds from dtCallStart to dtCallEnd.
FromTransfer_CallerHangup_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred to agent, caller hangup, max seconds from dtCallStart to dtCallEnd.
FromTransfer_Reject_Count	INT	Inbound calls transferred to agent, rejected.
FromTransfer_Reject_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred to agent, rejected, total seconds from dtCallStart to dtCallEnd.
FromTransfer_Reject_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred to agent, rejected, max seconds from dtCallStart to dtCallEnd.
FromTransfer_Failure_Count	INT	Inbound calls transferred to agent, failed.
TransferOut_Number_Count	INT	Inbound calls transferred out to number by agent, total attempts.
TransferOut_Number_OK_Count	INT	Inbound calls transferred out to number by agent, answered.
TransferOut_Number_OK_Time_CallStart_CallConnect_Total	BIGINT	Inbound calls transferred out to number by agent, answered, total seconds from dtCallStart to dtCallConnect.
TransferOut_Number_OK_Time_CallStart_CallConnect_Max	INT	Inbound calls transferred out to number by agent, answered, max seconds from dtCallStart to dtCallConnect.
TransferOut_Number_OK_Time_CallConnect_CallEnd_Total	BIGINT	Inbound calls transferred out to number by agent, answered, total seconds from dtCallConnect to dtCallEnd.
TransferOut_Number_OK_Time_CallConnect_CallEnd_Max	INT	Inbound calls transferred out to number by agent, answered, max seconds from dtCallConnect to dtCallEnd.
TransferOut_Number_NoAnswer_Count	INT	Inbound calls transferred out to number by agent, no answer.
TransferOut_Number_NoAnswer_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred out to number by agent, no answer, total seconds from dCallStart to dtCallEnd.
TransferOut_Number_NoAnswer_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred out to number by agent, no answer, max seconds from dCallStart to dtCallEnd.
TransferOut_Number_Busy_Count	INT	Inbound calls transferred out to number by agent, busy.
TransferOut_Number_CallerHangup_Count	INT	Inbound calls transferred out to number by agent, caller hangup.
TransferOut_Number_CallerHangup_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred out to number by agent, caller hangup, total seconds from dCallStart to dtCallEnd.
TransferOut_Number_CallerHangup_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred out to number by agent, caller hangup, max seconds from dCallStart to dtCallEnd.
TransferOut_Number_Reject_Count	INT	Inbound calls transferred out to number by agent, rejected.
TransferOut_Number_Reject_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred out to number by agent, rejected, total seconds from dCallStart to dtCallEnd.
TransferOut_Number_Reject_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred out to number by agent, rejected, max seconds from dCallStart to dtCallEnd.
TransferOut_Number_Failure_Count	INT	Inbound calls transferred out to number by agent, failed.
TransferOut_Group_Count	INT	Inbound calls transferred out to group by agent, total attempts.
TransferOut_Group_OK_Count	INT	Inbound calls transferred out to group by agent, answered.
TransferOut_Group_OK_Time_CallStart_CallConnect_Total	BIGINT	Inbound calls transferred out to group by agent, answered, total seconds from dtCallStart to dtCallConnect.
TransferOut_Group_OK_Time_CallStart_CallConnect_Max	INT	Inbound calls transferred out to group by agent, answered, max seconds from dtCallStart to dtCallConnect.
TransferOut_Group_OK_Time_CallConnect_CallEnd_Total	BIGINT	Inbound calls transferred out to group by agent, answered, total seconds from dtCallConnect to dtCallEnd.
TransferOut_Group_OK_Time_CallConnect_CallEnd_Max	INT	Inbound calls transferred out to group by agent, answered, max seconds from dtCallConnect to dtCallEnd.
TransferOut_Group_NoAnswer_Count	INT	Inbound calls transferred out to group by agent, no answer.
TransferOut_Group_NoAnswer_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred out to group by agent, no answer, total seconds from dCallStart to dtCallEnd.
TransferOut_Group_NoAnswer_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred out to group by agent, no answer, max seconds from dCallStart to dtCallEnd.
TransferOut_Group_Busy_Count	INT	Inbound calls transferred out to group by agent, busy.
TransferOut_Group_CallerHangup_Count	INT	Inbound calls transferred out to group by agent, caller hangup.
TransferOut_Group_CallerHangup_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred out to group by agent, caller hangup, total seconds from dCallStart to dtCallEnd.
TransferOut_Group_CallerHangup_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred out to group by agent, caller hangup, max seconds from dCallStart to dtCallEnd.
TransferOut_Group_Reject_Count	INT	Inbound calls transferred out to group by agent, rejected.
TransferOut_Group_Reject_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred out to group by agent, rejected, total seconds from dCallStart to dtCallEnd.
TransferOut_Group_Reject_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred out to group by agent, rejected, max seconds from dCallStart to dtCallEnd.
TransferOut_Group_Failure_Count	INT	Inbound calls transferred out to group by agent, failed.
TransferOut_Agent_Count	INT	Inbound calls transferred out to agent by agent, total attempts.
TransferOut_Agent_OK_Count	INT	Inbound calls transferred out to agent by agent, answered.
TransferOut_Agent_OK_Time_CallStart_CallConnect_Total	BIGINT	Inbound calls transferred out to agent by agent, answered, total seconds from dtCallStart to dtCallConnect.
TransferOut_Agent_OK_Time_CallStart_CallConnect_Max	INT	Inbound calls transferred out to agent by agent, answered, max seconds from dtCallStart to dtCallConnect.
TransferOut_Agent_OK_Time_CallConnect_CallEnd_Total	BIGINT	Inbound calls transferred out to agent by agent, answered, total seconds from dtCallConnect to dtCallEnd.
TransferOut_Agent_OK_Time_CallConnect_CallEnd_Max	INT	Inbound calls transferred out to agent by agent, answered, max seconds from dtCallConnect to dtCallEnd.
TransferOut_Agent_NoAnswer_Count	INT	Inbound calls transferred out to agent by agent, no answer.
TransferOut_Agent_NoAnswer_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred out to agent by agent, no answer, total seconds from dCallStart to dtCallEnd.
TransferOut_Agent_NoAnswer_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred out to agent by agent, no answer, max seconds from dCallStart to dtCallEnd.
TransferOut_Agent_Busy_Count	INT	Inbound calls transferred out to agent by agent, busy.
TransferOut_Agent_CallerHangup_Count	INT	Inbound calls transferred out to agent by agent, caller hangup.
TransferOut_Agent_CallerHangup_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred out to agent by agent, caller hangup, total seconds from dCallStart to dtCallEnd.
TransferOut_Agent_CallerHangup_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred out to agent by agent, caller hangup, max seconds from dCallStart to dtCallEnd.
TransferOut_Agent_Reject_Count	INT	Inbound calls transferred out to agent by agent, rejected.
TransferOut_Agent_Reject_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred out to agent by agent, rejected, total seconds from dCallStart to dtCallEnd.
TransferOut_Agent_Reject_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred out to agent by agent, rejected, max seconds from dCallStart to dtCallEnd.
TransferOut_Agent_Failure_Count	INT	Inbound calls transferred out to agent by agent, failed.
ClickToDial_Count	INT	Outbound, click to dial, total.
ClickToDial_OK_Count	INT	Outbound, click to dial, OK.
ClickToDial_OK_Time_CallStart_CallConnect_Total	INT	Outbound, click to dial, OK, total seconds from dtCallStart to dtCallConnect (to destination leg).
ClickToDial_OK_Time_CallStart_CallConnect_Max	INT	Outbound, click to dial, OK, max seconds from dtCallStart to dtCallConnect (to destination leg).
ClickToDial_OK_Time_CallConnect_CallEnd_Total	INT	Outbound, click to dial, OK, total seconds from dtCallConnect to dtCallEnd (to destination leg).
ClickToDial_OK_Time_CallConnect_CallEnd_Max	INT	Outbound, click to dial, OK, max seconds from dtCallConnect to dtCallEnd (to destination leg).
ClickToDial_NoAnswer_Count	INT	Outbound, click to dial, no answer.
ClickToDial_NoAnswer_Time_CallStart_CallEnd_Total	INT	Outbound, click to dial, OK, total seconds from dtCallStart to dtCallEnd (to destination leg).
ClickToDial_NoAnswer_Time_CallStart_CallEnd_Max	INT	Outbound, click to dial, OK, max seconds from dtCallStart to dtCallEnd (to destination leg).
ClickToDial_Busy_Count	INT	Outbound, click to dial, busy.
ClickToDial_AgentHangup_Count	INT	Outbound, click to dial, agent hangup before call connected.
ClickToDial_Reject_Count	INT	Outbound, click to dial, rejected.
ClickToDial_Failure_Count	INT	Outbound, click to dial, failed.
Dialler_Count	INT	Outbound, from dialler campaign, total.
Dialler_OK_Count	INT	Outbound, from dialler campaign, OK.
Dialler_OK_Time_CallStart_CallConnect_Total	INT	Outbound, from dialler campaign, OK, total seconds from dtCallStart to dtCallConnect (to destination leg).
Dialler_OK_Time_CallStart_CallConnect_Max	INT	Outbound, from dialler campaign, OK, max seconds from dtCallStart to dtCallConnect (to destination leg).
Dialler_OK_Time_CallConnect_CallEnd_Total	INT	Outbound, from dialler campaign, OK, total seconds from dtCallConnect to dtCallEnd (to destination leg).
Dialler_OK_Time_CallConnect_CallEnd_Max	INT	Outbound, from dialler campaign, OK, max seconds from dtCallConnect to dtCallEnd (to destination leg).
Dialler_NoAnswer_Count	INT	Outbound, from dialler campaign, no answer.
Dialler_NoAnswer_Time_CallStart_CallEnd_Total	INT	Outbound, from dialler campaign, OK, total seconds from dtCallStart to dtCallEnd (to destination leg).
Dialler_NoAnswer_Time_CallStart_CallEnd_Max	INT	Outbound, from dialler campaign, OK, max seconds from dtCallStart to dtCallEnd (to destination leg).
Dialler_Busy_Count	INT	Outbound, from dialler campaign, busy.
Dialler_AgentHangup_Count	INT	Outbound, from dialler campaign, agent hangup before call connected.
Dialler_Reject_Count	INT	Outbound, from dialler campaign, rejected.
Dialler_Failure_Count	INT	Outbound, from dialler campaign, failed.

Sv translation

language	de

Background

Hintergrund

CompressedUA contains statistics regarding:

Calls to users with respect to particular ACD groups and hotlines
Transfer calls made by users
Transfer calls received by users
Calls made by users for dialler campaigns
Calls made by users by click to dial

Information such as:

The service number
The ACD group
The dialler campaign
The number of calls
- Direct
- From a transfer
- Transfered by agent
Information on results
- Answered
- Busy
- Caller Hangup
- Rejected
Times
- Ring time
- Talk time

is provided.

Note: because these statistics are aggragated, not quite as much information is available as from the call detail records. However, this aggregated data can be retained for a much longer time.

Parameters

entält Statistiken bezüglich:

Anrufe an Benutzer in Bezug auf bestimmte ACD-Gruppen und Hotlines
Weiterleitung von Anrufen durch Benutzer
Weitergeleitete Anrufe empfangen von Benutzern
Anrufer getätigt von Benutzern für Dialer Kampagnen
Anrufe getätigt von Benutzern durch Click to Dial

Informationen wie z.b.:

Die Service Nummer
Due ACD Gruppe
Die Dialer Kampagne
Die Anzahl an Anrufen
- Direkt
- Durch eine Weiterleitung
- Weitergeleitet durch Agent
Informationen zu Resultaten
- Beantwortet
- Besetzt
- Auflegen durch Anrufer
- Abgelehnt
Zeiten
- Ring time
- Redezeit

sind zur Verfügung gestellt.

Beachten Sie: Da diese Statistiken aggregiert sind, sind weniger Informationen verfügbar als in den Einzelverbindungsnachweisen. Jedoch können diese aggregierten Daten sehr viel länger aufbewahrt werden.

Parameter

Die Daten werden entsprechend den Einstellungen der Parameter aggregiertData is aggregated according to the settings of the parameters:

Parameter	Default Value	Purpose
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.SecondsToWait	7200The minimum time after the end of a time interval before statistics are aggregated	Die Mindestzeit nach dem Ende eines Zeitintervalls, bevor die Statistiken aggregiert werden.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.NextTimeSlice	-The date / time of the next time slice to be calculated. This parameter can be reset to an earlier date / time in which case the system will recalculate all intervals from the given date and time again	Datum und Uhrzeit des nächsten zu berechnenden Zeitintervalls. Dieser Parameter kann auf ein früheres Datum / eine frühere Uhrzeit zurückgesetzt werden. In diesem Fall berechnet das System alle Intervalle ab dem angegebenen Datum und der angegebenen Uhrzeit neu.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.CustomCompressThe name of a stored procedure, in JTELStats2, which is called after the system statistics discussed below have been aggregated. This can be used to provide additional values in additional tables as required by a custom installation. NOTE: changing the CompressedUA tables themselves is NOT supported		Der Name einer gespeicherten Prozedur in JTELStats2, die aufgerufen wird, nachdem die unten beschriebenen Systemstatistiken aggregiert wurden. Dies kann verwendet werden, um zusätzliche Werte in zusätzlichen Tabellen bereitzustellen, wie es für eine benutzerdefinierte Installation festgelegt wurde. HINWEIS: Die Änderung der CompressedUA-Tabellen selbst wird NICHT unterstützt.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.CustomCompress.SuppressErrors	0Set	to Auf 1 gesetzt, to suppress errors in the CustomCompress routine. If this flag is set, the system will continue with calculations for the data, even if the custom routine throws errorsum Fehler in der CustomCompress-Routine zu unterdrücken. Wenn dieses Flag gesetzt ist, fährt das System mit den Berechnungen für die Daten fort, auch wenn die benutzerdefinierte Routine Fehler auslöst.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.EndTime	02:50	The end time beyond which the process will not run, and waits for the StartTime to pass before continuing. If empty, the process runs all the time.Die EndTime, nach der der Prozess nicht mehr weiterläuft und wartet, bis die StartTime verstrichen ist, bevor er fortgesetzt wird. Wenn leer, läuft der Prozess die ganze Ze
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.StartTime	22:00	The start time after which the process will start to run until the specified end time. If empty, the process runs all the time.

Query

Two tables are provided, CompressedUA15 (15 minute time slices) and CompressedUADay (day compression), aggregated according to the following queries.

Die Startzeit, nach der der Prozess beginnt, bis zur angegebenen Endzeit zu laufen. Wenn leer, läuft der Prozess die ganze Zeit.

Abfrage

Es werden zwei Tabellen bereitgestellt, CompressedA15 (15-Minuten-Zeitabschnitte) und CompressedADay (Tageskomprimierung), die gemäß der folgenden Abfrage aggregiert werden:

Die erste Abfrage aggregiert Anrufe, die AN den Agenten oder DURCH den Agenten getätigt werden (direkte Anrufe von der ACD und an den Agenten weitergeleitete Anrufe, Click-to-Dial-Anrufe und Dialer-AnrufeThe first query aggregates calls made TO the agent or BY the agent (direct calls from the ACD and calls transferred to the agent, click to dial calls and dialler calls):

Translations Ignore

Code Block

title	CompressedUA Query 1

SELECT      UsersID,
			(Various Aggregations)
FROM		JTELStats.StatisticsPartB b
LEFT JOIN	JTELStats.StatisticsPartA a
	ON		b.StatisticsPartAID = a.ID
WHERE		( b.ClientsID = _ClientsID )
			AND
			( b.dtCallStart BETWEEN _Timeslice_Begin AND Timeslice_End_ );

The second query aggregates calls made BY the agent (calls transferred by the agentDie zweite Abfrage aggregiert die vom Agenten getätigten Anrufe (vom Agenten weitergeleitete Anrufe):

Translations Ignore

Code Block

title	CompressedUA Query 2

SELECT      OriginUsersID,
			(Various Aggregations)
FROM		JTELStats.StatisticsPartB b
JOIN		JTELStats.StatisticsPartA a
	ON		b.StatisticsPartAID = a.ID
WHERE		( b.ClientsID = _ClientsID )
			AND
			( b.dtCallStart BETWEEN _Timeslice_Begin AND Timeslice_End_ )
			AND
			( b.OriginUsersID IS NOT NULL );

Partitioning and Aggregations

When the data is aggregated, it is divided into several consistent partitions, according to the following logic. The resulting aggregations then either count a call, if a condition is met, or determine the time between two timestamps.

Partitioning Inbound and Outbound

bOutbound	Partitioning
0	Inbound
1	Outbound

Partitioning on CONNRES

Partitionierung und Aggregationen

Wenn die Daten aggregiert werden, werden sie in mehrere konsistente Partitionen unterteilt, die folgender Logik folgen. Die daraus resultierenden Aggregationen zählen dann entweder einen Anruf, wenn eine Bedingung erfüllt ist, oder ermitteln die Zeit zwischen zwei Zeitstempeln.

Partitionierung Eingehend und Ausgehend

bOutbound	Partitionierung
0	Eingehend
1	Ausgehend

Partitionierung auf CONNRES

Alle Ergebnisse werden partitioniert nach CONNRES.

CONNRES

Feld

All results are partitioned by CONNRES.

CONNRES	Field
1	OK
2	No AnswerKeine Antwort
3	Busy Besetzt
4	Caller HangupAuflegen durch Anrufer
6	RejectAbgelehnt
0, 5, 6	FailureFehlgeschlagen

Inbound: Partitioning on calls to

Eingehend: Partitionierung von Anrufen an UsersID

StatisticsPartBOrigin	FieldFeld	MeaningBedeutung
NULL	Direct_*	Direct call to agentDirekter Anruf an Agent
NOT NULL	FromTransfer_*	Call transferred to agent

Inbound: Partitioning on calls made by

Anruf weitergeleitet an Agent

Eingehend: Partitionierung von Anrufen getätigt von OriginUsersID

bTransferExternalNumber	bTransferAgent	FieldFeld	MeaningBedeutung
1		TransferOut_Number_*	Call transferred by agent to external numberAnruf weitergeleitet durch Agent zu externer Nummer
	1	TransferOut_Agent_*	Call transferred by agent to another agentAnruf weitergeleitet durch Agent zu weiterem Agent
0	0	TransferOut_Group_*Call transferred by agent to group	Anruf weitergeleitet druch Agent zu Gruppe

Outbound: Partitioning on DiallerCampaignsID

DiallerCampaignsID	FieldFeld	MeaningBedeutung
NULL	ClickToDial_*	Agent performed click to dialhat Click-To-Dial durchgeführt
NOT NULL	Dialler_*	Agent working in dialler campaign and dialler performed outdial

Tables

CompressedUA15

This table contains compressed statistics for 15 minute intervals.

CompressedUADay

This table contains compressed statistics for day intervals.

Fields

The field definitions are essentially the same, in both tables, only the aggregation intervals are different.

arbeitet in Dialer-Kampagne und Dialer führte Outdial durch

Tabellen

CompressedUA15

Diese Tabelle enthält komprimierte Statistiken für 15-Minuten-Intervalle.

CompressedUADay

Diese Tabelle enthält komprimierte Statistiken für Tagesintervalle.

Felder

Die Felddefinitionen sind in beiden Tabellen im Wesentlichen identisch, nur die Aggregationsintervalle sind unterschiedlich.

Feld	Typ	Inhalte	Field	Type	Contents
ID	INT	A unique ID assigned to each record. Note, that IDs are not re-used, since if an interval is recalculated, the record is added with REPLACE, i.e. the existing record will be delteted and a new record with a new ID will be created in its place.
ClientsID	INT	ID of client from Clients table.
UsersID	INT	The ID of the user from the Users table.
UsersProfilesID	INT	The ID of the user profile from UserProfiles in which the agent was logged in, or 0 if no profile information is available.
ServiceNumbersID	INT	ID of service number from ServiceNumbers table.
DynamicPriorityGroupsID	INT	ID of dynamic priority group from DynamicPriorityGroups table, or 0 if no dynamic priority group was assigned.
RoutingApplicationsID	INT	ID of the routing application from the RoutingApplications Table, or 0 if the application is not available.
AcdGroupsID	INT	ID of the ACD group, from the AcdGroups table, or 0 if no ACD group is available.
DiallerCampaignsID	INT	ID of the dialler campaign, from the DiallerCampaigns table, or 0 if no dialler campaign is available.
dtIntervalStart	DATETIME	Date and Time of the start of the interval.
UsersUID	VARCHAR(64)	The UsersUID field.
UsersName	VARCHAR(64)	The Users Name.
UsersFirstName	VARCHAR(64)	The Users FirstName.
UsersProfilesName	VARCHAR(64)	The UsersProfiles Name.
ServiceNumbersRootNumber	VARCHAR(32)	The RootNumber field of the service number, as configured when the compressed statistics were created.
ServiceNumbersName	VARCHAR(64)	The Name field of the service number, as configured when the compressed statistics were created.
ServiceNumbersName2	VARCHAR(64)	The Name2 field of the service number, as configured when the compressed statistics were created.
DynamicPriorityGroupsName	VARCHAR(64)	The Name field from the DynamicPriorityGroups table, as configured when the compressed statistics were created.
AcdGroupsName	VARCHAR(64)	The Name field from the AcdGroups table, as configured when the compressed statistics were created.
Direct_Count	INT	Inbound calls directly to agent, total offered.
Direct_OK_Count	INT	Inbound calls directly to agent, answered.
Direct_OK_Time_CallStart_CallConnect_Total	BIGINT	Inbound calls directly to agent, answered, total seconds from dtCallStart to dtCallConnect.
Direct_OK_Time_CallStart_CallConnect_Max	INT	Inbound calls directly to agent, answered, max seconds from dtCallStart to dtCallConnect.
Direct_OK_Time_CallConnect_CallEnd_Total	BIGINT	Inbound calls directly to agent, answered, total seconds from dtCallConnect to dtCallEnd.
Direct_OK_Time_CallConnect_CallEnd_Max	INT	Inbound calls directly to agent, answered, max seconds from dtCallConnect to dtCallEnd.
Direct_OK_PostCall_Count	INT	Inbound calls directly to agent, answered, number of calls with post call work.
Direct_OK_PostCall_Time_Total	BIGINT	Inbound calls directly to agent, answered, total time in post call work.
Direct_OK_PostCall_Time_Max	INT	Inbound calls directly to agent, answered, max time in post call work.
Direct_NoAnswer_Count	INT	Inbound calls directly to agent, not answered.
Direct_NoAnswer_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls directly to agent, not answered, total seconds from dtCallStart to dtCallEnd.
Direct_NoAnswer_Time_CallStart_CallEnd_Max	INT	Inbound calls directly to agent, not answered, max seconds from dtCallStart to dtCallEnd.
Direct_Busy_Count	INT	Inbound calls directly to agent, busy.
Direct_CallerHangup_Count	INT	Inbound calls directly to agent, caller hangup.
Direct_CallerHangup_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls directly to agent, caller hangup, total seconds from dtCallStart to dtCallEnd.
Direct_CallerHangup_Time_CallStart_CallEnd_Max	INT	Inbound calls directly to agent, caller hangup, max seconds from dtCallStart to dtCallEnd.
Direct_Reject_Count	INT	Inbound calls directly to agent, rejected.
Direct_Reject_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls directly to agent, rejected, total seconds from dtCallStart to dtCallEnd.
Direct_Reject_Time_CallStart_CallEnd_Max	INT	Inbound calls directly to agent, rejected, max seconds from dtCallStart to dtCallEnd.
Direct_Failure_Count	INT	Inbound calls directly to agent, failed.
FromTransfer_Count	INT	Inbound calls transferred to agent, total offered.
FromTransfer_OK_Count	INT	Inbound calls transferred to agent, answered.
FromTransfer_OK_Time_CallStart_CallConnect_Total	BIGINT	Inbound calls transferred to agent, answered, total seconds from dtCallStart to dtCallConnect.
FromTransfer_OK_Time_CallStart_CallConnect_Max	INT	Inbound calls transferred to agent, answered, max seconds from dtCallStart to dtCallConnect.
FromTransfer_OK_Time_CallConnect_CallEnd_Total	BIGINT	Inbound calls transferred to agent, answered, total seconds from dtCallConnect to dtCallEnd.
FromTransfer_OK_Time_CallConnect_CallEnd_Max	INT	Inbound calls transferred to agent, answered, max seconds from dtCallConnect to dtCallEnd.
FromTransfer_OK_PostCall_Count	INT	Inbound calls transferred to agent, answered, number of calls with post call work.
FromTransfer_OK_PostCall_Time_Total	BIGINT	Inbound calls transferred to agent, answered, total time in post call work.
FromTransfer_OK_PostCall_Time_Max	INT	Inbound calls transferred to agent, answered, max time in post call work.
FromTransfer_NoAnswer_Count	INT	Inbound calls transferred to agent, not answered.
FromTransfer_NoAnswer_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred to agent, not answered, total seconds from dtCallStart to dtCallEnd.
FromTransfer_NoAnswer_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred to agent, not answered, max seconds from dtCallStart to dtCallEnd.
FromTransfer_Busy_Count	INT	Inbound calls transferred to agent, busy.
FromTransfer_CallerHangup_Count	INT	Inbound calls transferred to agent, caller hangup.
FromTransfer_CallerHangup_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred to agent, caller hangup, total seconds from dtCallStart to dtCallEnd.
FromTransfer_CallerHangup_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred to agent, caller hangup, max seconds from dtCallStart to dtCallEnd.
FromTransfer_Reject_Count	INT	Inbound calls transferred to agent, rejected.
FromTransfer_Reject_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred to agent, rejected, total seconds from dtCallStart to dtCallEnd.
FromTransfer_Reject_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred to agent, rejected, max seconds from dtCallStart to dtCallEnd.
FromTransfer_Failure_Count	INT	Inbound calls transferred to agent, failed.
TransferOut_Number_Count	INT	Inbound calls transferred out to number by agent, total attempts.
TransferOut_Number_OK_Count	INT	Inbound calls transferred out to number by agent, answered.
TransferOut_Number_OK_Time_CallStart_CallConnect_Total	BIGINT	Inbound calls transferred out to number by agent, answered, total seconds from dtCallStart to dtCallConnect.
TransferOut_Number_OK_Time_CallStart_CallConnect_Max	INT	Inbound calls transferred out to number by agent, answered, max seconds from dtCallStart to dtCallConnect.
TransferOut_Number_OK_Time_CallConnect_CallEnd_Total	BIGINT	Inbound calls transferred out to number by agent, answered, total seconds from dtCallConnect to dtCallEnd.
TransferOut_Number_OK_Time_CallConnect_CallEnd_Max	INT	Inbound calls transferred out to number by agent, answered, max seconds from dtCallConnect to dtCallEnd.
TransferOut_Number_NoAnswer_Count	INT	Inbound calls transferred out to number by agent, no answer.
TransferOut_Number_NoAnswer_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred out to number by agent, no answer, total seconds from dCallStart to dtCallEnd.
TransferOut_Number_NoAnswer_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred out to number by agent, no answer, max seconds from dCallStart to dtCallEnd.
TransferOut_Number_Busy_Count	INT	Inbound calls transferred out to number by agent, busy.
TransferOut_Number_CallerHangup_Count	INT	Inbound calls transferred out to number by agent, caller hangup.
TransferOut_Number_CallerHangup_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred out to number by agent, caller hangup, total seconds from dCallStart to dtCallEnd.
TransferOut_Number_CallerHangup_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred out to number by agent, caller hangup, max seconds from dCallStart to dtCallEnd.
TransferOut_Number_Reject_Count	INT	Inbound calls transferred out to number by agent, rejected.
TransferOut_Number_Reject_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred out to number by agent, rejected, total seconds from dCallStart to dtCallEnd.
TransferOut_Number_Reject_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred out to number by agent, rejected, max seconds from dCallStart to dtCallEnd.
TransferOut_Number_Failure_Count	INT	Inbound calls transferred out to number by agent, failed.
TransferOut_Group_Count	INT	Inbound calls transferred out to group by agent, total attempts.
TransferOut_Group_OK_Count	INT	Inbound calls transferred out to group by agent, answered.
TransferOut_Group_OK_Time_CallStart_CallConnect_Total	BIGINT	Inbound calls transferred out to group by agent, answered, total seconds from dtCallStart to dtCallConnect.
TransferOut_Group_OK_Time_CallStart_CallConnect_Max	INT	Inbound calls transferred out to group by agent, answered, max seconds from dtCallStart to dtCallConnect.
TransferOut_Group_OK_Time_CallConnect_CallEnd_Total	BIGINT	Inbound calls transferred out to group by agent, answered, total seconds from dtCallConnect to dtCallEnd.
TransferOut_Group_OK_Time_CallConnect_CallEnd_Max	INT	Inbound calls transferred out to group by agent, answered, max seconds from dtCallConnect to dtCallEnd.
TransferOut_Group_NoAnswer_Count	INT	Inbound calls transferred out to group by agent, no answer.
TransferOut_Group_NoAnswer_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred out to group by agent, no answer, total seconds from dCallStart to dtCallEnd.
TransferOut_Group_NoAnswer_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred out to group by agent, no answer, max seconds from dCallStart to dtCallEnd.
TransferOut_Group_Busy_Count	INT	Inbound calls transferred out to group by agent, busy.
TransferOut_Group_CallerHangup_Count	INT	Inbound calls transferred out to group by agent, caller hangup.
TransferOut_Group_CallerHangup_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred out to group by agent, caller hangup, total seconds from dCallStart to dtCallEnd.
TransferOut_Group_CallerHangup_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred out to group by agent, caller hangup, max seconds from dCallStart to dtCallEnd.
TransferOut_Group_Reject_Count	INT	Inbound calls transferred out to group by agent, rejected.
TransferOut_Group_Reject_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred out to group by agent, rejected, total seconds from dCallStart to dtCallEnd.
TransferOut_Group_Reject_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred out to group by agent, rejected, max seconds from dCallStart to dtCallEnd.
TransferOut_Group_Failure_Count	INT	Inbound calls transferred out to group by agent, failed.
TransferOut_Agent_Count	INT	Inbound calls transferred out to agent by agent, total attempts.
TransferOut_Agent_OK_Count	INT	Inbound calls transferred out to agent by agent, answered.
TransferOut_Agent_OK_Time_CallStart_CallConnect_Total	BIGINT	Inbound calls transferred out to agent by agent, answered, total seconds from dtCallStart to dtCallConnect.
TransferOut_Agent_OK_Time_CallStart_CallConnect_Max	INT	Inbound calls transferred out to agent by agent, answered, max seconds from dtCallStart to dtCallConnect.
TransferOut_Agent_OK_Time_CallConnect_CallEnd_Total	BIGINT	Inbound calls transferred out to agent by agent, answered, total seconds from dtCallConnect to dtCallEnd.
TransferOut_Agent_OK_Time_CallConnect_CallEnd_Max	INT	Inbound calls transferred out to agent by agent, answered, max seconds from dtCallConnect to dtCallEnd.
TransferOut_Agent_NoAnswer_Count	INT	Inbound calls transferred out to agent by agent, no answer.
TransferOut_Agent_NoAnswer_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred out to agent by agent, no answer, total seconds from dCallStart to dtCallEnd.
TransferOut_Agent_NoAnswer_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred out to agent by agent, no answer, max seconds from dCallStart to dtCallEnd.
TransferOut_Agent_Busy_Count	INT	Inbound calls transferred out to agent by agent, busy.
TransferOut_Agent_CallerHangup_Count	INT	Inbound calls transferred out to agent by agent, caller hangup.
TransferOut_Agent_CallerHangup_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred out to agent by agent, caller hangup, total seconds from dCallStart to dtCallEnd.
TransferOut_Agent_CallerHangup_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred out to agent by agent, caller hangup, max seconds from dCallStart to dtCallEnd.
TransferOut_Agent_Reject_Count	INT	Inbound calls transferred out to agent by agent, rejected.
TransferOut_Agent_Reject_Time_CallStart_CallEnd_Total	BIGINT	Inbound calls transferred out to agent by agent, rejected, total seconds from dCallStart to dtCallEnd.
TransferOut_Agent_Reject_Time_CallStart_CallEnd_Max	INT	Inbound calls transferred out to agent by agent, rejected, max seconds from dCallStart to dtCallEnd.
TransferOut_Agent_Failure_Count	INT	Inbound calls transferred out to agent by agent, failed.
ClickToDial_Count	INT	Outbound, click to dial, total.
ClickToDial_OK_Count	INT	Outbound, click to dial, OK.
ClickToDial_OK_Time_CallStart_CallConnect_Total	INT	Outbound, click to dial, OK, total seconds from dtCallStart to dtCallConnect (to destination leg).
ClickToDial_OK_Time_CallStart_CallConnect_Max	INT	Outbound, click to dial, OK, max seconds from dtCallStart to dtCallConnect (to destination leg).
ClickToDial_OK_Time_CallConnect_CallEnd_Total	INT	Outbound, click to dial, OK, total seconds from dtCallConnect to dtCallEnd (to destination leg).
ClickToDial_OK_Time_CallConnect_CallEnd_Max	INT	Outbound, click to dial, OK, max seconds from dtCallConnect to dtCallEnd (to destination leg).
ClickToDial_NoAnswer_Count	INT	Outbound, click to dial, no answer.
ClickToDial_NoAnswer_Time_CallStart_CallEnd_Total	INT	Outbound, click to dial, OK, total seconds from dtCallStart to dtCallEnd (to destination leg).
ClickToDial_NoAnswer_Time_CallStart_CallEnd_Max	INT	Outbound, click to dial, OK, max seconds from dtCallStart to dtCallEnd (to destination leg).
ClickToDial_Busy_Count	INT	Outbound, click to dial, busy.
ClickToDial_AgentHangup_Count	INT	Outbound, click to dial, agent hangup before call connected.
ClickToDial_Reject_Count	INT	Outbound, click to dial, rejected.
ClickToDial_Failure_Count	INT	Outbound, click to dial, failed.
Dialler_Count	INT	Outbound, from dialler campaign, total.
Dialler_OK_Count	INT	Outbound, from dialler campaign, OK.
Dialler_OK_Time_CallStart_CallConnect_Total	INT	Outbound, from dialler campaign, OK, total seconds from dtCallStart to dtCallConnect (to destination leg).
Dialler_OK_Time_CallStart_CallConnect_Max	INT	Outbound, from dialler campaign, OK, max seconds from dtCallStart to dtCallConnect (to destination leg).
Dialler_OK_Time_CallConnect_CallEnd_Total	INT	Outbound, from dialler campaign, OK, total seconds from dtCallConnect to dtCallEnd (to destination leg).
Dialler_OK_Time_CallConnect_CallEnd_Max	INT	Outbound, from dialler campaign, OK, max seconds from dtCallConnect to dtCallEnd (to destination leg).
Dialler_NoAnswer_Count	INT	Outbound, from dialler campaign, no answer.
Dialler_NoAnswer_Time_CallStart_CallEnd_Total	INT	Outbound, from dialler campaign, OK, total seconds from dtCallStart to dtCallEnd (to destination leg).
Dialler_NoAnswer_Time_CallStart_CallEnd_Max	INT	Outbound, from dialler campaign, OK, max seconds from dtCallStart to dtCallEnd (to destination leg).
Dialler_Busy_Count	INT	Outbound, from dialler campaign, busy.
Dialler_AgentHangup_Count	INT	Outbound, from dialler campaign, agent hangup before call connected.
Dialler_Reject_Count	INT	Outbound, from dialler campaign, rejected.
Dialler_Failure_Count	INT	Outbound, from dialler campaign, failed.

Sv translation

language	fr

Background

CompressedUA contient des statistiques concernant :

Appels aux utilisateurs concernant des groupes et des lignes directes particulières de l'ACD
Transférer les appels effectués par les utilisateurs
Transférer les appels reçus par les utilisateurs
Appels lancés par les utilisateurs pour les campagnes de numérotation
Appels effectués par les utilisateurs en cliquant pour composer

Des informations telles que :

Le numéro de service
Le Groupe ACD
Le Composeur Campagne
Le nombre d'appels
- Directe
- A partir d'un transfert
- Transfert par agent
Information sur les résultats
- Répondu
- Occupé
- Raccrochage Appelant
- Rejeté
Fois
- Temps de sonnerie
- Temps de conversation

est fournie.

Remarque : ces statistiques étant aggravées, les informations disponibles ne sont pas aussi nombreuses que celles provenant des enregistrements des détails des appels. Toutefois, ces données agrégées peuvent être conservées beaucoup plus longtemps.

Paramètres

Les données sont agrégées en fonction du réglage des paramètres :

Paramètre	Valeur par défaut	Objet
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.SecondsToWait	7200	Le temps minimum après la fin d'un intervalle de temps avant l'agrégation des statistiques.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.NextTimeSlice	-	La date / l'heure de la prochaine tranche horaire à calculer. Ce paramètre peut être réinitialisé à une date/heure antérieure, auquel cas le système recalculera à nouveau tous les intervalles à partir de la date et de l'heure données.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.CustomCompress		Le nom d'une procédure stockée, dans JTELStats2, qui est appelé après que les statistiques du système discutées ci-dessous ont été agrégées. Cela peut être utilisé pour fournir des valeurs supplémentaires dans des tableaux supplémentaires comme requis par une installation personnalisée. REMARQUE: changer les tableaux CompressedU eux-mêmes est NON soutenu.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.CustomCompress.SuppressErrors	0	Réglé sur 1, pour supprimer les erreurs dans la routine CustomCompress. Si ce drapeau est activé, le système poursuivra les calculs pour les données, même si la routine personnalisée lance des erreurs.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.EndTime	02:50	L'heure de fin au-delà de laquelle le processus ne s'exécute pas, et attend que l'heure de début soit passée avant de continuer. S'il est vide, le processus s'exécute tout le temps.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.StartTime	22:00	L'heure de début après laquelle le processus commencera à s'exécuter jusqu'à l'heure de fin spécifiée. S'il est vide, le processus s'exécute tout le temps.

Requête

Deux tableaux sont fournis, CompressedUA15 (tranches de temps de 15 minutes) et CompressedUADay (compression de jour), agrégés selon les requêtes suivantes.

La première interrogation regroupe les appels faits À l'agent ou PAR l'agent (appels directs de l'ACD et appels transférés à l'agent, cliquer pour composer les appels et composer les appels) :

Translations Ignore

Code Block

title	Requête CompressedUA 1

SELECT UsersID, (Various Aggregations) FROM JTELStats.StatisticsPartB b LEFT JOIN JTELStats.StatisticsPartA a ON b.StatisticsPartAID = a.ID WHERE ( b.ClientsID = _ClientsID ) AND ( b.dtCallStart BETWEEN _Timeslice_Begin AND Timeslice_End_ );

La deuxième requête regroupe les appels effectués par l'agent (appels transférés par l'agent) :

Translations Ignore

Code Block

title	Requête CompressedUA 2

SELECT OriginUsersID, (Various Aggregations) FROM JTELStats.StatisticsPartB b JOIN JTELStats.StatisticsPartA a ON b.StatisticsPartAID = a.ID WHERE ( b.ClientsID = _ClientsID ) AND ( b.dtCallStart BETWEEN _Timeslice_Begin AND Timeslice_End_ ) AND ( b.OriginUsersID IS NOT NULL );

Répartition et agrégations

Lorsque les données sont agrégées, elles sont divisées en plusieurs partitions cohérentes, selon la logique suivante. Les agrégats qui en résultent comptent alors soit un appel, si une condition est remplie, soit déterminent le temps entre deux horodatages.

Répartition des entrées et des sorties

bOutbound	Répartition
0	Entrant
1	Sortie

Partitionnement sur CONNRES

Tous les résultats sont partitionnés par CONNRES.

CONNRES	Champ
1	OK
2	Pas de réponse
3	Occupé
4	Raccrochage de l'appelant
6	Rejeter
0, 5, 6	Échec

Entrant: Partitionnement sur Appels to ID utilisateurs

StatisticsPartBOrigin	Champ	Signification
NULL	Direct_*	Appel direct à l'agent
NOT NULL	FromTransfer_*	Appel transféré à l'agent

Entrant: Partitionnement sur les appels effectués par OriginUsersID

bTransferExternalNumber	bTransferAgent	Champ	Signification
1		TransferOut_Number_*	Appel transféré par l'agent vers un numéro externe
	1	TransferOut_Agent_*	Appel transféré par agent à un autre agent
0	0	TransferOut_Group_*	Appel transféré par agent au groupe

Sortant : Répartition sur DiallerCampaignsID

DiallerCampaignsID	Champ	Signification
NULL	ClickToDial_*	L'agent a effectué un clic pour composer
NOT NULL	Dialler_*	Agent travaillant dans la campagne de numérotation et numérotation effectuée en dehors

Tableaux

CompressedUA15

Ce tableau contient des statistiques compressées pour des intervalles de 15 minutes.

CompressedUADay

Ce tableau contient des statistiques compressées pour les intervalles de jours.

Champs

Les définitions des champs sont essentiellement les mêmes, dans les deux tableaux, seuls les intervalles d'agrégation sont différents.

Champ	Type	Contenu
ID	INT	Un identifiant unique est attribué à chaque enregistrement. Notez que les ID ne sont pas réutilisés, car si un intervalle est recalculé, l'enregistrement est ajouté avec REMPLACER, c'est-à-dire que l'enregistrement existant sera supprimé et un nouvel enregistrement avec un nouvel ID sera créé à sa place.
ClientsID	INT	ID du client à partir du tableau des clients.
UsersID	INT	L'ID de l'utilisateur à partir du tableau des utilisateurs.
UsersProfilesID	INT	L'ID du profil d'utilisateur de UserProfiles dans lequel l'agent était connecté, ou 0 si aucune information de profil n'est disponible.
ServiceNumbersID	INT	ID du numéro de service à partir du tableau ServiceNumbers.
DynamicPriorityGroupsID	INT	ID du groupe de priorité dynamique de la table DynamicPriorityGroups, ou 0 si aucun groupe de priorité dynamique n'a été attribué.
RoutingApplicationsID	INT	ID de l'application de routage à partir du tableau des applications de routage, ou 0 si l'application n'est pas disponible.
AcdGroupsID	INT	ID du groupe ACD, à partir du tableau AcdGroups, ou 0 si aucun groupe ACD n'est disponible.
DiallerCampaignsID	INT	ID de la campagne de numérotation, à partir du tableau DiallerCampaigns, ou 0 si aucune campagne de numérotation n'est disponible.
dtIntervalStart	DATETIME	Date et heure du début de l'intervalle.
UsersUID	VARCHAR(64)	Le champ UsersUID.
UsersName	VARCHAR(64)	Le nom de l'utilisateur.
UsersFirstName	VARCHAR(64)	Le prénom des utilisateurs.
UsersProfilesName	VARCHAR(64)	Le nom des profils des utilisateurs.
ServiceNumbersRootNumber	VARCHAR(32)	Le champ RootNumber du numéro de service, tel qu'il a été configuré lors de la création des statistiques compressées.
ServiceNumbersName	VARCHAR(64)	Le champ Nom du numéro de service, tel qu'il a été configuré lors de la création des statistiques compressées.
ServiceNumbersName2	VARCHAR(64)	Le champ Name2 du numéro de service, tel qu'il a été configuré lors de la création des statistiques compressées.
DynamicPriorityGroupsName	VARCHAR(64)	Le champ Nom de la table DynamicPriorityGroups, tel qu'il a été configuré lors de la création des statistiques compressées.
AcdGroupsName	VARCHAR(64)	Le champ Nom de la table AcdGroups, tel qu'il a été configuré lors de la création des statistiques compressées.
Direct_Count	INT	Appels entrants directement à l'agent, total offert.
Direct_OK_Count	INT	Appels Entrantsdirectement à l'agent, répondu.
Direct_OK_Time_CallStart_CallConnect_Total	BIGINT	Appels Entrants directement à l'agent, répondu, nombre total de secondes de dtCallStart à dtCallConnect.
Direct_OK_Time_CallStart_CallConnect_Max	INT	Appels Entrants directement à l'agent, répondu, max. secondes de dtCallStart à dtCallConnect.
Direct_OK_Time_CallConnect_CallEnd_Total	BIGINT	Appels Entrants directement à l'agent, répondu, max. secondes de dtCallConnect à dtCallEnd.
Direct_OK_Time_CallConnect_CallEnd_Max	INT	Appels Entrantsdirectement à l'agent, répondu, max. secondes de dtCallConnect à dtCallEnd.
AgentCalls_OK_PostCall_Count	INT	Appels Entrantsdirectement à l'agent, répondu, nombre d'appels avec travail post-appel.
Direct_OK_PostCall_Time_Total	BIGINT	Appels Entrantsdirectement à l'agent, répondu, temps total de travail après l'appel.
Direct_OK_PostCall_Time_Max	INT	Appels Entrantsdirectement à l'agent, répondu, temps maximum dans le travail après-appel.
Direct_NoAnswer_Count	INT	Appels Entrantsdirectement à l'agent, sans réponse.
Direct_NoAnswer_Time_CallStart_CallEnd_Total	BIGINT	Appels Entrantsdirectement à l'agent, sans réponse, nombre total de secondes entre dtCallStart et dtCallEnd.
Direct_NoAnswer_Time_CallStart_CallEnd_Max	INT	Appels Entrantsdirectement à l'agent, sans réponse, secondes maximum entre dtCallStart et dtCallEnd.
Direct_Busy_Count	INT	Appels Entrantsdirectement à l'agent, occupé.
Direct_CallerHangup_Count	INT	Appels Entrantsdirectement à l'agent, l'appelant raccroche.
Direct_CallerHangup_Time_CallStart_CallEnd_Total	BIGINT	Appels Entrantsdirectement à l'agent, raccrochage de l'appelant, total des secondes entre dtCallStart et dtCallEnd.
Direct_CallerHangup_Time_CallStart_CallEnd_Max	INT	Appels Entrantsdirectement à l'agent, raccrochage de l'appelant, secondes maximum entre dtCallStart et dtCallEnd.
Direct_Reject_Count	INT	Appels Entrantsdirectement à l'agent, rejeté.
Direct_Reject_Time_CallStart_CallEnd_Total	BIGINT	Appels Entrantsdirectement à l'agent, rejeté, nombre total de secondes de dtCallStart à dtCallEnd.
Direct_Reject_Time_CallStart_CallEnd_Max	INT	Appels Entrants directement à l'agent, rejeté, maximum de secondes entre dtCallStart et dtCallEnd.
Direct_Failure_Count	INT	Appels Entrantsdirectement à l'agent, a échoué.
FromTransfer_Count	INT	Appels Entrantstransféré à l'agent, total offert.
FromTransfer_OK_Count	INT	Appels Entrantstransféré à l'agent, a répondu.
FromTransfer_OK_Time_CallStart_CallConnect_Total	BIGINT	Appels Entrants transféré à l'agent, répondu, nombre total de secondes de dtCallStart à dtCallConnect.
FromTransfer_OK_Time_CallStart_CallConnect_Max	INT	Appels Entrants transféré à l'agent, répondu, max. secondes de dtCallStart à dtCallConnect.
FromTransfer_OK_Time_CallConnect_CallEnd_Total	BIGINT	Appels Entrants transféré à l'agent, répondu, nombre total de secondes de dtCallConnect à dtCallEnd.
FromTransfer_OK_Time_CallConnect_CallEnd_Max	INT	Appels Entrants transféré à l'agent, répondu, max. secondes de dtCallConnect à dtCallEnd.
FromTransfer_OK_PostCall_Count	INT	Appels Entrants transféré à l'agent, répondu, nombre d'appels avec travail post-appel.
FromTransfer_OK_PostCall_Time_Total	BIGINT	Appels Entrants transféré à l'agent, répondu, temps total de travail après l'appel.
FromTransfer_OK_PostCall_Time_Max	INT	Appels Entrants transféré à l'agent, répondu, temps maximum dans le travail post-appel.
FromTransfer_NoAnswer_Count	INT	Appels Entrants transféré à l'agent, sans réponse.
FromTransfer_NoAnswer_Time_CallStart_CallEnd_Total	BIGINT	Appels Entrants transféré à l'agent, sans réponse, nombre total de secondes entre dtCallStart et dtCallEnd.
FromTransfer_NoAnswer_Time_CallStart_CallEnd_Max	INT	Appels Entrants transféré à l'agent, pas de réponse, secondes maximum entre dtCallStart et dtCallEnd.
FromTransfer_Busy_Count	INT	Appels Entrants transféré à l'agent, occupé.
FromTransfer_CallerHangup_Count	INT	Appels Entrants transféré à l'agent, l'appelant raccroche.
FromTransfer_CallerHangup_Time_CallStart_CallEnd_Total	BIGINT	Appels Entrants transféré à l'agent, raccrochage de l'appelant, total des secondes entre dtCallStart et dtCallEnd.
FromTransfer_CallerHangup_Time_CallStart_CallEnd_Max	INT	Appels Entrants transféré à l'agent, raccrochage de l'appelant, secondes maximum entre dtCallStart et dtCallEnd.
FromTransfer_Reject_Count	INT	Appels Entrants transféré à l'agent, rejeté.
FromTransfer_Reject_Time_CallStart_CallEnd_Total	BIGINT	Appels Entrants transféré to agent, rejected, total seconds from dtCallStart to dtCallEnd.
FromTransfer_Reject_Time_CallStart_CallEnd_Max	INT	Appels Entrants transféré à l'agent, rejeté, max. secondes de dtCallStart à dtCallEnd.
FromTransfer_Failure_Count	INT	Appels Entrantstransféré à l'agent, a échoué.
TransferOut_Number_Count	INT	Appels Entrants transféré au nombre par agent, total des tentatives.
TransferOut_Number_OK_Count	INT	Appels Entrants transféré au numéro par l'agent, répondu.
TransferOut_Number_OK_Time_CallStart_CallConnect_Total	BIGINT	Appels Entrantstransféré au numéro par agent, répondu, nombre total de secondes de dtCallStart à dtCallConnect.
TransferOut_Number_OK_Time_CallStart_CallConnect_Max	INT	Appels Entrants transféré au numéro par l'agent, répondu, max. secondes de dtCallStart à dtCallConnect.
TransferOut_Number_OK_Time_CallConnect_CallEnd_Total	BIGINT	Appels Entrants transféré au numéro par agent, répondu, total des secondes de dtCallConnect à dtCallEnd.
TransferOut_Number_OK_Time_CallConnect_CallEnd_Max	INT	Appels Entrantstransféré au numéro par l'agent, répondu, max. secondes de dtCallConnect à dtCallEnd.
TransferOut_Number_NoAnswer_Count	INT	Appels Entrantstransféré au numéro par l'agent, pas de réponse.
TransferOut_Number_NoAnswer_Time_CallStart_CallEnd_Total	BIGINT	Appels Entrantstransféré au numéro par l'agent, pas de réponse, total des secondes de dCallStart à dtCallEnd.
TransferOut_Number_NoAnswer_Time_CallStart_CallEnd_Max	INT	Appels Entrantstransféré au numéro par l'agent, pas de réponse, max. secondes à partir de dCallStart to dtCallEnd.
TransferOut_Number_Busy_Count	INT	Appels Entrants transféré au numéro par agent, occupé.
TransferOut_Number_CallerHangup_Count	INT	Appels Entrantstransféré au numéro par l'agent, l'appelant raccroche.
TransferOut_Number_CallerHangup_Time_CallStart_CallEnd_Total	BIGINT	Appels Entrantstransféré au numéro par l'agent, raccrochage de l'appelant, nombre total de secondes entre dCallStart et dtCallEnd.
TransferOut_Number_CallerHangup_Time_CallStart_CallEnd_Max	INT	Appels Entrantstransféré au numéro par l'agent, raccrochage de l'appelant, secondes maximum entre dCallStart et dtCallEnd.
TransferOut_Number_Reject_Count	INT	Appels Entrantstransféré au numéro par agent, rejeté.
TransferOut_Number_Reject_Time_CallStart_CallEnd_Total	BIGINT	Appels Entrantstransféré au numéro par agent, rejeté, nombre total de secondes de dCallStart à dtCallEnd.
TransferOut_Number_Reject_Time_CallStart_CallEnd_Max	INT	Appels Entrantstransféré au numéro par agent, rejeté, max. secondes de dCallStart à dtCallEnd.
TransferOut_Number_Failure_Count	INT	Appels Entrantstransféré au numéro par l'agent, a échoué.
TransferOut_Group_Count	INT	Appels Entrants transféré au groupe par agent, tentatives totales.
TransferOut_Group_OK_Count	INT	Appels Entrants transféré vers group par agent, a répondu.
TransferOut_Group_OK_Time_CallStart_CallConnect_Total	BIGINT	Appels Entrants transféré vers group par agent, répondu, nombre total de secondes entre dtCallStart et dtCallConnect.
TransferOut_Group_OK_Time_CallStart_CallConnect_Max	INT	Appels Entrants transféré vers group par agent, répondu, secondes maximum de dtCallStart à dtCallConnect.
TransferOut_Group_OK_Time_CallConnect_CallEnd_Total	BIGINT	Appels Entrants transféré vers group par agent, répondu, nombre total de secondes entre dtCallConnect et dtCallEnd.
TransferOut_Group_OK_Time_CallConnect_CallEnd_Max	INT	Appels Entrants transféré vers group par agent, répondu, max. secondes de dtCallConnect à dtCallEnd.
TransferOut_Group_NoAnswer_Count	INT	Appels Entrants transféré vers group par l'agent, pas de réponse.
TransferOut_Group_NoAnswer_Time_CallStart_CallEnd_Total	BIGINT	Appels Entrants transféré vers group par agent, pas de réponse, nombre total de secondes entre dCallStart et dtCallEnd.
TransferOut_Group_NoAnswer_Time_CallStart_CallEnd_Max	INT	Appels Entrants transféré vers groupe par agent, pas de réponse, maximum de secondes à partir de dCallStart à dtCallEnd.
TransferOut_Group_Busy_Count	INT	Appels Entrants transféré vers groupe par agent, occupé.
TransferOut_Group_CallerHangup_Count	INT	Appels Entrants transféré vers groupe par l'agent, l'appelant raccroche.
TransferOut_Group_CallerHangup_Time_CallStart_CallEnd_Total	BIGINT	Appels Entrants transféré vers groupe par agent, raccrochage de l'appelant, total des secondes entre dCallStart et dtCallEnd.
TransferOut_Group_CallerHangup_Time_CallStart_CallEnd_Max	INT	Appels Entrants transféré vers groupe par agent, raccrochage de l'appelant, secondes maximum entre dCallStart et dtCallEnd.
TransferOut_Group_Reject_Count	INT	Appels Entrants transféré vers groupe by agent, rejected.
TransferOut_Group_Reject_Time_CallStart_CallEnd_Total	BIGINT	Appels Entrants transféré vers groupe par agent, rejeté, nombre total de secondes entre dCallStart et dtCallEnd.
TransferOut_Group_Reject_Time_CallStart_CallEnd_Max	INT	Appels Entrants transféré vers groupe par agent, rejeté, max. secondes entre dCallStart et dtCallEnd.
TransferOut_Group_Failure_Count	INT	Appels Entrants transféré vers groupe par agent, a échoué.
TransferOut_Agent_Count	INT	Appels Entrantstransféré à l'agent par l'agent, tentatives totales.
TransferOut_Agent_OK_Count	INT	Appels Entrants transféré vers agent par agent, répondu.
TransferOut_Agent_OK_Time_CallStart_CallConnect_Total	BIGINT	Appels Entrants transféré vers agent par agent, répondu, nombre total de secondes entre dtCallStart et dtCallConnect.
TransferOut_Agent_OK_Time_CallStart_CallConnect_Max	INT	Appels Entrants transféré vers agent par agent, répondu, secondes maximum de dtCallStart à dtCallConnect.
TransferOut_Agent_OK_Time_CallConnect_CallEnd_Total	BIGINT	Appels Entrants transféré vers agent par agent, répondu, nombre total de secondes entre dtCallConnect et dtCallEnd.
TransferOut_Agent_OK_Time_CallConnect_CallEnd_Max	INT	Appels Entrants transféré vers agent par agent, répondu, max. secondes de dtCallConnect à dtCallEnd.
TransferOut_Agent_NoAnswer_Count	INT	Appels Entrants transféré vers agent by the agent, no answer.
TransferOut_Agent_NoAnswer_Time_CallStart_CallEnd_Total	BIGINT	Appels Entrants transféré vers agent par agent, pas de réponse, nombre total de secondes entre dCallStart et dtCallEnd.
TransferOut_Agent_NoAnswer_Time_CallStart_CallEnd_Max	INT	Appels Entrants transféré vers agent par agent, pas de réponse, maximum de secondes à partir de dCallStart à dtCallEnd.
TransferOut_Agent_Busy_Count	INT	Appels Entrants transféré vers agent par agent, occupé.
TransferOut_Agent_CallerHangup_Count	INT	Appels Entrants transféré vers agent par l'agent, l'appelant raccroche.
TransferOut_Agent_CallerHangup_Time_CallStart_CallEnd_Total	BIGINT	Appels Entrants transféré vers agent par agent, raccrochage de l'appelant, total des secondes entre dCallStart et dtCallEnd.
TransferOut_Agent_CallerHangup_Time_CallStart_CallEnd_Max	INT	Appels Entrants transféré vers agent par agent, raccrochage de l'appelant, secondes maximum entre dCallStart et dtCallEnd.
TransferOut_Agent_Reject_Count	INT	Appels Entrants transféré vers agent par agent, rejeté.
TransferOut_Agent_Reject_Time_CallStart_CallEnd_Total	BIGINT	Appels Entrants transféré vers agent par agent, rejeté, nombre total de secondes entre dCallStart et dtCallEnd.
TransferOut_Agent_Reject_Time_CallStart_CallEnd_Max	INT	Appels Entrants transféré vers agent par agent, rejeté, max. secondes entre dCallStart et dtCallEnd.
TransferOut_Agent_Failure_Count	INT	Appels Entrants transféré vers agent par agent, a échoué.
ClickToDial_Count	INT	Sortant, cliquez pour composer, total.
ClickToDial_OK_Count	INT	Sortant, cliquez pour composer, OK.
ClickToDial_OK_Time_CallStart_CallConnect_Total	INT	Sortant, cliquez pour composer, OK, secondes totales de dtCallStart à dtCallConnect (au tronçon de destination).
ClickToDial_OK_Time_CallStart_CallConnect_Max	INT	Sortant, cliquez pour composer, OK, secondes maximum entre dtCallStart et dtCallConnect (vers le segment de destination).
ClickToDial_OK_Time_CallConnect_CallEnd_Total	INT	Sortant, cliquez pour composer, OK, le nombre total de secondes entre dtCallConnect et dtCallEnd (vers le segment de destination).
ClickToDial_OK_Time_CallConnect_CallEnd_Max	INT	Sortant, cliquez pour composer, OK, secondes maximum entre dtCallConnect et dtCallEnd (vers le segment de destination).
ClickToDial_NoAnswer_Count	INT	Sortant, cliquez pour composer, pas de réponse.
ClickToDial_NoAnswer_Time_CallStart_CallEnd_Total	INT	Sortant, cliquez pour composer, OK, secondes totales de dtCallStart à dtCallEnd (jusqu'au segment de destination).
ClickToDial_NoAnswer_Time_CallStart_CallEnd_Max	INT	Sortant, cliquez pour composer, OK, secondes maximum entre dtCallStart et dtCallEnd (jusqu'à l'étape de destination).
ClickToDial_Busy_Count	INT	Sortant, cliquez pour composer, occupé.
ClickToDial_AgentHangup_Count	INT	Sortant, cliquez pour composer, l'agent raccroche avant que l'appel ne soit connecté.
ClickToDial_Reject_Count	INT	Sortant, cliquez pour composer, rejeté.
ClickToDial_Failure_Count	INT	Sortant, cliquez pour composer, échoué.
Dialler_Count	INT	Sortants, du campagne composeur, total.
Dialler_OK_Count	INT	Sortants, du campagne composeur, OK.
Dialler_OK_Time_CallStart_CallConnect_Total	INT	Sortants, du campagne composeur, OK, secondes totales de dtCallStart à dtCallConnect (au tronçon de destination).
Dialler_OK_Time_CallStart_CallConnect_Max	INT	Sortants, du campagne composeur, OK, secondes maximum entre dtCallStart et dtCallConnect (vers le segment de destination).
Dialler_OK_Time_CallConnect_CallEnd_Total	INT	Sortants, du campagne composeur, OK, secondes totales de dtCallConnect à dtCallEnd (au tronçon de destination).
Dialler_OK_Time_CallConnect_CallEnd_Max	INT	Sortants, du campagne composeur, OK, secondes maximum entre dtCallConnect et dtCallEnd (vers le segment de destination).
Dialler_NoAnswer_Count	INT	Sortants, du campagne composeur, pas de réponse.
Dialler_NoAnswer_Time_CallStart_CallEnd_Total	INT	Sortants, du campagne composeur, OK, secondes totales de dtCallStart à dtCallEnd (jusqu'au segment de destination).
Dialler_NoAnswer_Time_CallStart_CallEnd_Max	INT	Sortants, du campagne composeur, OK, secondes maximum entre dtCallStart et dtCallEnd (jusqu'à l'étape de destination).
Dialler_Busy_Count	INT	Sortants, du campagne composeur, occupé.
Dialler_AgentHangup_Count	INT	Sortants, du campagne composeur, l'agent raccroche avant que l'appel ne soit connecté.
Dialler_Reject_Count	INT	Sortants, du campagne composeur, rejeté.
Dialler_Failure_Count	INT	Sortants, du campagne composeur, échoué.

Page tree

Page History

Versions Compared

Old Version 16

New Version 17

Key

Background

Parameters

Query

Partitioning and Aggregations

Partitioning Inbound and Outbound

Inbound: Partitioning on calls to UsersID

Inbound: Partitioning on calls made by OriginUsersID

Outbound: Partitioning on DiallerCampaignsID

Tables

CompressedUADay

Fields

Hintergrund

Parameters

Parameter

Query

Abfrage

Partitioning and Aggregations

Partitioning Inbound and Outbound

Partitionierung und Aggregationen

Partitionierung Eingehend und Ausgehend

Eingehend: Partitionierung von Anrufen an UsersID

Eingehend: Partitionierung von Anrufen getätigt von OriginUsersID

Outbound: Partitioning on DiallerCampaignsID

Tables

CompressedUADay

Fields

Tabellen

CompressedUADay

Felder

Background

Paramètres

Requête

Répartition et agrégations

Répartition des entrées et des sorties

Entrant: Partitionnement sur Appels to ID utilisateurs

Entrant: Partitionnement sur les appels effectués par OriginUsersID

Sortant : Répartition sur DiallerCampaignsID

Tableaux

CompressedUADay

Champs