Genesys Cloud
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 (LTC) 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 true timetype varchar(50) true ...
public.queueinteractiondatamonthly
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 talertcount ...
public.subscriptiondata
Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false licensename varchar(100) true licensedate timestamp without time zone true licensecount integer true licenseusers text true updated timestamp without time zone true ...
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 (LTC) 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 true timetype varchar(50) true ...
public.userpresencedata
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 varchar(20) true ...
public.userqueuemappings
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 time zone true ...
public.planninggroupdetails
Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false businessunitid varchar(50) true id varchar(50) true name varchar(100) true servicelevelgoalid varchar(50) true queueid varchar(50) true mediatype varchar(50) true ...
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
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 varchar(50) true ...
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 (LTC) with standard field set Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false userid varchar(50) true direction varchar(50) true queueid varchar(50) true mediatype ...
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
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 queueid ...
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
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 score ...
public.offeredforecastdata
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 without time zone ...
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
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 conversationenddate ...
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
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 conversationenddate ...
public.timeoffdata
Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false userid varchar(50) true Agent GUID buid varchar(50) true Business Unit GUID scheduleid varchar(50) true Schedule GUID businessunitdate timestamp without time zone ...
public.userskillmappings
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 Constraints Name Type ...
public.queuerealtimeconvdata
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 varchar(50) true ...
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
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 day_of_quarter ...
public.odcontactlistdetails
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 true version ...
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
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 talertcount ...
public.budetails
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 Definition ...
public.userpresencedatamonthly
Description User presence data monthly (LTC) 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 true timetype varchar(50) true ...
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
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 participant ...
public.mvwconvvoiceoverviewdata
Description Backward compatibility alias for vwConvVoiceOverviewData - DEPRECATED: Use vwConvVoiceOverviewData instead Table Definition CREATE VIEW mvwconvvoiceoverviewdata AS ( SELECT vwconvvoiceoverviewdata.conversationid, ...
public.userdetails
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 department ...
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 ...
Next page