Genesys Cloud
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 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.mumemberdata
Description 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 ...
public.queueinteractiondataweekly
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.hoursblockdata
Description 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 ...
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 Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false evaluationid varchar(50) true questiongroupid varchar(50) true questiongroupname varchar(200) true totalscore numeric(20,2) true maxtotalscore ...
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
Description Columns Name Type Default Nullable Children Parents Comment id varchar(50) false name varchar(100) true startofweek varchar(50) true timezone varchar(50) true severealertthresholdminutes integer true adherencetargetpercent numeric(20,2) ...
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
Description 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 ...
public.partsumm_customer
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.surveyquestiongroupscores
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.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
Description 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 ...
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
Description 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 ...
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
Description 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 ...
public.surveyquestionanswers
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.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 ...