Genesys Cloud
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 ...
public.convvoiceoverviewdata
Description Voice Analysis Overview Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false Primary Key conversationid varchar(50) true Conversation GUID sentimentscore numeric(20,2) true Convesation Sentiment Score ...
public.userpresencedataweekly
Description User Presence Data Weekly 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.userpresencedata
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false id varchar(50) true userid varchar(50) true startdate timestamp without time zone false startdateltc timestamp without time zone true timetype ...
public.userqueuemappings
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false queueid varchar(50) true userid varchar(50) true divisionid varchar(50) true autoanswer bit(1) true ringnumber integer true updated timestamp without ...
public.planninggroupdetails
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false id varchar(50) true name varchar(100) true servicelevelgoalid varchar(50) true queueid varchar(50) true mediatype varchar(50) true skills1 varchar(50) ...
public.userpresencedetaileddata
Description User Presence Detailed Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false Primary Key userid varchar(50) true Agent GUID starttime timestamp without time zone false Start Time (UTC) starttimeltc ...
public.chatdata
Description Chat Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false conversationid varchar(50) true Conversation GUID conversationstart timestamp without time zone true Conversation Start Date (UTC) ...
public.suboverviewdata
Description Table storing suboverview data Columns Name Type Default Nullable Children Parents Comment keyid varchar(400) false Primary key identifier rowdate timestamp without time zone true Date of the row startdate timestamp without time zone true ...
public.userinteractiondatadaily
Description User Interaction Data Daily 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.teammemberdata
Description Work Team Membership Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false Primary Key teamid varchar(50) true Work Team GUID userid varchar(50) true User GUID updated timestamp without time zone true ...
public.evalquestiongroupdata
Description Evaluation Question Group Detailed Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false Primary Key evaluationid varchar(50) false Evaluation GUID evaluationformid varchar(50) false Evaluation Form GUID ...
public.surveydata
Description Columns Name Type Default Nullable Children Parents Comment surveyid varchar(50) false conversationid varchar(50) false surveyformid varchar(50) true surveyname varchar(200) true agentid varchar(50) true agentteamid varchar(50) true ...
public.timeoffrequestdata
Description WFM Time off requests entered by the Agents / or by proxys on their behalf Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false Primary Keyid id varchar(50) true Time Off Request GUID userid varchar(50) ...
Next page