McDewey

Storage Description Field Name datetime year to second NOT NULL Default -CURRENT_TIMESTAMP createdatetime int NOT NULL Primary Key Unique identifier for the record recordid nvarchar(10) NOT NULL Primary Key The area code of the call. areacode nvarchar(10) NULL Uses the same data as that of gmtzone. regioncode char(1) NOT NULL Indicates whether daylight savings time is observed. • N = Daylight savings time is not observed. • Y = Daylight savings time is observed. daylightsavingsenabled int NULL Stores identifiers that internally maps to the GMT offset corresponding to the area code. gmtzone BLOB NULL Any fields which are to be used internally only. privatedata boolean NOT NULL Whether the record is active in the system. A record becomes inactive if the team is deleted from the system. f = Inactive t = Active active datetime year to second NULL Date this record was deleted. dateinactive Related Topics ProfileIDMapping, on page 75 DialingList , on page 61 Assigned Prompts Database table name: AssignedPrompts Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 12 Database Schema Assigned Prompts