Max String Size for Analytics Metrics

[anon75321043]

Hi guys,

We are defining the data schemas in our databases for some Analytics details that we'll be getting from Genesys Cloud and I've been asked to provide the maximum character size per "String Field" specifically for the following metrics:

1. Any type of IDs (conversationId, divisionId, queueId, userId, etc..): we have noticed that ID's usual lenght is 37 characters, but we would like to confirm if this size can change.
2. participantName
3. purpose: could you please confirm that these are all the available options? (acd, agent, api, botflow, campaign, customer, dialer, external, fax, group, inbound, ivr, manual, outbound, station, user, voicemail, workflow). Based on this the max size should be 10 characters?
4. Direction / originatingDirection: could you please confirm that these are all the available options? (inbound, outbound). Based on this the max size should be 8 characters?
5. Anis & Dnis: could we consider 15 digit based on the e164 format + 4 digits for the prefix (sip: / tel:), total 19 characters?
6. codec: Since Genesys Cloud uses MIME types of audio encoding, what would be the maximum size for this field or the possible returned values?
7. mediaType: could you please confirm that these are all the available options? (callback, chat, cobrowse, email, message, screenshare, unknown, video, voice). Based on this the max size should be 12 characters?
8. disconectType: could you please confirm that these are all the available options? (client, conferenceTransfer, consultTransfer, endpoint, error, forwardTransfer, noAnswerTransfer, notAvailableTransfer, other, peer, spam, system, timeout, transfer, transportFailure, uncallable). Based on this the max size should be 21 characters ("notAvailableTransfer")?
9. segmentType: could you please confirm that these are all the available options? (client, conferenceTransfer, consultTransfer, endpoint, error, forwardTransfer, noAnswerTransfer, notAvailableTransfer, other, peer, spam, system, timeout, transfer, transportFailure, uncallable). Based on this the max size should be 13 characters ("transmitting")?
   10: usedRouting: could you please confirm that these are all the available options? (Bullseye, Last, Manual, Predictive, Preferred, Standard). Based on this the max size should be 11 characters ("Predictive")?

Thanks!

[anon11147534]

Hi Carlos,

The dev forum is for customers and partners. Please use internal channels for support.