McDewey

Table 11: Fields in Agent_Distribution Table Keys and NULL Option Data Type Description Name PK NOT NULL DBINT A unique identifier for the agent distribution. AgentDistributionID NOT NULL DBCHAR The flag that indicates to send Agent historical to HDS server filtered by peripheral. Default: Y AgentHistoricalData NOT NULL CHANGESTAMP Incremented when the record is changed in the central database. ChangeStamp NULL DBDATETIME Records the date and time at which the record was added / updated. DateTimeStamp AK-1 NOT NULL VNAME32 The name of the Distributor site to which agent data is sent. DistributorSiteName NOT NULL DBCHAR Indicates whether to send agent data or not: • Y = Yes, an agent can send data. • N = No, an agent cannot send data. Enabled AK-1, FK NOT NULL DBSMALLINT The peripheral from which agent data is sent. PeripheralID Agent_Event_Detail This table is one of the Agent Detail tables in the Skill Target category (see Skill Target, on page 635). To see database rules for these tables, see Skill Target Tables, on page 702. This table can become large. 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 (one that is not used for other Unified ICM and Unified CCE components). Use only DBDateTime (date and time of the record that was written to the HDS database) to perform the extraction. The table on the custom database can be indexed according to the custom reporting needs. You can have this capabilities only if you enable Agent Event Details checkbox from the PG Explorer. To get the additional Agent Events, the extended Agent events feature has to be turned ON. Note Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 28 All Tables Agent_Event_Detail