public.vw_assistant_details

public.vw_assistant_details

Description

View of assistant details with normalized user names and copilot configuration

Table Definition 
CREATE VIEW vw_assistant_details AS (
 SELECT ast.id,
    ast.name,
    ast.datecreated,
    ast.datemodified,
    ct.username AS createdby,
    md.username AS modifiedby,
    ast.vendorname,
    ast.vendornameknowledge,
    ast.knowledgebaseid,
    ast.languagecode,
    ast.confidencethreshold,
    ast.knowledgebaseselfuri,
    ast.state,
    ast.updated,
    ast.copilotenabled,
    ast.copilotliveonqueue,
    ast.copilotdefaultlanguage,
    ast.copilotknowledgeanswerenabled,
    ast.copilotsummarygenerationenabled,
    ast.copilotsummarysettingid,
    ast.copilotwrapupcodepredictionenabled,
    ast.copilotanswergenerationenabled,
    ast.copilotnluenginetype,
    ast.copilotnludomainid,
    ast.copilotnluintentconfidencethreshold,
    ast.copilotselfuri
   FROM ((assistantdetails ast
     LEFT JOIN vwuserdetail ct ON (((ast.createdby)::text = (ct.id)::text)))
     LEFT JOIN vwuserdetail md ON (((ast.modifiedby)::text = (md.id)::text)))
)

Columns

Name Type Default Nullable Children Parents Comment
id varchar(100) true Assistant unique identifier
name varchar(50) true Assistant name
datecreated timestamp without time zone true Date when the assistant was created
datemodified timestamp without time zone true Date when the assistant was last modified
createdby varchar(200) true Username of the user who created the assistant
modifiedby varchar(200) true Username of the user who last modified the assistant
vendorname varchar(100) true Name of the transcription vendor
vendornameknowledge varchar(50) true Name of the knowledge suggestion vendor
knowledgebaseid varchar(100) true ID of the knowledge base used by the assistant
languagecode varchar(50) true Language code for the knowledge base
confidencethreshold numeric(4,2) true Minimum confidence threshold for NLU intents
knowledgebaseselfuri varchar(200) true URI for the knowledge base object
state varchar(10) true Current state of the assistant
updated timestamp without time zone true Timestamp when the record was last updated
copilotenabled boolean true Whether copilot is enabled for this assistant
copilotliveonqueue boolean true Whether copilot is live on queue
copilotdefaultlanguage varchar(10) true Default language for copilot
copilotknowledgeanswerenabled boolean true Whether knowledge answer is enabled in copilot
copilotsummarygenerationenabled boolean true Whether summary generation is enabled in copilot
copilotsummarysettingid varchar(100) true ID of the summary setting used by copilot
copilotwrapupcodepredictionenabled boolean true Whether wrapup code prediction is enabled in copilot
copilotanswergenerationenabled boolean true Whether answer generation is enabled in copilot
copilotnluenginetype varchar(50) true Type of NLU engine used by copilot
copilotnludomainid varchar(100) true ID of the NLU domain used by copilot
copilotnluintentconfidencethreshold numeric(4,2) true Intent confidence threshold for NLU in copilot
copilotselfuri varchar(200) true The URI for the copilot configuration object

Referenced Tables

Name Columns Comment Type
public.assistantdetails 26 Manage virtual agent assistants BASE TABLE
public.vwuserdetail 17 See UserDetail: User Description in detail VIEW

    • Related Articles

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

      Description Manage virtual agent assistants Columns Name Type Default Nullable Children Parents Comment id varchar(100) false Primary Key name varchar(50) true Name of the assistant datecreated timestamp without time zone true Date when the assistant ...

    • public.queuedetails

      Description Queue Lookup data Columns Name Type Default Nullable Children Parents Comment id varchar(50) false Primary Key / Queue GUID name varchar(255) true Queue Name description varchar(255) true divisionid varchar(50) true Queue Division GUID ...

    • public.vwqueuedetails

      Description See QueueDetails: Queue Lookup data Table Definition CREATE VIEW vwqueuedetails AS ( SELECT qd.id, qd.name, qd.description, "substring"((qd.description)::text, 'queuegroup=([^;]+)(;|$)'::text) AS queuegroup, ...

    • public.vwwrapupdetails

      Description WrapUpDetails Table Definition CREATE VIEW vwwrapupdetails AS ( SELECT wrapupdetails.id, wrapupdetails.name, wrapupdetails.updated FROM wrapupdetails ) Columns Name Type Default Nullable Children Parents Comment id varchar(50) true ...