public.mvwconvvoicesentimentdetaildata

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
participant varchar(50) true
phrase varchar(400) true
sentiment numeric(20,2) true
phraseindex integer true
updated timestamp without time zone true
conversationstartdate timestamp without time zone true
conversationstartdateltc timestamp without time zone true
conversationenddate timestamp without time zone true
conversationenddateltc timestamp without time zone true
ttalkcomplete integer true
ani varchar(400) true
dnis varchar(400) true
firstmediatype varchar(50) true
divisionid varchar(50) true
divisionname varchar(255) true
firstqueueid varchar(50) true
firstqueuename varchar(255) true
lastqueueid varchar(50) true
lastqueuename varchar(255) true
firstagentid varchar(50) true
firstagentname varchar(200) true
firstagentdept varchar(200) true
firstagentmanagerid varchar(50) true
firstagentmanagername varchar(200) true
lastagentid varchar(50) true
lastagentname varchar(200) true
lastagentdept varchar(200) true
lastagentmanagerid varchar(50) true
lastagentmanagername varchar(200) true
firstwrapupcode varchar(255) true
firstwrapupname varchar(255) true
lastwrapupcode varchar(255) true
lastwrapupname varchar(255) true

Constraints

Name Type Definition
mvwconvvoicesentimentdetaildata_keyid_key UNIQUE UNIQUE (keyid)

Indexes

Name Definition
mvwconvvoicesentimentdetaildata_keyid_key CREATE UNIQUE INDEX mvwconvvoicesentimentdetaildata_keyid_key ON public.mvwconvvoicesentimentdetaildata USING btree (keyid)
mvconvvoicesentiment_agent CREATE INDEX mvconvvoicesentiment_agent ON public.mvwconvvoicesentimentdetaildata USING btree (firstagentid)
mvconvvoicesentiment_conv CREATE INDEX mvconvvoicesentiment_conv ON public.mvwconvvoicesentimentdetaildata USING btree (conversationid)
mvconvvoicesentiment_division CREATE INDEX mvconvvoicesentiment_division ON public.mvwconvvoicesentimentdetaildata USING btree (divisionid)
mvconvvoicesentiment_end CREATE INDEX mvconvvoicesentiment_end ON public.mvwconvvoicesentimentdetaildata USING btree (conversationenddate)
mvconvvoicesentiment_endltc CREATE INDEX mvconvvoicesentiment_endltc ON public.mvwconvvoicesentimentdetaildata USING btree (conversationenddateltc)
mvconvvoicesentiment_keyid CREATE UNIQUE INDEX mvconvvoicesentiment_keyid ON public.mvwconvvoicesentimentdetaildata USING btree (keyid)
mvconvvoicesentiment_queue CREATE INDEX mvconvvoicesentiment_queue ON public.mvwconvvoicesentimentdetaildata USING btree (firstqueueid)
mvconvvoicesentiment_sentiment CREATE INDEX mvconvvoicesentiment_sentiment ON public.mvwconvvoicesentimentdetaildata USING btree (sentiment)
mvconvvoicesentiment_start CREATE INDEX mvconvvoicesentiment_start ON public.mvwconvvoicesentimentdetaildata USING btree (conversationstartdate)
mvconvvoicesentiment_startltc CREATE INDEX mvconvvoicesentiment_startltc ON public.mvwconvvoicesentimentdetaildata USING btree (conversationstartdateltc)
mvconvvoicesentiment_wrapup CREATE INDEX mvconvvoicesentiment_wrapup ON public.mvwconvvoicesentimentdetaildata USING btree (firstwrapupcode)
mvwconvvoicesentiment_participant CREATE INDEX mvwconvvoicesentiment_participant ON public.mvwconvvoicesentimentdetaildata USING btree (participant)

    • Related Articles

    • 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.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.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.userinteractionpresencedetaileddata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false userid varchar(50) true starttime timestamp without time zone false starttimeltc timestamp without time zone true endtime timestamp without time zone ...

    • public.userpresencedata

      Description 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 ...