McDewey

C H A P T E R 1 Database Schema • Database Table Details, on page 1 Database Table Details Each description provides the following information: • Database Table Name—Name of the Unified CCX database table. • Field Name—Name of a field as it appears in the database table. • Description—Description of the field, including valid values where appropriate. • Storage—Information about the data in each field as follows: • Data type used for the field in the database. For storage characteristics and limitations of the data types used for the fields in the databases refer to "IBM Informix SQL Reference Guide". The date and time in the database fields are stored in Coordinated Universal Time (UTC). Note • Whether the NULL value is valid for the field. “NULL” if the NULL value is or “NOT NULL” if the NULL value is not valid. If the NULL value is valid, the database will record a value of -1 for a numeric field and an empty string for other fields. Note • “Primary Key” if the field is a primary key, or part of a primary key, in the database table. Overview of Tables The following tables are described in this guide: • AgentConnectionDetail, on page 4, contains records written for calls that are connected to an agent. Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 1