Genesys Cloud
public.vwbudetails
Description Business unit details 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 User interaction presence with detailed lookups Table Definition CREATE VIEW vwuserinteractionpresencedetaileddata AS ( SELECT userinteractionpresencedetaileddata.userid, userdetail.name AS agentname, userdetail.managerid, ...
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 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 pd.divisionid END AS ...
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 Adherence actual data with lookup expansion Table Definition CREATE VIEW vwadherenceactdata AS ( SELECT ad.userid, ad.startdate, ad.enddate, ad.startdateltc, ad.enddateltc, ad.durationsecs, ((ad.durationsecs)::numeric / 86400.00) AS ...
public.vwgroupdetails
Description View for agent group details and metadata Table Definition CREATE VIEW vwgroupdetails AS ( SELECT groupdetails.id, groupdetails.name, groupdetails.description, groupdetails.membercount, groupdetails.state, groupdetails.type, ...
public.vwtimeoffrequestdata
Description Time off request data with lookup expansion Table Definition CREATE VIEW vwtimeoffrequestdata AS ( SELECT tr.id, tr.userid, tr.isfulldayrequest, tr.status, tr.startdate, tr.notes, tr.timeoffduration, tr.submittedbyid, tr.submittedate, ...
public.vwchatdata
Description Table Definition CREATE VIEW vwchatdata AS ( SELECT c.keyid, c.conversationid, c.conversationstart, c.conversationstartltc, c.userid, u.name AS username, u.department, u.title, c.chatinitiatedby, c.agentchatcount, c.agentchattotal, ...
public.vwdetailedinteractiondata
Description Detailed interaction data with lookup expansion Table Definition CREATE VIEW vwdetailedinteractiondata AS ( SELECT di.keyid, di.conversationid, di.conversationstartdate, di.conversationstartdateltc, di.conversationenddate, ...
public.vwevaldetails
Description Evaluation details with lookup expansion Table Definition CREATE VIEW vwevaldetails AS ( SELECT evaldetails.id, evaldetails.evaluationid, evaldetails.evaluationformid, evaldetails.evaluationname, evaldetails.questiongroupid, ...
public.vwtimeoffdata
Description Time off data with lookup expansion Table Definition CREATE VIEW vwtimeoffdata AS ( SELECT td.userid, td.buid, td.scheduleid, td.businessunitdate, td.length, td.description, td.activitycode, td.paid, td.timeoffrequestid, ud.name AS ...
public.vwconvsummarydata
Description Conversation summary data with lookup expansion Table Definition CREATE VIEW vwconvsummarydata AS ( SELECT cs.conversationid, cs.conversationstartdate, cs.conversationstartdateltc, cs.conversationenddate AS convstartdateusrtz, ...
public.vwcallsummary
Description 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 "Date.ConversationStartDate", ...
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 Call detail data with lookup expansion Table Definition CREATE VIEW vwcalldetail AS ( SELECT di.conversationid, di.originaldirection, di.mediatype, di.ani, di.dnis, di.purpose, di.sessiondirection, di.conversationstartdate, di.userid, ...
public.vwqueueinteractiondatadaily
Description Queue Interaction Data Daily Data Table Definition CREATE VIEW vwqueueinteractiondatadaily AS ( SELECT queueinteractiondatadaily.keyid, queueinteractiondatadaily.startdate, queueinteractiondatadaily.direction, ...
public.vwscheduledata
Description Schedule data with lookup expansion Table Definition CREATE VIEW vwscheduledata AS ( SELECT sc.scheduleid, sc.userid, sc.shiftid, sc.shiftstartdate, sc.shiftstartdateltc, sc.shiftlengthtime, sc.activitystartdate, sc.activitystartdateltc, ...
public.mvwevaluationquestiondata
Description Backward compatibility alias for vwEvaluationQuestionData - DEPRECATED: Use vwEvaluationQuestionData instead Table Definition CREATE VIEW mvwevaluationquestiondata AS ( SELECT vwevaluationquestiondata.keyid, ...
public.vwheadcountforecast
Description Headcount forecast data with lookup expansion Table Definition CREATE VIEW vwheadcountforecast AS ( SELECT hcf.businessunitid, bu.name AS businessunitname, pg.businessunitid AS planninggroup_businessunitid, hcf.planninggroup AS ...
public.vwuserinteractiondata
Description User interaction data with lookup expansion Table Definition CREATE VIEW vwuserinteractiondata AS ( SELECT userinteractiondata.keyid, userinteractiondata.startdate AS startdateutc, userinteractiondata.startdateltc, ...
public.vwteammemberdata
Description Team Member Data View Table Definition CREATE VIEW vwteammemberdata AS ( SELECT tm.userid, ud.name AS "Agent Name", td.name AS "Team Name" FROM ((teammemberdata tm LEFT JOIN userdetails ud ON (((tm.userid)::text = (ud.id)::text))) LEFT ...
public.vwrealtimequeue
Description Real-time queue data Table Definition CREATE VIEW vwrealtimequeue AS ( WITH all_media AS ( SELECT DISTINCT queuerealtimeconvdata.media FROM queuerealtimeconvdata UNION SELECT unnest(ARRAY['voice'::text, 'callback'::text, 'chat'::text, ...
public.vwrealtimeuser_groups
Description Table Definition CREATE VIEW vwrealtimeuser_groups AS ( SELECT rd.name AS user_name, rd.id AS user_id, rd.divisionid, rd.division_name, rd.groupid, rd.groupname, rd.managername, rd.managerid, CASE WHEN (rd.systempresence = ...
public.vwadherencedaydata
Description Adherence Summarised Daily Data Table Definition CREATE VIEW vwadherencedaydata AS ( SELECT ad.userid, ad.startdate, ad.startdateltc, ad.daystartoffsetsecs, ((ad.daystartoffsetsecs)::numeric / 86400.00) AS daystartoffsetsecsday, ...
public.vwmudetails
Description Management unit details Table Definition CREATE VIEW vwmudetails AS ( SELECT mudetails.id, mudetails.name, mudetails.startofweek, mudetails.timezone, mudetails.severealertthresholdminutes, mudetails.adherencetargetpercent, ...
public.vwuserpresencedatadaily
Description Daily user presence data with lookup expansion Table Definition CREATE VIEW vwuserpresencedatadaily AS ( SELECT userpresencedatadaily.id, userpresencedatadaily.userid, userdetail.name AS agentname, userdetail.managerid, ...
public.vwqueueauditdata
Description Audit Table for Queue Membership changes Table Definition CREATE VIEW vwqueueauditdata AS ( SELECT qa.queueid, qa.userid, ud.name, ud.department, ud.managername, qa.addorremove, qa.activeorinactive, qa.datemodified, qa.modifiedby, ...
public.vwoauthusagedata
Description OAuth usage by client ID per day Table Definition CREATE VIEW vwoauthusagedata AS ( SELECT oauthusagedata.clientid, oauthusagedata.rowdate, oauthusagedata.clientname, oauthusagedata.organizationid, oauthusagedata.userid, ...
public.vwevalquestiondata
Description Evaluation question data with additional details Table Definition CREATE VIEW vwevalquestiondata AS ( SELECT DISTINCT eq.evaluationid, eq.questionid, eq.answerid, eq.score, ed.questionanswervalue, eq.markedna, eq.failedkillquestions, ...
public.vwqueuedetails
Description Queue lookup data Table Definition CREATE VIEW vwqueuedetails AS ( SELECT qd.id, qd.name, qd.description, "substring"((qd.description)::text, 'queuegroup=([^;]+)(;|$)'::text) AS queuegroup, "substring"((qd.description)::text, ...
public.vwqueueconvrealtime
Description Queue conversation real-time data Table Definition CREATE VIEW vwqueueconvrealtime AS ( SELECT queuerealtimeconvdata.conversationid, queuerealtimeconvdata.media, queuerealtimeconvdata.actingas, queuerealtimeconvdata.conversationstate, ...
public.vwactivitycodedetails
Description Activity code lookup data Table Definition CREATE VIEW vwactivitycodedetails AS ( SELECT activitycodedetails.keyid, activitycodedetails.id, activitycodedetails.businessunitid, activitycodedetails.name, activitycodedetails.active, ...
public.vwuserdetail
Description User details with manager and division context Table Definition CREATE VIEW vwuserdetail AS ( SELECT ud.id, ud.name, ud.jabberid, ud.state, ud.title, lower((ud.email)::text) AS email, ud.username, ud.department, ud.manager AS managerid, ...
public.vwrealtimeuserconv
Description Real-time user conversation data Table Definition CREATE VIEW vwrealtimeuserconv AS ( SELECT ud.conversationid, ud.media, ud.queueid, ud.direction, ud.conversationstate, CASE WHEN ((ud.conversationstate)::text = 'dialing'::text) THEN ...
public.vwsurveyquestiongroupscores
Description Survey Question Group Scores View Table Definition CREATE VIEW vwsurveyquestiongroupscores AS ( SELECT surveyquestiongroupscores.surveyid, surveyquestiongroupscores.conversationid, survey.completeddate, survey.completeddateltc, ...
public.userinteractiondataweekly
Description User interaction data weekly (LTC) with standard field set Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false userid varchar(50) true direction varchar(50) true queueid varchar(50) true mediatype ...
public.userinteractionpresencedetaileddata
Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false userid varchar(50) true starttime timestamp without time zone false starttimeltc timestamp without time zone true endtime timestamp without time zone true endtimeltc ...
Next page