CIC Data Dictionary Improvements

A new webpage for the CIC Data Dictionary will now be accessible from our support pages at http://help.inin.com. This online reference replaces the current CIC Data Dictionary Technical Reference document and will now be updated regularly with PureConnect releases.

Along with a new webpage, there are improvements to the maintainability and the content of the information on the reporting CIC Data Dictionary. The webpage is now accurately maintained by extracting the content from current database schemas. The improvements also include additional table column information and consistency of the table information throughout the data dictionary. Examples of additional column information include: table and column change versions and change reasons; whether a table contains personally identifiable information (PII); and information about the views and stored procedures used by Interaction Reporter.

The new reporting CIC Data Dictionary webpage

Changes have also been made to the way we build our database scripts. This might produce differences with some database objects when comparing schemas against an older IC database install. These differences will also appear in the Database Schema Change Library on the Product Information website. Even though these changes show up as differences, they are still functionally equivalent to the previous version of these objects and will make change tracking more robust for future changes.