public.userrealtimedata

Description

Name	Type	Nullable
id	varchar(50)	false
name	varchar(255)	true
jabberid	varchar(100)	true
email	varchar(255)	true
state	varchar(50)	true
title	varchar(255)	true
username	varchar(255)	true
department	varchar(255)	true
routingstatus	varchar(20)	true
routstarttime	timestamp without time zone	true
systempresence	varchar(50)	true
presenceid	varchar(50)	true
presstarttime	timestamp without time zone	true
cccallactive	integer	true
cccallacw	integer	true
othcallactive	integer	true
othcallacw	integer	true
cbcallactive	integer	true
cbcallacw	integer	true
cbothcallactive	integer	true
cbothcallacw	integer	true
ccemailactive	integer	true
ccemailacw	integer	true
othemailactive	integer	true
othemailacw	integer	true
ccchatactive	integer	true
ccchatacw	integer	true
othchatactive	integer	true
othchatacw	integer	true
adherencestate	varchar(50)	true
adherencestarttime	timestamp without time zone	true
impact	varchar(50)	true
scheduledactivitycategory	varchar(50)	true
updated	timestamp without time zone	true

Name	Type	Definition
userrealtimedata_key	PRIMARY KEY	PRIMARY KEY (id)

Name	Definition
userrealtimedata_key	CREATE UNIQUE INDEX userrealtimedata_key ON public.userrealtimedata USING btree (id)

Related Articles
public.vwrealtimeuser
Description Real-time user data Table Definition CREATE VIEW vwrealtimeuser AS ( SELECT rd.name AS user_name, rd.id AS user_id, rd.divisionid, rd.groupname, rd.managername, rd.managerid, CASE WHEN (rd.systempresence = 'ON_QUEUE'::text) THEN ...
public.vwrealtimeuser_groups
Description Table Definition CREATE VIEW vwrealtimeuser_groups AS ( SELECT rd.name AS user_name, rd.id AS user_id, rd.divisionid, rd.division_name, rd.groupid, rd.groupname, rd.managername, rd.managerid, CASE WHEN (rd.systempresence = ...
public.mvwconvvoiceoverviewdata
Description Columns Name Type Default Nullable Children Parents Comment conversationid varchar(50) false sentimentscore numeric(20,2) true sentimenttrend numeric(20,2) true agentdurationpercentage numeric(20,2) true customerdurationpercentage ...
public.mvwconvvoicesentimentdetaildata
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true starttime timestamp without time zone true starttimeltc timestamp without time zone true duration numeric(20,2) true ...
public.vwteammemberdata
Description Team Member Data View Table Definition CREATE VIEW vwteammemberdata AS ( SELECT tm.userid, ud.name AS "Agent Name", td.name AS "Team Name" FROM ((teammemberdata tm LEFT JOIN vwuserdetail ud ON (((tm.userid)::text = (ud.id)::text))) LEFT ...