Genesys Cloud
public.vwoutboundcampaign
Description Outbound campaign model: one row per voice campaign as currently configured in Genesys Cloud, from odcampaigndetails. Table Definition CREATE VIEW vwoutboundcampaign AS ( SELECT c.id AS campaign_id, c.name AS campaign_name, ...
public.vwoutboundattemptdatabuild
Description Build query for the outboundattemptdata table: one row per Attempt (one dial placed for an outbound campaign) computed from detailedinteractiondata alone; companion Sessions are attributed by peer. The Interaction job selects one UTC day ...
public.vwoutboundattemptdata
Description Outbound attempt model: one row per outbound campaign dial attempt from outboundattemptdata, with attempt_number computed per contact on read. Table Definition CREATE VIEW vwoutboundattemptdata AS ( SELECT outboundattemptdata.attempt_id, ...
public.outboundattemptdata
Description One row per outbound campaign dial attempt, rebuilt per UTC day by the Interaction job from vwOutboundAttemptDataBuild. Query vwOutboundAttemptData. Columns Name Type Default Nullable Children Parents Comment attempt_id varchar(120) false ...
public.vwinteractionlegdatabuild
Description Build query for the interactionlegdata table: one row per answered Leg computed from detailedinteractiondata, keyed by (conversationid, conversationstartdate). The Interaction job selects one UTC day of conversationstartdate at a time ...
public.interactionlegdata
Description One row per answered Leg (agent participant that handled a Conversation), rebuilt per UTC day by the Interaction job from vwInteractionLegDataBuild. Abandoned interactions produce no row; filter on conversationstartdate for partition ...
public.vwrealtimemonitorservicehealth
Description Table Definition CREATE VIEW vwrealtimemonitorservicehealth AS ( WITH service_rows AS ( SELECT realtimeadaptermonitordata.keyid, realtimeadaptermonitordata.servicename, realtimeadaptermonitordata.status, ...
public.vwrealtimemonitorqueueobsmedia
Description Table Definition CREATE VIEW vwrealtimemonitorqueueobsmedia AS ( SELECT replace((realtimeadaptermonitordata.keyid)::text, 'QueueObsService:media:'::text, ''::text) AS media, realtimeadaptermonitordata.servicename, ...
public.vwrealtimemonitoroverview
Description Table Definition CREATE VIEW vwrealtimemonitoroverview AS ( WITH service_rows AS ( SELECT realtimeadaptermonitordata.keyid, realtimeadaptermonitordata.servicename, realtimeadaptermonitordata.status, realtimeadaptermonitordata.isrunning, ...
public.realtimeadaptermonitordata
Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false servicename varchar(100) true status varchar(50) true isrunning boolean true eventsprocessed bigint true errorcount bigint true activeconnections integer true ...
public.vwuserroutingstatusdetaileddata
Description User routing status periods only, including OFF_QUEUE; presence periods are in vwUserPresenceDetailedData Table Definition CREATE VIEW vwuserroutingstatusdetaileddata AS ( SELECT (upd.userid)::text AS user_id, (upd.routingstatus)::text AS ...
public.vwuserlanguagemappings
Description User routing language assignments with user and division context Table Definition CREATE VIEW vwuserlanguagemappings AS ( SELECT (ulm.userid)::text AS user_id, (ud.name)::text AS user_name, (ud.divisionid)::text AS division_id, ...
public.vwinteractionlegdata
Description One row per answered interaction leg (queue plus agent handling pair) with rolled-up IVR/queue/talk/hold/wrap times, transfer chain, and per-leg wrap-up/disconnect/Genesys metrics. Abandoned interactions (queued, never handled) produce no ...
public.userlanguagemappings
Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false userid varchar(50) true languageid varchar(50) true languagename varchar(255) true proficiency numeric(20,2) true state varchar(50) true updated timestamp without ...
public.vwplanninggroupbusinessunit
Description Convenience view joining planning groups to their business units Table Definition CREATE VIEW vwplanninggroupbusinessunit AS ( SELECT pg.id AS planninggroupid, pg.name AS planninggroupname, pg.businessunitid AS ...
public.vwoauthusagedetaileddata
Description Table Definition CREATE VIEW vwoauthusagedetaileddata AS ( SELECT oauthusagedetaileddata.clientid, oauthusagedetaileddata.rowdate, oauthusagedetaileddata.clientname, oauthusagedetaileddata.organizationid, oauthusagedetaileddata.userid, ...
public.oauthusagedetaileddata
Description Detailed OAuth usage by client, endpoint and HTTP method per day Columns Name Type Default Nullable Children Parents Comment keyid varchar(200) false Primary Key clientid varchar(50) true OAuth Client GUID rowdate timestamp without time ...
public.vwsubuserlicensedata
Description License assignment history: one row per Assignment interval, open or closed, with user details Table Definition CREATE VIEW vwsubuserlicensedata AS ( SELECT l.keyid, l.userid, l.username AS licensedusername, l.email AS licensedemail, ...
public.vwlicensecountsbytype
Description Assignment interval counts per license name Table Definition CREATE VIEW vwlicensecountsbytype AS ( SELECT l.licensename, l.licensetype, count(DISTINCT l.userid) AS totalusers, sum( CASE WHEN (l.licenseactive = true) THEN 1 ELSE 0 END) AS ...
public.vwknowledgedocumentfeedback
Description Comprehensive view of knowledge document feedback with user, document, version, and knowledge base context Table Definition CREATE VIEW vwknowledgedocumentfeedback AS ( SELECT fb.keyid, fb.feedbackid AS feedback_id, fb.datecreated AS ...
public.vwknowledgedocument
Description Comprehensive view of knowledge documents with knowledge base, category context, and feedback statistics Table Definition CREATE VIEW vwknowledgedocument AS ( SELECT doc.id, doc.title, doc.visible, doc.state, doc.datecreated AS ...
public.vwknowledgecategory
Description Knowledge base categories with KB context, document statistics, feedback metrics, and hierarchy information Table Definition CREATE VIEW vwknowledgecategory AS ( SELECT cat.id AS category_id, cat.name AS category_name, cat.description AS ...
public.vwknowledgebase
Description Comprehensive view of knowledge bases with document, category, feedback, and usage statistics Table Definition CREATE VIEW vwknowledgebase AS ( SELECT kb.id, kb.name, kb.description, kb.corelanguage AS core_language, kb.datecreated AS ...
public.vwknowledgeaggregatesdata
Description Knowledge usage analytics with user and knowledge base context for reporting Table Definition CREATE VIEW vwknowledgeaggregatesdata AS ( SELECT ka.keyid, ka.intervalstart AS interval_start, ka.intervalend AS interval_end, ka.usagedate AS ...
public.vwcopilotlicensedusers
Description Users with active Copilot licenses Table Definition CREATE VIEW vwcopilotlicensedusers AS ( SELECT l.userid, l.username, l.email, l.licenseid, l.licensename, l.licensetype, l.licenseassignmentdate, l.divisionid, l.updated, ud.name AS ...
public.subuserlicensedata
Description License assignment history from Genesys Cloud: one row per Assignment interval, open or closed. User attributes are copied from userdetails when a row is written. Columns Name Type Default Nullable Children Parents Comment keyid ...
public.knowledgedocumentfeedbackdata
Columns Name Type Default Nullable Children Parents Comment keyid varchar(200) false feedbackid varchar(50) false knowledgebaseid varchar(50) false documentid varchar(50) false rating varchar(20) true reason varchar(50) true comment text true userid ...
public.knowledgebasedocumentvariation
Columns Name Type Default Nullable Children Parents Comment id varchar(50) false documentid varchar(50) true documentversionid varchar(50) true knowledgebaseid varchar(50) true name varchar(255) true priority integer true datecreated timestamp ...
public.knowledgeaggregatesdata
Description Aggregated knowledge base usage metrics from Genesys Cloud Analytics API Columns Name Type Default Nullable Children Parents Comment keyid varchar(200) false Primary key - SHA256 hash of all dimensions and interval agentassistantid ...
public.agentcopilotaggregatesdata
Description Aggregated agent copilot usage metrics from Genesys Cloud Analytics API with all 24 dimensions Columns Name Type Default Nullable Children Parents Comment keyid varchar(200) false SHA256 hash of all 24 dimensions + interval for uniqueness ...
public.systemcallusagedata
Description System conversation usage statistics per minute Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false Primary Key rowdate timestamp without time zone true Date/time for the minute slot mediatype varchar(50) ...
public.vwscheduledatacomplete
Description Combined schedule and full-day time-off data Table Definition CREATE VIEW vwscheduledatacomplete AS ( SELECT sc.scheduleid, sc.userid, sc.shiftid, sc.shiftstartdate, sc.shiftstartdateltc, sc.shiftlengthtime, sc.activitystartdate, ...
public.kq_analysis_question_keyword
Columns Name Type Default Nullable Children Parents Comment kq_analysisquestionkeywordid varchar(50) false kq_analysisquestionid varchar(50) false keyword varchar(100) false updated timestamp without time zone true Constraints Name Type Definition ...
public.kq_analysis_keyword
Columns Name Type Default Nullable Children Parents Comment kq_analysiskeywordid varchar(50) false kq_analysisid varchar(50) false keyword varchar(100) false updated timestamp without time zone true Constraints Name Type Definition ...
public.vwbotreportingturnsdata
Description Normalized view of bot reporting turns with categorized confidence levels, feedback ratings, and duration calculations Table Definition CREATE VIEW vwbotreportingturnsdata AS ( SELECT brt.id, brt.flowid, brt.flowname, brt.sessionid, ...
public.botreportingturnsdata
Columns Name Type Default Nullable Children Parents Comment id text false flowid varchar(100) true flowname varchar(255) true userinput text true botprompt text true sessionid varchar(200) true actionid varchar(200) true actionname varchar(100) true ...
public.vwcopilotusagedata
Description Copilot usage analytics with user and queue context Table Definition CREATE VIEW vwcopilotusagedata AS ( SELECT cu.keyid, cu.conversationid, cu.summaryid, cu.usagedate, cu.userid, ud.name AS agent_name, ud.username AS agent_username, ...
public.vwcopilotsummaryinsights
Description Copilot summary insights with usage context Table Definition CREATE VIEW vwcopilotsummaryinsights AS ( SELECT cs.conversationid, cs.conversationstartdate, cs.conversationenddate, cs.conversationstartdateltc, cs.conversationenddateltc, ...
public.vwbotreportingturns
Description Normalized view of bot reporting turns with categorized confidence levels, feedback ratings, and duration calculations Table Definition CREATE VIEW vwbotreportingturns AS ( SELECT brt.id, brt.sessionid, brt.conversationid, brt.actionid, ...
public.vwassistantqueuesummary
Description Summary statistics for queues with AI assistant enabled, including interaction counts and summary generation metrics Table Definition CREATE VIEW vwassistantqueuesummary AS ( SELECT q.id AS queueid, q.name AS queuename, q.description AS ...
Next page