McDewey

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

Page 273

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

Keys and NULL Option Data Type Description Name PK, FK, IE-1 NOT NULL DBINT Foreign Key from the Service table. SkillTargetID Enterprise_Skill_Group This table is one of the Enterprise tables (see Enterprise, on page 621). For database rules see Enterprise Tables, on page 699. Each row defines an enterprise-wide skill group composed of skill groups from different peripherals. Use Unified ICM Configuration Manager to add, update, and delete Enterprise_Skill_Group records. Related Tables Business_Entity, on page 107 (via EntityID) Enterprise_Skill_Group_Member, on page 256 (via EnterpriseSkillGroupID) Table 191: Indexes for Enterprise_Skill_Group Table index_keys index_description index_name EntityID, EnterpriseName nonclustered, unique, unique key located on PRIMARY XAK1Enterprise_Skill_Group EnterpriseSkillGroupID clustered, unique, primary key located on PRIMARY XPKEnterprise_Skill_Group Table 192: Fields in Enterprise_Skill_Group Table Keys and NULL Option Data Type Description Name NOT NULL CHANGESTAMP Incremented when the record is changed in the central database. ChangeStamp NULL DBDATETIME Records the date and time when a record is added/updated. DateTimeStamp NULL DESCRIPTION Additional information about the enterprise skill group. Description NULL DBINT A unique identifier that identifies a department in CCDM/CCMP deployment. DepartmentID Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 255 All Tables Enterprise_Skill_Group