McDewey

Storage Description Field Name boolean NOT NULL Whether this record is active: f —Inactive t —Active A record becomes inactive if the resource is deleted or updated. active boolean NOT NULL Determines whether the resource goes to Ready State after handling a Unified CCX call: f —No t —Yes autoAvail nvarchar(50,0) NOT NULL The Unified CCX extension of the resource. extension int NULL Order in which the resource resides within the resource group. Null if no resource group is assigned to the resource. orderInRG datetime year to fraction(3) NULL Date and time that the record became inactive when the active field is "f". dateInactive int NOT NULL Identifier used to locate the associated skill set of the resource in the ResourceSkillMapping table. The ResourceSkillMapping table can contain multiple records for one resource. resourceSkillMapID int NOT NULL Team ID of the resource. assignedTeamID nvarchar(50,0) NOT NULL First name of the resource. resourceFirstName nvarchar(50,0) NOT NULL Last name of the resource. resourceLastName nvarchar(50,0) NULL Alias name of the resource. resourceAlias smallint NOT NULL Advanced Supervisor Capabilities for the resource. capabilities nvarchar(255) NULL Email ID of the resource. resourceEmailId Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 82 Database Schema Resource