McDewey

Storage Description Field Name boolean NOT NULL Whether this record is active. Possible values: f = inactive t = active active datetime year to second NULL If active = f, the time when the record became inactive. dateInactive CrsProperties Database table name: CrsProperties This table stores the configuration properties as key-value pair. Table 38: CrsProperties Table Fields Storage Description Field Name lvarchar(256) NOT NULL Unique identifier of the property from a properties file. propertyname lvarchar(2048) NOT NULL Specifies the value of the property from a properties file. propertyvalue CrsTrigger Database table name: CrsTrigger The CrsTrigger table describes trigger information. A trigger is uniquely identified by a trigger name (triggerName). When a trigger is created, a new record is inserted into this table. When a trigger is modified, the old record is marked as inactive, and a new record is inserted into the table with a new recordID. When a trigger is deleted, the corresponding record will be marked as inactive. Table 39: CrsTrigger Table Fields Storage Description Field Name int NOT NULL Primary Key Unique numeric ID for each record. Introduced for historical reporting purposes. recordID int NOT NULL Primary Key Indentifier of the profile Possible values: 1, 2, 3.... profileID Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 56 Database Schema CrsProperties