public.groupdetails

public.groupdetails

Description

Agent Group Lookup Data

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) false Primary Key / Agent Group GUID
name varchar(255) true Agent Group Name
description varchar(255) true Agent Group Description
membercount integer true Agent Group Member Count (Includes all members and Owners if flag set in GC)
state varchar(50) true Agent Group State
type varchar(50) true Agent Group Type
selfuri varchar(150) true Agent Group URI
updated timestamp without time zone true Date Row Updated (UTC)

Constraints

Name Type Definition
groupdetails_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
groupdetails_pkey CREATE UNIQUE INDEX groupdetails_pkey ON public.groupdetails USING btree (id)

    • Related Articles

    • public.vwgroupdetails

      Description View for agent group details and metadata Table Definition CREATE VIEW vwgroupdetails AS ( SELECT groupdetails.id, groupdetails.name, groupdetails.description, groupdetails.membercount, groupdetails.state, groupdetails.type, ...

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