McDewey

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

Page 513

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

Keys and NULL Option Data Type Description Name NOT NULL CHANGESTAMP Incremented when the record is changed in the central database. ChangeStamp NULL varchar(255) A string of parameters the system software sends to the peripheral to initialize the skill group. ConfigParam NULL DBDATETIME Records the date and time when a record is added/updated. DateTimeStamp NOT NULL DBINT Usual entries are 0 (zero). Any records with DefaultEntry value > (greater than) 0 will be considered a default skill group for configuration purposes. Records having a DefaultEntry value of 1 are used by OPC as the default target skill group. Where only a base default skill group is created, it has a DefaultEntry value of 1. If sub-skill group records are created, the primary sub-group has a DefaultEntry value of 1, while the others have a DefaultEntry value of 2. Note An automatic DefaultEntry is created with each possible combination of Peripheral and MRDomain (PeripheralID and MRDOmainID) in the system. These entries are visible to configuration applications but cannot be directly modified. DefaultEntry NOT NULL DBCHAR Deleted Flag. Stored as a character: • Y = Yes • N = No Deleted NULL DBINT Foreign key from Department. NULL for global department. DepartmentID NULL DESCRIPTION Additional information about the group. Description AK-1 NOT NULL VNAME32 An enterprise name for the skill group. This name must be unique among all skill groups in the enterprise. EnterpriseName NULL VTELNO10 The extension number for the service (used by Lucent DEFINITY ECS). Extension NOT NULL DBCHAR Indicates whether or not this is an 'Unified ICM picks the agent (IPTA)' skill group: • Y = Yes, this is an IPTA skill group. • N = No, this is not an IPTA skill group. IPTA Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 495 All Tables Skill_Group