UCCX 7.01 - Get ReasonCode description for report

Unanswered Question
Apr 23rd, 2009


I know that we can get reason codes for agents actions from reasonCode field in AgentStatusDetail table.

I can get the reason code but can't find out where to get the description , like logout, loggof. Is there any table that contains this mapping?



I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (1 ratings)
sebastiaanv Mon, 04/27/2009 - 03:16


On our UCCE 7.2 environment the following displays the agentid, agent extension, the reasoncode and the reason description:

SELECT T3.EnterpriseName, T2.Extension, T1.ReasonText, T1.Description

FROM t_Reason_Code T1, t_Agent_Real_Time T2, t_Agent T3

WHERE T1.ReasonCode = T2.ReasonCode

AND T3.SkillTargetID = T2.SkillTargetID

ORDER BY T1.ReasonText

I couldn't find the Database schema for UCCX 7, the table you are looking for is called 'Reason_Code' in UCCE.



metalium2007 Mon, 04/27/2009 - 03:48


i can't find that table on the schema for uccx 7. There is a document:

Cisco Unified Contact Center Express Database Schema Guide 7.01

And i can't really find it. Maybe there isnt a table that maps the primary key number to a reason text in uccx? weird..

can anyone confirm it to me?

best regards,


sebastiaanv Mon, 04/27/2009 - 03:54


Thanks for the guide name.

What does

SELECT * FROM EEMReasonCodeDescription give you?


metalium2007 Mon, 04/27/2009 - 04:07

hello friend,

In fact it should be the table!

But when i return all rows from the table it is an empty rowset...




sebastiaanv Mon, 04/27/2009 - 04:55

What happens if you create a custom reason code and query that table again?


metalium2007 Mon, 04/27/2009 - 05:20


Created a new reason code:

77 - ReasonCodeXPTO

Applied it to the Not Ready and Logout lists...and after returning all rows from the table, the rowset is still empty..



kiarash.kazemi Thu, 09/01/2011 - 03:22

Did anyone get this to work? I am after the table that shows the reason code to reason code descriptions in UCCX 8.5.

Aaron Harrison Thu, 09/01/2011 - 04:22

Hi All

EEM refers to the email subsystem. There is no table in the UCCX DB that lists reason codes mapped to descriptions, it's stored in the 'dark side'... in the Calabrio LDAP directories or somewhere.

I generally do static mappings in the client app. Not because I think it's a good way to do it, but because there's no other way as far as I can tell.


Please rate helpful posts..

kiarash.kazemi Thu, 09/01/2011 - 05:43

That helps a lot, thanks very much Aaron. I have rated your response.

Many thanks,



This Discussion