CDR Log Headers
Estimated reading time: 5 minutes | Target users: Supervisors, System Administrators
You can define which CDR log columns you want to export and in what order with the VCC Live Archiver application by using the column IDs below. You can specify these with the –fields command option and in the CDR_HEADER_ORDER value in the .env file.
For more details about CDR Logs, see CDR Logs.
|shortid||shortid.treecol.label||Call event short identifier number. The number is generated when a call is initiated or a call enters a queue. The number can be read back to the clients.|
|source||source.label.value||The phone number the call was initiated from.|
|destination||destination.label.value||The phone number the call was initiated toward.|
|destination_name||destination_name.treecol.label||The phone number’s label.|
|direction||direction.label||The direction of the call.|
|userid||User ID||User identifier number. The number is generated when a user is created.|
|userextension||extension.treecol.label||The user’s extension number. Available only if the user’s calls are connected to an IP phone.|
|userfullname||agent.label.value||The agent who handled the call.|
|username||Username||The user name of the agent.|
|numberid||numberid.label.value||A unique call identifier.|
|start_time_answer_time||start_ts.treecol.label||The time when the call (the conversation itself) was initiated or answered. Outbound calls: calculated from the time the call was connected (the call is established or the agent is informed that the client is not available). Inbound calls: calculated from the time the first process answers the call.|
|next_contact||next_calldate.treecol.label||The time the client is scheduled to be called back.|
|prework||prework.treecol.label||The time the agent spent in Prework state. Prework includes administrative tasks required to be done before the call starts.|
|ringtime||ringtime.treecol.label||Length of ringing before the call was answered, rejected or timed out.|
|billing_ts||billing_ts.treecol.label||The start time of the billing interval. Outbound calls: calculated from the time the client answers the call. Inbound calls: calculated from the time the first process is reached.|
|billingtime||billingtime.treecol.label||The amount of time to be billed.|
|talktime||talktime.treecol.label||Length of the conversation. Call on hold is not included.|
|holdtime||hold.treecol.label||The total time the client was placed on hold.|
|afterwork||afterwork.treecol.label||The time the agent spent in Afterwork state. Afterwork includes finishing administrative tasks after the call ended.|
|queuetime||queuetime.treecol.label||The time the client spent in the queue.|
|beforequeuetime||beforequeuetime.treecol.label||The time the client spent in the call before entering the final virtual queue, including time spent in the IVR menu. Any time spent in a virtual queue is not included.|
|disposition_label||dispositionid.treecol.label||The disposition allocated to the record by the agent or the dialer.|
|dispositionreach_label||dispositionreach.treecol.label||The outcome of the disposition. (Not Reached, Reached, or Successful)|
|dispositionstatus_label||dispositionstatus.treecol.label||Disposition type. (Callback, Shared callback, Finished, or a system disposition.)|
|dialermode_label||dialer_queue.label||The dialing mode that was used to initiate the call. (Manual, Power, or Predictive. Inbound calls are marked as Inbound.)|
|projectid||projectid.treecol.label||Project identifier number. The number is generated when a project is created.|
|projectname||Project Name||The corresponding project.|
|queue_label||queue.label.value||The queue from which the client was connected to the agent.|
|vcc_score||vcc_score.treecol.label||The score field’s value; a variable. The field must be set up in the project’s inbound settings. If the vcc_score field value is set with inbound processes, then the value equals the processes’ content. If there are multiple fields, then the values are presented in alphabetical order, separated with a vertical bar character.|
|hangup_disposition||hangup_disposition.treecol.label||The party who ended the call. (Agent or client. If empty, the call disconnected.)|
|dc||dc.treecol.label||A code used to identify the cause of call disconnection.|
|sum_work||sum_work.treecol.label||The time the agent spent working on the record. (Includes Prework, Ringing, Talk time, After call work. If no agent was connected, the value is zero.)|
|start_ts||start_ts.treecol.label||The start time of the initiated call. Outbound calls: the starting time of initiating a call (ie. dialing the customer). Inbound calls: the starting time of a customer initiating a call.|
Ready to Learn More?
View the complete list of all of our available tutorials.
See available tutorials >
Can’t find what you need? Use the comment section below to connect with others, get answers from our experts, or share your ideas with us.
There are no comments yet.