McDewey

AuditReskill Database table name: audit_reskill The Unified CCX system creates a new record in the audit_reskill table for addition, deletion, and increase or decrease in the competency level of resources or CSQ skills. Supervisors can revert the changes that are made to the resource skills either manually or through the Auto-Removal option from the Supervisor desktop. Table 9: audit_reskill Table Fields Storage Description Field Name int NOT NULL Primary Key Numeric identifier of the record. recordID int NOT NULL Primary Key Identifier of the Unified CCX profile that is associated with this record. profileID nvarchar(128,0) NOT NULL User ID in the Unified CM configuration. resourceLoginID int NOT NULL Numeric identifier for the CSQ. csqID smallint NOT NULL The type of operation performed on the resource or CSQ: • Resource_Modified(1) • Csq_Modified(2) • Csq_Added(3) • Csq_Deleted(4) • Skill_Deleted(5) operation smallint NOT NULL The resultant action because of type of operation performed on the resource: • Added_to_csq(1) • Removed_from_csq(2) result int NOT NULL The record ID corresponding to the skill group from the audit_skillgroup table for a CSQ. skillgrouprecordid Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 15 Database Schema AuditReskill