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.

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.
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 raw (16) False No

Interaction ID.

20.4.0.0 Creation.
ConversationId raw (16) True No IDS_GC_INTERACTIONS_LOG_INTERACTIONUUID_LD_RESID20867 20.4.0.0 Creation.
StartDatetime timestamp False No

UTC start date time of the interaction.

20.4.0.0 Creation.
StartDatetimeOffset integer False No

Start date time offset in minutes.

20.4.0.0 Creation.

Constraints

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

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


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