McDewey

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

Page 28

↗ View in doc context
page
28
source
uccx/v12.5/db-schema-guide/uccx-12.5su1-db-schema-guide.md
chunk_id
uccx::v12.5::db-schema-guide::uccx-12.5su1-db-schema-guide::21

Storage Description Field Name nvarchar(128,0) NOT NULL Login ID of the user. reskiller smallint NOT NULL Resource is reskilled by: • Supervisor(1) • Admin(2) • System(3) Note If the resource is reskilled by the Auto-Removal option, the reskiller_type is System. reskiller_type datetime year to fraction(3) NOT NULL Date and Time this record was changed. reskilledtimestamp boolean NOT NULL Indicates whether the record is active based on the values in the "result" field in the audit_reskill table. • True=The record is active when a resource is added to a CSQ and the value of the "result" field is "Added_to_csq". • False =The record is inactive when the resource is removed from the CSQ and the value of the "result" field is "Removed_from_csq". If an active record exists for the same resource and the same CSQ, then this record is alo marked inactive. active Related Topics AuditSkillGroup, on page 16 AuditSkillGroup Database table name: audit_skillgroup The Unified CCX system creates a new record in the audit_skillgroup table when resources are added or removed from a CSQ. This record is created when addition, deletion, or increase or decrease in the competency level of a resource skill. Table 10: audit_skillgroup Table Fields Storage Description Field Name int NOT NULL Primary Key Numeric identifier of the record. recordID Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 16 Database Schema AuditSkillGroup

Page 28 diagram