public.convvoicetopicdetaildata

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
duration numeric(20,2) true
confidence numeric(20,2) true
topicname varchar(200) true
topicid varchar(50) true
topicphrase varchar(200) true
transcriptphrase varchar(200) true
updated timestamp without time zone true
transcriptnumber varchar(50) true
communicationid varchar(50) true
ani varchar(200) true
dnis varchar(200) true
queueid varchar(50) true
userid varchar(50) true

Constraints

Name Type Definition
convvoicetopicdetaildata_new_pkey PRIMARY KEY PRIMARY KEY (keyid, starttime)

Indexes

Name Definition
convvoicetopicdetaildata_new_pkey CREATE UNIQUE INDEX convvoicetopicdetaildata_new_pkey ON ONLY public.convvoicetopicdetaildata USING btree (keyid, starttime)
convvoicetopic__new_topicid CREATE INDEX convvoicetopic__new_topicid ON ONLY public.convvoicetopicdetaildata USING btree (topicid)
convvoicetopic_new_conv CREATE INDEX convvoicetopic_new_conv ON ONLY public.convvoicetopicdetaildata USING btree (conversationid)
convvoicetopicdetaildata_updated_idx CREATE INDEX convvoicetopicdetaildata_updated_idx ON ONLY public.convvoicetopicdetaildata USING btree (updated)
convvoicetopicdetaildata_confidence_idx CREATE INDEX convvoicetopicdetaildata_confidence_idx ON ONLY public.convvoicetopicdetaildata USING btree (confidence)
convvoicetopic_new_start CREATE INDEX convvoicetopic_new_start ON ONLY public.convvoicetopicdetaildata USING btree (starttime)
convvoicetopic_new_startltc CREATE INDEX convvoicetopic_new_startltc ON ONLY public.convvoicetopicdetaildata USING btree (starttimeltc)
convvoicetopic_participant CREATE INDEX convvoicetopic_participant ON ONLY public.convvoicetopicdetaildata USING btree (participant)
convvoicetopic_topicphrase CREATE INDEX convvoicetopic_topicphrase ON ONLY public.convvoicetopicdetaildata USING btree (topicphrase)
idx_convvoicetopicdetaildata_time_queue_topic CREATE INDEX idx_convvoicetopicdetaildata_time_queue_topic ON ONLY public.convvoicetopicdetaildata USING btree (starttime, queueid, topicname) INCLUDE (confidence, duration, participant) WHERE ((starttime IS NOT NULL) AND (queueid IS NOT NULL))
idx_convvoicetopicdetaildata_topic_time CREATE INDEX idx_convvoicetopicdetaildata_topic_time ON ONLY public.convvoicetopicdetaildata USING btree (topicname, starttime DESC) INCLUDE (queueid, userid, confidence, duration) WHERE (topicname IS NOT NULL)

    • Related Articles

    • public.vwconvvoicetopicdetaildata

      Description View for conversation voice topic detail data combining topic analysis with conversation summary data Table Definition CREATE VIEW vwconvvoicetopicdetaildata AS ( SELECT ct.keyid, ct.conversationid, ct.starttime, ct.starttimeltc, ...

    • README

      Logo Genesys Adapter Data Dictionary Tables Name Columns Comment Type public.tabledefinitions 5 Subscription Detailed Data BASE TABLE public.activeqmembersdata 9 Historical Active Membership of Queues BASE TABLE public.activitycodedetails 11 Activity ...

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