Genesys Cloud
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 Business unit details Table Definition CREATE VIEW vwbudetails AS ( SELECT bu.id, bu.name, bu.updated, bu.divisionid AS division_id, dd.name AS division_name FROM (budetails bu LEFT JOIN divisiondetails dd ON (((dd.id)::text = ...
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 mu.id, mu.name, mu.startofweek, mu.timezone, mu.severealertthresholdminutes, mu.adherencetargetpercent, mu.adherenceexceptionthresholdseconds, ...
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 ...
Next page