McDewey

The Unified CCX system stores the skills or competencies that could not be removed due to overlapping skills across queues in the AuditResidualSkills table. Table 8: audit_residualskills Fields Storage Description Field Name int NOT NULL Primary Key Unique identifier for the record. Default value = 0 recordid nvarchar(128,0) NOT NULL The resource login ID. resourceloginid int NOT NULL Numeric identifier of the skill that was not removed from the audit_skillgroup table. skillid int NOT NULL Agent’s existing skill level that was not removed from the audit_skillgroup table. fromcompetency int NOT NULL Agent’s modified skill level that was not removed from the audit_skillgroup table. tocompetency smallint NOT NULL The type of operation performed on the skill that was not removed from the audit_skillgroup table. operation int NOT NULL Record ID of the audit_reskill table, which is the parent of the residual entity. Default value = 0 residualparentid boolean NOT NULL Indicates if the record is active or not. Default value = f, which indicates that the record is inactive. The record is inactive when you remove the residual skill or modify the competency. t = Indicates that the record is active. The record is active when the residual skill exists in the resource. active datetime year to second Date and Time at which, the record is made inactive. dateinactive The values in the skillid, fromcompetency, tocompetency, and operation fields are the same as that of the corresponding record in the audit_skillgroup table. Note Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 14 Database Schema AuditResidualSkills