public.partsumm_agent

public.partsumm_agent

Description

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(100) false
conversationid varchar(50) 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
divisionid varchar(100) true
divisionid2 varchar(100) true
divisionid3 varchar(100) true
updated timestamp without time zone true

Constraints

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

Indexes

Name Definition
partsumm_agent_pkey CREATE UNIQUE INDEX partsumm_agent_pkey ON public.partsumm_agent USING btree (keyid, purpose)
partsumm_agent_conversationid_idx CREATE INDEX partsumm_agent_conversationid_idx ON public.partsumm_agent USING btree (conversationid)

    • Related Articles

    • public.partsumm_acd

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true participantid varchar(50) true purpose varchar(50) false mediatype varchar(50) true userid varchar(50) true queueid ...

    • public.partsumm_customer

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true participantid varchar(50) true purpose varchar(50) false mediatype varchar(50) true userid varchar(50) true queueid ...

    • public.groupdetails

      Description Agent Group Lookup Data Columns Name Type Default Nullable Children Parents Comment id varchar(50) false Primary Key / Agent Group GUID name varchar(255) true Agent Group Name email varchar(255) true Agent Group Email Address membercount ...

    • public.vwgroupdetails

      Description See GroupDetails - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwgroupdetails AS ( SELECT groupdetails.id, groupdetails.name, groupdetails.email, groupdetails.state, groupdetails.type, groupdetails.selfuri FROM ...

    • public.vwteammemberdata

      Description Team Member Data View Table Definition CREATE VIEW vwteammemberdata AS ( SELECT tm.userid, ud.name AS "Agent Name", td.name AS "Team Name" FROM ((teammemberdata tm LEFT JOIN vwuserdetail ud ON (((tm.userid)::text = (ud.id)::text))) LEFT ...