Contact Lens Summary

Contact Lens Summary

contactcentredb.contact_lens_summary

Description

Columns

Name Type Default Nullable Children Parents Comment
contact_id varchar(255) false
transcript_summary varchar true
overall_sentiment_agent double precision true
overall_sentiment_customer double precision true
language_code varchar(255) true
input_s3_uri varchar(255) true
db_last_updated timestamp without time zone true

Constraints

Name Type Definition
pk_contact_lens_summary PRIMARY KEY PRIMARY KEY (contact_id)

Indexes

Name Definition
pk_contact_lens_summary CREATE UNIQUE INDEX pk_contact_lens_summary ON contactcentredb.contact_lens_summary USING btree (contact_id)

Generated by tbls


    • Related Articles

    • README

      Logo Amazon Connect Data Dictionary Tables Name Columns Comment Type contactcentredb.queueobservations 13 BASE TABLE contactcentredb.queuemetrics 42 BASE TABLE contactcentredb.usergroups 15 BASE TABLE contactcentredb.agentstatus 12 BASE TABLE ...

    • Contact Trace Records

      contactcentredb.contacttracerecords Description Columns Name Type Default Nullable Children Parents Comment ContactId varchar(255) false AgentName varchar(255) true AfterContactWorkDuration integer true AgentInteractionDuration integer true ...

    • public.convvoicesummarydata

      Description AI-generated summaries for voice conversations from Genesys Cloud Speech and Text Analytics Columns Name Type Default Nullable Children Parents Comment keyid varchar(150) false Primary key composed of conversation ID, summary type, and ...

    • public.vwcopilotsummaryinsights

      Description Copilot summary insights with usage context Table Definition CREATE VIEW vwcopilotsummaryinsights AS ( SELECT cs.conversationid, cs.conversationstartdate, cs.conversationenddate, cs.conversationstartdateltc, cs.conversationenddateltc, ...

    • public.vwcopilotusagedata

      Description Copilot usage analytics with user and queue context Table Definition CREATE VIEW vwcopilotusagedata AS ( SELECT cu.keyid, cu.conversationid, cu.summaryid, cu.usagedate, cu.userid, ud.name AS agent_name, ud.username AS agent_username, ...