" /> Field Values for Contact info type and Call Result in SQL DB - Genesys CTI User Forum

Author Topic: Field Values for Contact info type and Call Result in SQL DB  (Read 2574 times)

Offline PFCCWA

  • Hero Member
  • *****
  • Posts: 655
  • Karma: -7
Field Values for Contact info type and Call Result in SQL DB
« on: March 04, 2014, 02:41:12 PM »
Advertisement
Hello,

Does anyone know which table would provide me with the values for fields such as contact info type or call result?
I know the schema is not available for configuration server but looking to determine what is required for an import directly into the calling list through DB.
Most of the values are in outbound contact reference manual but would be useful if DBA can use genesys table to reference and write relevant value into the column.

thanks.
« Last Edit: March 04, 2014, 02:59:50 PM by PFCCWA »

Offline Kubig

  • Hero Member
  • *****
  • Posts: 2755
  • Karma: 44
Re: Field Values for Contact info type and Call Result in SQL DB
« Reply #1 on: March 04, 2014, 03:04:08 PM »
The association between number and constant name is hardcoded as a struct in application, so it does not present in any DB or external data store.

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7641
  • Karma: 56330
Re: Field Values for Contact info type and Call Result in SQL DB
« Reply #2 on: March 05, 2014, 01:54:55 AM »
[quote author=PFCCWA link=topic=8245.msg36301#msg36301 date=1393944072]
Does anyone know which table would provide me with the values for fields such as contact info type or call result?
[/quote]

It is very well documented on the Outbound deployment/reference guides.

Offline minuteman

  • Newbie
  • *
  • Posts: 17
  • Karma: 0
Re: Field Values for Contact info type and Call Result in SQL DB
« Reply #3 on: April 06, 2014, 06:07:41 AM »
It could be retrieved from config server DB, for example for call result:

select lc_subtype, lc_value from cfg_locale
where lcid=1
and lc_class=8
and lc_type=18

but I suggest to simply create your own dictionary table