Fields mappings
The fields mappings table displays how the field name you see in Data Explorer relates to the column name in the source data set.
|
Display name |
Type |
Tags |
Aggregator |
Display format |
Source |
Data set column name |
|---|---|---|---|---|---|---|
| Abandon Time - CCD | NUMBER | Calabrio, Contact Call Detail | Sum | Contact Call Detail | ccd_calls_abandoned_connecttime | |
| Abandon Time - CQD | NUMBER | Calabrio, Contact Queue Detail | Sum | Contact Queue Detail | cqd_time_abandoned | |
| Abandoned Calls Met Service Level | NUMBER | Calabrio, Contact Queue Detail | Sum | Contact Queue Detail | cqd_metservicelevel_calls_abandoned | |
| ACD Resource Id | STRING | Calabrio | Latest | Agent Connection Detail | aqd_resourceid | |
| ACD Resource Id | STRING | Calabrio | Latest | Agent State Detail | agentid | |
| Agent Name | STRING | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail | Latest | Contact Call Detail | dest_resource_full_name | |
| Agent Name | STRING | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail | Latest | Agent Connection Detail | agent_name | |
| Agent Name | STRING | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail | Latest | Agent State Detail | agent_name | |
| Application ID | NUMBER | Calabrio, Contact Call Detail | Latest | {0,number,#} | Contact Call Detail | applicationid |
| Application Name | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | applicationname | |
| Call Count - ACD | NUMBER | Agent Connection Detail, Calabrio | Sum | Agent Connection Detail | aqd_callcount | |
| Call Count - CCD | NUMBER | Calabrio, Contact Call Detail | Sum | Contact Call Detail | callcount | |
| Call End Datetime - CCD | DATE | Calabrio, Contact Call Detail | Latest | {0,date,yyyy/MM/dd HH:mm:ss} | Contact Call Detail | ccd_acd_enddatetime |
| Call Result Code Description | STRING | Agent Connection Detail, Calabrio | Latest | Agent Connection Detail | call_result_code_desc | |
| Call Result Code Value | NUMBER | Agent Connection Detail, Calabrio | Latest | {0,number,#} | Agent Connection Detail | call_result_code_value |
| Call Start Datetime - ACD | DATE | Agent Connection Detail, Calabrio | Latest | {0,date,yyyy/MM/dd HH:mm:ss} | Agent Connection Detail | aqd_acd_startdatetime |
| Call Start Datetime - CCD | DATE | Calabrio, Contact Call Detail | Latest | {0,date,yyyy/MM/dd HH:mm:ss} | Contact Call Detail | ccd_acd_startdatetime |
| Call Start Datetime - CQD | DATE | Calabrio, Contact Queue Detail | Latest | {0,date,yyyy/MM/dd HH:mm:ss} | Contact Queue Detail | cqd_call_startdatetime |
| Call Time | NUMBER | Agent Connection Detail, Calabrio | Sum | Agent Connection Detail | aqd_calltime | |
| Call Wrap Up Data | STRING | Calabrio | Latest | Agent Connection Detail | aqd_callwrapupdata | |
| Called Number | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | callednumber | |
| Calls Abandoned - CCD | NUMBER | Calabrio, Contact Call Detail | Sum | Contact Call Detail | ccd_calls_abandoned | |
| Calls Abandoned - CQD | NUMBER | Calabrio, Contact Queue Detail | Sum | Contact Queue Detail | cqd_calls_abandoned | |
| Calls Dequeued | NUMBER | Calabrio, Contact Queue Detail | Sum | Contact Queue Detail | cqd_calls_dequeued | |
| Calls Flow Out | NUMBER | Calabrio, Contact Call Detail | Sum | Contact Call Detail | flowout | |
| Calls Handled - CCD | NUMBER | Calabrio, Contact Call Detail | Sum | Contact Call Detail | ccd_calls_handled | |
| Calls Handled - CQD | NUMBER | Calabrio, Contact Queue Detail | Sum | Contact Queue Detail | cqd_calls_handled | |
| Calls Handled Connect Time | NUMBER | Calabrio, Contact Call Detail | Sum | Contact Call Detail | ccd_calls_handled_connecttime | |
| Calls Handled Time | NUMBER | Agent Connection Detail, Calabrio | Sum | Agent Connection Detail | aqd_handle_time | |
| Calls Met Service Level | NUMBER | Calabrio, Contact Queue Detail | Sum | Contact Queue Detail | metservicelevel | |
| Calls On Hold | NUMBER | Agent Connection Detail, Calabrio | Sum | Agent Connection Detail | acd_hold_count | |
| Calls Redirected | NUMBER | Calabrio, Contact Call Detail | Sum | Contact Call Detail | redirect | |
| Calls Transfered | NUMBER | Calabrio, Contact Call Detail | Sum | Contact Call Detail | transfer | |
| Conference Calls | NUMBER | Calabrio, Contact Call Detail | Sum | Contact Call Detail | conference | |
| Connect Time | NUMBER | Calabrio, Contact Call Detail | Sum | Contact Call Detail | connecttime | |
| Contact Disposition Code Description | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | contactdisp_code_desc | |
| Contact Disposition Code Value | NUMBER | Calabrio, Contact Call Detail | Latest | {0,number,#} | Contact Call Detail | contactdisp_code_value |
| Contact Service Queue ID | NUMBER | Agent Connection Detail, Calabrio, Contact Queue Detail | Latest | {0,number,#} | Contact Queue Detail | contactservicequeueid |
| Contact Service Queue ID | NUMBER | Agent Connection Detail, Calabrio, Contact Queue Detail | Latest | {0,number,#} | Agent Connection Detail | contactservicequeueid |
| Contact Service Queue Name | STRING | Agent Connection Detail, Calabrio, Contact Queue Detail | Latest | Contact Queue Detail | csqname | |
| Contact Service Queue Name | STRING | Agent Connection Detail, Calabrio, Contact Queue Detail | Latest | Agent Connection Detail | csqname | |
| Contact Service Queue Record ID | NUMBER | Agent Connection Detail, Calabrio, Contact Queue Detail | Latest | {0,number,#} | Agent Connection Detail | recordid |
| Contact Service Queue Record ID | NUMBER | Agent Connection Detail, Calabrio, Contact Queue Detail | Latest | {0,number,#} | Contact Queue Detail | recordid |
| Contact Service Queue Service Level | NUMBER | Agent Connection Detail, Calabrio, Contact Queue Detail | Latest | {0,number,#} | Contact Queue Detail | servicelevel |
| Contact Service Queue Service Level | NUMBER | Agent Connection Detail, Calabrio, Contact Queue Detail | Latest | {0,number,#} | Agent Connection Detail | servicelevel |
| Contact Service Queue Service Level Percentage | NUMBER | Agent Connection Detail, Calabrio, Contact Queue Detail | Latest | {0,number,#} | Agent Connection Detail | servicelevelpercentage |
| Contact Service Queue Service Level Percentage | NUMBER | Agent Connection Detail, Calabrio, Contact Queue Detail | Latest | {0,number,#} | Contact Queue Detail | servicelevelpercentage |
| Contact Type Code Description | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | contacttype_code_desc | |
| Contact Type Code Value | NUMBER | Calabrio, Contact Call Detail | Latest | {0,number,#} | Contact Call Detail | contacttype_code_value |
| CQD Target Id | STRING | Calabrio | Latest | Contact Queue Detail | targetid | |
| CQD Target Type | STRING | Calabrio | Latest | Contact Queue Detail | targettype | |
| Custom Variable 8 - text | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | customvariable8 | |
| Custom Variable 7 - text | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | customvariable7 | |
| Custom Variable 1 | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | customvariable1 | |
| Custom Variable 2 | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | customvariable2 | |
| Custom Variable 3 | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | customvariable3 | |
| Custom Variable 4 | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | customvariable4 | |
| Custom Variable 5 | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | customvariable5 | |
| Custom Variable 6 | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | customvariable6 | |
| Custom Variable 9 | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | customvariable9 | |
| Custom Variable 10 | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | customvariable10 | |
| Data Source | STRING | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail, Contact Queue Detail | Latest | Contact Queue Detail | acd_src | |
| Data Source | STRING | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail, Contact Queue Detail | Latest | Contact Call Detail | acd_src | |
| Data Source | STRING | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail, Contact Queue Detail | Latest | Agent State Detail | acd_src | |
| Data Source | STRING | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail, Contact Queue Detail | Latest | Agent Connection Detail | acd_src | |
| Date | DATE | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail, Contact Queue Detail | Latest | {0,date,yyyy/MM/dd} | Agent State Detail | Date |
| Date | DATE | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail, Contact Queue Detail | Latest | {0,date,yyyy/MM/dd} | Contact Queue Detail | Date |
| Date | DATE | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail, Contact Queue Detail | Latest | {0,date,yyyy/MM/dd} | Agent Connection Detail | Date |
| Date | DATE | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail, Contact Queue Detail | Latest | {0,date,yyyy/MM/dd} | Contact Call Detail | Date |
| Destination Type Code Description | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | desttype_code_desc | |
| Destination Type Code Value | NUMBER | Calabrio, Contact Call Detail | Latest | {0,number,#} | Contact Call Detail | desttype_code_value |
| Disposition Code Description | STRING | Agent Connection Detail, Calabrio, Contact Queue Detail | Latest | Contact Queue Detail | disposition_code_desc | |
| Disposition Code Description | STRING | Agent Connection Detail, Calabrio, Contact Queue Detail | Latest | Agent Connection Detail | disposition_code_desc_acd_correction | |
| Disposition Code Name | STRING | Agent Connection Detail, Calabrio, Contact Queue Detail | Latest | Contact Queue Detail | disposition_code_name | |
| Disposition Code Name | STRING | Agent Connection Detail, Calabrio, Contact Queue Detail | Latest | Agent Connection Detail | disposition_code_name | |
| Disposition Code Value | NUMBER | Agent Connection Detail, Calabrio, Contact Queue Detail | Latest | {0,number,#} | Agent Connection Detail | disposition_code_value |
| Disposition Code Value | NUMBER | Agent Connection Detail, Calabrio, Contact Queue Detail | Latest | {0,number,#} | Contact Queue Detail | disposition_code_value |
| Event Count | NUMBER | Agent State Detail, Calabrio | Sum | Agent State Detail | eventcount | |
| Event Duration | NUMBER | Agent State Detail, Calabrio | Sum | Agent State Detail | event_duration | |
| Event End Time | DATE | Agent State Detail, Calabrio | Latest | Agent State Detail | asd_event_enddatetime | |
| Event Start Time | DATE | Agent State Detail, Calabrio | Latest | Agent State Detail | asd_event_startdatetime | |
| Event Type Code Description | STRING | Agent State Detail, Calabrio | Latest | Agent State Detail | eventtype_code_desc | |
| Event Type Code Value | NUMBER | Agent State Detail, Calabrio | Latest | {0,number,#} | Agent State Detail | eventtype_code_value |
| eventtype | NUMBER | Calabrio | Latest | Agent State Detail | eventtype | |
| Extension | NUMBER | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail | Latest | {0,number,#} | Agent State Detail | extension |
| Extension | NUMBER | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail | Latest | {0,number,#} | Contact Call Detail | dest_extension |
| Extension | NUMBER | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail | Latest | {0,number,#} | Agent Connection Detail | extension |
| Handled Call Wait Time | NUMBER | Calabrio, Contact Queue Detail | Sum | Contact Queue Detail | cqd_time_before_handled | |
| Handled Calls Met Service Level | NUMBER | Calabrio, Contact Queue Detail | Sum | Contact Queue Detail | cqd_metservicelevel_calls_handled | |
| Hold Time | NUMBER | Agent Connection Detail, Calabrio | Sum | Agent Connection Detail | aqd_holdtime | |
| Is Valid Event | NUMBER | Agent State Detail, Calabrio | Sum | Agent State Detail | is_valid_event | |
| Login Count | NUMBER | Agent State Detail, Calabrio | Sum | Agent State Detail | asd_login_count | |
| Login Duration | NUMBER | Agent State Detail, Calabrio | Sum | Agent State Detail | asd_login_duration | |
| Node ID | NUMBER | Agent Connection Detail, Calabrio, Contact Call Detail, Contact Queue Detail | Latest | {0,number,#} | Agent Connection Detail | nodeid |
| Node ID | NUMBER | Agent Connection Detail, Calabrio, Contact Call Detail, Contact Queue Detail | Latest | {0,number,#} | Contact Queue Detail | nodeid |
| Node ID | NUMBER | Agent Connection Detail, Calabrio, Contact Call Detail, Contact Queue Detail | Latest | {0,number,#} | Contact Call Detail | nodeid |
| Not Ready Count | NUMBER | Agent State Detail, Calabrio | Sum | Agent State Detail | asd_notready_count | |
| Not Ready Duration | NUMBER | Agent State Detail, Calabrio | Sum | Agent State Detail | asd_notready_duration | |
| Originator Extension | NUMBER | Calabrio, Contact Call Detail | Latest | {0,number,#} | Contact Call Detail | orig_extension |
| Originator Full Name | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | orig_resource_full_name | |
| Originator Resource First Name | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | orig_resourcefirstname | |
| Originator Resource Last Name | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | orig_resourcelastname | |
| Originator Resource Login ID | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | orig_resourceloginid | |
| Originator Resource Name | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | orig_resourcename | |
| Originator Resource Type | NUMBER | Calabrio, Contact Call Detail | Latest | {0,number,#} | Contact Call Detail | orig_resourcetype |
| Originator Type Code Description | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | origtype_code_desc | |
| Originator Type Code Value | NUMBER | Calabrio, Contact Call Detail | Latest | {0,number,#} | Contact Call Detail | origtype_code_value |
| Originator Type Description | STRING | Calabrio, Contact Call Detail | Latest | Contact Call Detail | orig_resourcetype_desc | |
| Originatordn | STRING | Calabrio | Latest | Contact Call Detail | originatordn | |
| Profile ID | NUMBER | Calabrio, Contact Call Detail, Contact Queue Detail | Latest | {0,number,#} | Agent Connection Detail | profileid |
| Profile ID | NUMBER | Calabrio, Contact Call Detail, Contact Queue Detail | Latest | {0,number,#} | Contact Call Detail | profileid |
| Profile ID | NUMBER | Calabrio, Contact Call Detail, Contact Queue Detail | Latest | {0,number,#} | Contact Queue Detail | profileid |
| Profile ID | NUMBER | Calabrio, Contact Call Detail, Contact Queue Detail | Latest | {0,number,#} | Agent State Detail | profileid |
| Qindex | NUMBER | Agent Connection Detail, Calabrio, Contact Queue Detail | Latest | {0,number,#} | Agent Connection Detail | qindex |
| Qindex | NUMBER | Agent Connection Detail, Calabrio, Contact Queue Detail | Latest | {0,number,#} | Contact Queue Detail | qindex |
| Queue Count - ACD | NUMBER | Agent Connection Detail, Calabrio | Sum | Agent Connection Detail | aqd_queuecount | |
| Queue Count - CQD | NUMBER | Calabrio, Contact Queue Detail | Sum | Contact Queue Detail | queuecount | |
| Queue Time - ACD | NUMBER | Agent Connection Detail, Calabrio | Sum | Agent Connection Detail | aqd_queuetime | |
| Queue Time - CQD | NUMBER | Calabrio, Contact Queue Detail | Sum | Contact Queue Detail | queuetime | |
| Reason Code Description | STRING | Agent State Detail, Calabrio | Latest | Agent State Detail | reason_code_desc | |
| Reason Code Value | STRING | Agent State Detail, Calabrio | Latest | Agent State Detail | reason_code_value | |
| reasoncode | NUMBER | Calabrio | Latest | Agent State Detail | reasoncode | |
| Resource Firstname | STRING | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail | Latest | Contact Call Detail | dest_resourcefirstname | |
| Resource Firstname | STRING | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail | Latest | Agent Connection Detail | resourcefirstname | |
| Resource Lastname | STRING | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail | Latest | Agent Connection Detail | resourcelastname | |
| Resource Lastname | STRING | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail | Latest | Contact Call Detail | dest_resourcelastname | |
| Resource Login ID | STRING | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail | Latest | Contact Call Detail | dest_resourceloginid | |
| Resource Login ID | STRING | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail | Latest | Agent State Detail | resourceloginid | |
| Resource Login ID | STRING | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail | Latest | Agent Connection Detail | resourceloginid | |
| Resource Name | STRING | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail | Latest | Agent Connection Detail | resourcename | |
| Resource Name | STRING | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail | Latest | Contact Call Detail | dest_resourcename | |
| Resource Type | NUMBER | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail | Latest | Contact Call Detail | dest_resourcetype | |
| Resource Type | NUMBER | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail | Latest | Agent Connection Detail | resourcetype | |
| Resource Type Description | STRING | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail | Latest | Contact Call Detail | dest_resourcetype_desc | |
| Resource Type Description | STRING | Agent Connection Detail, Agent State Detail, Calabrio, Contact Call Detail | Latest | Agent Connection Detail | resourcetype_desc | |
| Ring No Answer | NUMBER | Agent Connection Detail, Calabrio | Sum | Agent Connection Detail | acd_rna | |
| Ring Time | NUMBER | Agent Connection Detail, Calabrio | Sum | Agent Connection Detail | aqd_ringtime | |
| Session ID | NUMBER | Agent Connection Detail, Calabrio, Contact Call Detail, Contact Queue Detail | Latest | {0,number,#} | Contact Call Detail | sessionid |
| Session ID | NUMBER | Agent Connection Detail, Calabrio, Contact Call Detail, Contact Queue Detail | Latest | {0,number,#} | Contact Queue Detail | sessionid |
| Session ID | NUMBER | Agent Connection Detail, Calabrio, Contact Call Detail, Contact Queue Detail | Latest | {0,number,#} | Agent Connection Detail | sessionid |
| Session Sequence Number | NUMBER | Agent Connection Detail, Calabrio, Contact Call Detail, Contact Queue Detail | Latest | {0,number,#} | Contact Queue Detail | sessionseqnum |
| Session Sequence Number | NUMBER | Agent Connection Detail, Calabrio, Contact Call Detail, Contact Queue Detail | Latest | {0,number,#} | Agent Connection Detail | sessionseqnum |
| Session Sequence Number | NUMBER | Agent Connection Detail, Calabrio, Contact Call Detail, Contact Queue Detail | Latest | {0,number,#} | Contact Call Detail | sessionseqnum |
| State Transition Time | DATE | Agent State Detail, Calabrio | Latest | {0,date,yyyy/MM/dd HH:mm:ss} | Agent State Detail | asd_eventdatetime |
| Talk Time | NUMBER | Agent Connection Detail, Calabrio | Sum | Agent Connection Detail | aqd_talktime | |
| Work Time | NUMBER | Agent Connection Detail, Calabrio | Sum | Agent Connection Detail | aqd_worktime | |
| Wrapup Time | NUMBER | Agent Connection Detail, Calabrio | Sum | Agent Connection Detail | wrapuptime |