McDewey

Storage Description Field Name datetime year to second NULL Data collection starting time. startdatetime datetime year to second NULL Date and time this table was last updated. enddatetime varchar(25,0) NULL Average talk duration in HH:MM:SS format. convavgtalkduration varchar(25,0) NULL Average wait duration in HH:MM:SS format. convavgwaitduration varchar(25,0) NULL Longest talk duration in HH:MM:SS format. convlongesttalkduration varchar(25,0) NULL Longest wait duration in HH:MM:SS format. convlongestwaitduration varchar(25,0) NULL Oldest call in the queue in HH:MM:SS format. convoldestcontact Schedule Reskill Database table name: schedule_reskill The Unified CCX system creates a new record in the Schedule Reskill table when an agent is scheduled to be added or removed from a queue. It also indicates whether the agent was scheduled by a supervisor or administrator. Table 64: Skill Table Fields Storage Description Field Name int NOT NULL Primary Key Unique identifier of the record. recordid nvarchar(128,0) NOT NULL The login ID of the resource being rekilled for a CSQ. resourceloginid int NOT NULL Unique identifier of the CSQ for which the resource is being reskilled. csqid Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 91 Database Schema Schedule Reskill