Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Note De Mise

 (via receivedReasonFK)

 (via finalDispositionTypeFK)

When an agent makes an email-related state change, the state change is recorded in the 
EEMEmailAgentStateDetail table. For each state change, there is an "eventStart" and an "eventEnd". 
The times for these are recorded in the corresponding eventStartDateTime and eventEndDateTime 
columns. Human-readable descriptions of states and reason codes are found in the 
EEMReasonCodeDescription and EEMStateDescription tables. Some events (login and logout) have a 
zero length duration, as the agent immediately moves to another state.

The EEMEmailAgentStateDetail table contains one row for each Email state change for an agent.

fromAddress

Email address of sender

lvarchar(320) 
NULL

toAddress

Email address(es) of recipient(s)

lvarchar(320) 
NULL

emailSubject

Subject line

nvarchar(200) 
NULL

EEMQueueId

Id of email queue email was routed to

Int 

NULL

receivedDateTime

Date the email was received by the mail server

datetime year to 
second 

NULL

receivedDateTimeGmt

Date the email was received by the mail server 
(GMT)

datetime year to 
second 

NULL

receivedReasonFK

Index into EEMReasonCodeDescription table, the 
reason code associated with this message

int 

NULL

agent

The agent login name, if an agent is working on this 
email, otherwise null.

nvarchar(64) 

NULL

finalDispositionTypeFK

Index into EEMEmailStatusDescription

int 

NULL

finalDispositionDateTime Date the email was disposed, in local time, 

otherwise null.

datetime year to 
second

NULL

finalDispositionDateTime
GMT

Date the email was disposed (GMT), otherwise null. datetime year to 

second 

NULL