Genesys Cloud
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 Evaluation Question Group Detailed Data Table Definition CREATE VIEW vwevalquestiongroupdata AS ( SELECT concat(egd.evaluationformid, '|', egd.questiongroupid) AS questiongroupfactkey, egd.keyid, egd.evaluationid, egd.questiongroupid, ...
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 ...
public.knowledgebasedocumentversion
Columns Name Type Default Nullable Children Parents Comment id varchar(50) false datepublished timestamp without time zone true dateexpires timestamp without time zone true documentid varchar(50) true versionnumber integer true updated timestamp ...
public.knowledgebasedocument
Columns Name Type Default Nullable Children Parents Comment id varchar(50) false title varchar(255) true visible boolean true state varchar(50) true datecreated timestamp without time zone true datemodified timestamp without time zone true ...
public.knowledgebasecategorydata
Columns Name Type Default Nullable Children Parents Comment id varchar(50) false name varchar(100) true description varchar(255) true externalid varchar(100) true datecreated timestamp without time zone true datemodified timestamp without time zone ...
public.knowledgebase
Columns Name Type Default Nullable Children Parents Comment id varchar(50) false name varchar(100) true description varchar(255) true corelanguage varchar(50) true datecreated timestamp without time zone true datemodified timestamp without time zone ...
README
Logo Genesys Adapter Data Dictionary Tables Name Columns Comment Type public.tabledefinitions 5 Subscription Detailed Data BASE TABLE public.activeqmembersdata 9 Historical Active Membership of Queues BASE TABLE public.activitycodedetails 11 Activity ...
public.mvwevaluationoverview
Description Backward compatibility alias for vwEvaluationOverview - DEPRECATED: Use vwEvaluationOverview instead Table Definition CREATE VIEW mvwevaluationoverview AS ( SELECT vwevaluationoverview.keyid, vwevaluationoverview.conversationid, ...
public.vwadherenceexcdata
Description Adherence exception data with lookup expansion Table Definition CREATE VIEW vwadherenceexcdata AS ( SELECT ad.userid, ad.startdate, ad.enddate, ad.startdateltc, ad.enddateltc, ad.durationsecs, ((ad.durationsecs)::numeric / 86400.00) AS ...
public.vwmumemberdata
Description MU Member Data Table Definition CREATE VIEW vwmumemberdata AS ( SELECT mudetails.id AS mu_id, mudetails.name AS mu_name, mumemberdata.id AS user_id, vwuserdetail.name AS user_name, vwuserdetail.managername AS manager_name FROM ...
public.vwrealtimeuser
Description Real-time user data Table Definition CREATE VIEW vwrealtimeuser AS ( SELECT rd.name AS user_name, rd.id AS user_id, rd.divisionid, rd.groupname, rd.managername, rd.managerid, CASE WHEN (rd.systempresence = 'ON_QUEUE'::text) THEN ...
public.vwqueueinteractiondata
Description Queue Interaction Data Interval Data - Interval is from (15-60) Min(s) Table Definition CREATE VIEW vwqueueinteractiondata AS ( SELECT queueinteractiondata.keyid, queueinteractiondata.startdate, queueinteractiondata.startdateltc, ...
public.vwuserpresencedata
Description User presence data with lookup expansion Table Definition CREATE VIEW vwuserpresencedata AS ( SELECT pd.id, pd.userid, ud.name AS agentname, ud.managerid, ud.managername, ud.divisionid, dd.name AS divisionname, pd.startdate, ...
public.vwsurveydata
Description Survey Data View Table Definition CREATE VIEW vwsurveydata AS ( SELECT surveydata.surveyid, surveydata.conversationid, surveydata.surveyformid, surveydata.surveyname, surveydata.agentid, agent.name AS agentname, agent.department AS ...
public.vwwrapupdetails
Description WrapUpDetails Table Definition CREATE VIEW vwwrapupdetails AS ( SELECT wrapupdetails.id, wrapupdetails.name, wrapupdetails.updated FROM wrapupdetails ) Columns Name Type Default Nullable Children Parents Comment id varchar(50) true ...
public.vwskillmemberdata
Description Contains data on skill mappings for users Table Definition CREATE VIEW vwskillmemberdata AS ( SELECT sm.userid, ud.name AS user_name, sd.name AS skill_name, sm.proficiency, sm.state FROM ((userskillmappings sm LEFT JOIN vwuserdetail ud ON ...
Next page