Amazon Connect
User Groups
contactcentredb.usergroups Description Columns Name Type Default Nullable Children Parents Comment UserId varchar(255) false UserName varchar(255) true Level1Id varchar(255) true Level1Name varchar(255) true Level2Id varchar(255) true Level2Name ...
Transcript Segment
contactcentredb.transcript_segment Description Columns Name Type Default Nullable Children Parents Comment id varchar(255) false contact_id varchar(255) true participant_id varchar(255) true participant_role varchar(255) true content varchar true ...
Queue Observations
contactcentredb.queueobservations Description Columns Name Type Default Nullable Children Parents Comment QueueName varchar(255) false LastUpdate timestamp without time zone true AGENTS_ONLINE smallint true AGENTS_AVAILABLE smallint true ...
Queue Metrics
contactcentredb.queuemetrics Description Columns Name Type Default Nullable Children Parents Comment QueueNameKey varchar(255) false LastUpdate timestamp without time zone true StartDate timestamp without time zone true QueueName varchar(255) true ...
Matched Category
contactcentredb.matched_category Description Columns Name Type Default Nullable Children Parents Comment contact_id varchar(255) false category varchar(255) false db_last_updated timestamp without time zone true Constraints Name Type Definition ...
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 ...
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 ...
Agent Status History
contactcentredb.agentstatushistory Description Columns Name Type Default Nullable Children Parents Comment AgentARN varchar(255) false Timestamp timestamp without time zone false UserName varchar(255) true Queue varchar(255) true RoutingProfile ...
Agent Status
contactcentredb.agentstatus Description Columns Name Type Default Nullable Children Parents Comment AgentARN varchar(255) false UserName varchar(255) true Queue varchar(255) true RoutingProfile varchar(255) true Timestamp timestamp without time zone ...
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 ...