Genesys Cloud
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 Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false conversationid varchar(50) true conversationstart timestamp without time zone true conversationstartltc timestamp without time zone true userid ...
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) ...
public.evalquestiondata
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false evaluationid varchar(50) false evaluationformid varchar(50) false questiongroupid varchar(50) true questionid varchar(50) true answerid varchar(50) true ...
public.offeredforecastdata
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(150) false businessunitid varchar(50) true scheduleid varchar(50) true planninggroup varchar(50) true shorttermforecastid varchar(50) true startdate timestamp ...
public.activeqmembersdata
Description Historical Active Membership of Queues Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false Primary Key queueid varchar(50) true startdate timestamp without time zone true Start Time (UTC) startdateltc ...
public.participantattributesdynamic
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false conversationid varchar(50) false conversationstartdate timestamp without time zone false conversationstartdateltc timestamp without time zone true ...
public.subuserusagedata
Description Subscription Detailed Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false Primary Key date timestamp without time zone true Date userlogin varchar(50) true User GUID licensename varchar(200) true ...
public.partsumm_acd
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true conversationstartdate timestamp without time zone false conversationstartdateltc timestamp without time zone true ...
public.timeoffdata
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false userid varchar(50) true businessunitdate timestamp without time zone true length integer true description varchar(200) true activitycode varchar(50) true ...
public.userskillmappings
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false userid varchar(50) true skillid varchar(50) true proficiency numeric(20,2) true state varchar(50) true updated timestamp without time zone true ...
public.queuerealtimeconvdata
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true queueid varchar(50) true conversationstate varchar(50) true userid varchar(50) true media varchar(50) true direction ...
public.convsummarydata
Description Conversation Summary Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true Conversation GUID conversationstartdate timestamp without time zone false Conversation Start ...
public.dimension_date
Description Columns Name Type Default Nullable Children Parents Comment date_dim_id integer false date_actual date false epoch bigint false day_suffix varchar(4) false day_name varchar(9) false day_of_week integer false day_of_month integer false ...
public.odcontactlistdetails
Description Columns Name Type Default Nullable Children Parents Comment id varchar(50) false name varchar(200) true datecreated timestamp without time zone true datecreatedltc timestamp without time zone true datemodified timestamp without time zone ...
public.adherenceexcdata
Description Adherence Detailed Exception Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false Primary Key userid varchar(50) true User GUID startdate timestamp without time zone true Start Time (UTC) startdateltc ...
public.queueinteractiondatadaily
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.budetails
Description Columns Name Type Default Nullable Children Parents Comment id varchar(50) false name varchar(50) true updated timestamp without time zone true Constraints Name Type Definition bu2details_pkey PRIMARY KEY PRIMARY KEY (id) Indexes Name ...
public.userpresencedatamonthly
Description User Presence Data Monthly 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 ...
public.tabledefinitions
Description Subscription Detailed Data Columns Name Type Default Nullable Children Parents Comment rowid integer false Primary Keyid tablename varchar(100) true Table Name keyfield varchar(100) true Primary Key field on the Table datekeyfield ...
public.convvoicesentimentdetaildata
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true starttime timestamp without time zone true starttimeltc timestamp without time zone true duration numeric(20,2) true ...
public.mvwconvvoiceoverviewdata
Description Columns Name Type Default Nullable Children Parents Comment conversationid varchar(50) false sentimentscore numeric(20,2) true sentimenttrend numeric(20,2) true agentdurationpercentage numeric(20,2) true customerdurationpercentage ...
public.userdetails
Description Columns Name Type Default Nullable Children Parents Comment id varchar(50) false name varchar(200) true jabberid varchar(100) true state varchar(50) true title varchar(200) true email varchar(200) true username varchar(200) true ...
public.userrealtimeconvdata
Description User Real Time Conversation Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false Primary Key id varchar(50) true conversationid varchar(50) true Conversation GUID media varchar(50) true Conversation ...
public.odcampaigndetails
Description Outbound Dialling Campaign Lookup Data Columns Name Type Default Nullable Children Parents Comment id varchar(50) false Primary Key / Campaign GUID name varchar(200) true Campaign Name datecreated timestamp without time zone true Campaign ...
public.wrapupdetails
Description Wrap Up Code Details Lookup Up Data Columns Name Type Default Nullable Children Parents Comment id varchar(50) false Primary Key / Wrap Up GUID name varchar(255) true Wrap Up Name updated timestamp without time zone true Date Row Updated ...
public.evaldata
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) false evaluationid varchar(50) false calibrationid varchar(50) true evaluationformid varchar(50) true evaluatorid varchar(50) ...
public.presencedetails
Description Persence Code Lookup Data Columns Name Type Default Nullable Children Parents Comment id varchar(50) false Primary Key systempresence varchar(255) true Presence System Presence Name orgpresence varchar(255) true Presence Organisation ...
public.partsumm_agent
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true conversationstartdate timestamp without time zone false conversationstartdateltc timestamp without time zone true ...
public.evaldetails
Description Evaluation Lookup Data Columns Name Type Default Nullable Children Parents Comment id varchar(200) false Primary Key evaluationid varchar(50) true Evaluation Form GUID (Historical column name - this actually contains the form ID, not the ...
Next page