Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Release Note
1-51
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1 Database Schema
Database Table Details
Related Tables
•
(applicationServerID maps to nodeID)
•
(applicationServerID maps to nodeID)
•
(applicationServerID maps to nodeID)
•
(applicationServerID maps to nodeID)
•
(applicationServerID maps to nodeID)
•
(applicationServerID maps to nodeID)
EEMActiveEmail
When an email is being processed by an agent, a record for that email is created in the EEMActiveEmail
table. The columns in the table are updated as the agent works on the email. When the email is terminated
(sent, deleted, requeued), the record is deleted.
table. The columns in the table are updated as the agent works on the email. When the email is terminated
(sent, deleted, requeued), the record is deleted.
The EEMActiveEmail table contains one row for each email message being processed by an agent
Database table name: EEMActiveEmail
Table 1-31
EEMActiveEmail Table Fields
Field Name
Description
Storage
emailID
Unique record identifier
SERIAL
NOT NULL
Primary key
Primary key
emailUIDOnMailServer Identifier for this email message
nvarchar(20)
NULL
NULL
fromAddress
Email address of sender
lvarchar(320)
NULL
NULL
toAddress
Email address(es) of recipient(s)
lvarchar(320)
NULL
NULL
emailSubject
Subject line
Nvarchar(200)
NULL
NULL
receivedDateTime
Date the email was received by the mail server, in local
time.
time.
datetime year to
second
second
NULL
receivedDateTimeGmt
Date the email was received by the mail server (GMT). datetime year to
second
NULL
EEMQueueId
Id of email queue email was routed to
Int
NULL
queuedDateTime
Date the email was placed into the CSQ, in local time. datetime year to
second
NULL