Genesys Cloud
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 version integer true ...
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 GUID evaluationformid varchar(50) true Evaluation Form GUID evaluationname ...
public.convvoicetopicdetaildata
Description 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 ...
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
Description 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 ...
public.location_areacode_mapping
Description 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 ...
public.mvwconvvoicetopicdetaildata
Description 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 ...
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
Description 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 ...
public.userinteractiondatamonthly
Description User Interaction Data Monthly 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.viewdefinitions
Description 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 ...
public.csg_artefacts
Description 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
Description 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 ...
public.shrinkagedata
Description 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 ...
public.participantsummarydata
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 ...
Next page