McDewey

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

Page 83

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

Agent_Skill_Group_Logout This table is 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. Each row provides information about a single login session for a member of a skill group. If an individual agent is a member of multiple skill groups, multiple Agent Skill Group Logout rows are created for that agent. The software generates an Agent_Skill_Group_Logout record for each skill group member. Related tables • Skill_Group_Member, on page 527 (SkillTargetID + SkillGroupSkillTargetID maps to Skill_Group_Member.AgentSkillTargetID + Skill_Group_Member.SkillGroupSkillTargetID) Table 22: Indexes for Agent_Skill_Group_Logout Table index_keys index_description index_name LogoutDateTime, SkillTargetID, SkillGroupSkillTargetID, TimeZone Primary key XPKAgent_Skill_Group_Logout RecoveryKey Unique key XAK1Agent_Skill_Group_Logout DbDateTime Inversion key XIE1Agent_Skill_Group_Logout Table 23: Fields in Agent_Skill_Group_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 DBINT Number of seconds the agent was logged in to the skill group. LoginDuration PK NOTNULL DBDATETIME Date and time when the agent logged out of the skill group. LogoutDateTime NULL DBINT Reason code returned by the peripheral for the agent logout. See Reason Codes, on page 675. ReasonCode AK-1 NOTNULL DBFLT8 A unique ID assigned to each record and used internally by the Unified ICM or Unified CCE software to track the record. RecoveryKey PK, FK NOTNULL DBINT Together with SkillTargetID identifies the skill group member. SkillGroupSkillTargetID Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 65 All Tables Agent_Skill_Group_Logout