McDewey

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

Page 84

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

Keys and NULL Option Data Type Description Name PK, FK NOTNULL DBINT The SkillTargetID of the agent. Together with SkillGroupSkillTargetID identifies the skill group member. SkillTargetID PK NOTNULL DBINT The Central Controller’s time zone for the date and time. The value is the offset in minutes from UTC (formerly GMT).The value is negative for time zones to the east of UTC and positive for time zones to the west of UTC. TimeZone Agent_Skill_Group_Real_Time 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. Local database only. Each row provides real-time statistics for a member of a skill group. If an individual agent is a member of multiple skill groups, multiple Agent Skill Group Real Time rows are created for that agent. The software generates an Agent_Skill_Group_Real_Time 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) • Precision_Queue, on page 346 (through PrecisionQueueID) Table 24: Index for Agent_Skill_Group_Real_Time Table index_keys index_description index_name SkillTargetID, SkillGroupSkillTargetID Primary key XPKAgent_Skill_Group_Real_Time Table 25: Fields in Agent_Skill_Group_Real_Time Table Keys and NULL Option Data Type Description Name NULL DBINT The current real time state of the agent. To see the list of Agent States, see AgentState, on page 654. AgentState NULL DBINT AttributeID1 of the agent associated with the Precision Queue. AttributeID1 Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 66 All Tables Agent_Skill_Group_Real_Time