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.

Data as of 09 Aug 2022

Display name

Type

Tags

Aggregator

Display format

Source

Data set column name

ACD ID STRING QM Latest   Agent Productivity Daily AgentAcdId
ACD Login Id STRING Analytics, QM Latest   Person 2 acdLoginId
AD Login STRING Analytics, QM Latest   Person 2 adLogin
Agent Email STRING Analytics, QM Latest   Person 2 AgentEmail
Agent Full Name STRING Analytics, QM Latest   Person 2 AgentFullName
Agent ID NUMBER Analytics, QM Latest {0,number,#} Person 2 WFMAgentId
Agent Rank STRING Analytics, QM Latest   Person 2 agentRank
Answered NUMBER QM Latest {0,number,#} Customer Contact Record wasAnswered
APD Average Contact Seconds NUMBER   Sum {0,number,#,##0.0} Agent Productivity Daily AverageContactSeconds
APD Average Contacts Per Hour NUMBER   Sum {0,number,#,###} Agent Productivity Daily AverageContactsPerHour
APD Average Handle Seconds NUMBER   Sum {0,number,#,##0.0} Agent Productivity Daily AverageHandleSeconds
APD Average Hold Seconds NUMBER   Sum {0,number,#,##0.0} Agent Productivity Daily AverageHoldSeconds
APD Average Prorated Not Ready Seconds NUMBER   Sum {0,number,#,##0.0} Agent Productivity Daily AverageProratedNotReadySeconds
APD Average Prorated Ready Seconds NUMBER   Sum {0,number,#,##0.0} Agent Productivity Daily AverageProratedReadySeconds
APD Average Work Seconds NUMBER   Sum {0,number,#,##0.0} Agent Productivity Daily AverageWorkSeconds
Application STRING Analytics Latest   Application Usage API application
Application Capture Contact Start DATE Analytics Latest   Application Usage API start
Application Capture Start DATE Analytics Latest   Application Usage API date
Application Duration Seconds NUMBER Analytics Sum {0,number,#,###.0} Application Usage API applicationDurationSeconds
Application In Focus Duration Seconds NUMBER Analytics Sum {0,number,#,###.0} Application Usage API applicationInFocusDurationSeconds
Application In Focus Start DATE Analytics Latest   Application Usage API applicationInfocusStart
Application Label STRING Analytics Latest   Application Usage API applicationLabel
APSI Average Contact Seconds NUMBER   Sum {0,number,#,##0.0} Agent Productivity by Service Queue Interval AverageContactSeconds
APSI Average Handle Seconds NUMBER   Sum {0,number,#,##0.0} Agent Productivity by Service Queue Interval AverageHandleSeconds
APSI Average Hold Seconds NUMBER   Sum {0,number,#,##0.0} Agent Productivity by Service Queue Interval AverageHoldSeconds
APSI Average Prorated Not Ready Seconds NUMBER   Sum {0,number,#,##0.0} Agent Productivity by Service Queue Interval AverageProratedNotReadySeconds
APSI Average Prorated Ready Seconds NUMBER   Sum {0,number,#,##0.0} Agent Productivity by Service Queue Interval AverageProratedReadySeconds
APSI Average Work Seconds NUMBER   Sum {0,number,#,##0.0} Agent Productivity by Service Queue Interval AverageWorkSeconds
Associated Call ID STRING Analytics, QM Latest   Customer Contact Record associatedCallId
BandMax1 NUMBER QM Latest {0,number,#,###.0} Evaluations View bandMax1
BandMax2 NUMBER QM Latest {0,number,#,###.0} Evaluations View bandMax2
Calibrated NUMBER QM Latest {0,number,#} Customer Contact Record isCalibration
Calling Number STRING QM Latest   Customer Contact Record ani
Capture ID NUMBER Analytics Latest {0,number,#} Application Usage API captureid
Channel NUMBER Analytics Latest   Transcription Analytics channel
Contact Evaluation State STRING QM Latest   Customer Contact Record ccr.EvalState
Contact ID NUMBER Analytics, QM Latest {0,number,#} Application Usage API ccrid
Contact ID NUMBER Analytics, QM Latest {0,number,#} Phrase List spoofCcrId
Contact ID NUMBER Analytics, QM Latest {0,number,#} z_Legacy Contact Predictive Score ccrId
Contact ID NUMBER Analytics, QM Latest {0,number,#} Machine Learning CcrId
Contact ID NUMBER Analytics, QM Latest {0,number,#} Contact Phrase Usage API ccrid
Contact ID NUMBER Analytics, QM Latest {0,number,#} Recording Event CcrId
Contact ID NUMBER Analytics, QM Latest {0,number,#} Text Analytics ccrid
Contact ID NUMBER Analytics, QM Latest {0,number,#} z_Legacy Sentiment Analysis API ccrid
Contact ID NUMBER Analytics, QM Latest {0,number,#} Custom Metadata CcrId
Contact ID NUMBER Analytics, QM Latest {0,number,#} Evaluations View CallId
Contact ID NUMBER Analytics, QM Latest {0,number,#} Customer Contact Record ccrId
Contact ID NUMBER Analytics, QM Latest {0,number,#} Transcription Analytics ccrId
Contact Start Time DATE Analytics, QM Latest   Customer Contact Record startTime
Contact State STRING Analytics Latest   Application Usage API callState
Contact Type ID NUMBER Analytics, QM Latest {0,number,#} Customer Contact Record ccrTypeFK
Contact Type ID NUMBER Analytics, QM Latest {0,number,#} Customer Contact Record Type CcrTypeId
Contact Type Name STRING Analytics, QM Latest   Customer Contact Record Type name
Contact Was Held NUMBER Analytics, QM Max {0,number,#} Recording Event Contact Was Held
Contact Was Paused NUMBER Analytics, QM Max {0,number,#} Recording Event Contact Was Paused
Custom Data 01 STRING Analytics, QM Latest   Custom Metadata Custom Data 01
Custom Data 02 STRING Analytics, QM Latest   Custom Metadata Custom Data 02
Custom Data 03 STRING Analytics, QM Latest   Custom Metadata Custom Data 03
Custom Data 04 STRING Analytics, QM Latest   Custom Metadata Custom Data 04
Custom Data 05 STRING Analytics, QM Latest   Custom Metadata Custom Data 05
Custom Data 06 STRING Analytics, QM Latest   Custom Metadata Custom Data 06
Custom Data 07 STRING Analytics, QM Latest   Custom Metadata Custom Data 07
Custom Data 08 STRING Analytics, QM, CWFM Latest   Custom Metadata Custom Data 08
Custom Data 09 STRING Analytics, QM, CWFM Latest   Custom Metadata Custom Data 09
Custom Data 10 STRING Analytics, QM Latest   Custom Metadata Custom Data 10
Custom Data 11 STRING Analytics, QM Latest   Custom Metadata Custom Data 11
Custom Data 12 STRING Analytics, QM Latest   Custom Metadata Custom Data 12
Custom Data 13 STRING Analytics, QM Latest   Custom Metadata Custom Data 13
Custom Data 14 STRING Analytics, QM Latest   Custom Metadata Custom Data 14
Custom Data 15 STRING Analytics, QM Latest   Custom Metadata Custom Data 15
Custom Data 16 STRING Analytics, QM Latest   Custom Metadata Custom Data 16
Custom Data 17 STRING Analytics, QM Latest   Custom Metadata Custom Data 17
Custom Data 18 STRING Analytics, QM Latest   Custom Metadata Custom Data 18
Custom Data 19 STRING Analytics, QM Latest   Custom Metadata Custom Data 19
Custom Data 20 STRING Analytics, QM Latest   Custom Metadata Custom Data 20
Date Evaluated DATE QM Latest   Evaluations View DateEvaluated
dCount of Eval Comment ID NUMBER QM DistinctCount {0,number,#,###} Evaluation Comments dCount of Eval Comment ID
Detractors NUMBER Analytics, QM Sum   Custom Metadata Detractors
Document STRING Analytics Latest   Application Usage API document
Document Label STRING Analytics Latest   Application Usage API documentLabel
Duration NUMBER QM Sum   Customer Contact Record duration
Duration in Seconds NUMBER QM Sum   Customer Contact Record Duration in Seconds
Employee ID STRING Analytics, QM Latest   Person 2 employeeId
Evaluation Comment Contact Offset NUMBER QM Latest {0,number,#} Evaluation Comments contactOffset
Evaluation Comment Date DATE QM Latest   Evaluation Comments created
Evaluation Comment ID NUMBER Analytics, QM Latest {0,number,#} Evaluation Comments CommentKey
Evaluation Comment Text STRING QM Latest   Evaluation Comments CommentText
Evaluation Commenter Full Name STRING QM Latest   Person 2 CommenterFullName
Evaluation Commenter ID NUMBER QM Latest {0,number,#} Person 2 CommenterID
Evaluation Commenter ID NUMBER QM Latest {0,number,#} Evaluation Comments personFK
Evaluation Form ID NUMBER QM Latest {0,number,#} Evaluations View EvalFormId
Evaluation Form ID NUMBER QM Latest {0,number,#} Customer Contact Record evalFormFK
Evaluation Form Question ID NUMBER QM Latest   Evaluation Comments questionFK
Evaluation Form Question ID NUMBER QM Latest   Evaluations View formQuestionFK
Evaluation Form Question Option ID NUMBER QM Latest {0,number,#} Evaluations View EvalFormQuestionOptionId
Evaluation Form Question Option Type ID NUMBER QM Latest {0,number,#} Evaluations View EvalFormQuestionOptiontypefk
Evaluation Form Question Option Type Name STRING QM Latest   Evaluations View EvalFormQuestionOptionTypeName
Evaluation Form Section ID NUMBER QM Latest {0,number,#} Evaluation Comments sectionFK
Evaluation Form Section ID NUMBER QM Latest {0,number,#} Evaluations View EvalFormSectionId
Evaluation ID NUMBER QM Latest {0,number,#} Evaluation Comments evalFK
Evaluation ID NUMBER QM Latest {0,number,#} Evaluations View EvaluationId
Evaluation IsDeleted NUMBER QM Latest   Evaluations View Evaluation IsDeleted
Evaluation Total Score NUMBER QM Latest   Evaluations View totalScore
Evaluator Full Name STRING QM Latest   Person 2 EvaluatorFullName
Evaluator ID NUMBER QM Latest {0,number,#} Person 2 EvaluatorId
Evaluator ID NUMBER QM Latest {0,number,#} Customer Contact Record evaluatorFK
First Name STRING Analytics, QM Latest   Person 2 firstName
Form Additive Score NUMBER QM Latest {0,number,#,###.0} Evaluations View additiveScore
Form Description STRING QM Latest   Evaluations View FormDescription
Form KPI STRING QM Latest   Evaluations View kpi
Form Name STRING QM Latest   Evaluations View FormName
Form Total Points NUMBER QM Sum   Evaluations View FormTotalPoints
Full Name STRING Analytics, QM Latest   Person 2 FullName
Group Deactivated DATE Analytics, QM Latest   Group Groupdeactivated
Group IsActive NUMBER Analytics, QM Latest   Group Group IsActive
Group Name STRING Analytics, QM Latest   Group GroupName
GroupId NUMBER Analytics, QM Latest {0,number,#} Group GroupId
GroupId NUMBER Analytics, QM Latest {0,number,#} Application Usage API groupId
GroupId NUMBER Analytics, QM Latest {0,number,#} Customer Contact Record groupFK
Has Screen NUMBER Analytics, QM Latest   Customer Contact Record Has Screen
Has Voice NUMBER Analytics, QM Latest   Customer Contact Record Has Voice
HR NUMBER QM Latest {0,number,#} Customer Contact Record isPip
icmCallId STRING QM Latest   Customer Contact Record icmCallId
Inbound NUMBER QM Latest   Customer Contact Record isInbound
isAgent STRING Analytics, QM Latest   Person 2 IsAgent
Last Name STRING Analytics, QM Latest   Person 2 lastName
LocalStartTime DATE QM Latest   Customer Contact Record localStartTime
MinMaxHoursProfileId NUMBER   Latest {0,number,#} Person 2 MinMaxHoursProfileId
Normalized Contact Score NUMBER QM Latest   Evaluations View Normalized Contact Score
NotApproved STRING Analytics Latest   Application Usage API notApproved
NPS Response NUMBER Analytics, QM Latest {0,number,#} Custom Metadata NPS Response
Number Called STRING QM Latest   Customer Contact Record dnis
Passives NUMBER Analytics, QM Sum {0,number,#,###} Custom Metadata Passives
Person Activated DATE Analytics, QM Latest   Person 2 activated
Person Deactivated DATE Analytics, QM Latest   Person 2 deactivated
Person Department Start Date DATE Analytics, QM Latest   Person 2 departmentStartDate
Person Email STRING Analytics, QM Latest   Person 2 email
Person ID NUMBER Analytics, QM Latest {0,number,#} Agent Adherence Report PersonId
Person ID NUMBER Analytics, QM Latest {0,number,#} Person 2 PersonId
Person ID NUMBER Analytics, QM Latest {0,number,#} Customer Contact Record personFK
Person ID NUMBER Analytics, QM Latest {0,number,#} Agent Productivity Interval PersonId
Person ID NUMBER Analytics, QM Latest {0,number,#} Agent Productivity Daily PersonId
Person ID NUMBER Analytics, QM Latest {0,number,#} Application Usage API personid
Person ID NUMBER Analytics, QM Latest {0,number,#} Agent Schedule AgentId
Person ID NUMBER Analytics, QM Latest {0,number,#} Agent Productivity by Service Queue Interval PersonId
Person ID NUMBER Analytics, QM Latest {0,number,#} z_Legacy Sentiment Analysis API agentid
Person Peripheral ID NUMBER QM Latest {0,number,#} Person 2 peripheralId
PersonTeamId NUMBER   Latest   Person 2 memberGroupFK
Phrase STRING Analytics Latest   Phrase List PhraseText
Phrase STRING Analytics Latest   Text Analytics phrase
Phrase STRING Analytics Latest   Transcription Analytics text
Phrase STRING Analytics Latest   Contact Phrase Usage API phrase
Phrase Category STRING Analytics Latest   Contact Phrase Usage API category
Phrase Category STRING Analytics Latest   Transcription Analytics category
Phrase Category STRING Analytics Latest   Phrase List PhraseCategoryName
Phrase Category STRING Analytics Latest   Text Analytics category
Phrase Confidence NUMBER Analytics Latest   Phrase List spoofConfidence
Phrase Confidence NUMBER Analytics Latest   Contact Phrase Usage API confidence
Phrase Confidence NUMBER Analytics Latest   Transcription Analytics confidence
Phrase Confidence NUMBER Analytics Latest   Text Analytics spoofConfidence
Phrase Confidence Cohort NUMBER Analytics Sum   Contact Phrase Usage API Phrase Confidence Cohort
Phrase Confidence Cohort NUMBER Analytics Sum   Transcription Analytics Phrase Confidence Cohort
Phrase Confidence Cohort NUMBER Analytics Sum   Phrase List spoofConfidenceCohort
Phrase End Seconds NUMBER Analytics Latest   Transcription Analytics Phrase End Seconds
Phrase Source STRING Analytics Latest   Contact Phrase Usage API Phrase Source
Phrase Source STRING Analytics Latest   Transcription Analytics Phrase Source
Phrase Source STRING Analytics Latest   Text Analytics Phrase Source
Phrase Start Seconds NUMBER Analytics Latest   Transcription Analytics Phrase Start Seconds
PhraseCategoryPicklist STRING Analytics Latest   Phrase List PhraseCategoryNamePicklist
PhrasePicklist STRING Analytics Latest   Phrase List PhraseTextPicklist
PointsFormQuestionPossibleScore NUMBER QM Latest   Evaluations View PointsFormQuestionPossibleScore
PointsFormQuestionPossibleScoreApplicable NUMBER QM Sum   Evaluations View PointsFormQuestionPossibleScoreApplicable
Position NUMBER Analytics Latest {0,number,#,###} Text Analytics position
Position NUMBER Analytics Latest {0,number,#,###} Transcription Analytics position
Predictive Detractors NUMBER Analytics Sum {0,number,#,###} z_Legacy Contact Predictive Score Predictive Detractors
Predictive Detractors NUMBER Analytics Sum {0,number,#,###} Machine Learning Predictive Detractors
Predictive Net Promoter Score NUMBER Analytics Sum {0,number,#} z_Legacy Contact Predictive Score netPromoterScore
Predictive Net Promoter Score NUMBER Analytics Sum {0,number,#} Machine Learning PredictiveNPS
Predictive NPS Response NUMBER Analytics Latest {0,number,#} z_Legacy Contact Predictive Score Predictive NPS Response
Predictive NPS Response NUMBER Analytics Latest {0,number,#} Machine Learning Predictive NPS Response
Predictive Passives NUMBER Analytics Sum {0,number,#,###} z_Legacy Contact Predictive Score Predictive Passives
Predictive Passives NUMBER Analytics Sum {0,number,#,###} Machine Learning Predictive Passives
Predictive Promoters NUMBER Analytics Sum {0,number,#,###} z_Legacy Contact Predictive Score Predictive Promoters
Predictive Promoters NUMBER Analytics Sum {0,number,#,###} Machine Learning Predictive Promoters
Predictive Quality Score NUMBER Analytics Sum {0,number,#} z_Legacy Contact Predictive Score evalScorePrediction
Predictive Quality Score NUMBER Analytics Sum {0,number,#} Machine Learning PredictiveEval
Promoters NUMBER Analytics, QM Sum {0,number,#,###} Custom Metadata Promoters
Question Label STRING QM Latest   Evaluations View label
Question Points NUMBER QM Sum {0,number,#,##0.0} Evaluations View points
Question Possible Score NUMBER QM Sum   Evaluations View QuestionPossibleScore
Question Score NUMBER QM Sum {0,number,#,##0.0} Evaluations View QuestionScore
Question Text STRING Analytics, QM Latest   Evaluations View QuestionText
Question Weight NUMBER QM Latest   Evaluations View QuestionWeight
Receiver STRING Analytics Latest   Text Analytics receiver
Reconciled NUMBER QM Latest {0,number,#} Customer Contact Record isReconciled
Recording Event Created Date DATE QM Latest   Recording Event RecordingEventCreatedDate
Recording Event Duration NUMBER QM Sum   Recording Event duration
Recording Event ID NUMBER QM Latest {0,number,#} Recording Event RecordingEventId
Recording Event Type ID NUMBER QM Latest {0,number,#} Recording Event recordingEventTypeId
Recording Event Type ID NUMBER QM Latest {0,number,#} Recording Event Type RecordingEventTypeId
Recording Event Type Name STRING QM Latest   Recording Event Type name
Schedule Release Profile ID NUMBER   Latest {0,number,#} Person 2 scheduleReleaseProfileId
Score Is Counted NUMBER QM Latest {0,number,#} Evaluations View isCountedScore
ScoringType STRING QM Latest   Evaluations View ScoringType
Section Average NUMBER QM Sum   Evaluations View sectionAvg
Section Name STRING QM Latest   Evaluations View SectionName
Section Weight NUMBER QM Latest   Evaluations View sectionWeight
Sender STRING Analytics Latest   Text Analytics sender
Sentiment STRING Analytics Latest   z_Legacy Sentiment Analysis API Sentiment_Friendly
Sentiment STRING Analytics Latest   Machine Learning Sentiment_Friendly
SQHI Average Contact Seconds NUMBER   Sum {0,number,#,###.0} Service Queue Historical Interval AverageContactSeconds
SQHI Average Speed Of Answer Seconds NUMBER   Sum {0,number,#,###.0} Service Queue Historical Interval AverageSpeedOfAnswerSeconds
SQHI Average Work Seconds NUMBER   Sum {0,number,#,###.0} Service Queue Historical Interval AverageWorkSeconds
Staffing Group ID NUMBER   Latest {0,number,#} Person 2 StaffingGroupId
Subject STRING Analytics Latest   Text Analytics subject
Team Deactivated DATE Analytics, QM Latest   Group Teamdeactivated
Team IsActive NUMBER Analytics, QM Latest   Group Team IsActive
Team Name STRING Analytics, QM Latest   Group TeamName
TeamId NUMBER Analytics, QM Latest {0,number,#} Group TeamId
TeamId NUMBER Analytics, QM Latest {0,number,#} Customer Contact Record teamFK
TeamId NUMBER Analytics, QM Latest {0,number,#} Application Usage API teamId
Time to Answer NUMBER Analytics, QM Sum {0,number,#,###.0} Customer Contact Record timeToAnswer
Timezone Display Name STRING Analytics, QM Latest   Timezone DisplayName
Timezone ID NUMBER Analytics, QM Latest {0,number,#} Timezone Timezone
Timezone ID NUMBER Analytics, QM Latest {0,number,#} Customer Contact Record startTimeTzFK
Timezone ID NUMBER Analytics, QM Latest {0,number,#} Evaluations View evaluatedTzFK
Timezone ID NUMBER Analytics, QM Latest {0,number,#} Evaluation Comments createdTzFK
Timezone Java Name STRING Analytics, QM Latest   Timezone javaName
Timezone UTC Offset NUMBER Analytics, QM Latest {0,number,#} Timezone UtcOffset
Training NUMBER QM Latest {0,number,#} Customer Contact Record isTraining
URL STRING Analytics Latest   Application Usage API URL
UsedPhrase STRING Analytics Latest   Phrase List spoofUsedPhrase
UsedPhrase STRING Analytics Latest   Text Analytics EachUsedPhrase
UsedPhrase STRING Analytics Latest   Transcription Analytics UsedPhrase
UsedPhrase STRING Analytics Latest   Contact Phrase Usage API UsedPhrase