McDewey

Storage Description Field Name int NULL Purge run time in minutes which is the difference between purgeCompletedDataTime and purgeStartedDateTime. purgeRunTime Purge the old data from the historical tables periodically to ensure that the number of rows are within the recommended limits. The recommended limits for the number of rows in the historical tables are as follows: • agentstatedetail: Less than 10 million • agentconnectiondetail: Less than 10 million • contactcalldetail: Less than 8 million • contactqueuedetail: Less than 10 million • contactroutingdetail: Less than 10 million Note ReasoncodeLabelMap Database table name: ReasoncodeLabelMap Unified CCX maintains a table of reason codes and labels for Logout and Not Ready states. The reason codes and labels are available in the Cisco Finesse Administration console. This table holds the mapping between reason codes and labels. Table 54: ReasoncodeLabelMap Storage Description Field Name Smallint NOT NULL Primary Key Reason code as configured in the Cisco Finesse Administration console. code NVARCHAR(40,0) NOT NULL Reason label as configured in the Cisco Finesse Administration console. label NVARCHAR(15,0) NOT NULL Primary Key Type of reason code, label: NOT_READY LOGOUT category boolean NULL Specifies whether the record is active in the system. A record becomes Inactive if you delete the reason code label from the Cisco Finesse Administration console and mark the field as "FALSE". active Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 78 Database Schema ReasoncodeLabelMap