Data sets

A data set is a container that holds data and information about that data’s structure, layout, and format. It is a single store of related data in the data model. This table lists the data sets that are part of the Calabrio ONE data model and the data fields (columns) that belong in each data set.

Data as of 09 Aug 2022

Data set name

Column name

Column type

Included

Mapped

Mapped to
Agent Adherence Report ActivityInAdherenceSeconds NUMBER Yes No  
Agent Adherence Report ActivityOutOfAdherenceSeconds NUMBER Yes No  
Agent Adherence Report ActivityStartTime DATE Yes No  
Agent Adherence Report ActivityType STRING Yes No  
Agent Adherence Report ActualAgentStartTime DATE Yes No  
Agent Adherence Report AdherenceReportId NUMBER Yes No  
Agent Adherence Report AgentState STRING Yes No  
Agent Adherence Report CreateModifiedDate DATE Yes No  
Agent Adherence Report PersonId NUMBER Yes Yes Person ID
Agent Adherence Report ReasonCode STRING Yes No  
Agent Adherence Report ScheduleAdherence NUMBER Yes No  
Agent Adherence Report ScheduleConformity NUMBER Yes No  
Agent Adherence Report SnapshotInAdherenceSeconds NUMBER Yes No  
Agent Adherence Report SnapshotOutOfAdherenceSeconds NUMBER Yes No  
Agent Adherence Report TenantDate DATE Yes No  
Agent Adherence Report TenantTimeZone STRING Yes No  
Agent Adherence Report TotalActualInServiceSeconds NUMBER Yes No  
Agent Adherence Report TotalOutOfAdherenceSeconds NUMBER Yes No  
Agent Adherence Report TotalScheduledInServiceSeconds NUMBER Yes No  
Agent Adherence Report TotalScheduledSeconds NUMBER Yes No  
Agent Productivity by Service Queue Interval AgentProductivityStatisticsIntervalCreatedDate DATE Yes No  
Agent Productivity by Service Queue Interval AgentProductivityStatisticsIntervalId NUMBER Yes No  
Agent Productivity by Service Queue Interval AgentProductivityStatisticsIntervalStart DATE Yes No  
Agent Productivity by Service Queue Interval AgentProductivityStatisticsIntervalUpdatedDate DATE Yes No  
Agent Productivity by Service Queue Interval AverageContactSeconds NUMBER Yes Yes SQHI Average Contact Seconds
Agent Productivity by Service Queue Interval AverageHandleSeconds NUMBER Yes Yes APSI Average Handle Seconds
Agent Productivity by Service Queue Interval AverageHoldSeconds NUMBER Yes Yes APSI Average Hold Seconds
Agent Productivity by Service Queue Interval AverageProratedNotReadySeconds NUMBER Yes No  
Agent Productivity by Service Queue Interval AverageProratedReadySeconds NUMBER Yes No  
Agent Productivity by Service Queue Interval AverageWorkSeconds NUMBER Yes Yes SQHI Average Work Seconds
Agent Productivity by Service Queue Interval CreateModifiedDate DATE Yes No  
Agent Productivity by Service Queue Interval FIL_SEQUENCE NUMBER Yes Yes Service Queue Id
Agent Productivity by Service Queue Interval HandledContacts NUMBER Yes No  
Agent Productivity by Service Queue Interval IncomingContacts NUMBER Yes No  
Agent Productivity by Service Queue Interval InServiceByInSession NUMBER Yes No  
Agent Productivity by Service Queue Interval ipHostName STRING Yes Yes ACD Host
Agent Productivity by Service Queue Interval Occupancy NUMBER Yes Yes APD Occupancy %
Agent Productivity by Service Queue Interval OutgoingContacts NUMBER Yes No  
Agent Productivity by Service Queue Interval PersonId NUMBER Yes Yes Person ID
Agent Productivity by Service Queue Interval ServiceQueueAcdId NUMBER Yes No  
Agent Productivity by Service Queue Interval TotalInServiceSeconds NUMBER Yes Yes APD Period In-Service Seconds
Agent Productivity by Service Queue Interval TotalInSessionSeconds NUMBER Yes No  
Agent Productivity by Service Queue Interval TotalNotReadySeconds NUMBER Yes Yes APD Not Ready Seconds
Agent Productivity by Service Queue Interval TotalPeriodContactSeconds NUMBER Yes Yes APD Period Contact Seconds
Agent Productivity by Service Queue Interval TotalPeriodHandleSeconds NUMBER Yes Yes APSI Total Period Handle Seconds
Agent Productivity by Service Queue Interval TotalPeriodHoldSeconds NUMBER Yes Yes APD Period Hold Seconds
Agent Productivity by Service Queue Interval TotalPeriodWorkSeconds NUMBER Yes Yes APD Period Work Seconds
Agent Productivity by Service Queue Interval TotalReadySeconds NUMBER Yes Yes APD Ready Seconds
Agent Productivity by Service Queue Interval TransferredContacts NUMBER Yes Yes APSI Contacts Transferred
Agent Productivity by Service Queue Interval Utilization NUMBER Yes No  
Agent Productivity Daily actualDurationInAdherenceForPeriodInSeconds NUMBER Yes Yes APD In Adherence Seconds
Agent Productivity Daily actualDurationOfConformanceForPeriodInSeconds NUMBER Yes No  
Agent Productivity Daily Adherence NUMBER Yes No  
Agent Productivity Daily AgentAcdId STRING Yes Yes ACD ID
Agent Productivity Daily AgentEmployeeNumber STRING Yes Yes Employee Number
Agent Productivity Daily AgentProductivityStatisticsByDayCreatedBy STRING Yes No  
Agent Productivity Daily AgentProductivityStatisticsByDayCreatedDate DATE Yes No  
Agent Productivity Daily AgentProductivityStatisticsByDayDate DATE Yes Yes Agent Productivity Statistics By Day Date
Agent Productivity Daily AgentProductivityStatisticsByDayId NUMBER Yes No  
Agent Productivity Daily AgentProductivityStatisticsByDayUpdatedBy STRING Yes No  
Agent Productivity Daily AgentProductivityStatisticsByDayUpdatedDate DATE Yes No  
Agent Productivity Daily AverageContactSeconds NUMBER Yes Yes SQHI Average Contact Seconds
Agent Productivity Daily AverageContactsPerHour NUMBER Yes No  
Agent Productivity Daily AverageHandleSeconds NUMBER Yes Yes APSI Average Handle Seconds
Agent Productivity Daily AverageHoldSeconds NUMBER Yes Yes APSI Average Hold Seconds
Agent Productivity Daily AverageProratedNotReadySeconds NUMBER Yes No  
Agent Productivity Daily AverageProratedReadySeconds NUMBER Yes No  
Agent Productivity Daily AverageWorkSeconds NUMBER Yes Yes SQHI Average Work Seconds
Agent Productivity Daily Conformance NUMBER Yes No  
Agent Productivity Daily CreateModifiedDate DATE Yes No  
Agent Productivity Daily HandledContacts NUMBER Yes No  
Agent Productivity Daily IncomingContacts NUMBER Yes No  
Agent Productivity Daily InServiceByInSession NUMBER Yes No  
Agent Productivity Daily Occupancy NUMBER Yes Yes APD Occupancy %
Agent Productivity Daily OutgoingContacts NUMBER Yes No  
Agent Productivity Daily PersonId NUMBER Yes Yes Person ID
Agent Productivity Daily scheduledDurationForAdherenceForPeriodInSeconds NUMBER Yes Yes APD Scheduled Adherence Seconds
Agent Productivity Daily scheduledDurationForConformanceForPeriodInSeconds NUMBER Yes No  
Agent Productivity Daily TotalInServiceSeconds NUMBER Yes Yes APD Period In-Service Seconds
Agent Productivity Daily TotalInSessionSeconds NUMBER Yes No  
Agent Productivity Daily TotalNotReadySeconds NUMBER Yes Yes APD Not Ready Seconds
Agent Productivity Daily TotalPeriodContactSeconds NUMBER Yes Yes APD Period Contact Seconds
Agent Productivity Daily TotalPeriodHandleSeconds NUMBER Yes Yes APSI Total Period Handle Seconds
Agent Productivity Daily TotalPeriodHoldSeconds NUMBER Yes Yes APD Period Hold Seconds
Agent Productivity Daily TotalPeriodWorkSeconds NUMBER Yes Yes APD Period Work Seconds
Agent Productivity Daily TotalReadySeconds NUMBER Yes Yes APD Ready Seconds
Agent Productivity Daily TransferredContacts NUMBER Yes Yes APSI Contacts Transferred
Agent Productivity Daily Utilization NUMBER Yes No  
Agent Productivity Interval AverageContactSeconds NUMBER Yes Yes SQHI Average Contact Seconds
Agent Productivity Interval AverageHandleSeconds NUMBER Yes Yes APSI Average Handle Seconds
Agent Productivity Interval AverageWorkSeconds NUMBER Yes Yes SQHI Average Work Seconds
Agent Productivity Interval CreateModifiedDate DATE Yes No  
Agent Productivity Interval HandledContacts NUMBER Yes No  
Agent Productivity Interval IntervalStart DATE Yes No  
Agent Productivity Interval Occupancy NUMBER Yes Yes APD Occupancy %
Agent Productivity Interval PersonId NUMBER Yes Yes Person ID
Agent Productivity Interval TotalContactSecond NUMBER Yes No  
Agent Productivity Interval TotalHandleSeconds NUMBER Yes No  
Agent Productivity Interval TotalInServiceSeconds NUMBER Yes Yes APD Period In-Service Seconds
Agent Productivity Interval TotalInSessionSeconds NUMBER Yes No  
Agent Productivity Interval TotalNotReadySeconds NUMBER Yes Yes APD Not Ready Seconds
Agent Productivity Interval TotalReadySeconds NUMBER Yes Yes APD Ready Seconds
Agent Productivity Interval TotalWorkSecond NUMBER Yes No  
Agent Productivity Interval Utilization NUMBER Yes No  
Agent Schedule ActivityDetail STRING Yes No  
Agent Schedule ActivityEnd DATE Yes No  
Agent Schedule ActivityId NUMBER Yes No  
Agent Schedule ActivityMetaData STRING Yes No  
Agent Schedule ActivityStart DATE Yes No  
Agent Schedule ActivityType STRING Yes No  
Agent Schedule ActivityTypeId NUMBER Yes No  
Agent Schedule AgentId NUMBER Yes No  
Agent Schedule CreateModifiedDate DATE Yes No  
Application Usage API application STRING Yes Yes Application
Application Usage API applicationDuration NUMBER Yes No  
Application Usage API applicationInfocusDuration NUMBER Yes No  
Application Usage API applicationInfocusStart DATE Yes Yes Application In Focus Start
Application Usage API applicationLabel STRING Yes Yes Application Label
Application Usage API callState STRING Yes Yes Contact State
Application Usage API captureid NUMBER Yes Yes Capture ID
Application Usage API ccrid NUMBER Yes No  
Application Usage API date DATE Yes No  
Application Usage API document STRING Yes Yes Document
Application Usage API documentLabel STRING Yes Yes Document Label
Application Usage API groupId NUMBER Yes No  
Application Usage API notApproved STRING Yes Yes NotApproved
Application Usage API personid NUMBER Yes No  
Application Usage API start DATE Yes No  
Application Usage API teamId NUMBER Yes No  
Contact Phrase Usage API category STRING Yes No  
Contact Phrase Usage API ccrid NUMBER Yes No  
Contact Phrase Usage API confidence NUMBER Yes No  
Contact Phrase Usage API phrase STRING Yes No  
Custom Metadata CcrId NUMBER Yes No  
Custom Metadata Created DATE Yes No  
Custom Metadata CreateModifiedDate DATE Yes No  
Custom Metadata data STRING Yes No  
Custom Metadata dataExplorerKey STRING Yes No  
Custom Metadata LastModified DATE Yes No  
Custom Metadata metaDataFieldDisplayName STRING Yes No  
Custom Metadata metaDataFieldId NUMBER Yes No  
Custom Metadata metaDataFieldName STRING Yes No  
Customer Contact Record ani STRING Yes Yes Calling Number
Customer Contact Record associatedCallId STRING Yes No  
Customer Contact Record audioUploadState NUMBER Yes No  
Customer Contact Record calibrationFormFK STRING Yes No  
Customer Contact Record CcrCreatedBy STRING Yes No  
Customer Contact Record CcrCreatedDate DATE Yes No  
Customer Contact Record ccrId NUMBER Yes No  
Customer Contact Record ccrTypeFK NUMBER Yes No  
Customer Contact Record CcrUpdatedBy STRING Yes No  
Customer Contact Record CcrUpdatedDate DATE Yes No  
Customer Contact Record CreateModifiedDate DATE Yes No  
Customer Contact Record dailyRuleFK NUMBER Yes No  
Customer Contact Record dnis STRING Yes Yes Number Called
Customer Contact Record duration NUMBER Yes Yes Duration
Customer Contact Record endOfCallRuleFK NUMBER Yes No  
Customer Contact Record evalFormFK NUMBER Yes No  
Customer Contact Record evalStateFK NUMBER Yes No  
Customer Contact Record evaluatorFK NUMBER Yes No  
Customer Contact Record groupFK NUMBER Yes No  
Customer Contact Record icmCallId STRING Yes Yes icmCallId
Customer Contact Record isCalibration NUMBER Yes Yes Calibrated
Customer Contact Record isInbound NUMBER Yes Yes Inbound
Customer Contact Record isPip NUMBER Yes Yes HR
Customer Contact Record isReconciled NUMBER Yes Yes Reconciled
Customer Contact Record isTraining NUMBER Yes Yes Training
Customer Contact Record line STRING Yes No  
Customer Contact Record localStartTime DATE Yes Yes LocalStartTime
Customer Contact Record personFK NUMBER Yes No  
Customer Contact Record reasonFK NUMBER Yes No  
Customer Contact Record recordingTypeFK NUMBER Yes No  
Customer Contact Record retentionFK NUMBER Yes No  
Customer Contact Record screenUploadState NUMBER Yes No  
Customer Contact Record startTime DATE Yes Yes Contact Start Time
Customer Contact Record startTimeTzFK NUMBER Yes No  
Customer Contact Record startTimeTzOffset NUMBER Yes No  
Customer Contact Record SurveySendStatus NUMBER Yes No  
Customer Contact Record teamFK NUMBER Yes No  
Customer Contact Record tenantId NUMBER Yes No  
Customer Contact Record timeToAnswer NUMBER Yes Yes Time to Answer
Customer Contact Record wasAnswered NUMBER Yes Yes Answered
Customer Contact Record Type CcrTypeCreatedBy STRING Yes No  
Customer Contact Record Type CcrTypeCreatedDate DATE Yes No  
Customer Contact Record Type CcrTypeId NUMBER Yes Yes Contact Type ID
Customer Contact Record Type CcrTypeUpdatedBy STRING Yes No  
Customer Contact Record Type CcrTypeUpdatedDate DATE Yes No  
Customer Contact Record Type CreateModifiedDate DATE Yes No  
Customer Contact Record Type name STRING Yes No  
Deleted Agent Adherence Report AdherenceReportId NUMBER Yes No  
Deleted Agent Adherence Report CreateModifiedDate DATE Yes No  
Deleted Agent Adherence Report DeletedAdherenceReportId NUMBER Yes No  
Deleted Agent Schedule ActivityId NUMBER Yes No  
Deleted Agent Schedule CreateModifiedDate STRING Yes No  
Deleted Forecast CreateModifiedDate STRING Yes No  
Deleted Forecast ForecastIntervalId NUMBER Yes No  
Evaluation Comments contactOffset NUMBER Yes No  
Evaluation Comments created DATE Yes No  
Evaluation Comments createdTzFK NUMBER Yes No  
Evaluation Comments createdTzOffset NUMBER Yes No  
Evaluation Comments CreateModifiedBy STRING Yes No  
Evaluation Comments CreateModifiedDate DATE Yes No  
Evaluation Comments evalFK NUMBER Yes No  
Evaluation Comments id NUMBER Yes No  
Evaluation Comments parentCommentFK NUMBER Yes No  
Evaluation Comments personFK NUMBER Yes No  
Evaluation Comments questionFK NUMBER Yes No  
Evaluation Comments sectionFK NUMBER Yes No  
Evaluation Comments tenantId NUMBER Yes No  
Evaluation Comments text STRING Yes No  
Evaluations View additiveScore NUMBER Yes No  
Evaluations View adLogin STRING Yes No  
Evaluations View bandMax1 NUMBER Yes Yes BandMax1
Evaluations View bandMax2 NUMBER Yes Yes BandMax2
Evaluations View CallDuration STRING Yes No  
Evaluations View CalledNumber STRING Yes No  
Evaluations View CallId NUMBER Yes No  
Evaluations View CallingNumber STRING Yes No  
Evaluations View CallStartTime DATE Yes No  
Evaluations View ContactTimeZone STRING Yes No  
Evaluations View DateEvaluated DATE Yes No  
Evaluations View email STRING Yes Yes Person Email
Evaluations View EvalFormId NUMBER Yes Yes Evaluation Form ID
Evaluations View EvalFormQuestionOptionId NUMBER Yes Yes Evaluation Form Question Option ID
Evaluations View EvalFormQuestionOptiontypefk NUMBER Yes No  
Evaluations View EvalFormQuestionOptionTypeName STRING Yes No  
Evaluations View EvalFormSectionId NUMBER Yes No  
Evaluations View evaluatedTzFK NUMBER Yes No  
Evaluations View evaluatedTzOffset NUMBER Yes No  
Evaluations View EvaluationId NUMBER Yes No  
Evaluations View EvaluationTimeZone STRING Yes No  
Evaluations View evaluatorAdLogin STRING Yes No  
Evaluations View evaluatorEmail STRING Yes No  
Evaluations View evaluatorFirstName STRING Yes No  
Evaluations View evaluatorLastName STRING Yes No  
Evaluations View firstName STRING Yes Yes First Name
Evaluations View FormDescription STRING Yes Yes Form Description
Evaluations View FormName STRING Yes Yes Form Name
Evaluations View formQuestionFK NUMBER Yes No  
Evaluations View FormTotalPoints NUMBER Yes Yes Form Total Points
Evaluations View isCountedScore NUMBER Yes No  
Evaluations View kpi STRING Yes Yes Form KPI
Evaluations View label STRING Yes Yes Question Label
Evaluations View lastName STRING Yes Yes Last Name
Evaluations View ordinal NUMBER Yes No  
Evaluations View points NUMBER Yes Yes Question Points
Evaluations View PointsFormQuestionPossibleScore NUMBER Yes Yes PointsFormQuestionPossibleScore
Evaluations View QuestionPossibleScore NUMBER Yes Yes Question Possible Score
Evaluations View QuestionScore NUMBER Yes No  
Evaluations View QuestionText STRING Yes Yes Question Text
Evaluations View QuestionWeight NUMBER Yes Yes Question Weight
Evaluations View ScoringType STRING Yes Yes ScoringType
Evaluations View sectionAvg NUMBER Yes No  
Evaluations View SectionName STRING Yes Yes Section Name
Evaluations View sectionWeight NUMBER Yes No  
Evaluations View selectedOptionFK NUMBER Yes No  
Evaluations View TeamId NUMBER Yes Yes TeamId
Evaluations View TeamName STRING Yes Yes Team Name
Evaluations View totalScore NUMBER Yes No  
Forecast CreateModifiedDate DATE Yes No  
Forecast ForecastedAgents NUMBER Yes No  
Forecast ForecastedAgentsShrinkageApplied NUMBER Yes No  
Forecast ForecastedAverageTalkTime NUMBER Yes No  
Forecast ForecastedAverageWorkTime NUMBER Yes No  
Forecast ForecastedContacts NUMBER Yes No  
Forecast ForecastedServiceLevel NUMBER Yes No  
Forecast ForecastId NUMBER Yes Yes ForecastId
Forecast ForecastIntervalStart DATE Yes No  
Forecast ForecastScenarioId NUMBER Yes No  
Forecast ForecastScenarioName STRING Yes No  
Forecast ForecastServiceLevelPercent NUMBER Yes No  
Forecast ForecastServiceLevelTime NUMBER Yes No  
Forecast ForecastTotalShrinkagePercent NUMBER Yes No  
Forecast ServiceQueueId NUMBER Yes No  
Group GroupActivated DATE Yes No  
Group GroupCreated STRING Yes No  
Group Groupdeactivated DATE Yes Yes Group Deactivated
Group GroupId NUMBER Yes Yes GroupId
Group GroupName STRING Yes Yes Group Name
Group GroupUpdated STRING Yes No  
Group LastChangeDate STRING Yes No  
Group TeamActivated DATE Yes No  
Group TeamCreated STRING Yes No  
Group Teamdeactivated DATE Yes Yes Team Deactivated
Group TeamId NUMBER Yes Yes TeamId
Group TeamName STRING Yes Yes Team Name
Group TeamUpdated STRING Yes No  
Group TenantActivated STRING Yes No  
Group TenantCreated STRING Yes No  
Group Tenantdeactivated STRING Yes No  
Group TenantId NUMBER Yes No  
Group TenantName STRING Yes No  
Group TenantUpdated STRING Yes No  
Machine Learning CcrId NUMBER Yes No  
Machine Learning LastModifiedBy STRING Yes No  
Machine Learning LastModifiedDate DATE Yes No  
Machine Learning PredictiveEval NUMBER Yes No  
Machine Learning PredictiveMetaDataId NUMBER Yes No  
Machine Learning PredictiveNPS NUMBER Yes No  
Machine Learning PredictiveSentimentChannelA NUMBER Yes No  
Machine Learning PredictiveSentimentChannelB NUMBER Yes No  
Person 2 acdLoginId STRING Yes No  
Person 2 activated DATE Yes Yes Person Activated
Person 2 adLogin STRING Yes No  
Person 2 agentRank STRING Yes No  
Person 2 CreateModifiedDate DATE Yes No  
Person 2 deactivated DATE Yes Yes Person Deactivated
Person 2 departmentStartDate DATE Yes No  
Person 2 email STRING Yes Yes Person Email
Person 2 employeeId STRING Yes No  
Person 2 firstName STRING Yes Yes First Name
Person 2 fteFK NUMBER Yes No  
Person 2 LastModifiedDate DATE Yes No  
Person 2 lastName STRING Yes Yes Last Name
Person 2 memberGroupFK NUMBER Yes No  
Person 2 MinMaxHoursProfileId NUMBER Yes Yes MinMaxHoursProfileId
Person 2 peripheralId NUMBER Yes No  
Person 2 PersonId NUMBER Yes Yes Person ID
Person 2 PersonModifiedDate DATE Yes No  
Person 2 scheduleReleaseProfileId NUMBER Yes Yes Schedule Release Profile ID
Person 2 schedulingEndDate DATE Yes No  
Person 2 schedulingStartDate DATE Yes No  
Person 2 SchedulingTimeZoneId STRING Yes No  
Person 2 ServiceQueueId NUMBER Yes No  
Person 2 StaffingGroupId NUMBER Yes Yes Staffing Group ID
Person 2 WFMAgentCreatedDate DATE Yes No  
Person 2 WFMAgentId NUMBER Yes Yes Agent ID
Person 2 WFMAgentUpdatedDate DATE Yes No  
Person 2 WfoPersonCreatedDate DATE Yes No  
Person 2 WfoPersonUpdatedDate DATE Yes No  
Phrase List CreateModifiedDate DATE Yes No  
Phrase List LastModifiedDate DATE Yes No  
Phrase List PhraseCategoryName STRING Yes No  
Phrase List PhraseId NUMBER Yes No  
Phrase List PhraseText STRING Yes No  
Recording Event CcrId NUMBER Yes No  
Recording Event CreateModifiedDate DATE Yes No  
Recording Event duration NUMBER Yes Yes Duration
Recording Event RecordingEventCreatedDate DATE Yes Yes Recording Event Created Date
Recording Event RecordingEventId NUMBER Yes Yes Recording Event ID
Recording Event recordingEventTypeId NUMBER Yes Yes Recording Event Type ID
Recording Event RecordingEventUpdatedDate DATE Yes No  
Recording Event Type CreateModifiedDate DATE Yes No  
Recording Event Type displayName STRING Yes No  
Recording Event Type name STRING Yes No  
Recording Event Type RecordingEventTypeCreatedBy STRING Yes No  
Recording Event Type RecordingEventTypeId NUMBER Yes No  
Recording Event Type RecordingEventTypeUpdatedDate DATE Yes No  
Service Queue Historical Interval AbandonedContacts NUMBER Yes Yes SQHI Contacts Abandoned
Service Queue Historical Interval AgentsInService NUMBER Yes Yes SQHI Agents Actual
Service Queue Historical Interval AnsweredContacts NUMBER Yes Yes SQHI Contacts Actual
Service Queue Historical Interval AverageContactSeconds NUMBER Yes Yes SQHI Average Contact Seconds
Service Queue Historical Interval AverageSpeedOfAnswerSeconds NUMBER Yes Yes SQHI Average Speed Of Answer Seconds
Service Queue Historical Interval AverageWorkSeconds NUMBER Yes Yes SQHI Average Work Seconds
Service Queue Historical Interval BlockedContacts NUMBER Yes No  
Service Queue Historical Interval CreateModifiedDate DATE Yes No  
Service Queue Historical Interval FIL_DESCRIPTION STRING Yes Yes Service Queue Name
Service Queue Historical Interval FIL_SEQUENCE NUMBER Yes Yes Service Queue Id
Service Queue Historical Interval HandledContacts NUMBER Yes No  
Service Queue Historical Interval MaxContactsInQueue NUMBER Yes Yes SQHI Max Contacts In Queue
Service Queue Historical Interval OfferedContacts NUMBER Yes Yes SQHI Contacts Offered
Service Queue Historical Interval ServiceLevelDenominator NUMBER Yes Yes Service Level Denominator
Service Queue Historical Interval ServiceLevelNumerator NUMBER Yes Yes Service Level Numerator
Service Queue Historical Interval ServiceLevelPercent NUMBER Yes No  
Service Queue Historical Interval ServiceQueueHistoricalIntervalCreatedDate DATE Yes No  
Service Queue Historical Interval ServiceQueueHistoricalIntervalId NUMBER Yes No  
Service Queue Historical Interval ServiceQueueHistoricalIntervalStart DATE Yes Yes Interval Start
Service Queue Historical Interval ServiceQueueHistoricalIntervalUpdatedDate DATE Yes No  
Service Queue Historical Interval TotalAnswerDelaySeconds NUMBER Yes Yes SQHI Total Answer Delay Seconds
Service Queue Historical Interval TotalPeriodInServiceSeconds NUMBER Yes Yes SQHI Total Period In Service Seconds
Service Queue Historical Interval TotalReadySeconds NUMBER Yes Yes APD Ready Seconds
Service Queues acdServerId NUMBER No No  
Service Queues CalServicesCreatedBy STRING No No  
Service Queues CalServicesCreatedDate DATE Yes No  
Service Queues CalServicesUpdatedBy STRING No No  
Service Queues CalServicesUpdatedDate DATE Yes No  
Service Queues closedHoursRedistributionType NUMBER No No  
Service Queues CreateModifiedDate DATE Yes No  
Service Queues FIL_COULEUR NUMBER No No  
Service Queues FIL_DATE_CREATION DATE Yes No  
Service Queues FIL_DATE_DEBUT STRING No No  
Service Queues FIL_DATE_FIN STRING No No  
Service Queues FIL_DATE_MODIFICATION DATE Yes No  
Service Queues FIL_DELAI_MOYEN_ABANDON STRING No No  
Service Queues FIL_DESCRIPTION STRING Yes Yes Service Queue Name
Service Queues FIL_DIMANCHE_PER_HEURE_DEBUT STRING No No  
Service Queues FIL_DIMANCHE_PER_HEURE_FIN STRING No No  
Service Queues FIL_FILES_SOURCES STRING No No  
Service Queues FIL_FTE STRING No No  
Service Queues FIL_HOUR_BREAK_PER_WEEK STRING No No  
Service Queues FIL_INBOUND STRING No No  
Service Queues FIL_IND_ALERTE STRING No No  
Service Queues FIL_INDICATEUR_INTERPOLATION STRING No No  
Service Queues FIL_JEUDI_PER_HEURE_DEBUT STRING No No  
Service Queues FIL_JEUDI_PER_HEURE_FIN STRING No No  
Service Queues FIL_JOUR_01_FERMETURE STRING No No  
Service Queues FIL_JOUR_01_OUVERTURE STRING No No  
Service Queues FIL_JOUR_02_FERMETURE STRING No No  
Service Queues FIL_JOUR_02_OUVERTURE STRING No No  
Service Queues FIL_JOUR_03_FERMETURE STRING No No  
Service Queues FIL_JOUR_03_OUVERTURE STRING No No  
Service Queues FIL_JOUR_04_FERMETURE STRING No No  
Service Queues FIL_JOUR_04_OUVERTURE STRING No No  
Service Queues FIL_JOUR_05_FERMETURE STRING No No  
Service Queues FIL_JOUR_05_OUVERTURE STRING No No  
Service Queues FIL_JOUR_06_FERMETURE STRING No No  
Service Queues FIL_JOUR_06_OUVERTURE STRING No No  
Service Queues FIL_JOUR_07_FERMETURE STRING No No  
Service Queues FIL_JOUR_07_OUVERTURE STRING No No  
Service Queues FIL_LUNDI_PER_HEURE_DEBUT STRING No No  
Service Queues FIL_LUNDI_PER_HEURE_FIN STRING No No  
Service Queues FIL_MARDI_PER_HEURE_DEBUT STRING No No  
Service Queues FIL_MARDI_PER_HEURE_FIN STRING No No  
Service Queues FIL_MERCREDI_PER_HEURE_DEBUT STRING No No  
Service Queues FIL_MERCREDI_PER_HEURE_FIN STRING No No  
Service Queues FIL_MQA STRING No No  
Service Queues FIL_NIVEAU_PRECISION STRING No No  
Service Queues FIL_NO_SITE STRING No No  
Service Queues FIL_NUMERO NUMBER Yes No  
Service Queues FIL_ORDONNANCEMENT_DIMANCHE STRING No No  
Service Queues FIL_ORDONNANCEMENT_JEUDI STRING No No  
Service Queues FIL_ORDONNANCEMENT_LUNDI STRING No No  
Service Queues FIL_ORDONNANCEMENT_MARDI STRING No No  
Service Queues FIL_ORDONNANCEMENT_MERCREDI STRING No No  
Service Queues FIL_ORDONNANCEMENT_SAMEDI STRING No No  
Service Queues FIL_ORDONNANCEMENT_VENDREDI STRING No No  
Service Queues FIL_OUTBOUND STRING No No  
Service Queues FIL_POSTAGE STRING No No  
Service Queues FIL_PRIORITE STRING No No  
Service Queues FIL_PRODUCTIVITY_RATIO STRING No No  
Service Queues FIL_QUALITE_P NUMBER No No  
Service Queues FIL_QUALITY_THRESHOLD NUMBER No No  
Service Queues FIL_SAMEDI_PER_HEURE_DEBUT STRING No No  
Service Queues FIL_SAMEDI_PER_HEURE_FIN STRING No No  
Service Queues FIL_SANS_HISTORIQUES NUMBER No No  
Service Queues FIL_SANS_PREVISIONS NUMBER No No  
Service Queues FIL_SEQUENCE NUMBER Yes Yes Service Queue Id
Service Queues FIL_SEUIL_QUALITE_MAX NUMBER No No  
Service Queues FIL_TAUX_OCCUPATION NUMBER No No  
Service Queues FIL_TEMPS_CONVERS_STD STRING No No  
Service Queues FIL_TEMPS_PAS_LIB_STD STRING No No  
Service Queues FIL_TYPE_SERVICE NUMBER No No  
Service Queues FIL_UNCONFIGURED NUMBER No No  
Service Queues FIL_VENDREDI_PER_HEURE_DEBUT STRING No No  
Service Queues FIL_VENDREDI_PER_HEURE_FIN STRING No No  
Service Queues FIL_XRF_FUS_SEQUENCE NUMBER No No  
Service Queues handlingThreshold NUMBER No No  
Service Queues peripheralId NUMBER No No  
Service Queues precisionQueueId NUMBER No No  
Service Queues service_level_type STRING No No  
Service Queues serviceQueueType NUMBER No No  
Service Queues ShrinkageScenarioId STRING No No  
Service Queues tenantId NUMBER No No  
Text Analytics category STRING Yes No  
Text Analytics ccrid NUMBER Yes No  
Text Analytics date DATE Yes No  
Text Analytics firstName STRING Yes Yes First Name
Text Analytics group STRING Yes No  
Text Analytics groupId NUMBER Yes No  
Text Analytics lastName STRING Yes Yes Last Name
Text Analytics personId NUMBER Yes No  
Text Analytics phrase STRING Yes No  
Text Analytics position NUMBER Yes Yes Position
Text Analytics receiver STRING Yes Yes Receiver
Text Analytics sender STRING Yes Yes Sender
Text Analytics subject STRING Yes Yes Subject
Text Analytics team STRING Yes No  
Text Analytics teamId NUMBER Yes No  
Text Analytics textid NUMBER Yes No  
Timezone CreateModifiedby STRING Yes No  
Timezone CreateModifiedDate STRING Yes No  
Timezone DisplayName STRING Yes No  
Timezone javaName STRING Yes No  
Timezone SupportDaylightSavings NUMBER Yes No  
Timezone Timezone NUMBER Yes No  
Timezone UtcOffset NUMBER Yes No  
Transcription Analytics category STRING Yes No  
Transcription Analytics ccrId NUMBER Yes No  
Transcription Analytics channel NUMBER Yes No  
Transcription Analytics confidence NUMBER Yes No  
Transcription Analytics indexTimestamp DATE Yes No  
Transcription Analytics position NUMBER Yes Yes Position
Transcription Analytics start NUMBER Yes No  
Transcription Analytics stop NUMBER Yes No  
Transcription Analytics text STRING Yes No  
Transcription Analytics time DATE Yes No  
z_Legacy Contact Predictive Score CallDetailFactId NUMBER Yes No  
z_Legacy Contact Predictive Score ccrId NUMBER Yes No  
z_Legacy Contact Predictive Score CreatedDateTimeUTC DATE Yes No  
z_Legacy Contact Predictive Score evalScorePrediction NUMBER Yes No  
z_Legacy Contact Predictive Score netPromoterScore NUMBER Yes No  
z_Legacy Sentiment Analysis API agentid NUMBER Yes No  
z_Legacy Sentiment Analysis API ccrid NUMBER Yes No  
z_Legacy Sentiment Analysis API sentimentChannel1 NUMBER Yes No  
z_Legacy Sentiment Analysis API sentimentChannel2 NUMBER Yes No  
z_Legacy Sentiment Analysis API tenantid NUMBER Yes No