/mcpIt contains information about handling each call at a peripheral. Therefore, the system generates a Termination_Call_Detail record for each call that arrives at a peripheral. 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 data from the HDS into your custom database. The custom database must be on a separate server and ensure that other Unified ICM or Unified CC Enterprise components do not use it. Use only DBDateTime (the date and time of the record when written to the HDS database) to perform the extraction. You can index the table on the custom database according to the custom reporting needs. Related Tables • Agent, on page 17 (the AgentSkillTargetID maps to Agent.SkillTargetID. SourceAgentSkillTargetID maps to Agent.SkillTargetID) • Call_Type, on page 112 (through CallTypeID) • Media_Routing_Domain, on page 305 (through MRDomainID) • Network_Target, on page 310 (through NetworkTargetID) • Peripheral, on page 326 (through PeripheralID) • Precision_Queue, on page 346 (through PrecisionQueueID) • Route, on page 379 (through RouteID) • Route_Call_Detail, on page 380 (through Day + RouterCallKey) • Service, on page 452 (ServiceSkillTargetID maps to Service.SkillTargetID) • Skill_Group, on page 493 (SkillGroupSkillTargetID maps to Skill_Group.SkillTargetID) • Termination_Call_Variable, on page 585 (RecoveryKey maps to Termination_Call_Variable.TCDRecoveryKey) Table 440: Indexes for Termination_Call_Detail Table index_keys index_description index_name RecoveryKey Primary key Note This primary key is nonclustered. XPKTermination_Call_Detail DateTime, PeripheralID, ICRCallKey Unique key Note This unique key is clustered. XAK2Termination_Call_Detail DateTime Inversion key XIE1Termination_Call_Detail DbDateTime Inversion key XIE2Termination_Call_Detail RouterCallKeyDay, RouterCallKey Inversion key XIE3Termination_Call_Detail CallGUID Inversion key XIE4Termination_Call_Detail Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 567 All Tables Termination_Call_Detail