public.vwuserinteractiondata

Description

See UserInteractionData - Expands all the GUIDs with their lookups

Table Definition

CREATE VIEW vwuserinteractiondata AS (
 SELECT userinteractiondata.keyid,
    userinteractiondata.startdate AS startdateutc,
    userinteractiondata.startdateltc,
    userinteractiondata.userid,
    userdetail.name AS agentname,
    userdetail.managerid,
    userdetail.managername,
    userdetail.divisionid AS agentdivisionid,
    userdetail.divisionname AS agentdivisionname,
    userinteractiondata.direction,
    userinteractiondata.queueid,
    queuedetail.name AS queuename,
    queuedetail.divisionid,
    queuedetail.divisionname,
    userinteractiondata.mediatype,
    userinteractiondata.wrapupcode,
    wrapupdetails.name AS wrapupdesc,
    userinteractiondata.talertcount,
    userinteractiondata.talerttimesum,
    (userinteractiondata.talerttimesum / 86400.00) AS talerttimesumday,
    userinteractiondata.talerttimemax,
    (userinteractiondata.talerttimemax / 86400.00) AS talerttimemaxday,
    userinteractiondata.talerttimemin,
    (userinteractiondata.talerttimemin / 86400.00) AS talerttimeminday,
    userinteractiondata.tansweredcount,
    userinteractiondata.tansweredtimesum,
    (userinteractiondata.tansweredtimesum / 86400.00) AS tansweredtimesumday,
    userinteractiondata.tansweredtimemax,
    (userinteractiondata.tansweredtimemax / 86400.00) AS tansweredtimemaxday,
    userinteractiondata.tansweredtimemin,
    (userinteractiondata.tansweredtimemin / 86400.00) AS tansweredtimeminday,
    userinteractiondata.ttalkcount,
    userinteractiondata.ttalktimesum,
    (userinteractiondata.ttalktimesum / 86400.00) AS ttalktimesumday,
    userinteractiondata.ttalktimemax,
    (userinteractiondata.ttalktimemax / 86400.00) AS ttalktimemaxday,
    userinteractiondata.ttalktimemin,
    (userinteractiondata.ttalktimemin / 86400.00) AS ttalktimeminday,
    userinteractiondata.ttalkcompletecount,
    userinteractiondata.ttalkcompletetimesum,
    (userinteractiondata.ttalkcompletetimesum / 86400.00) AS ttalkcompletetimesumday,
    userinteractiondata.ttalkcompletetimemax,
    (userinteractiondata.ttalkcompletetimemax / 86400.00) AS ttalkcompletetimemaxday,
    userinteractiondata.ttalkcompletetimemin,
    (userinteractiondata.ttalkcompletetimemin / 86400.00) AS ttalkcompletetimeminday,
    userinteractiondata.tnotrespondingcount,
    userinteractiondata.tnotrespondingtimesum,
    (userinteractiondata.tnotrespondingtimesum / 86400.00) AS tnotrespondingtimesumday,
    userinteractiondata.tnotrespondingtimemax,
    (userinteractiondata.tnotrespondingtimemax / 86400.00) AS tnotrespondingtimemaxday,
    userinteractiondata.tnotrespondingtimemin,
    (userinteractiondata.tnotrespondingtimemin / 86400.00) AS tnotrespondingtimeminday,
    userinteractiondata.theldcount,
    userinteractiondata.theldtimesum,
    (userinteractiondata.theldtimesum / 86400.00) AS theldtimesumday,
    userinteractiondata.theldtimemax,
    (userinteractiondata.theldtimemax / 86400.00) AS theldtimemaxday,
    userinteractiondata.theldtimemin,
    (userinteractiondata.theldtimemin / 86400.00) AS theldtimeminday,
    userinteractiondata.theldcompletecount,
    userinteractiondata.theldcompletetimesum,
    (userinteractiondata.theldcompletetimesum / 86400.00) AS theldcompletetimesumday,
    userinteractiondata.theldcompletetimemax,
    (userinteractiondata.theldcompletetimemax / 86400.00) AS theldcompletetimemaxday,
    userinteractiondata.theldcompletetimemin,
    (userinteractiondata.theldcompletetimemin / 86400.00) AS theldcompletetimeminday,
    userinteractiondata.thandlecount,
    userinteractiondata.thandletimesum,
    (userinteractiondata.thandletimesum / 86400.00) AS thandletimesumday,
    userinteractiondata.thandletimemax,
    (userinteractiondata.thandletimemax / 86400.00) AS thandletimemaxday,
    userinteractiondata.thandletimemin,
    (userinteractiondata.thandletimemin / 86400.00) AS thandletimeminday,
    userinteractiondata.tacwcount,
    userinteractiondata.tacwtimesum,
    (userinteractiondata.tacwtimesum / 86400.00) AS tacwtimesumday,
    userinteractiondata.tacwtimemax,
    (userinteractiondata.tacwtimemax / 86400.00) AS tacwtimemaxday,
    userinteractiondata.tacwtimemin,
    (userinteractiondata.tacwtimemin / 86400.00) AS tacwtimeminday,
    userinteractiondata.nconsult,
    userinteractiondata.nconsulttransferred,
    userinteractiondata.noutbound,
    userinteractiondata.nerror,
    userinteractiondata.ntransferred,
    userinteractiondata.nblindtransferred,
    userinteractiondata.nconnected,
    userinteractiondata.tdialingcount,
    userinteractiondata.tdialingtimesum,
    (userinteractiondata.tdialingtimesum / 86400.00) AS tdialingtimesumday,
    userinteractiondata.tdialingtimemax,
    (userinteractiondata.tdialingtimemax / 86400.00) AS tdialingtimemaxday,
    userinteractiondata.tdialingtimemin,
    (userinteractiondata.tdialingtimemin / 86400.00) AS tdialingtimeminday,
    userinteractiondata.tcontactingcount,
    userinteractiondata.tcontactingtimesum,
    (userinteractiondata.tcontactingtimesum / 86400.00) AS tcontactingtimesumday,
    userinteractiondata.tcontactingtimemax,
    (userinteractiondata.tcontactingtimemax / 86400.00) AS tcontactingtimemaxday,
    userinteractiondata.tcontactingtimemin,
    (userinteractiondata.tcontactingtimemin / 86400.00) AS tcontactingtimeminday,
    userinteractiondata.tvoicemailcount,
    userinteractiondata.tvoicemailtimesum,
    (userinteractiondata.tvoicemailtimesum / 86400.00) AS tvoicemailtimesumday,
    userinteractiondata.tvoicemailtimemax,
    (userinteractiondata.tvoicemailtimemax / 86400.00) AS tvoicemailtimemaxday,
    userinteractiondata.tvoicemailtimemin,
    (userinteractiondata.tvoicemailtimemin / 86400.00) AS tvoicemailtimeminday,
    userinteractiondata.updated
   FROM (((userinteractiondata userinteractiondata
     LEFT JOIN vwuserdetail userdetail ON (((userdetail.id)::text = (userinteractiondata.userid)::text)))
     LEFT JOIN vwqueuedetails queuedetail ON (((queuedetail.id)::text = (userinteractiondata.queueid)::text)))
     LEFT JOIN wrapupdetails wrapupdetails ON (((wrapupdetails.id)::text = (userinteractiondata.wrapupcode)::text)))
)

