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