public.vwqueueconvrealtime

public.vwqueueconvrealtime

Description

See QueueConvRealTime: Queue Conversation Real-Time Data

Table Definition

CREATE VIEW vwqueueconvrealtime AS (
 SELECT queuerealtimeconvdata.conversationid,
    queuerealtimeconvdata.media,
    queuerealtimeconvdata.actingas,
    queuerealtimeconvdata.conversationstate,
    datediff('second'::character varying, queuerealtimeconvdata.startdate, timezone('utc'::text, now())) AS statustimesecs,
    ((datediff('second'::character varying, queuerealtimeconvdata.startdate, timezone('utc'::text, now())))::numeric / 86400.00) AS statusdays,
    (((datediff('second'::character varying, queuerealtimeconvdata.startdate, timezone('utc'::text, now())))::double precision * '00:00:01'::interval))::character varying AS "StatusTimeFormatted",
    queuerealtimeconvdata.skill1,
    skill1.name AS skillname1,
    queuerealtimeconvdata.skill2,
    skill2.name AS skillname2,
    queuerealtimeconvdata.skill3,
    skill3.name AS skillname3,
    queuerealtimeconvdata.initialpriority,
    queuerealtimeconvdata.participantname,
    queuerealtimeconvdata.queueid,
    queuedetails.name AS queuename,
    queuedetails.divisionid AS division,
    divisiondetails.name AS divisionname,
    queuerealtimeconvdata.userid,
    userdetail.name,
    userdetail.department,
    userdetail.managername,
    queuerealtimeconvdata.direction,
    queuerealtimeconvdata.ani,
    queuerealtimeconvdata.dnis,
    queuerealtimeconvdata.requestedrout1,
    queuerealtimeconvdata.requestedrout2,
    queuerealtimeconvdata.usedrout
   FROM ((((((queuerealtimeconvdata queuerealtimeconvdata
     LEFT JOIN skilldetails skill1 ON (((skill1.id)::text = (queuerealtimeconvdata.skill1)::text)))
     LEFT JOIN skilldetails skill2 ON (((skill2.id)::text = (queuerealtimeconvdata.skill2)::text)))
     LEFT JOIN skilldetails skill3 ON (((skill3.id)::text = (queuerealtimeconvdata.skill3)::text)))
     LEFT JOIN queuedetails queuedetails ON (((queuedetails.id)::text = (queuerealtimeconvdata.queueid)::text)))
     LEFT JOIN divisiondetails divisiondetails ON (((divisiondetails.id)::text = (queuedetails.divisionid)::text)))
     LEFT JOIN vwuserdetail userdetail ON (((userdetail.id)::text = (queuerealtimeconvdata.userid)::text)))
)

Columns

Name Type Default Nullable Children Parents Comment
conversationid varchar(50) true Conversation GUID
media varchar(50) true Media
actingas varchar(50) true Acting As
conversationstate varchar(50) true Conversation State
statustimesecs integer true Status Time in Seconds
statusdays numeric true Status Time in Days
StatusTimeFormatted varchar true
skill1 varchar(50) true Skill 1
skillname1 varchar(50) true Skill Name 1
skill2 varchar(50) true Skill 2
skillname2 varchar(50) true Skill Name 2
skill3 varchar(50) true Skill 3
skillname3 varchar(50) true Skill Name 3
initialpriority integer true Initial Priority
participantname varchar(200) true Participant Name
queueid varchar(50) true Queue GUID
queuename varchar(255) true Queue Name
division varchar(50) true Division GUID
divisionname varchar(50) true Division Name
userid varchar(50) true User GUID
name varchar(200) true User Name
department varchar(200) true Department
managername varchar(200) true Manager Name
direction varchar(50) true Direction
ani varchar(400) true ANI
dnis varchar(400) true DNIS
requestedrout1 varchar(50) true Requested Route 1
requestedrout2 varchar(50) true Requested Route 2
usedrout varchar(50) true Used Route

Referenced Tables

Name Columns Comment Type
public.queuerealtimeconvdata 32 BASE TABLE
public.skilldetails 4 BASE TABLE
public.queuedetails 17 Queue Lookup data BASE TABLE
public.divisiondetails 4 BASE TABLE
public.vwuserdetail 17 See UserDetail: User Description in detail VIEW

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