McDewey

Storage Description Field Name boolean NOT NULL Whether the record is active in the Unified CCX system: f —Inactive t —Active A record becomes inactive if the resource group is deleted or updated. active datetime year to fraction(3) NULL If the active field is “f”, date and time that the record became inactive. dateInactive Related Topics • ContactServiceQueue , on page 47 (via resourceGroupID, profileID) • ProfileIDMapping, on page 75 (via profileID) • Resource, on page 81 (via resourceGroupID, profileID) ResourceSkillMapping Database table name: ResourceSkillMapping The Unified CCX system creates a new record in the ResourceSkillMapping table when an agent is associated with a skill in the Unified CCX Administration. A ResourceSkillMapping record contains information about all of the skills that are assigned to resources. Table 58: ResourceSkillMapping Table Fields Storage Description Field Name int NOT NULL Primary Key Identifier of the skill set that is associated with a resource. resourceSkillMapID int NOT NULL Primary Key Identifier of the skill that is associated with a resource. skillID int NOT NULL Primary Key Identifier of the Unified CCX profile that is associated with this record. profileID smallint NOT NULL Competence level associated with the skill, as set up in the Unified CCX Administration. Values range from 1 (lowest) to 10 (highest). competenceLevel Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 84 Database Schema ResourceSkillMapping