public.userrealtimedata

Description

Name	Type	Default	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
manuallychecked	boolean	false	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)
userrealtimedata_updated_idx	CREATE INDEX userrealtimedata_updated_idx ON public.userrealtimedata USING btree (updated)
userrealtimedata_presenceid_idx	CREATE INDEX userrealtimedata_presenceid_idx ON public.userrealtimedata USING btree (presenceid)
idx_userrealtimedata_manuallychecked	CREATE INDEX idx_userrealtimedata_manuallychecked ON public.userrealtimedata USING btree (manuallychecked) WHERE (manuallychecked = false)
idx_userrealtimedata_presence_routing	CREATE INDEX idx_userrealtimedata_presence_routing ON public.userrealtimedata USING btree (systempresence, routingstatus) INCLUDE (name, department, adherencestate, updated) WHERE (systempresence IS NOT NULL)
idx_userrealtimedata_name_presence	CREATE INDEX idx_userrealtimedata_name_presence ON public.userrealtimedata USING btree (name, systempresence, routingstatus) INCLUDE (email, department, adherencestate) WHERE ((name IS NOT NULL) AND ((systempresence)::text <> ‘OFFLINE’::text))

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