Genesys Cloud
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(50) false Flow Outcome Name divisionid varchar(50) true Division ID description varchar(50) 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
Description 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 ...
public.learningmodules
Description Columns Name Type Default Nullable Children Parents Comment id varchar(50) false name varchar(100) true description varchar(100) true version varchar(255) true externalid varchar(50) true source varchar(50) true enforcecontentorder ...
public.learningmoduleassignments
Description Columns Name Type Default Nullable Children Parents Comment id varchar(50) false assessmentid varchar(50) true isoverdue boolean true version varchar(255) true percentagescore numeric(20,2) true assessmentpercentagescore numeric(20,2) ...
public.learningassignmentresults
Description Columns Name Type Default Nullable Children Parents Comment id varchar(50) false assessmentid varchar(50) true moduleid varchar(50) true assessmentformid varchar(50) true passpercent numeric(20,2) true assessmentpercentagescore ...
public.knowledgebasedocumentversion
Description 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 ...
public.knowledgebasedocument
Description 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 ...
public.knowledgebasecategorydata
Description 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 ...
public.knowledgebase
Description 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 ...
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 Materialized view for evaluation overview data Table Definition CREATE MATERIALIZED VIEW mvwevaluationoverview AS ( SELECT concat(evaldata.conversationid, '|', evaldata.evaluationid, '|', evaldata.evaluationformid) AS keyid, ...
public.vwadherenceexcdata
Description See AdherenceExcData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwadherenceexcdata AS ( SELECT ad.userid, ad.startdate, ad.enddate, ad.startdateltc, ad.enddateltc, ad.durationsecs, ((ad.durationsecs)::numeric ...
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 See UserPresenceData - Expands all the GUIDs with their lookups 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, ...
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 ...
public.vwbudetails
Description See budetails table Table Definition CREATE VIEW vwbudetails AS ( SELECT budetails.id, budetails.name, budetails.updated FROM budetails ) Columns Name Type Default Nullable Children Parents Comment id varchar(50) true Primary Key name ...
public.vwuserinteractionpresencedetaileddata
Description See UserInteractionPresenceDetailedData: User Interaction Presence Detailed Data View Table Definition CREATE VIEW vwuserinteractionpresencedetaileddata AS ( SELECT userinteractionpresencedetaileddata.userid, userdetail.name AS agentname, ...
public.vwuserqueuemappings
Description UserQueueMappings: View for mappings in between User and Queue Table Definition CREATE VIEW vwuserqueuemappings AS ( SELECT qm.queueid, qd.name AS queuename, qm.userid, ud.name, ud.department, ud.managername, qm.divisionid FROM ...
public.vwpresencedetails
Description See PresenceDetails: Presence Code Lookup Data Table Definition CREATE VIEW vwpresencedetails AS ( SELECT pd.id, pd.systempresence, pd.orgpresence, pd.deactivated, pd.type, CASE WHEN ((pd.divisionid)::text = '*'::text) THEN dd.id ELSE ...
public.vwsubuserusagedata
Description View containing usage data for sub-users, including HTTP status code counts Table Definition CREATE VIEW vwsubuserusagedata AS ( SELECT oauthusagedata.clientid, oauthusagedata.rowdate, oauthusagedata.clientname, ...
public.vwcallabandonedsummary
Description Shows the details for abandoned calls in the detailed interaction data – Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwcallabandonedsummary AS ( SELECT det.conversationid, det.conversationstartdate, ...
public.vwadherenceactdata
Description See AdherenceActData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwadherenceactdata AS ( SELECT ad.userid, ad.startdate, ad.enddate, ad.startdateltc, ad.enddateltc, ad.durationsecs, ((ad.durationsecs)::numeric ...
public.vwgroupdetails
Description Table Definition CREATE VIEW vwgroupdetails AS ( SELECT groupdetails.id, groupdetails.name, groupdetails.description, groupdetails.membercount, groupdetails.state, groupdetails.type, groupdetails.selfuri FROM groupdetails ) Columns Name ...
public.vwtimeoffrequestdata
Description See TimeOffRequestData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwtimeoffrequestdata AS ( SELECT tr.id, tr.userid, tr.isfulldayrequest, tr.status, tr.startdate, tr.notes, tr.timeoffduration, ...
public.vwchatdata
Description See Chat Data - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwchatdata AS ( SELECT cd.conversationid, cd.conversationstart, cd.conversationstartltc, cd.userid, ud.name, ud.managerid, ud.managername, ...
public.vwdetailedinteractiondata
Description See DetailedInteractionData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwdetailedinteractiondata AS ( SELECT di.keyid, di.conversationid, di.conversationstartdate, di.conversationstartdateltc, ...
public.vwevaldetails
Description See EvalDetails- Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwevaldetails AS ( SELECT evaldetails.id, evaldetails.evaluationid, evaldetails.evaluationformid, evaldetails.evaluationname, ...
public.vwtimeoffdata
Description See TimeOffData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwtimeoffdata AS ( SELECT td.userid, td.businessunitdate, td.length, td.description, td.activitycode, td.paid, td.timeoffrequestid, ud.name AS ...
public.vwconvsummarydata
Description See ConvSummaryData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwconvsummarydata AS ( SELECT cs.conversationid, cs.conversationstartdate, cs.conversationstartdateltc, cs.conversationenddate AS ...
public.vwcallsummary
Description See Callummary : View for call summary data with aggregated metrics Table Definition CREATE VIEW vwcallsummary AS ( SELECT di.conversationid AS "Fact.ConversationId", qd.name AS "Fact.QueueName", di.conversationstartdate AS ...
public.vwsurveyquestionanswers
Description Survey Question Answers View Table Definition CREATE VIEW vwsurveyquestionanswers AS ( SELECT surveyquestionanswers.surveyid, surveyquestionanswers.conversationid, survey.completeddate, survey.completeddateltc, ...
public.vwcallnotrespondingdetails
Description Shows the details of agents missing calls (Not Responding) from the DetailedInteractionData table - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwcallnotrespondingdetails AS ( SELECT det.conversationid, ...
public.vwcalldetail
Description See DetailedInteractionData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwcalldetail AS ( SELECT di.conversationid, di.originaldirection, di.mediatype, di.ani, di.dnis, di.purpose, di.sessiondirection, ...
Next page