McDewey

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

Page 515

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

Keys and NULL Option Data Type Description Name NOT NULL DBSMALLINT Indicates how the system software calculates the service level for the skillgroup. If this field is 0, Unified ICM uses the default specified for the associated Peripheral/MRD pair in the Service_Level_Threshold table. Possible values: • 0 = Use Default • 1 = Ignore Abandoned Calls • 2 = Abandoned Call Has Negative Impact: • 3 = Abandoned Call Has Positive Impact: ServiceLevelType PK, FK, NOT NULL DBINT An identifier that is unique among all skill targets in the enterprise. SkillTargetID NOT NULL DBSMALLINT Indicates whether to use the SubSkillGroupMask field for the skill group or to use the peripheral default: • 0 = Use peripheral default. • 1 = Override the peripheral default. SubGroupMaskType NULL varchar(64) A series of characters (Y and N) indicating which sub-skill groups to create for the skill group. Ignored if SubGroupMaskType is 0. SubSkillGroupMask NOT NULL DBCHAR Indicates if the record can be deleted by a user. Default is Y. UserDeletable Skill_Group_Five_Minute 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. It gets populated on central and HDS databases. This table contains statistics about each skill group during the five-minute interval. The Unified ICM generates Skill_Group_Five_Minute records for each skill group. Related table Skill_Group, on page 493 (via SkillTargetID) Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 497 All Tables Skill_Group_Five_Minute