McDewey

Table 5: ApplicationPromptMap 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 nvarchar (50) NOT NULL Name of the application. applicationname int NOT NULL Unique identifier for the prompt file or folder assigned to the application. This is retrieved from assignedprompts table. promptid boolean Indicates whether the record is active or not. By default, it is True. It is marked as False when either the application or the assigned prompt (file or folder) is deleted. active date time year to second Date and Time at which, the record is marked as inactive. Default value: NULL dateinactive AreaCode Database table name: AreaCode The AreaCode table contains a mapping of area codes and their time zones. This table is used as a reference for populating the gmtPhone and dstPhone columns of the DialingList table. This table is pre-populated by the Unified CCX system with the data for North America during the installation process, using a SQL script that the installer invokes. If the Unified CCX is installed in a different location, administrators can enter the area code and time zone information for that region using Unified CCX Administration, and the data is stored in this table. Table 6: AreaCode Table Fields Storage Description Field Name int NOT NULL Primary Key Identifier of the profile. profileid Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 11 Database Schema AreaCode