public.partsumm_customer

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
conversationenddate timestamp without time zone true
conversationenddateltc timestamp without time zone true
participantid varchar(50) true
purpose varchar(50) false
mediatype varchar(50) true
userid varchar(50) true
queueid varchar(50) true
wrapupcode varchar(50) true
wrapupnote text true
nflow integer true
tivr numeric(20,2) true
tflow numeric(20,2) true
tflowdisconnect numeric(20,2) true
tflowexit numeric(20,2) true
tflowout numeric(20,2) true
tacd numeric(20,2) true
tacw numeric(20,2) true
talert numeric(20,2) true
tanswered numeric(20,2) true
ttalk numeric(20,2) true
ttalkcomplete numeric(20,2) true
thandle numeric(20,2) true
tconnected numeric(20,2) true
tfirstconnect numeric(20,2) true
tcontacting numeric(20,2) true
tdialing numeric(20,2) true
tfirstdial numeric(20,2) true
tnotresponding numeric(20,2) true
tabandon numeric(20,2) true
theld numeric(20,2) true
theldcomplete numeric(20,2) true
tvoicemail numeric(20,2) true
tmonitoring numeric(20,2) true
tmonitoringcomplete numeric(20,2) true
tshortabandon numeric(20,2) true
tagentresponsetime numeric(20,2) true
tuserresponsetime numeric(20,2) true
tactivecallback numeric(20,2) true
tactivecallbackcomplete numeric(20,2) true
noffered integer true
nconnected integer true
nconsult integer true
nconsulttransferred integer true
ntransferred integer true
nblindtransferred integer true
nerror integer true
noutbound integer true
nstatetransitionerror integer true
noversla integer true
noutboundattempted integer true
noutboundconnected integer true
nflowoutcome integer true
tflowoutcome numeric(20,2) true
nflowoutcomefailed integer true
nbotinteractions integer true
tpark numeric(20,2) true
tparkcomplete numeric(20,2) true
divisionid varchar(100) true
divisionid2 varchar(100) true
divisionid3 varchar(100) true
updated timestamp without time zone true

Constraints

Name Type Definition
partsumm_customer_pkey PRIMARY KEY PRIMARY KEY (keyid, purpose)

Indexes

Name Definition
partsumm_customer_pkey CREATE UNIQUE INDEX partsumm_customer_pkey ON public.partsumm_customer USING btree (keyid, purpose)
partsumm_customer_conversationid_idx CREATE INDEX partsumm_customer_conversationid_idx ON public.partsumm_customer USING btree (conversationid)

    • Related Articles

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

    • CXiaaS: Customer hosted installation

      You can host our solution within your own nominated data centre cloud-hosted environment. All you need is a Linux or Windows Server and an SQL server of your choice. We install our adapter, provide available analytics templates for out-of-the-box ...

    • public.vwchatdata

      Description See Chat Data - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwchatdata AS ( SELECT cd.conversationid, cd.conversationstart, cd.conversationstartltc, cd.userid, ud.name, ud.managerid, ud.managername, ...

    • public.chatdata

      Description Chat Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false conversationid varchar(50) true Conversation GUID conversationstart timestamp without time zone true Conversation Start Date (UTC) ...