Genesys Cloud
public.knowledgebasedocumentversion
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 timestamp ...
public.knowledgebasedocument
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 true ...
public.knowledgebasecategorydata
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 time zone ...
public.knowledgebase
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 without time zone ...
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 Backward compatibility alias for vwEvaluationOverview - DEPRECATED: Use vwEvaluationOverview instead Table Definition CREATE VIEW mvwevaluationoverview AS ( SELECT vwevaluationoverview.keyid, vwevaluationoverview.conversationid, ...
public.vwadherenceexcdata
Description Adherence exception data with lookup expansion Table Definition CREATE VIEW vwadherenceexcdata AS ( SELECT ad.userid, ad.startdate, ad.enddate, ad.startdateltc, ad.enddateltc, ad.durationsecs, ((ad.durationsecs)::numeric / 86400.00) AS ...
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 User presence data with lookup expansion 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, pd.startdate, ...
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, wrapupdetails.isrightpartycontact, wrapupdetails.iscontactuncallable, wrapupdetails.isnumberuncallable, ...
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 uipd.userid, userdetail.name AS agentname, userdetail.managerid, userdetail.managername, userdetail.divisionid, ...
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 = ...
Next page