...
Table | Alias |
---|---|
StatisticsPartA (See also Table Reference - StatisticsPartA (A) ) | a |
AcdStatisticsPartB (See also Table Reference - AcdStatisticsPartB (AcdB) ) | acdb |
StatisticsPartB (See also Table Reference - StatisticsPartB (B) ) | b |
StatisticsPartO (See also Table Reference - StatisticsPartO ) | o |
Name | Description | Criteria Used | |
---|---|---|---|
Calls | Date / Time | The date the call was initiated | a.dtCallStart |
Start | The time the call was started | a.dtCallStart | |
End | The time the call was ended | a.dtCallEnd | |
Numbers | Caller | Telephone number of the caller(A Number) | |
Service Number | Platform Destination (B Number) | ||
Group | Name | Name of the group | |
Start | The time the call entered the ACD group | acdb.dtGroupStart | |
End | The time the call quit the ACD group | IF ( b.dtCallEnd ='00-00-00 00:00:00', NULL, b.dtCallEnd ) | |
Connected | The time when the agent answered the call | acdb.dtAgentConnect | |
Duration | Total duration of the call | StatisticsPartA.dtCallEnd - StatisticsPartA.dtCallStart | |
Agent | Name | The name of the agent followed by the agent number in brackets | |
Destination Number | Telephone number of the agent (B Number) | StatisticsPartB.BNumber | |
Duration | The connection time with the agent | IF ( b.dtCallConnect IS NOT NULL, (StatisticsPartB.dtCallEnd - StatisticsPartB.dtCallConnect, ), NULL ) | |
Result | Result | Final result of the conversation with the agent:
| b.CONNRES |
...