public.vwuserroutingstatusdetaileddata

Description

User routing status periods only, including OFF_QUEUE; presence periods are in vwUserPresenceDetailedData

Table Definition

CREATE VIEW vwuserroutingstatusdetaileddata AS (
 SELECT (upd.userid)::text AS user_id,
    (upd.routingstatus)::text AS routing_status,
    upd.starttime AS start_time,
    upd.endtime AS end_time,
    (ud.name)::text AS user_name,
    (ud.state)::text AS user_state,
    ud.email AS user_email,
    (ud.username)::text AS username,
    (ud.title)::text AS title,
    (ud.managerid)::text AS manager_id,
    (ud.acdautoanswer)::text AS acd_auto_answer,
    (ud.divisionid)::text AS division_id,
    (ud.divisionname)::text AS division_name,
    (ud.managername)::text AS manager_name,
    (ud.department)::text AS department,
    (ud.employeeid)::text AS employee_id,
    upd.starttimeltc AS start_time_ltc,
    upd.endtimeltc AS end_time_ltc,
    upd.timeinstate AS time_in_state,
    (upd.timeinstate / 86400.00) AS time_in_state_day,
    upd.updated,
    (upd.keyid)::text AS key_id
   FROM (userpresencedetaileddata upd
     LEFT JOIN vwuserdetail ud ON (((ud.id)::text = (upd.userid)::text)))
  WHERE (upd.routingstatus IS NOT NULL)
)

Columns

Name	Type	Nullable	Comment
user_id	text	true	User GUID
routing_status	text	true	Routing Status (OFF_QUEUE rows cover time not on queue)
start_time	timestamp without time zone	true	Start Time (UTC)
end_time	timestamp without time zone	true	End Time (UTC)
user_name	text	true	User name
user_state	text	true	User state
user_email	text	true	User email address
username	text	true	Username
title	text	true	User title
manager_id	text	true	Manager GUID
acd_auto_answer	text	true	ACD auto answer setting
division_id	text	true	User division GUID
division_name	text	true	User division name
manager_name	text	true	Manager Name
department	text	true	User department
employee_id	text	true	Employee GUID
start_time_ltc	timestamp without time zone	true	Start Time (LTC)
end_time_ltc	timestamp without time zone	true	End Time (LTC)
time_in_state	numeric(20,2)	true	Time in State (Secs)
time_in_state_day	numeric	true	Time in State (Days)
updated	timestamp without time zone	true	Last Updated Time
key_id	text	true	Primary Key

Referenced Tables

Name	Columns	Comment	Type
public.userpresencedetaileddata	12	User Presence Detailed Data	BASE TABLE
public.vwuserdetail	18	User details with manager and division context	VIEW