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

    • Release Notes

      Customer Science releases regular updates to our Genesys Adapter and associated CXiaaS offerings. Please review to understand our current releases: October 2025 October 2025 Version v3.53.3 - October 24, 2025 Improvements Enhanced Voice Analysis ...

    • Genesys Adapter - Technical Documentation

      Executive Summary The Genesys Adapter provides comprehensive, enterprise-grade solutions for synchronizing Genesys Cloud contact center data into various database platforms including Microsoft SQL Server, PostgreSQL, and Snowflake. These integrations ...

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