Recent Articles
Genesys Adapter - Technical Documentation
Executive Summary The Genesys Adapter provides comprehensive, enterprise-grade solutions for synchronizing Genesys Cloud contact center data into various database platforms including Microsoft SQL Server, PostgreSQL, and Snowflake. These integrations ...
public.z_vwcallabandonedsummary
Description See CallAbandonedSummary: Summary of abandoned calls with relevant details Table Definition CREATE VIEW z_vwcallabandonedsummary AS ( SELECT det.conversationid, det.conversationstartdate, (det.conversationstartdate AT TIME ZONE ...
public.vwuserpresencedetaileddata
Description See UserPresenceDetailedData - Expands all the GUIDs with their lookups(Detailed) Table Definition CREATE VIEW vwuserpresencedetaileddata AS ( SELECT upd.keyid, upd.userid, ud.name AS agentname, ud.managerid, ud.divisionid, ...
public.vwrealtimequeueconv
Description Real-time queue conversation data Table Definition CREATE VIEW vwrealtimequeueconv AS ( SELECT qc.conversationid, qc.media, qc.actingas, datediff('second'::character varying, qc.startdate, timezone('utc'::text, now())) AS statussecs, ...
public.vwqueuerealtimedata
Description Table Definition CREATE VIEW vwqueuerealtimedata AS ( SELECT qc.keyid, qc.queueid, qd.name AS queuename, qc.media, qc.statscount, qc.startdate, qc.startdateltc, COALESCE(datediff('second'::character varying, qc.startdate, ...