Genesys Cloud
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, ...
public.vwevaluationoverview
Description View for evaluation overview data (converted from materialized view) Table Definition CREATE VIEW vwevaluationoverview AS ( SELECT concat(evaldata.conversationid, '|', evaldata.evaluationid, '|', evaldata.evaluationformid) AS keyid, ...
public.vwevaluationgroupdata
Description View for evaluation group data (converted from table) Table Definition CREATE VIEW vwevaluationgroupdata AS ( SELECT egd.keyid, egd.evaluationid, egd.questiongroupid, ( SELECT ed.questiongroupname FROM evaldetails ed WHERE ...
public.vwconvvoicetopicdetaildata
Description View for conversation voice topic detail data combining topic analysis with conversation summary data Table Definition CREATE VIEW vwconvvoicetopicdetaildata AS ( SELECT ct.keyid, ct.conversationid, ct.starttime, ct.starttimeltc, ...
public.vwconvvoicesentimentdetaildata
Description View for conversation voice sentiment detail data combining sentiment analysis with conversation summary data Table Definition CREATE VIEW vwconvvoicesentimentdetaildata AS ( SELECT ct.keyid, ct.conversationid, ct.starttime, ...
public.vwconvvoiceoverviewdata
Description View for conversation voice overview data combining voice analytics with conversation summary data Table Definition CREATE VIEW vwconvvoiceoverviewdata AS ( SELECT cv.conversationid, cv.sentimentscore, cv.sentimenttrend, ...
public.kq_analysis_taxonomy
Columns Name Type Default Nullable Children Parents Comment kq_analysistaxonomyid varchar(50) false Primary key for the taxonomy analysis record kq_analysisid varchar(50) true References the parent kq_analysis record taxonomy varchar(200) true Legacy ...
public.kq_analysis_question
Columns Name Type Default Nullable Children Parents Comment kq_analysisquestionid varchar(50) false Primary key for the question analysis record kq_analysisid varchar(50) true References the parent kq_analysis record question text true The question ...
public.kq_analysis
Columns Name Type Default Nullable Children Parents Comment kq_analysisid varchar(50) false Primary key for the knowledge analysis record conversationid varchar(50) true ID of the Genesys Cloud conversation this analysis relates to communicationid ...
public.z_vwcallabandonedsummary
Description Summary of abandoned calls with key details Table Definition CREATE VIEW z_vwcallabandonedsummary AS ( SELECT det.conversationid, det.conversationstartdate, (det.conversationstartdate AT TIME ZONE 'Australia/Sydney'::text) AS ...
public.vwuserpresencedetaileddata
Description Detailed user presence data with lookup expansion Table Definition CREATE VIEW vwuserpresencedetaileddata AS ( SELECT upd.keyid, upd.userid, ud.name AS agentname, ud.managerid, ud.divisionid, ud.managername, upd.starttime, ...
public.vwrealtimequeueconv
Description Real-time queue conversation data Table Definition CREATE VIEW vwrealtimequeueconv AS ( SELECT qc.conversationid, qc.media, qc.actingas, datediff('second'::text, 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'::text, qc.startdate, timezone('utc'::text, ...
public.vwofferedforecast
Description Table Definition CREATE VIEW vwofferedforecast AS ( SELECT DISTINCT ofd.keyid, ofd.businessunitid, bu.name AS "BUSINESSUNITNAME", ofd.scheduleid, scd.description AS "SCHEDULEDESC", ofd.planninggroup AS "PLANNINGGROUPID", ...
public.vwevalquestiongroupdata
Description One row per scored question group in an evaluation, with achieved and maximum group scores Table Definition CREATE VIEW vwevalquestiongroupdata AS ( SELECT (((egd.evaluationformid)::text || '|'::text) || (egd.questiongroupid)::text) AS ...
public.vwevaldata
Description Evaluation data with user context Table Definition CREATE VIEW vwevaldata AS ( SELECT DISTINCT ed.keyid, ed.agenthasread, ed.assigneddate, ed.assigneddateltc, ed.conversationid, ed.evaluationformid, ed.evaluationid, ed.evaluatorid, ...
public.z_wfmscheduledata
Description WFM schedule data combining schedule and time off information Table Definition CREATE VIEW z_wfmscheduledata AS ( SELECT sc.userid, sc.shiftstartdate, sc.shiftlengthtime, sc.activitystartdate, sc.activitystartdateltc, ...
public.queuerealtimedata
Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false queueid varchar(50) true media varchar(50) true statscount numeric(20,2) true startdate timestamp without time zone true startdateltc timestamp without time zone ...
public.jobminimumdefinition
Columns Name Type Default Nullable Children Parents Comment jobid integer nextval(‘jobminimumdefinition_jobid_seq’::regclass) false jobname varchar(255) true maxsyncspan varchar(50) true lookbackspan varchar(50) true Constraints Name Type Definition ...
public.vwuserskillmappings
Description View combining user-skill mappings with detailed user information (including manager, division, and division name) and corresponding skill details Table Definition CREATE VIEW vwuserskillmappings AS ( SELECT usm.keyid, usm.userid, ud.name ...
public.vwusergroupmappings
Description Table Definition CREATE VIEW vwusergroupmappings AS ( SELECT ugm.id, ugm.name, ud.id AS user_id, ud.name AS user_name, ugm.groupid AS group_id, ugm.updated FROM (usergroupmappings ugm JOIN userdetails ud ON (((ugm.userid)::text = ...
public.flowoutcomedetails
Description Flow Outcome Details Columns Name Type Default Nullable Children Parents Comment id varchar(255) false Flow Outcome ID name varchar(255) false Flow Outcome Name divisionid varchar(50) true Division ID description varchar(255) true ...
public.flowoutcomedata
Description Conversation Flow Outcome Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false conversationid varchar(50) true Conversation GUID conversationstartdate timestamp without time zone false Conversation ...
public.servicegoaldetails
Columns Name Type Default Nullable Children Parents Comment id varchar(50) false name varchar(50) true servicelevelpercent integer true servicelevelseconds integer true averagespeedofanswer integer true abandonrate integer true lastmodifiedby ...
public.learningmodules
Columns Name Type Default Nullable Children Parents Comment id varchar(50) false name varchar(100) true description varchar(500) true version varchar(255) true externalid varchar(50) true source varchar(50) true enforcecontentorder boolean true ...
public.learningmoduleassignments
Description Learning Module Assignments Table - Stores assignment data for learning modules assigned to users. This table tracks the complete lifecycle of learning module assignments from initial assignment through completion. It serves as the ...
public.learningassignmentresults
Description Learning Assignment Results Table - Stores detailed results and completion data for learning module assignments. This table captures the outcome and performance metrics when users complete learning module assignments. It serves as the ...
Next page