Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: PFCCWA on April 17, 2020, 01:43:29 PM
-
hello
does anyone have the table join info for the interaction flow report in GCXI (we have yet to deploy the solution).
I am trying to replicate it using the info mart tables and whilst I can create a fair portion, there are missing timelines that im not sure where it would be taken from.
I am using INTERACTION_FACT (IF), INTERACTION_RESOURCE_FACT (IRF), MEDIATION_SEGMENT_FACT (MSF), RESOURCE_ (RES) tables to try and piece it together.
our call flow takes into account multiple Strategies, Route Points (RP), ACD Queue, IVR voice treatment port, External Route Point and Agent (+consultations/transfers).
An example of the difficulty is that I can get the last used RP however not any of the previous RPs - if all were used in the call. I can however get the total time spent on all the route points from just the IRF.
thanks.
-
Info Mart 8+ does not have such information, unfortunately. Up to version 7.6, you could extract the entire flow in a table that no longer exists: INTERACTION_SEGMENT_FACT (ISF).
IRF only has the last RP before a handling resource.
You can make your own flow using GIDB_G_PARTY_V, GIDB_G_ROUTERESULT_V and GIDB_G_VIRTUALQUEUE_V tables, but those GIDB tables are purged quite quickly (usually store up to 7 days only). And in Multisite scenarios, you would need to Join with GIDB_G_CALL_V, GIDB_G_IS_LINK_V
-
[quote author=hsujdik link=topic=11586.msg52798#msg52798 date=1587133105]
Info Mart 8+ does not have such information, unfortunately. Up to version 7.6, you could extract the entire flow in a table that no longer exists: INTERACTION_SEGMENT_FACT (ISF).
IRF only has the last RP before a handling resource.
You can make your own flow using GIDB_G_PARTY_V, GIDB_G_ROUTERESULT_V and GIDB_G_VIRTUALQUEUE_V tables, but those GIDB tables are purged quite quickly (usually store up to 7 days only). And in Multisite scenarios, you would need to Join with GIDB_G_CALL_V, GIDB_G_IS_LINK_V
[/quote]
this is great and has helped achiever what I needed.
do the GIDB tables have the technical results, resource roles and reason which would have been obtained from the TECHNICAL_DESCRIPTOR table.
thanks,
-
[quote author=PFCCWA link=topic=11586.msg52808#msg52808 date=1587332811]
do the GIDB tables have the technical results, resource roles and reason which would have been obtained from the TECHNICAL_DESCRIPTOR table.
[/quote]
Not exactly. They have some columns called CCEvent and CCEventCause. The values on those columns are mapped according to the dictionary that you can find at:
https://docs.genesys.com/Documentation/ICON/latest/PDMOra/GDict
You will probably want to check the dictionaries 30 and 31.