Genesys Cloud
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 divisionid varchar(50) true Management Unit Division GUID startofweek varchar(50) true timezone ...
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 description text true Division Description homedivision varchar(50) true updated timestamp without time zone true Constraints Name Type Definition ...
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 ...