public.presencedetails

Description

Persence Code Lookup Data

Name	Type	Nullable	Comment
id	varchar(50)	false	Primary Key
systempresence	varchar(255)	true	Presence System Presence Name
orgpresence	varchar(255)	true	Presence Organisation Presence Name
deactivated	bit(1)	true	Presence Active ?
type	varchar(50)	true	Presence Type
divisionid	varchar(50)	true	Division ID
updated	timestamp without time zone	true	Date Row Updated (UTC)

Name	Type	Definition
presencedetails_pkey	PRIMARY KEY	PRIMARY KEY (id)

Name	Definition
presencedetails_pkey	CREATE UNIQUE INDEX presencedetails_pkey ON public.presencedetails USING btree (id)

Related Articles
public.vwpresencedetails
Description See PresenceDetails: Presence Code Lookup Data Table Definition CREATE VIEW vwpresencedetails AS ( SELECT pd.id, pd.systempresence, pd.orgpresence, pd.deactivated, pd.type, CASE WHEN ((pd.divisionid)::text = '*'::text) THEN dd.id ELSE ...
public.vwuserpresencedatadaily
Description See UserPresenceDataDaily - Expands all the GUIDs with their lookups(Daily) Table Definition CREATE VIEW vwuserpresencedatadaily AS ( SELECT userpresencedatadaily.id, userpresencedatadaily.userid, userdetail.name AS agentname, ...
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 ...