public.kq_analysis

public.kq_analysis

Description

Columns

Name Type Default Nullable Children Parents Comment
kq_analysisid varchar(50) false Primary key for the knowledge analysis record
conversationid varchar(50) true ID of the Genesys Cloud conversation this analysis relates to
communicationid varchar(50) true ID of the specific communication within the conversation
callsummary text true AI-generated summary of the call/interaction
callresolution text true Description of how the call was resolved
callbackrequired boolean true Boolean indicating if a callback was requested
selfserviceattempted boolean true Boolean indicating if self-service was attempted
selfserviceproblems boolean true Boolean indicating if self-service problems occurred
satisfactionsentiment numeric(5,2) true Customer satisfaction sentiment score (-1.00 to 1.00 typical)
knowledgeareaid varchar(50) true Canonical ID for the knowledge area connected to this analysis (nullable)
knowledgeareaname varchar(400) true Human-readable name of the knowledge area assigned to the analysis (nullable)
qualityinteraction boolean true Boolean flag marking if the interaction is considered a quality interaction (nullable)
updated timestamp without time zone true

Constraints

Name Type Definition
kq_analysis_pkey PRIMARY KEY PRIMARY KEY (kq_analysisid)

Indexes

Name Definition
kq_analysis_pkey CREATE UNIQUE INDEX kq_analysis_pkey ON public.kq_analysis USING btree (kq_analysisid)
idx_kq_analysis_communicationid CREATE INDEX idx_kq_analysis_communicationid ON public.kq_analysis USING btree (communicationid)
idx_kq_analysis_conversationid CREATE INDEX idx_kq_analysis_conversationid ON public.kq_analysis USING btree (conversationid)

    • Related Articles

    • public.kq_analysis_keyword

      Description Columns Name Type Default Nullable Children Parents Comment kq_analysiskeywordid varchar(50) false kq_analysisid varchar(50) false keyword varchar(100) false updated timestamp without time zone true Constraints Name Type Definition ...

    • public.kq_analysis_taxonomy

      Description Columns Name Type Default Nullable Children Parents Comment kq_analysistaxonomyid varchar(50) false Primary key for the taxonomy analysis record kq_analysisid varchar(50) true References the parent kq_analysis record taxonomy varchar(200) ...

    • public.kq_analysis_question

      Description Columns Name Type Default Nullable Children Parents Comment kq_analysisquestionid varchar(50) false Primary key for the question analysis record kq_analysisid varchar(50) true References the parent kq_analysis record question text true ...

    • public.kq_analysis_question_keyword

      Description Columns Name Type Default Nullable Children Parents Comment kq_analysisquestionkeywordid varchar(50) false kq_analysisquestionid varchar(50) false keyword varchar(100) false updated timestamp without time zone true Constraints Name Type ...

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