McDewey

Multi-vendor documentation library · semantic search · MCP endpoint at /mcp

Page 243

↗ View in doc context
page
243
source
ucce/v15.0.1/db-schema-handbook/db-schema-handbook.md
chunk_id
ucce::v15.0.1::db-schema-handbook::db-schema-handbook::229

Dialer_Detail This table is in the Blended Agent category. (See Blended Agent (Outbound Option), on page 616.) To see database rules for these tables, see Blended Agent Tables (Outbound Option), on page 695. Because this table grows larger in size, running custom reporting queries against it while it is on the HDS can degrade performance. To optimize performance, extract the data from the HDS into your own custom database on a separate server (that other Unified CCE components do not use). Use only DBDateTime (date and time of the record that was written to the HDS database) to extract the data. You can index the table on the custom database according to the custom reporting needs. If Outbound Option was not selected during setup, this table contains no data. Note This historical table tracks data on all outbound attempts, including personal callback attempts and preview calls that an agent skips. Unified CCE and G3 Support: The Dialer_Detail table is supported for Unified CCE only. Dialer Detail records are not supported for the G3 dialer. Some records might be written to the Dialer_Detail table for older G3 dialers, but do not use the records. Note Related Tables • Campaign, on page 156(through CampaignID) • Campaign_Skill_Group, on page 184 (through CampaignID) • Dialer, on page 220 (through DialerID) • Dialer_Real_Time, on page 240 (through DialerID) • Peripheral, on page 326 (through PeripheralID) • Query_Rule, on page 362 (through QueryRuleID) Table 164: Indexes for Dialer_Detail Table index_keys index_description index_name RecoveryKey Primary key XPKDialer_Detail DbDateTime Inversion key XIE1Dialer_Detail CampaignReportingDateTime Inversion key XIE2Dialer_Detail RouterCallKey, RouterCallKeyDay Inversion key XIE3Dialer_Detail CallGUID Inversion key XIE4Dialer_Detail DateTime Inversion key XIE5Dialer_Detail Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 225 All Tables Dialer_Detail