Expand All Collapse All
<p>IVR Retention Settings</p>

IVR_RetentionSettings Table

IVR Retention Settings

This table stores all Retention/Purge settings information.

  • Table Type - Historical
  • Last Changed Version - 19.3.0.0
  • Last Changed Reason - IVR Analytics Feature

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
ServerName nvarchar (60) False No

PureConnect Server name

 19.3.0.0 IVR Analytics Feature Server Name Attribute IVR
PurgingEnabled bit (1) False No

This is a boolean flag which allows customer to control the data purging

 19.3.0.0 IVR Analytics Feature Purging Enabled Fact IVR
PurgeTime time (3) True No

The time in a day at which data will get purged if purging is enabled

 19.3.0.0 IVR Analytics Feature Purge Time Fact IVR
DaysToKeep int (4) True No

The number of days for which data to be retained in the system.

 19.3.0.0 IVR Analytics Feature Days To Keep Fact IVR

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_IVR_RetentionSettings Clustered ServerName (Ascending)