{"type":"doc","content":[{"type":"paragraph"},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"minLevel":{"value":"1"},"maxLevel":{"value":"2"}},"macroMetadata":{"macroId":{"value":"ab60a89eeb7e1bf6ba2ad0d778f96c6f"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"7cc1abe2-3154-41f2-89fb-3a8d04b2fefd"}},{"type":"paragraph","content":[{"text":"This document describes data structures that are used for reporting data. ","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Data types and formats ","type":"text","marks":[{"type":"strong"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Data generation and storing","type":"text","marks":[{"type":"strong"}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"File naming","type":"text"}]},{"type":"paragraph","content":[{"text":"Data is exported in CSV-format, one csv-file per export type per day.","type":"text"}]},{"type":"paragraph","content":[{"text":"Export files are named useing following pattern: __daily_.csv","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"12c16925-a91d-42d1-ad7d-0aa4dedf1993"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph"}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Example","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Date in format YYYY-MM-DD","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"2020-12-12","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Organization name","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"exampleorg","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Type of export","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"calldetails","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":"The resulting filename is ","type":"text"},{"text":"2020-12-12_exampleorg_daily_calldetails.csv","type":"text","marks":[{"type":"strong"}]},{"text":", which contains ","type":"text"},{"text":"calldetails ","type":"text","marks":[{"type":"link","attrs":{"href":"#calldetails"}}]},{"text":"export of date 2020-12-12.","type":"text"}]},{"type":"paragraph","content":[{"text":"There are two options for data generation: daily and intraday","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Daily","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"All daily files are created at 0300 UTC, containing data from previous day.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Intraday","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Export files are created as 00:15 UTC of current day","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"New data is added to the same file every 5mins.","type":"text"}]}]}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Timestamps ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"All timestamps are in UTC time, unless specifically stated otherwise. ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Phone numbers ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Phone numbers are stored in varchar columns. Numbers are normalized to E164 (+35850123...). Prefixing the numbers with plus-sign varies.","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":1},"content":[{"text":"Export file retention","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"When using Enreach provided SFTP service, generated data export files are removed after 30 days. ","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Call data exports","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Call data is aggregated to two different structures:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Raw call event data is available for ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"DirectCalls","type":"text","marks":[{"type":"link","attrs":{"href":"https://benemen.atlassian.net/wiki/spaces/PD/pages/914948542/Voice+Data+integration+description#DirectCall"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"ServiceCalls","type":"text","marks":[{"type":"link","attrs":{"href":"https://benemen.atlassian.net/wiki/spaces/PD/pages/914948542/Voice+Data+integration+description#ServiceCall"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"ServiceCallDetails","type":"text","marks":[{"type":"link","attrs":{"href":"https://benemen.atlassian.net/wiki/spaces/PD/pages/914948542/Voice+Data+integration+description#ServiceCallDetail"}}]}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Calculated data for calls are","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Calls ","type":"text","marks":[{"type":"link","attrs":{"href":"https://benemen.atlassian.net/wiki/spaces/PD/pages/914948542/Voice+Data+integration+description#CallsExtended"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"CallDetails","type":"text","marks":[{"type":"link","attrs":{"href":"https://benemen.atlassian.net/wiki/spaces/PD/pages/914948542/Voice+Data+integration+description#CallDetails%5BinlineExtension%5D"}}]}]}]}]}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"DirectCall contains calls made directly to (and by) an individual user. Same logical call can also exist in ServiceCall data in two cases: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"User’s incoming calls are handled by BeneCC work number queue. In these cases, ServiceCall.email is that of the targeted user. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"ServiceCalls where Queue name is null can be left out of standard reporting ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"User’s incoming call is transferred to BeneCC. In these cases, ServiceCall.email is that of the targeted user, and Queue name is the first service pool call overflowed to. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Incoming DirectCalls where corresponding CallId exists in ServiceCall and Queue name is not null should be left out of combined reports ","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"DirectCall ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"A single DirectCall entry is created for a call targeting a user directly. It is a simple structure, containing only a single row with no complex sub-event structure that is required for service calls. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Only direct calls classified as ","type":"text"},{"text":"Work ","type":"text","marks":[{"type":"strong"}]},{"text":"are included.","type":"text"}]},{"type":"paragraph","content":[{"text":"Export name: ","type":"text"},{"text":"daily_directcall.csv","type":"text","marks":[{"type":"strong"}]}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"fec01587-8d33-4617-954e-a93edc4766ab"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Column ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Id ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Unique identifier for the entry","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"CallId ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Logical call entry is based on. A single call can result in multiple DirectCall entries for example when call is made from one known user to another and they both have their own entry","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Timestamp ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Connection timestamp for connected calls, arrival timestamp for other","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"TypeId ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Call type. 0 for incoming, 1 for outgoing, 2 for Transfer","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"email ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"email of the user","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"ResultTypeId ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Call result. 0 for answered, 1 for abandoned, 2 for transferred. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"ExternalNumber ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"External party of the call, caller for incoming and called number for outgoing","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"UserNumber ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"User number, caller for outgoing and called number for incoming calls. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Duration ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Call answered duration in seconds for answered calls, 0 for others","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Modified ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"When entry was created or modified. Creation date in practice for now, entry is not modified afterwards. ","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"ServiceCall ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"A single ServiceCall entry is created for each logical call. ","type":"text"}]},{"type":"paragraph","content":[{"text":"In current BeneCC use case, entry is first created with Ongoing result type when call connects to the system but is not yet completed. Result type is updated when call completes. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For reporting use, fetching calls with non-Ongoing result modified since last fetch should be effective. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Export name: ","type":"text"},{"text":"daily_servicecall.csv","type":"text","marks":[{"type":"strong"}]}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"c6f89a7a-9259-43f7-8705-f7f71c4dcdf2"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Column ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Id ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Identifier for the logical call. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Corresponds to DirectCall.CallId","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Timestamp ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Time when call arrived in system","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"queuename ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Name of first queue call arrived in. Normally this means the queue corresponding to the called number. ","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"If call arrived at user personal queue and overflowed to a real queue, this displays the first real queue after the overflow has occurred. ","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"Null if call arrives to personal queue and never overflows to a real queue.","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"email ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Null for calls not arriving to personal queue. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For personal queue use, email of the targeted user.","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"ResultTypeId ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Simplified call result. Processed directly from found ServiceCallDetail rows when call completes. Corresponds to ServiceCallResultTypes, types and logic described below.","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Anum ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Original a-number of the call","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Bnum ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Original b-number call was made to","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Modified ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Modification timestamp. Creation time for new calls and updated when ResultTypeId is updated for completed calls. Used for fetching data to external systems. ","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"ServiceCallResultTypes ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"ResultTypeId is calculated once when call completes. Result is calculated directly by finding a single latest event of types 102=QueueScheduleClosed, 201=UserAnswer, 204=UserTransfer, 300=QueueTransfer. ","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"5ec58182-d18d-4e79-9d7f-e93a62829a2a"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Id ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Name ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Description ","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"0 ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Answered ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Result if 201=UserAnswer is the last event ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"1 ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Abandoned ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Result if not one of the others ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"2 ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Transfered out ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Result if 204=UserTransfer 300=QueueTransfer is last event ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"3 ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"OffSchedule ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Result if 102=QueueScheduleClosed is last event ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"1000 ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Ongoing ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Result when call is still ongoing and the final result is undetermined. ","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"ServiceCallDetail ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Each ServiceCall can have several individual events describing the progress of the call. They are the primary way of performing reporting, as they provide the most detailed info available and provide the flexibility for different kinds of needs. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Export name: ","type":"text"},{"text":"daily_servicecalldetail.csv","type":"text","marks":[{"type":"strong"}]}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"557fc9a3-395e-4271-ad9a-5f0fefb3f53a"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Column ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Id ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Row identifie","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"CallId ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Id of ServiceCall event belongs t","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Timestamp ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Event timestamp","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"EventTypeId ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Event type id. Corresponds to ","type":"text"},{"text":"ServiceCallEventTypes.Id","type":"text","marks":[{"type":"link","attrs":{"href":"http://ServiceCallEventTypes.Id"}}]},{"text":" described belo","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"QueueName","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"name of queue related to the even","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Email","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"email of user related to the even","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Reason ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Descriptive, more detailed info about the event. Values are un-normalized and specific to the underlying system (currently BeneCC), so the column should be used sparingly","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Modified ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Modified timestamp for the row, used for fetching data to external systems. ","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"ServiceCallEventTypes ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"EventTypes represent different events that occur during a call","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"CallConnect (1) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when call connects to the system. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue name is non-null if call was made to a number configured to a real queue. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Email is non-null if call was made to a number configured to a user. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Reason field in BeneCC use describes the type of the attempted target: PersonalWork for users, ServiceQueue for queues. In addition, Reason can also signal an error, for example if call was attempted to an unknown number NotInController is logged.","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"CallDisconnect (2) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when the entire call is disconnected and can be treated as complete. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue name and Email are always null. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Disconnect usually occurs when the caller disconnects either before or after the call is answered, or the answering user disconnects the call. The system itself can also disconnect the call for example when service is closed, and the relevant prompt has been played. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For BeneCC, reason field describes the disconnecting party: local for system disconnects, remote for disconnects triggered by a remote party (either the caller or the answering user).","type":"text"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"QueueArrive (100) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when call is accepted and arrives to an individual queue. Allocation to agents is then attempted if available. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue name is always the queue call arrives in. If Email is non-null, call arrived to a personal queue with logged queue name. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For BeneCC, reason is always null.","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"QueueReject (101) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when queue rejects the call instead of accepting it. The event is not currently used for BeneCC-originated data.","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"QueueScheduleClosed (102) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when call connects to a specific queue that is closed for some reason at the time (usually outside of service hours). ","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue name is the queue that was targeted but is closed. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Email is always null. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For BeneCC, reason is always null.","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"QueueOverflow (103) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when call overflows from one queue to another for some reason. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue name is the attempted overflow target. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Email is always null. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For BeneCC, reason describes the technical reason for overflowing. ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"NoAvailableProviders: No users are available for allocation ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"QueueFull: Maximum queue length was reached ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"QueueTimeout: Maximum queueing time was reached","type":"text"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"QueueAllocateUser (200) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when queue allocates the call to a user. Call can be allocated to multiple users at the same time. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue name is the allocating queue. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Email is the allocated user. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For BeneCC, Reason describes the type of allocating queue: PersonalWork for personal queues, ServiceQueue for real queues.","type":"text"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"UserAnswer (201) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when user answers the allocated call. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue name is the allocating queue. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Email is the answering user. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For BeneCC, Reason describes the type of allocating queue: PersonalWork for personal queues, ServiceQueue for real queues.","type":"text"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"UserDisconnect (202) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when user disconnects the call from UI (BeneDesk). Disconnects from terminals are not logged as separate UserDisconnect events but simply in CallDisconnect. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue name is the allocating queue. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Email is the disconnecting user. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For BeneCC, Reason is always null.","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"UserReject (203) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged either when user rejects the allocated call actively or the allocation is cancelled for some reason. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue name is the allocating queue. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Email is the allocated user. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For BeneCC, Reason describes the reason for reject in more detail: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Timeout: Maximum allocation time was reached. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"CallDisconnected: Call disconnected during allocation. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"GenericUserRejected: User either rejected actively or was found to be unreachable for example due to terminal being busy. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"OtherConnected: Another agent answered the call (for simultaneous allocation).","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"UserTransfer (204) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when answering user requests a call transfer using the UI (BeneDesk). Both internal and external transfers are logged identically, later events describe where the call was actually transferred to. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue name is the queue. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Email is the transferring user. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For BeneCC, Reason contains the transfer target number.","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"UserPark (205) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when answering user parks the call. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue name is the allocating queue. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Email is the answering user. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For BeneCC, Reason is always null.","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"UserUnpark (206) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when answering user unparks the call. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue name is the allocating queue. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Email is the answering user. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For BeneCC, Reason is always null.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"UserOnHold (207) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when answering user places the call on hold. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue name is the allocating queue. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Email is the answering user. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For BeneCC, Reason is always null.","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"UserUnHold (208) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when answering user retrieves the call from hold. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue name is the allocating queue. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Email is the answering user. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For BeneCC, Reason is always null.","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"ExtQuery (250) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when the system queries an external system for routing information, for example to check if the customer should be routed directly to a prioritized queue. Actual query functionality is implementation-specific and related to a custom project. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue name is logged if the query is caused by a queue configuration ","type":"text"}]},{"type":"paragraph","content":[{"text":"Email is logged if query is caused by user configuration ","type":"text"}]},{"type":"paragraph","content":[{"text":"Reason describes the query result. Value can vary by implementation, standard values are ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"OK: query receives an acceptable result ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"NOT_FOUND: no results found","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"ExtTarget (251) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged after an ExtQuery event to describe routing targets received in response. Possible targets are queues, users and direct numbers. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue name is logged if target is a queue ","type":"text"}]},{"type":"paragraph","content":[{"text":"Email is logged if target is a user ","type":"text"}]},{"type":"paragraph","content":[{"text":"Reason contains a semicolon-separated list of detailed information: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"nbr: stored if target is a direct number ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"values: received target number (not necessarily normalized) ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"example: nbr=+358501231234 ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"pr: if multiple targets are received, their relative priority (0 being the highest) ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"values: positive integer ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"example: pr=0; ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"req: whether to wait for target for time specified in parameter ttl. This only applies to user targets ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"values: bit 0/1 ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"example: req=0; ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"ttl: how long requirement is valid. Currently used in combination with req flag to require a specific user ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"values: positive integer, second ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"example: ttl=30;","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"QueueTransfer (300) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when the call is transferred out of the system. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue name is always null. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Email is always null. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For BeneCC, Reason contains the transfer target number.","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"QueueTransferConnect (301) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when externally transferred call connects to the external system (e.g. the transfer was successful). ","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue name is always null. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Email is non-null if transfer targets a number mapped to a known user. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For BeneCC, Reason contains the target number.","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"QueueTransferCancel (302) ","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when external transfer is cancelled or fails. This occurs if the original caller disconnects during transfer, or if the transfer target rejects the incoming call. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue name is always null. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Email is non-null if transfer targets a number mapped to a known user. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For BeneCC, Reason contains the detailed reason for cancel or reject: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"CallDisconnected: Original caller disconnected the call ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"GenericUserRejected: Targeted user rejected the call ","type":"text"}]}]}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":4},"content":[{"text":"SupervisionStatus (320)","type":"text"}]},{"type":"paragraph","content":[{"text":"Supervision status for the call has been changed.","type":"text"}]},{"type":"paragraph","content":[{"text":"Reason contains supervisor name and status ","type":"text"}]},{"type":"paragraph","content":[{"text":":","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"Possible values for status: SilentlyListening, Whispering, Participating, Exited, Entered.","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":4},"content":[{"text":"IvrSelection (400)","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when caller has made (DTMF) IVR menu selection or entered some longer collected input.","type":"text"}]},{"type":"paragraph","content":[{"text":"Reason contains comma separated list of details about IVR selection ","type":"text"}]},{"type":"paragraph","content":[{"text":",,","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"Usercase:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"IVR_MENU ","type":"text","marks":[{"type":"strong"}]},{"text":"if selection happened in IVR menu","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"ALLOC_MENU","type":"text"}]}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"StartBlockingPrompt (401)\t","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when prompt playing that prevents allocation to agents has been started. ","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":4},"content":[{"text":"WrapUpStarted (410)","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when agent wrap-up time started","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":4},"content":[{"text":"WrapUpTerminated (411)","type":"text"}]},{"type":"paragraph","content":[{"text":"Logged when agent wrap-up time was terminated","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":4},"content":[{"text":"CallbackCreated (500)","type":"text"}]},{"type":"paragraph","content":[{"text":"A callback request was created from the call","type":"text"}]},{"type":"paragraph","content":[{"text":"Queue is the last queue before leaving callback requests.","type":"text"}]},{"type":"paragraph","content":[{"text":"Reason contains Id of the Callback list the requests were created.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"CallsExtended","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Combined table consisting of both the Direct and Service Calls and with some measures already calculated at the call level. Contains usually one row per callid.","type":"text"}]},{"type":"paragraph","content":[{"text":" Export name: ","type":"text"},{"text":"daily_calls_extended.csv","type":"text","marks":[{"type":"strong"}]}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"21df9321-1f51-4158-8b34-750913974c40"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Column ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"CallId ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Logical call entry is based on. A single call can result in multiple entries for example when call is made from one known user to another and they both have their own entry","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Timestamp ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Connection timestamp for connected calls, arrival timestamp for other","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"EntryQueue","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Name of the entry queue","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"LastQueue","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Name of the last queue","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"ExternalNumber ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"External party of the call, caller for incoming and called number for outgoing","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"UserNumber ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"User number, caller for outgoing and called number for incoming calls ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"TotalWaitingTime ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Total call waiting time duration in seconds","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"TotalTalkingTime ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Call talking duration in seconds ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"IVRClearedWaitingTime ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Call waiting time duration in seconds, excluding time the call has been in IVR or pre-welcome stages","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"ServiceCall ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is a service call, 1/0 ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"DirectCall ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is a direct call, 1/0 ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Incoming ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is an incoming call, 1/0 ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Outgoing ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is an outgoing call, 1/0 ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Answered ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is an answered incoming call, 1/0 ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"OutAnswered ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is an answered outgoing call, 1/0 ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Transferred ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is the call transferred outside, 1/0 ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Abandoned ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is an abandoned call (disconnected before answer), 1/0 ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Offschedule ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is the call a service call coming when the service pool is closed, 1/0 ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"TransferredToService ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is the direct call overflown or transferred to service pool, 1/0 ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Modified ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"When entry was created or modified. ","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"CallDetails","type":"text","marks":[{"type":"strong"}]},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"calldetails"},"legacyAnchorId":{"value":"VoiceDataintegrationdescription-calldetails"}},"macroMetadata":{"macroId":{"value":"bca2005699247210bd2ec91e5d1bf71b"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"7865a077-f60e-4089-90ac-73ea5e43dd08"}}]},{"type":"paragraph","content":[{"text":"Contains call details related to users and service queues with some measures already calculated. Contains usually multiple rows for each callid. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Export name: ","type":"text"},{"text":"daily_calldetails.csv","type":"text","marks":[{"type":"strong"}]}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"db1931f0-dd05-4c09-a4de-b98aaa906d27"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Column ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"CallId ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Logical call entry is based on. A single call can result in multiple entries for example when call is made from one known user to another and they both have their own entry.","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"OrganisationId","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Id for the customer organisation.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Event_TS","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Timestamp of the call flow event","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"QueueId","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Id of the service pool","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"LastName","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Name of service pool related to the event","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Title ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Type of queue ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Email ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"email of user related to the event","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"WaitingTime ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"call waiting time duration in seconds at user level. How long the call was allocated to a user before, it was answered, canceled or rejected.","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"TalkingTime ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Call talking duration in seconds at user level ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"IVRWaitingTime","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Time spent in IVR menu","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"DirectCallWaitTime","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Waiting time for direct calls","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"QueueWaitingTime ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Call waiting time duration in seconds at queue level","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"QueueTalkingTime ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Call talking duration in seconds at queue level ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"ServiceCall ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is a service call, 1/0 ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"DirectCall ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is a direct call, 1/0 ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"CallConnects ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Call has been connected to the queue, 1/0 ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"UserAnswers ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"User has answered the call, 1/0 ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"UserAllocate ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Call is allocated (offered) to the user, 1/0 ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"AnsweredInQueue ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is the service call answered in the queue, 1/0 ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Incoming ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is an incoming call, 1/0 ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Outgoing ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is an outgoing call, 1/0 ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"TransferredToService ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is the direct call overflown or transferred to service pool, 1/0 ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Modified ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"When entry was created or modified. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"ExternalNumber","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Phone number of external party","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Classification data exports","type":"text"}]},{"type":"paragraph","content":[{"text":"Classification data is exported in three different datasets","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Classifications","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"ClassificationTags","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"ClassificationSchemas","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Classification ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Classifications for calls or external events. ","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"0c40e729-de33-48cd-96ad-497c51665122"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Column ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Id ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Unique id for classification","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Timestamp ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Timestamp for conversation creation ","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Tagschemaid ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Tag schema id for classification ","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Classifiedtypeid ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Classified type: 1 – None, 2 – DirectCall, 3 – ServiceCall, 4 – Email, 5 – CallListItem","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Referencedcallid ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"If classification is related to calls, the corresponding Callid","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Referencedexternalid ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"If classification is related to external systems, the corresponding external id, e.g. message id","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Note ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Classification note, free text","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Createdby ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Email of classifying user","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Modified ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"When entry was created or modified. ","type":"text"}]}]}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Export name: ","type":"text"},{"text":"daily_clasification.csv","type":"text","marks":[{"type":"strong"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"ClassificationTags ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Tags for individual classifications. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Export name: ","type":"text"},{"text":"daily_clasification_tags.csv","type":"text","marks":[{"type":"strong"}]}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"0cb2fb6e-ab90-49d4-81b2-35002f90b741"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Column ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"ClassificationId ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Unique id for classification. Corresponds to ","type":"text"},{"text":"classification.id","type":"text","marks":[{"type":"link","attrs":{"href":"http://classification.id"}}]},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Tagid ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Id for tag","type":"text"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Tagdeleted ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is tag deleted (in classification),1/0","type":"text"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Modified ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"When entry was created or modified. ","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"ClassificationTagSchemas ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Schema information for classification tags. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Export name: ","type":"text"},{"text":"clasification_tag_schemas.csv","type":"text","marks":[{"type":"strong"}]}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"ffc11677-59a3-46ed-9bd2-d87597da608e"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Column ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Schemaid ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Tag schema id ","type":"text"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Schemaname ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Tag schema name ","type":"text"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Groupid ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Tag group id ","type":"text"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Groupname ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Tag group name ","type":"text"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Tagid ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Tag id","type":"text"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Schemaarchived ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is schema archived, 1/0","type":"text"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Schemadeleted ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is schema deleted, 1/0","type":"text"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Grouparchived ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is tag group archived, 1/0","type":"text"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Groupdeleted ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is tag group deleted, 1/0","type":"text"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Tagarchived ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is tag archived, 1/0","type":"text"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Tagdeleted ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Is tag deleted (in schema), 1/0","type":"text"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Modified ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"When entry was created or modified. ","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Callback data exports","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"CallHandling (callback)","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Table consisting of combined presentation of callback request / attempt information. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Limitations to CallHandling -exports in cases where callback process is handled within Dynamics or Salesforce","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Information from callback attempts are not reflected in these data exports.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Requests are closed automatically when they are moved from Enreach Voice services to Dynamics or Salesforce.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"All callback requests are handled / closed by the same user (Salesforce or Dynamics Integration user)","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":" Export name: ","type":"text"},{"text":"daily_call_handling.csv","type":"text","marks":[{"type":"strong"}]}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"ce2d15e9-9d92-49c9-8ace-da2bc0a1571d"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"Column ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"Key_id","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"Unique id for the callback attempt","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"Callback list to which the related request belongs","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"Contactnumber","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"Number of the caller who left the callback request","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"Assigneduser","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"User to who have the callback request has been assigned","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"Channelin","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"Name of the service pool where the call arrived before callback request was created","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"Creationtime","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"Creation time of the related callback request","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"Callbackrequestid ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"Related callback request Id","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"User ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"User who have made the callback attempt","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"Timestamp ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"Timestamp of the callback attempt","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"Callbackattemptypeid (CallBackAttemptType)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"Type Id for the callback attempt, described below.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"Status","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"Status of the related callback request","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"Difference ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"Difference in minutes from callback request creation to attempt.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"Noattempts ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"TBD","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"Callbackattempt ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"Flag for callback attempt (1/0)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"Callbacksuccessful","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"Was callback attempt successful, 1/0","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"Callbacktypeid (CallBackRequestType)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"Type id for the related callback request, described below","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"Callid ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"Callid for the related callback request. Callback request can be identified from the call data exports via the callid.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"Clasificationid ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"Id for the related clasification","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[341.0]},"content":[{"type":"paragraph","content":[{"text":"Modified ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"transparent","rowspan":1,"colwidth":[339.0]},"content":[{"type":"paragraph","content":[{"text":"When entry was created or modified. ","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"CallbackAttemptType","type":"text"}]},{"type":"paragraph","content":[{"text":"Types of attempts that can be created. Different meanings for reporting/informational use, two main logical types (closing and not closing).","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"7f5e163c-122f-453a-9895-1f99629e935b"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Value","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Unknown","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"-1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Unknown value","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"CloseSuccessful","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"0","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Closes request","type":"text","marks":[{"type":"strong"}]},{"text":", handled successfully","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"CloseUnsuccessful","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Closes request","type":"text","marks":[{"type":"strong"}]},{"text":", was not handled","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Busy","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"2","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Contact was busy","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"NoAnswer","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"3","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Contact did not answer","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"OtherAnswered","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"4","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Voicemail, switchboard or some other target answered","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Other","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"5","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Other unspecified","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Noattempts","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"6","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"No attempts have been made. Used for filtering requests.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"CloseExpired","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"7","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Closes request","type":"text","marks":[{"type":"strong"}]},{"text":", expired","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"CallbackRequestType","type":"text"}]},{"type":"paragraph","content":[{"text":"Different types for callback requests","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"df8e5a90-4c1c-49dd-bf7f-7a9bca72ab76"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Value","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Unknown","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"0","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Unknown value. Provided for backwards compatibility, should be disregarded","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Callback","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Callback item","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Overflow","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"2","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Overflow item","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"CallList","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"3","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Call list item","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Any","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"50","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Symbolic \"any\". Requests cannot actually be this type, used for filtering","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"contentbylabel","parameters":{"macroParams":{"cql":{"value":"label = \"integration\""}},"macroMetadata":{"macroId":{"value":"a54c6db6-0e45-440b-b4dd-2af5dbf700de"},"schemaVersion":{"value":"4"},"title":"Filter by label (Content by label)"}},"localId":"f0bc14c9-237e-441a-9bec-6d7ed5fc7576"}},{"type":"paragraph","content":[{"text":" ","type":"text"}]}],"version":1}