Genesys Cloud
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
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) true userid ...
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
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.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 ...
public.convvoicetopicdetaildata
Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true starttime timestamp without time zone false starttimeltc timestamp without time zone true participant varchar(50) true duration ...
public.adherencedaydata
Description Adherence Summarised Daily Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false userid varchar(50) true User GUID startdate timestamp without time zone true Start Time (UTC) startdateltc timestamp ...
public.teamdetails
Columns Name Type Default Nullable Children Parents Comment id varchar(50) false name varchar(200) true division varchar(50) true datecreated timestamp without time zone true datemodified timestamp without time zone true membercount integer true ...
public.location_areacode_mapping
Columns Name Type Default Nullable Children Parents Comment area_code varchar(10) false state varchar(255) true state_abbreviation varchar(10) true timezone varchar(10) true center_coordinates varchar(50) true country varchar(255) true short_country ...
public.mvwconvvoicetopicdetaildata
Description Backward compatibility alias for vwConvVoiceTopicDetailData - DEPRECATED: Use vwConvVoiceTopicDetailData instead Table Definition CREATE VIEW mvwconvvoicetopicdetaildata AS ( SELECT vwconvvoicetopicdetaildata.keyid, ...
public.odcontactlistdata
Description Outbound Dialling Contact List Data - Any new attribs are added automatically by the adapter. Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false Primary Key contactlistid varchar(50) true Contact List ...
public.userrealtimedata
Columns Name Type Default Nullable Children Parents Comment id varchar(50) false name varchar(255) true jabberid varchar(100) true email varchar(255) true state varchar(50) true title varchar(255) true username varchar(255) true department ...
public.userinteractiondatamonthly
Description User interaction data monthly (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.viewdefinitions
Columns Name Type Default Nullable Children Parents Comment rowid integer nextval(‘viewdefinitions_rowid_seq’::regclass) false viewname varchar(50) true version integer true Constraints Name Type Definition viewdefinitions_pkey PRIMARY KEY PRIMARY ...
public.csg_artefacts
Columns Name Type Default Nullable Children Parents Comment id integer nextval(‘csg_artefacts_id_seq’::regclass) false logo text true Constraints Name Type Definition csg_artefacts_pkey PRIMARY KEY PRIMARY KEY (id) Indexes Name Definition ...
public.skilldetails
Columns Name Type Default Nullable Children Parents Comment id varchar(50) false name varchar(50) true state varchar(50) true updated timestamp without time zone true Constraints Name Type Definition skilldetails_pkey PRIMARY KEY PRIMARY KEY (id) ...
public.shrinkagedata
Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false id varchar(50) true startdate timestamp without time zone true enddate timestamp without time zone true activitycategory varchar(255) true scheduledshrinkageseconds ...
public.participantsummarydata
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.queuedetails
Description Queue Lookup data Columns Name Type Default Nullable Children Parents Comment id varchar(50) false Primary Key / Queue GUID name varchar(255) true Queue Name description varchar(255) true divisionid varchar(50) true Queue Division GUID ...
public.mvwconvvoicesentimentdetaildata
Description Backward compatibility alias for vwConvVoiceSentimentDetailData - DEPRECATED: Use vwConvVoiceSentimentDetailData instead Table Definition CREATE VIEW mvwconvvoicesentimentdetaildata AS ( SELECT vwconvvoicesentimentdetaildata.keyid, ...
public.mumemberdata
Columns Name Type Default Nullable Children Parents Comment id varchar(50) false muid varchar(50) false selfuri varchar(100) true updated timestamp without time zone true Constraints Name Type Definition mumemberdata_pkey PRIMARY KEY PRIMARY KEY (id) ...
public.queueinteractiondataweekly
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.hoursblockdata
Columns Name Type Default Nullable Children Parents Comment keyid varchar(200) false userid varchar(50) true startdate timestamp without time zone true startdateltc timestamp without time zone true enddate timestamp without time zone true enddateltc ...
public.scheduledetails
Description Schedule Details Lookup Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false businessunitid varchar(50) true Schedule Business Unit GUID scheduleid varchar(50) true weekdate date true Schedule Week ...
public.mvwevaluationgroupdata
Description Backward compatibility alias for vwEvaluationGroupData - DEPRECATED: Use vwEvaluationGroupData instead Table Definition CREATE VIEW mvwevaluationgroupdata AS ( SELECT vwevaluationgroupdata.keyid, vwevaluationgroupdata.evaluationid, ...
public.oauthusagedata
Description Oauth Usage by Client ID per Day Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false Primary Key clientid varchar(50) true Oauth Client GUID rowdate timestamp without time zone true Date clientname ...
public.mudetails
Columns Name Type Default Nullable Children Parents Comment id varchar(50) false name varchar(100) true businessunitid varchar(50) true Business Unit GUID startofweek varchar(50) true timezone varchar(50) true severealertthresholdminutes integer true ...
public.activitycodedetails
Description Activity Code Lookup Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false id varchar(50) true businessunitid varchar(50) true name varchar(50) true active bit(1) true defaultcode bit(1) true category ...
public.headcountforecastdata
Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false businessunitid varchar(50) true planninggroup varchar(50) true scheduleid varchar(50) true weekdate timestamp without time zone true startdate timestamp without time ...
public.partsumm_customer
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.surveyquestiongroupscores
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.wfmauditdata
Description Audit Table for WFM Schedule Change Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(150) false Primary Key modifiedby varchar(50) true Schedule GUID scheduleid varchar(50) true addorremove varchar(10) true ...
public.detailedinteractiondata
Description Conversation Detailed Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false conversationid varchar(50) true Conversation GUID conversationstartdate timestamp without time zone false Conversation Start ...
public.usergroupmappings
Columns Name Type Default Nullable Children Parents Comment id varchar(100) false Primary Key / Unique Identifier for User-Group Mapping name varchar(100) true Name of the User-Group Mapping userid varchar(50) true Unique Identifier for the User ...
public.adherenceactdata
Description Adherence Actual Activity 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.divisiondetails
Columns Name Type Default Nullable Children Parents Comment id varchar(50) false name varchar(50) true homedivision varchar(50) true updated timestamp without time zone true Constraints Name Type Definition divisiondetails_pkey PRIMARY KEY PRIMARY ...
public.userinteractiondata
Description User Interaction Data Interval Data - Interval is from (15-60) Min(s) Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false Primary Key userid varchar(50) true Agent GUID direction varchar(50) true ...
public.scheduledata
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 shiftid integer true Shift GUID shiftstartdate ...
public.surveyquestionanswers
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.queueinteractiondata
Description Queue Interaction Data Interval Data - Interval is from (15-60) Min(s) Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false Primary Key direction varchar(50) true Direction queueid varchar(50) true Queue ...