Genesys Cloud
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 Subscription user license data with user details Table Definition CREATE VIEW vwsubuserlicensedata AS ( SELECT l.keyid, l.userid, l.username AS licensedusername, l.email AS licensedemail, l.licenseid, l.licensename, l.licensetype, ...
public.vwlicensecountsbytype
Description Aggregate license counts by license type 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 Per-user license assignments from Genesys Cloud. Tracks which licenses are assigned to each user including Copilot license status. Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false Unique identifier: ...
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 ...
public.vwassistantenabledinteractions
Description Detailed interaction data for queues with AI assistant enabled, including AI-generated summaries Table Definition CREATE VIEW vwassistantenabledinteractions AS ( SELECT d.conversationid, d.participantid, d.participantname, ...
public.vw_assistant_details
Description View of assistant details with normalized user names and copilot configuration Table Definition CREATE VIEW vw_assistant_details AS ( SELECT ast.id, ast.name, ast.datecreated, ast.datemodified, ct.username AS createdby, md.username AS ...
public.copilotusagedata
Description Copilot feature usage analytics data with full groupBy dimension support Columns Name Type Default Nullable Children Parents Comment keyid varchar(200) false SHA256 hash of all groupBy dimensions + interval for uniqueness conversationid ...
public.convvoicesummarydata
Description AI-generated summaries for voice conversations from Genesys Cloud Speech and Text Analytics Columns Name Type Default Nullable Children Parents Comment keyid varchar(150) false Primary key composed of conversation ID, summary type, and ...
public.botreportingturns
Description Columns Name Type Default Nullable Children Parents Comment id text false userinput text true botprompt text true sessionid varchar(200) true actionid varchar(200) true actionname varchar(100) true actionnumber integer true actiontype ...
public.assistantdetails
Description Manage virtual agent assistants Columns Name Type Default Nullable Children Parents Comment id varchar(100) false Primary Key name varchar(50) true Name of the assistant datecreated timestamp without time zone true Date when the assistant ...
public.odmessagingcampaigndetails
Description Outbound Messaging Campaign Lookup Data (SMS, Email, WhatsApp) Columns Name Type Default Nullable Children Parents Comment id varchar(50) false Messaging Campaign GUID name varchar(200) true Messaging Campaign Name datecreated timestamp ...
public.flowdetails
Description Flow Details Columns Name Type Default Nullable Children Parents Comment id varchar(255) false Flow ID name varchar(255) false Flow Name divisionid varchar(50) true Division ID description varchar(500) true Flow Description type ...
public.vwflowoutcomedetails
Description Normalized Flow Outcome Details (with division and user lookups) Table Definition CREATE VIEW vwflowoutcomedetails AS ( SELECT fod.id, fod.name, fod.description, fod.divisionid, dd.name AS divisionname, fod.operationid, CASE WHEN ...
public.vwflowoutcomedata
Description Flow Outcome Data with conversation summary enrichment and outcome name Table Definition CREATE VIEW vwflowoutcomedata AS ( SELECT fod.keyid, fod.conversationid, fod.conversationstartdate, fod.conversationstartdateltc, ...
public.vwlearninguserassignmentsummary
Description Comprehensive user-centric view combining learning assignments and results. Shows complete learning lifecycle per user including assignment status, completion status, and performance metrics. Key relationships: userdetails -> ...
public.vwlearningmodulecompletionanalytics
Description Module-centric analytics view providing comprehensive completion rates, performance metrics, and assignment statistics. Calculates completion rates, pass rates, average scores, and timing analytics per learning module. Optimized for ...
public.vwlearningassignmentcorrelation
Description Direct correlation view between learning assignments and their completion results. Tracks complete assignment lifecycle from assignment to completion with timing and performance metrics. Includes calculated fields for lifecycle status, ...
public.vwevaluationquestiondata
Description View for evaluation question data (converted from materialized view) Table Definition CREATE VIEW vwevaluationquestiondata AS ( SELECT DISTINCT eq.keyid, eq.evaluationid, eq.questionid, eq.answerid, eq.score, ed.questionanswervalue, ...
Next page