Contact Trace Records

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
ConnectedToAgentTimestamp timestamp without time zone true
CustomerHoldDuration integer true
LongestHoldDuration integer true
NumberOfHolds integer true
RoutingProfile varchar(255) true
AgentConnectionAttempts integer true
Channel varchar(255) true
ConnectedToSystemTimestamp timestamp without time zone true
CustomerEndpointAddress varchar(255) true
CustomerEndpointType varchar(255) true
DisconnectTimestamp timestamp without time zone true
InitialContactId varchar(255) true
InitiationMethod varchar(255) true
InitiationTimestamp timestamp without time zone true
LastUpdateTimestamp timestamp without time zone true
MediaStreamsType varchar(255) true
NextContactId varchar(255) true
PreviousContactId varchar(255) true
QueueName varchar(255) true
QueueEnqueueTimestamp timestamp without time zone true
QueueDequeueTimestamp timestamp without time zone true
QueueDuration integer true
RecordingLocation varchar(255) true
RecordingStatus varchar(255) true
SystemEndpointAddress varchar(255) true
SystemEndpointType varchar(255) true
TransferCompletedTimestamp varchar(255) true
TransferredToEndpointAddress varchar(255) true
TransferredToEndpointType varchar(255) true
ZendeskLookupResult varchar(255) true
callflowARN varchar(255) true
customerCallback varchar(255) true
customerDisplayNumber varchar(255) true
customerReferenceNumber varchar(255) true
intent varchar(255) true
journey varchar(255) true
lambdaARNAttributeSet varchar(255) true
lambdaARNBannerEvents varchar(255) true
lambdaARNPrompts varchar(255) true
lambdaResultBNR varchar(255) true
lambdaResultDID varchar(255) true
lineName varchar(255) true
modulePath varchar(255) true
promptAfterhours varchar(255) true
promptCallback varchar(255) true
promptInQMessage1 varchar(255) true
promptInQMessage2 varchar(255) true
promptNoStaff varchar(255) true
promptPreQMessage varchar(255) true
promptPrivacy varchar(255) true
promptReferenceNumber varchar(255) true
promptWelcome varchar(255) true
state varchar(255) true
whisper varchar(255) true
db_last_updated timestamp without time zone true
dispositionCode varchar true
dispositionName varchar true
vfConnectedAt varchar true
ZendeskOrganization varchar true
ZendeskUserID varchar true
ZendeskUserName varchar true
ZendeskUserRole varchar true
vfOriginAgentId varchar true
vfPreviousContactId varchar true
vfQueueARN varchar true
vfQueueId varchar true
vfQueueName varchar true
vfTransferTarget varchar true
vfTransferType varchar true
vf_is_internal_call varchar true
vf_origin_name varchar true
account_code varchar true
customerCallbackCED varchar true
vfAutoCloseAt varchar true
vf varchar true
account varchar true
error varchar true
destination varchar true
emergencyType varchar true
lambdaResultOnCallAttrSet varchar true
lambdaResultOnCallBanner varchar true
oncallDutyManagerAH varchar true
initialiseTransfer varchar true
oncallDutyManagerBH varchar true
lambdaResultBNRTransfer varchar true
oncallPhoneNumberAH varchar true
lambdaResultDIDTransfer varchar true
oncallPhoneNumberBH varchar true
promptInQMessage varchar true
script varchar true
agentId varchar true
encryptVoicemail varchar true
extensionNumber varchar true
saveCallRecording varchar true
transcribeVoicemail varchar true
transferMessage varchar true
lambdaResultDST varchar true
lambdaResultBNRQueue varchar true
AgentAssitedTransferInitiated varchar true
UserShortName varchar true

Constraints

Name Type Definition
pk_contacttracerecords PRIMARY KEY PRIMARY KEY (“ContactId”)

Indexes

Name Definition
pk_contacttracerecords CREATE UNIQUE INDEX pk_contacttracerecords ON contactcentredb.contacttracerecords USING btree (“ContactId”)

Generated by tbls


    • Related Articles

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

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

    • public.odcontactlistdata

      Description Outbound Dialling Contact List Data - Any new attribs are added automatically by the adapter. Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false Primary Key contactlistid varchar(50) true Contact List ...

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

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