IDS_DIGITALHISTORY_DETAILS_SD_RESID20601

DigitalHistory Table

IDS_DIGITALHISTORY_DETAILS_SD_RESID20601

IDS_DIGITALHISTORY_DETAILS_LD_RESID20602

  • Table Type - Historical
  • Last Changed Version - 18.0.0.000
  • Last Changed Reason - Added for reporting on the various digital interactions initiated by dialer campaigns.

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
interactionid char (19) False Unknown

Interaction Id of the email initiated by Dialer.

18.4.0.000 Added for reporting on the various digital interactions initiated by dialer campaigns.
associated_callid char (19) True Unknown

Interaction Id of the Dialer call that initiated the email.

18.4.0.000 Added for reporting on the various digital interactions initiated by dialer campaigns.
time_queued_utc datetime2 True Unknown

The time when Dialer sent the request to the PostOffice subsystem to send an email.

18.4.0.000 Added for reporting on the various digital interactions initiated by dialer campaigns.
sender nvarchar (255) True Unknown

The sender's email address.

18.4.0.000 Added for reporting on the various digital interactions initiated by dialer campaigns.
recipient nvarchar (255) True Unknown

The recipient's email address.

18.4.0.000 Added for reporting on the various digital interactions initiated by dialer campaigns.
email_subject nvarchar (MAX) True Unknown

Text of the email's subject field.

18.4.0.000 Added for reporting on the various digital interactions initiated by dialer campaigns.
policy_behavior_name nvarchar (30) True Unknown

Name of the policy behavior that initiated the email, as defined in Interaction Administrator.

18.4.0.000 Added for reporting on the various digital interactions initiated by dialer campaigns.
digital_type tinyint True Unknown

An integer indicating the type of digital interaction.

Value Description
0 Email interaction
1 Reserved for future use
18.4.0.000 Added for reporting on the various digital interactions initiated by dialer campaigns.

SQL Constraints