Columns

Name	Type	Nullable	Comment
keyid	varchar(255)	true	Primary Key
startdateutc	timestamp without time zone	true	Start Date (UTC)
startdateltc	timestamp without time zone	true	Start Date (LTC)
userid	varchar(50)	true	User ID
agentname	varchar(200)	true	Agent Name
managerid	varchar(50)	true	Manager GUID
managername	varchar(200)	true	Manager Name
agentdivisionid	varchar(50)	true
agentdivisionname	varchar(50)	true
direction	varchar(50)	true	Interaction Direction
queueid	varchar(50)	true	Queue GUID
queuename	varchar(255)	true	Queue Name
divisionid	varchar(50)	true
divisionname	varchar(50)	true
mediatype	varchar(50)	true	Media Type
wrapupcode	varchar(255)	true	Wrap-up Code
wrapupdesc	varchar(255)	true	Wrap-up Description
talertcount	integer	true	Alert Count
talerttimesum	numeric(20,2)	true	Total Alert Time
talerttimesumday	numeric	true	Total Alert Time (Days)
talerttimemax	numeric(20,2)	true	Maximum Alert Time
talerttimemaxday	numeric	true	Maximum Alert Time (Days)
talerttimemin	numeric(20,2)	true	Minimum Alert Time
talerttimeminday	numeric	true	Minimum Alert Time (Days)
tansweredcount	integer	true	Answered Count
tansweredtimesum	numeric(20,2)	true	Total Answered Time
tansweredtimesumday	numeric	true	Total Answered Time (Days)
tansweredtimemax	numeric(20,2)	true	Maximum Answered Time
tansweredtimemaxday	numeric	true	Maximum Answered Time (Days)
tansweredtimemin	numeric(20,2)	true	Minimum Answered Time
tansweredtimeminday	numeric	true	Minimum Answered Time (Days)
ttalkcount	integer	true	Talk Count
ttalktimesum	numeric(20,2)	true	Total Talk Time
ttalktimesumday	numeric	true	Total Talk Time (Days)
ttalktimemax	numeric(20,2)	true	Maximum Talk Time
ttalktimemaxday	numeric	true	Maximum Talk Time (Days)
ttalktimemin	numeric(20,2)	true	Minimum Talk Time
ttalktimeminday	numeric	true	Minimum Talk Time (Days)
ttalkcompletecount	integer	true	Completed Talk Count
ttalkcompletetimesum	numeric(20,2)	true	Total Completed Talk Time
ttalkcompletetimesumday	numeric	true	Total Completed Talk Time (Days)
ttalkcompletetimemax	numeric(20,2)	true	Maximum Completed Talk Time
ttalkcompletetimemaxday	numeric	true	Maximum Completed Talk Time (Days)
ttalkcompletetimemin	numeric(20,2)	true	Minimum Completed Talk Time
ttalkcompletetimeminday	numeric	true	Minimum Completed Talk Time (Days)
tnotrespondingcount	integer	true	Not Responding Count
tnotrespondingtimesum	numeric(20,2)	true	Total Not Responding Time
tnotrespondingtimesumday	numeric	true	Total Not Responding Time (Days)
tnotrespondingtimemax	numeric(20,2)	true	Maximum Not Responding Time
tnotrespondingtimemaxday	numeric	true	Maximum Not Responding Time (Days)
tnotrespondingtimemin	numeric(20,2)	true	Minimum Not Responding Time
tnotrespondingtimeminday	numeric	true	Minimum Not Responding Time (Days)
theldcount	integer	true	Held Count
theldtimesum	numeric(20,2)	true	Total Held Time
theldtimesumday	numeric	true	Total Held Time (Days)
theldtimemax	numeric(20,2)	true	Maximum Held Time
theldtimemaxday	numeric	true	Maximum Held Time (Days)
theldtimemin	numeric(20,2)	true	Minimum Held Time
theldtimeminday	numeric	true	Minimum Held Time (Days)
theldcompletecount	integer	true	Completed Held Count
theldcompletetimesum	numeric(20,2)	true	Total Completed Held Time
theldcompletetimesumday	numeric	true	Total Completed Held Time (Days)
theldcompletetimemax	numeric(20,2)	true	Maximum Completed Held Time
theldcompletetimemaxday	numeric	true	Maximum Completed Held Time (Days)
theldcompletetimemin	numeric(20,2)	true	Minimum Completed Held Time
theldcompletetimeminday	numeric	true	Minimum Completed Held Time (Days)
thandlecount	integer	true	Handle Count
thandletimesum	numeric(20,2)	true	Total Handle Time
thandletimesumday	numeric	true	Total Handle Time (Days)
thandletimemax	numeric(20,2)	true	Maximum Handle Time
thandletimemaxday	numeric	true	Maximum Handle Time (Days)
thandletimemin	numeric(20,2)	true	Minimum Handle Time
thandletimeminday	numeric	true	Minimum Handle Time (Days)
tacwcount	integer	true	ACW Count
tacwtimesum	numeric(20,2)	true	Total ACW Time
tacwtimesumday	numeric	true	Total ACW Time (Days)
tacwtimemax	numeric(20,2)	true	Maximum ACW Time
tacwtimemaxday	numeric	true	Maximum ACW Time (Days)
tacwtimemin	numeric(20,2)	true	Minimum ACW Time
tacwtimeminday	numeric	true	Minimum ACW Time (Days)
nconsult	integer	true	Number of Consult Calls
nconsulttransferred	integer	true	Number of Consult Transfers
noutbound	integer	true	Number of Outbound Calls
nerror	integer	true	Number of Errors
ntransferred	integer	true	Number of Transfers
nblindtransferred	integer	true	Number of Blind Transfers
nconnected	integer	true	Number of Connected Calls
tdialingcount	integer	true	Dialing Count
tdialingtimesum	numeric(20,2)	true	Total Dialing Time
tdialingtimesumday	numeric	true	Total Dialing Time (Days)
tdialingtimemax	numeric(20,2)	true	Maximum Dialing Time
tdialingtimemaxday	numeric	true	Maximum Dialing Time (Days)
tdialingtimemin	numeric(20,2)	true	Minimum Dialing Time
tdialingtimeminday	numeric	true	Minimum Dialing Time (Days)
tcontactingcount	integer	true	Contacting Count
tcontactingtimesum	numeric(20,2)	true	Total Contacting Time
tcontactingtimesumday	numeric	true	Total Contacting Time (Days)
tcontactingtimemax	numeric(20,2)	true	Maximum Contacting Time
tcontactingtimemaxday	numeric	true	Maximum Contacting Time (Days)
tcontactingtimemin	numeric(20,2)	true	Minimum Contacting Time
tcontactingtimeminday	numeric	true	Minimum Contacting Time (Days)
tvoicemailcount	integer	true	Voicemail Count
tvoicemailtimesum	numeric(20,2)	true	Total Voicemail Time
tvoicemailtimesumday	numeric	true	Total Voicemail Time (Days)
tvoicemailtimemax	numeric(20,2)	true	Maximum Voicemail Time
tvoicemailtimemaxday	numeric	true	Maximum Voicemail Time (Days)
tvoicemailtimemin	numeric(20,2)	true	Minimum Voicemail Time
tvoicemailtimeminday	numeric	true	Minimum Voicemail Time (Days)
updated	timestamp without time zone	true

Referenced Tables

Name	Columns	Comment	Type
public.userinteractiondata	112	User Interaction Data Interval Data - Interval is from (15-60) Min(s)	BASE TABLE
public.vwuserdetail	16	See UserDetail: User Description in detail	VIEW
public.vwqueuedetails	14	See QueueDetails: Queue Lookup data	VIEW
public.wrapupdetails	3	Wrap Up Code Details Lookup Up Data	BASE TABLE

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

public.vwuserinteractiondata

public.vwuserinteractiondata

Description

Columns

Referenced Tables

Related Articles

public.participantattributesdynamic

public.evalquestiondata

public.userpresencedetaileddata

public.userinteractionpresencedetaileddata

public.userpresencedata