public.vwuserroutingstatusdetaileddata

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 Default Nullable Children Parents 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

    • Related Articles

    • README

      Logo Genesys Adapter Data Dictionary Tables Name Columns Comment Type public.tabledefinitions 5 Subscription Detailed Data BASE TABLE public.activeqmembersdata 9 Historical Active Membership of Queues BASE TABLE public.activitycodedetails 11 Activity ...

    • public.evalquestiondata

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

    • public.participantattributesdynamic

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

    • public.hoursblockdata

      Columns Name Type Default Nullable Children Parents Comment keyid varchar(200) false userid varchar(50) true startdate timestamp without time zone true startdateltc timestamp without time zone true enddate timestamp without time zone true enddateltc ...

    • public.userinteractionpresencedetaileddata

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