public.vwuserinteractionpresencedetaileddata

Description

User interaction presence with detailed lookups

Table Definition

CREATE VIEW vwuserinteractionpresencedetaileddata AS (
 SELECT uipd.userid,
    userdetail.name AS agentname,
    userdetail.managerid,
    userdetail.managername,
    userdetail.divisionid,
    uipd.starttime,
    uipd.starttimeltc,
    uipd.endtime,
    uipd.endtimeltc,
    uipd.systempresence,
    uipd.orgpresence,
    uipd.routingstatus,
    uipd.conversationid,
    uipd.mediatype,
    uipd.timeinstate,
    (uipd.timeinstate / 86400.00) AS timeinstateday,
    uipd.updated,
    uipd.organizationpresenceid AS organization_presence_id
   FROM (userinteractionpresencedetaileddata uipd
     LEFT JOIN vwuserdetail userdetail ON (((userdetail.id)::text = (uipd.userid)::text)))
)

Columns

Name	Type	Nullable	Comment
userid	varchar(50)	true	User GUID
agentname	varchar(200)	true	Agent Name
managerid	varchar(50)	true	Manager GUID
managername	varchar(200)	true	Manager Name
divisionid	varchar(50)	true	Division GUID
starttime	timestamp without time zone	true	Start Time
starttimeltc	timestamp without time zone	true	Start Time (LTC)
endtime	timestamp without time zone	true	End Time
endtimeltc	timestamp without time zone	true	End Time (LTC)
systempresence	varchar(50)	true	System Presence
orgpresence	varchar(50)	true	Organization Presence
routingstatus	varchar(50)	true	Routing Status
conversationid	varchar(50)	true	Conversation GUID
mediatype	varchar(50)	true	Media Type
timeinstate	numeric(20,2)	true	Time in State
timeinstateday	numeric	true	Time in State (Days)
updated	timestamp without time zone	true	Last Updated Time
organization_presence_id	varchar(50)	true	Organization Presence GUID

Referenced Tables

Name	Columns	Comment	Type
public.userinteractionpresencedetaileddata	14		BASE TABLE
public.vwuserdetail	18	User details with manager and division context	VIEW