| Table of Contents |
|---|
| maxLevel | 2 |
|---|
| outline | true |
|---|
| type | flat |
|---|
|
DescriptionThis report contains itemised call details for all calls made using a selection of service numbers. The calls are reported whether they only use the IVR, the IVR and the ACD or just the ACD. Both inbound and outbound calls are reported. | Warning |
|---|
NOTE: To allow for future extensions NO assumptions on the ordering of columns should be made when processing the raw data. The logic in the processor MUST always read the column headers to ascertain the position of the relevant columns in the report. The processing of raw CSV files without headers is NOT supported. |
Row and Column PopulationRowsAt least one row per call is produced. There will be additional rows in the report if more than one of any of the following actions happens: - An outdial is made from the IVR
- An acd group is entered but no agents are called
- An outdial is made from an ACD group to an agent
- The call is transferred to another agent or an external destination
- A group to group transfer is made
ColumnsThe columns are grouped into 4 areas, populated as follows: The system records data as follows: | Column Group | Recorded when |
|---|
| a | Always populated. | | b1 | A call is made from the IVR to any destination, using one of the Connect Calls objects. | | acdb | The call enters an ACD group (inbound) or is associated with an ACD group (outbound or dialler). | | b2 | A call is made from the ACD to: - An agent to distribute the call
- An external destination (because of a group rule)
- An agent as a result of a call transfer
- An external destination as the result of a call transfer
|
Cases| Call Scenario | Rows Produced | a | b1 | acdb | b2 | Can be Produced by Outbound Calls |
|---|
| Call enters the IVR and the caller hangs up in the IVR. No attempt to transfer the call is ever made. | One row | Populated | NULL | NULL | NULL | SOAP / REST API Outbound Calls | | Call enters the IVR and at least one attempt is made to connect the call to a destination in the IVR. | One row for each connect attempt | Populated | Populated | NULL | NULL | SOAP / REST API Outbound Calls | | Call enters an ACD group but no agent calls are made, because no agents are available. | One row | Populated | NULL | Populated | NULL | NoAll click to dial or dialler calls. | | Call enters an ACD group and attempts are made to reach an agent or external destination. | One row for each call attempt | Populated | NULL | Populated | NULLPopulated | All click to dial or dialler calls. |
ColumnsThe following columns are provided. Legenda - Columns| Column | Source Table
(when not StatisticsPartA) | Field |
|---|
| a_IDStatisticsPartA |
| ID | | a_ServiceNumbersID | StatisticsPartA |
| ServiceNumbersID | | a_ServiceNumbersName | ServiceNumbers | Name | | a_ServiceNumbersName2 | ServiceNumbers | Name2 | | a_DynamicPriorityGroupsID | StatisticsPartA |
| DynamicPriorityGroupsID | | a_DynamicPriorityGroupsName | DynamicPriorityGroups | Name | | a_ANumber | StatisticsPartA |
| ANumber | | a_BNumberStatisticsPartA |
| BNumber | | a_bOutbound | StatisticsPartA |
| bOutbound | | a_dtCallStart | StatisticsPartA |
| dtCallStart | | a_dtCallAlert | StatisticsPartA |
| dtCallAlert | | a_dtCallConnectStatisticsPartA |
| dtCallConnect | | a_dtCallEndStatisticsPartA |
| dtCallEnd | | a_bCallerHangupStatisticsPartA |
| bCallerHangup | | a_CauseCodesID | StatisticsPartA |
| CauseCodesID | | a_RoutingApplicationsID | StatisticsPartA |
| RoutingApplicationsID | | a_RoutingApplicationsName | RoutingApplications | Name | | a_CONNRES | StatisticsPartA |
| CONNRES | | a_UserData | StatisticsPartA |
| UserData | | a_UserData2 |
| UserData2 | | a_UserData3 |
| UserData3UserData | | a_DiallerCampaignsIDStatisticsPartA |
| DiallerCampaignsID | | a_DiallerCampaignsName | DiallerCampaigns | Name | | a_AcdEventsID |
| AcdEventsID |
b1 - Columns| Column | Source Table
(when not StatisticsPartB) | Field |
|---|
| b1_ID | StatisticsPartB |
| ID | | b1_ANumber | StatisticsPartB |
| ANumber | | b1_BNumber | StatisticsPartB |
| BNumber | | b1_dtCallStart | StatisticsPartB |
| dtCallStart | | b1_dtCallAlertStatisticsPartB |
| dtCallAlert | | b1_dtCallConnect | StatisticsPartB |
| dtCallConnect | | b1_dtWhisperEndStatisticsPartB |
| dtWhisperEnd | | b1_dtCallEndStatisticsPartB |
| dtCallEnd | | b1_bCallerHangupStatisticsPartB |
| bCallerHangup | | b1_CauseCodesID | StatisticsPartB |
| CauseCodesID | | b1_CNumbersID | StatisticsPartB |
| CNumbersID | | b1_CNumbersName | CNumbers | Name | | b1_CONNRES | StatisticsPartB |
| CONNRES |
acdb - Columns| Column | Source Table
(when not AcdStatisticsPartB) | Field |
|---|
| acdb_ID |
| ID | | acdb_AcdGroupsIDAcdStatisticsPartB |
| AcdGroupsID | | acdb_AcdGroupsName | AcdGroups | Name | | acdb_AcdConfigurationGroupsIDAcdStatisticsPartB |
| AcdConfigurationGroupsID | | acdb_AcdConfigurationGroupsName | AcdGroups | Name | | acdb_AcdGroupEndReasonsID | AcdStatisticsPartB |
| AcdGroupEndReasonsID | | acdb_AcdGroupEndReasonsName | AcdGroupEndReasons | Name (via ShortTexts) | | acdb_AcdGroupActionListID | AcdStatisticsPartB |
| AcdGroupActionListID | | acdb_AcdGroupActionListName | AcdGroupActionList | Name | | acdb_AcdGroupActionTypesIDAcdStatisticsPartB |
| AcdGroupActionTypesID | | acdb_AcdGroupActionTypesName | AcdGroupActionTypes | Name (via ShortTexts) | | acdb_AcdGroupCheckPointsIDAcdStatisticsPartB |
| AcdGroupCheckPointsID | | acdb_AcdGroupCheckPointsName | AcdGroupCheckPoints | Name (via ShortTexts) | | acdb_nPriorityGroupStartAcdStatisticsPartB |
| nPriorityGroupStart | | acdb_nPriorityGroupEnd | AcdStatisticsPartB |
| nPriorityGroupEnd | | acdb_dtGroupStart | AcdStatisticsPartB |
| dtGroupStart | | acdb_dtAnnouncement1Start | AcdStatisticsPartB |
| dtAnnouncement1Start | | acdb_dtAnnouncement2Start | AcdStatisticsPartB |
| dtAnnouncement2Start | | acdb_dtQueueStartAcdStatisticsPartB |
| dtQueueStart | | acdb_dtDistributeStartAcdStatisticsPartB |
| dtDistributeStart | | acdb_dtAgentConnect | AcdStatisticsPartB |
| dtAgentConnect | | acdb_dtGroupActionStart | AcdStatisticsPartB |
| dtGroupActionStart | | acdb_dtGroupEnd | AcdStatisticsPartB |
| dtGroupEnd | | acdb_bLastAgentConnect | AcdStatisticsPartB |
| bLastAgentConnect | | acdb_bCallbackVoiceMailBooked | AcdStatisticsPartB |
| bCallbackVoiceMailBooked | | acdb_bCallInStandardServiceTimesAcdStatisticsPartB |
| bCallInStandardServiceTimes | | acdb_AcdSkillsID1 | AcdStatisticsPartB |
| AcdSkillsID1 | | acdb_AcdSkillsName1 | AcdSkills | Name | | acdb_bDeletedAcdSkillsID1AcdStatisticsPartB |
| bDeletedAcdSkillsID1 | | acdb_AcdSkillsID2AcdStatisticsPartB |
| AcdSkillsID2 | | acdb_AcdSkillsName2 | AcdSkills | Name | | acdb_bDeletedAcdSkillsID2AcdStatisticsPartB |
| bDeletedAcdSkillsID2 | | acdb_AcdSkillsID3 | AcdStatisticsPartB |
| AcdSkillsID3 | | acdb_AcdSkillsName3 | AcdSkills | Name | | acdb_bDeletedAcdSkillsID3 | AcdStatisticsPartB |
| bDeletedAcdSkillsID3 | | acdb_nOverflowLevelIndicator | AcdStatisticsPartB |
| nOverflowLevelIndicator | | acdb_ExtendedGroupSearchAcdGroupsIDAcdStatisticsPartB |
| ExtendedGroupSearchAcdGroupsID | | acdb_ExtendedGroupSearchAcdGroupsName | AcdGroups | Name |
b2 - Columns| ColumnCorresponds To | Source Table
(when not StatisticsPartB) | Field |
|---|
| b2_ID |
| ID | | b2_ANumber |
| ANumber | | b2_BNumber |
| BNumber | | b2_dtCallStart |
| dtCallStart | | b2_dtCallAlert |
| dtCallAlert | | b2_dtCallConnect |
| dtCallConnect | | b2_dtWhisperEnd |
| dtWhisperEnd | | b2_dtCallEnd |
| dtCallEnd | | b2_bCallerHangup |
| bCallerHangup | | b2_CauseCodesID |
| CauseCodesID | | b2_CNumbersID |
| CNumbersID | | b2_CNumbersName | CNumbers | Name | | b2_CONNRES |
| CONNRES | | b2_UsersID |
| UsersID | | b2_UsersUID | Users | UID | | b2_UsersName | Users | Name | | b2_UsersFirstName | Users | FirstName | | b2_nSkillReal |
| nSkillReal | | b2_nSkillAfterCorrection |
| nSkillAfterCorrection | | b2_PostCallInterval |
| PostCallInterval | | b2_AcdEventsID |
| AcdEventsID | | b2_TransferAcdSynonymsID |
| TransferAcdSynonymsID | | b2_TransferAcdSynonymsName | AcdSynonyms | Name | | b2_bTransferAgent |
| bTransferAgent | | b2_bTransferExternalNumber |
| bTransferExternalNumber | | b2_StatisticsPartBOrigin |
| StatisticsPartBOrigin | | b2_OriginUsersID |
| OriginUsersID | | b2_nSkillRealOriginUsersUID | Users | UID | | b2_OriginUsersName | Users | Name | | b2_nSkillAfterCorrectionOriginUsersFirstName | Users | FirstName |
| Table of Contents |
|---|
| maxLevel | 2 |
|---|
| outline | true |
|---|
| type | flat |
|---|
|
| 