Genesys Cloud
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 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 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, ...
public.vwqueueinteractiondatadaily
Description Queue Interaction Data Daily Data Table Definition CREATE VIEW vwqueueinteractiondatadaily AS ( SELECT queueinteractiondatadaily.keyid, queueinteractiondatadaily.startdate, queueinteractiondatadaily.direction, ...
public.vwscheduledata
Description See ScheduleData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwscheduledata AS ( SELECT sc.scheduleid, sc.userid, sc.shiftid, sc.shiftstartdate, sc.shiftstartdateltc, sc.shiftlengthtime, sc.activitystartdate, ...
public.mvwevaluationquestiondata
Description Materialized view for evaluation question data Table Definition CREATE MATERIALIZED VIEW mvwevaluationquestiondata AS ( SELECT DISTINCT eq.keyid, eq.evaluationid, eq.questionid, eq.answerid, eq.score, ed.questionanswervalue, eq.markedna, ...
public.vwheadcountforecast
Description See HeadCountForecast - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwheadcountforecast AS ( SELECT hcf.businessunitid, bu.name AS businessunitname, hcf.planninggroup AS planninggroup_id, pg.name AS ...
public.vwuserinteractiondata
Description See UserInteractionData - Expands all the GUIDs with their lookups 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 vwuserdetail 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 See MuDetails Table Definition CREATE VIEW vwmudetails AS ( SELECT mudetails.id, mudetails.name, mudetails.startofweek, mudetails.timezone, mudetails.severealertthresholdminutes, mudetails.adherencetargetpercent, ...
public.vwuserpresencedatadaily
Description See UserPresenceDataDaily - Expands all the GUIDs with their lookups(Daily) Table Definition CREATE VIEW vwuserpresencedatadaily AS ( SELECT userpresencedatadaily.id, userpresencedatadaily.userid, userdetail.name AS agentname, ...
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 See OauthUsageData: Oauth Usage by Client ID per Day Table Definition CREATE VIEW vwoauthusagedata AS ( SELECT oauthusagedata.clientid, oauthusagedata.rowdate, oauthusagedata.clientname, oauthusagedata.organizationid, ...
public.vwevalquestiondata
Description See EvalQuestionData: View for evaluation question data with additional details Table Definition CREATE VIEW vwevalquestiondata AS ( SELECT DISTINCT eq.evaluationid, eq.questionid, eq.answerid, eq.score, ed.questionanswervalue, ...
public.vwqueuedetails
Description See QueueDetails: Queue Lookup data Table Definition CREATE VIEW vwqueuedetails AS ( SELECT qd.id, qd.name, qd.description, "substring"((qd.description)::text, 'queuegroup=([^;]+)(;|$)'::text) AS queuegroup, ...
public.vwqueueconvrealtime
Description See QueueConvRealTime: Queue Conversation Real-Time Data Table Definition CREATE VIEW vwqueueconvrealtime AS ( SELECT queuerealtimeconvdata.conversationid, queuerealtimeconvdata.media, queuerealtimeconvdata.actingas, ...
public.vwactivitycodedetails
Description See activitycodes table Table Definition CREATE VIEW vwactivitycodedetails AS ( SELECT activitycodedetails.keyid, activitycodedetails.id, activitycodedetails.businessunitid, activitycodedetails.name, activitycodedetails.active, ...
public.vwuserdetail
Description See UserDetail: User Description in detail 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 Data - LTC - See UserInteractionData for Field Descriptions Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false userid varchar(50) true direction varchar(50) true queueid ...
public.userinteractionpresencedetaileddata
Description 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 ...
public.groupdetails
Description Agent Group Lookup Data Columns Name Type Default Nullable Children Parents Comment id varchar(50) false Primary Key / Agent Group GUID name varchar(255) true Agent Group Name description varchar(255) true Agent Group Description ...
public.queueauditdata
Description Audit Table for Queue Membership changes Columns Name Type Default Nullable Children Parents Comment keyid varchar(500) false Primary Key queueid varchar(50) true Queue GUID userid varchar(50) true User GUID addorremove varchar(10) true ...
public.userpresencedatadaily
Description User Presence Data Daily Data - LTC - See UserPresenceData for Descriptions Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false id varchar(50) true userid varchar(50) true startdate timestamp without time ...
public.queueinteractiondatamonthly
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false direction varchar(50) true queueid varchar(50) true mediatype varchar(50) true wrapupcode varchar(255) true startdate timestamp without time zone true ...
public.subscriptiondata
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false licensename varchar(100) true licensedate timestamp without time zone true licensecount integer true licenseusers text true updated timestamp without ...
Next page