Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Prithy on January 06, 2016, 10:22:55 AM

Title: Call UUID as primary key in master table
Post by: Prithy on January 06, 2016, 10:22:55 AM

Hi all,

Could we use the Genesys system variable - CallUUID as the primary key for logging in our DB.
Are there any limitations of using the same.

Please share.

Thanks,

Title: Re: Call UUID as primary key in master table
Post by: Kubig on January 06, 2016, 01:21:35 PM

It depends on what you want to log into database. CallUUID is a unique key for interaction, but interaction might have several parts, so in case where you will store all parts as separated row/record, the CallUUID will not be unique for this.

Title: Re: Call UUID as primary key in master table
Post by: Prithy on January 07, 2016, 11:10:34 AM

Hi Kubig,

We wanted to log the CallUUID as a unique key for a customer inbound call. Could you please also help us in the length of the CallUUID to allocate the field length in the table.

Thanks,

Title: Re: Call UUID as primary key in master table
Post by: Kubig on January 07, 2016, 12:08:20 PM

varchar2(50 char) is enough for this type of data

Title: Re: Call UUID as primary key in master table
Post by: Prithy on January 07, 2016, 12:22:45 PM

Many Thanks to you ..