Expand All Collapse All
<p>This Table contains the historic of all Genesys Cloud Interactions. </p>

GC_InteractionsLog Table

This Table contains the historic of all Genesys Cloud Interactions.

This Table contains the historic of all Genesys Cloud Interactions. Those interactions may or not have been recorded.

  • Table Type - Historical
  • Last Changed Version - 20.4.0.0
  • Last Changed Reason - Creation.

SQL Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
InteractionUUID uniqueidentifier False No

Interaction ID.

20.4.0.0 Creation.
ConversationId uniqueidentifier True No

Conversation ID of the interaction.

20.4.0.0 Creation.
StartDatetime datetime False No

UTC start date time of the interaction.

20.4.0.0 Creation.
StartDatetimeOffset smallint False No

Start date time offset in minutes.

20.4.0.0 Creation.

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_GC_InteractionsLog Clustered InteractionUUID (Ascending)


Index Name Type Column Name (sort order)
IX_GC_InteractionsLog_ConversationId Non-clustered ConversationId (Ascending)