Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: PFCCWA on March 04, 2014, 02:41:12 PM

Title: Field Values for Contact info type and Call Result in SQL DB
Post by: PFCCWA on March 04, 2014, 02:41:12 PM

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.

Title: Re: Field Values for Contact info type and Call Result in SQL DB
Post by: Kubig 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.

Title: Re: Field Values for Contact info type and Call Result in SQL DB
Post by: cavagnaro 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.

Title: Re: Field Values for Contact info type and Call Result in SQL DB
Post by: minuteman 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