/mcpTable 16: Indexes for Agent_Logout Table index_keys index_description index_name LogoutDateTime, SkillTargetID, TimeZone, MRDomainID Primary key XPKAgent_Logout RecoveryKey Unique key XAK1Agent_Logout DbDateTime Inversion key XIEAgent_Logout Table 17: Fields in Agent_Logout Table Keys and NULL Option Data Type Description Name IE-1 NULL DBDATETIME The current date and time stamp when the records are written to the HDS database. The logger database has NULL for this column DbDateTime NULL varchar (32) Extension the Agent was logged in Extension NULL DBINT Number of seconds the agent was logged in. LoginDuration PK NOT NULL DBDATETIME Central Controller date and time when the agent logged out. LogoutDateTime PK NOT NULL DBINT The identifier for the Media Routing Domain associated with the agent logout. MRDomainID NULL DBINT The device target the agent was logged on to. This applies to Unified CCE agents only. NetworkTargetID NULL DBSMALLINT The type of phone being used: 0 = normal ACD/Unified CCE phone, or non-voice task 1 = remote phone, call by call 2 = remote phone, nailed connection All new agent logout data has a NOT NULL value by default. During upgrade or migration, the value for this column is NULL. PhoneType NULL DBINT Reason code returned by the peripheral for the agent logout. See Reason Codes, on page 675. ReasonCode AK-1 NOT NULL DBFLT8 A unique ID assigned to each record and used internally by the Unified ICM and Unified CCE Enterprise software to track the record. RecoveryKey NULL varchar(32) For a mobile agent working remotely, the current phone number. RemotePhoneNumber Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 41 All Tables Agent_Logout