McDewey

This table stores the details of prompt files and folders that are assigned to applications. Before updating the applicationpromptmap table, the system verifies if the selected prompt file or prompt folder is available in this table. If it is not available, a new record is created. Table 7: AssignedPrompts Table Fields Storage Description Field Name int NOT NULL Primary Key Unique identifier of the record. recordid int NOT NULL Primary Key Profile ID of the node. profileid int NOT NULL Unique identifier for the prompt file or folder assigned to the application. promptid small int NOT NULL To identify if the selection is a prompt file or folder. 0 = File 1 = Folder Default value: 0 type int NOT NULL The ID of parent folder of this prompt, which is stored in the assignedFolder table. parentfolderid lvarchar (255) NOT NULL Name of the prompt file or folder. name boolean Indicates whether the record is active in the Unified CCX system. A record becomes inactive if a prompt file or folder is renamed or deleted (name). f = Inactive t - Active active date time year to second Date and Time at which, the record is marked as inactive. Default value: NULL dateinactive AuditResidualSkills Database table name: audit_residualskills Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 13 Database Schema AuditResidualSkills