vFACT_DETAILEDCALLHISTORY
Definition
Calling data about incoming and outgoing calls. Some of the call legs belongs to users and some to technical components of the infrastructure like gateways, voice mail, etc.. Internal calls are present as outgoing calls for the caller and as incoming calls for the called user.
Data Repository: Call Detail Record (CDR)
API: Get Detailed Call History (REST) /cdr_feed
Original field description
This documentation is available from external source: Webex Calling Detailed Call History report
b+s specific fields or modifications
| Field name | Type | Description |
|---|---|---|
| OriginCallingNumber | nvarchar(100) | Number of the caller that initiated the call and is present on the first call leg. |
| OriginCalledNumber | nvarchar(100) | Number that was initially called and is present on the first call leg. |
| OriginCallType | nvarchar(50) | Type of call for the first call leg of a call |
| TotalCallDuration | int | Duration in seconds from the start time to the end time of the call |
| NoCallEvent | int | 1 if the call was not a real call (e.g. when configuring the phone, call park and retrieval, call pickup, monitoring, recording, barge in, etc.) |
| CallCenterCall | Int | 1 if the call was controlled and routed by the Contact Center and therefor also available within Contact Center statistics |
| HuntGroupNumber | nvarchar(100) | Number of the hunt group |
| HuntGroupOffered | Int | 1 if the call was assigned to the hunt group |
| HuntGroupAnswered | Int | 1 if the call was answered by a user or place of the hunt group |
| HuntGroupRedirected | Int | 1 if the call was redirected to another number after being assigned to the hunt group |
| HuntGroupUnanswered | int | 1 if the call was not answered by a user or place of the hunt group and the caller dropped the call |
| HuntGroupRingDuration | int | Duration in seconds while the incoming call was ringing at a user or place of the hunt group. This value is cumulating from hunt group to hunt group. |
| PlaceNumber | nvarchar(100) | Number of the device, located in a workgroup and not associated to a specific user |
| InUserDelivered | int | 1 if the incoming call was delivered to the user or place |
| InUserRingDuration | int | Duration in seconds while the incoming call was ringing at the user or place |
| InDeliveredByHuntGroup | int | 1 if the incoming call was delivered by a hunt group (simultaneously ringing at all users or places of the hunt group) |
| InUserRedirected | int | 1 if the incoming call was redirected to another number due to call forward scenarios |
| InUserAnswered | int | 1 if the incoming call was answered by the user or place |
| InUserAnsweredOther | int | 1 if the incoming call was answered by another user or place of the hunt group |
| InUserHandledDuration | int | Duration in seconds while the user or place was talking on the incoming call or took the call on hold |
| InUserTransferred | int | 1 if the user or place forwarded the incoming call to another number after answering |
| InUserTransferNumber | nvarchar(100) | Number to which the user or place transferred the call |
| InRedirectNumber | nvarchar(100) | Number to which the incoming call was redirected by the hunt group, user, place or other device without being answered |
| InRedirectedToVoicemail | int | 1 if the incoming call was redirected to the voice mailbox |
| InVoicemail | int | 1 if the incoming call finally ended at the voice mailbox |
| InVoicemailDuration | int | Duration in seconds while the incoming caller has left a message on the voice mailbox |
| OutUserDialed | int | 1 if the user or place dialed a number |
| OutUserRingDuration | int | Duration in seconds for call setup and ringing at the destination |
| OutUserAnswered | int | 1 if the outgoing call of the user or place was answered at the destination |
| OutUserHandledDuration | int | Duration in seconds while the user or place was talking on the outgoing call or took the call on hold |
| OutUserUnanswered | int | 1 if the outgoing call of the user or place was not answered at the destination and the user or place hung up |
| OutUserTransferred | int | 1 if the user or place dialed out to transfer the call (consultation call or blind transfer) |
| OutUserForwarded | int | 1 if the outgoing call at the user or place was produced due to call forward scenarios (not dialed by the user/place) |
note
Surrogate keys (integer) of the datamart are used for tenant (org), user, location, date and time fields.