Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Note De Mise
1-52
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1 Database Schema
Database Table Details
Related Tables
•
(via emailStatusFK)
•
(via emailUIDOnMailServer)
EEMContactEmailDetail
When an email message is placed into a CSQ, a record for that email message is created in this table.
When the email is assigned to an agent, the agent name column is updated. When the email is terminated
(sent, deleted, requeued), the finalDisposition columns are updated.
When the email is assigned to an agent, the agent name column is updated. When the email is terminated
(sent, deleted, requeued), the finalDisposition columns are updated.
The EEMContactEmailDetail table contains one row for each email message currently in the system.
Database table name: EEMContactEmailDetail
queuedDateTimeGmt
Date the email was placed into the CSQ (GMT).
datetime year to
second
second
NULL
draftUIDOnMailServer
If message is in draft, the UID of the draft. Currently
always blank; reserved for future use
always blank; reserved for future use
nvarchar(20)
NULL
NULL
emailStatusFK
The email status
Int
NULL
Foreign Key
agent
The agent login name, if an agent is working on this
email, otherwise null.
email, otherwise null.
nvarchar(64)
NULL
NULL
getDateTime
Date/Time email was assigned to an agent, in local
time.
time.
datetime year to
second
second
NULL
getDateTimeGmt
Date/Time email was assigned to an agent (GMT).
datetime year to
second
second
NULL
inProcessTimeSeconds
Number of seconds, cumulative, that one or more
agents has spent in the processing state for this email.
agents has spent in the processing state for this email.
Int
NULL
Table 1-31
EEMActiveEmail Table Fields (continued)
Field Name
Description
Storage
Table 1-32
EEMContactEmailDetail Table Fields
Field Name
Description
Storage
ContactEmailDetailId
Unique record identifier
SERIAL
NOT NULL
Primary key
Primary key
emailUIDOnMailServer
Identifier for this email message
nvarchar(20)
NULL