Jump to: navigation, search

INTERACTION_TYPE Dimension

The INTERACTION_TYPE Dimension describes facts based on interaction type, such as Inbound, Outbound, or Unknown.

The INTERACTION_TYPE Dimension
Field Data Type Description
INTERACTION_TYPE_KEY int Primary key of this table.
INTERACTION_TYPE_NAME nvarchar(255)

The interaction type. This field is set to one of the following values:

  • Unknown
  • Inbound
  • Outbound
INTERACTION_TYPE_SUBTYPE nvarchar(255)

The interaction subtype.

For Inbound interaction type, the following will most likely be seen:

  • InboundNew
  • InboundCustomerReply

For Outbound interaction type:

  • OutboundNew
  • OutboundReply
  • OutboundAcknowledgement
  • OutboundAutoResponse
  • OutboundCollaborationInvite
  • OutboundRedirect
CREATED_ETL_AUDIT_KEY int Key to the ETL_AUDIT dimension identifying the ETL job that created this record.
UPDATED_ETL_AUDIT_KEY int Key to the ETL_AUDIT dimension, identifying the ETL job that last updated this record.
This page was last edited on December 23, 2020, at 09:04.
Comments or questions about this documentation? Contact us for support!