04-23-2009 05:45 AM - edited 03-14-2019 04:00 AM
Hello,
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?
Thanks,
Met.
04-27-2009 03:16 AM
Hello,
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.
HTH
--bas
04-27-2009 03:48 AM
Hi,
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,
met.
04-27-2009 03:54 AM
Met,
Thanks for the guide name.
What does
SELECT * FROM EEMReasonCodeDescription give you?
--bas
04-27-2009 04:07 AM
hello friend,
In fact it should be the table!
But when i return all rows from the table it is an empty rowset...
ish..
thanks!
met.
04-27-2009 04:55 AM
What happens if you create a custom reason code and query that table again?
--bas
04-27-2009 05:20 AM
Hi,
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..
thanks,
met.
09-01-2011 03:22 AM
Did anyone get this to work? I am after the table that shows the reason code to reason code descriptions in UCCX 8.5.
09-01-2011 04:22 AM
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.
Aaron
Please rate helpful posts..
09-01-2011 05:43 AM
That helps a lot, thanks very much Aaron. I have rated your response.
Many thanks,
Kiarash
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide