public.kq_analysis

public.kq_analysis

Description

Columns

Name Type Default Nullable Children Parents Comment
kq_analysisid uuid false public.kq_analysis_keyword Primary key UUID for the knowledge analysis record
conversationid uuid true UUID of the Genesys Cloud conversation this analysis relates to
communicationid uuid true UUID 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 uuid 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)

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 uuid false kq_analysisid uuid false public.kq_analysis keyword varchar(100) false created_date timestamp without time zone now() true updated_date timestamp ...

    • public.kq_analysis_taxonomy

      Description Columns Name Type Default Nullable Children Parents Comment kq_analysistaxonomyid uuid false Primary key UUID for the taxonomy analysis record kq_analysisid uuid true Foreign key UUID referencing the parent kq_analysis record taxonomy ...

    • public.kq_analysis_question

      Description Columns Name Type Default Nullable Children Parents Comment kq_analysisquestionid uuid false public.kq_analysis_question_keyword Primary key UUID for the question analysis record kq_analysisid uuid true Foreign key UUID referencing the ...

    • public.kq_analysis_question_keyword

      Description Columns Name Type Default Nullable Children Parents Comment kq_analysisquestionkeywordid uuid false kq_analysisquestionid uuid false public.kq_analysis_question keyword varchar(100) false created_date timestamp without time zone now() ...

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