Expand All Collapse All
Account Code Mirror

AccountCodeMirror Table

Account Code Mirror

The content of this table is a mirror image of the account codes as they are currently configured in CIC. This table is not used on any of the CIC reports. There are plans to remove this table from the database in a future release.

  • Table Type - Lookup
  • Last Changed Version - 4.0.106.453
  • Last Changed Reason - 4.0 Release

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
AccountCode nvarchar (50) False Depends on customer usage

This is the account/billing code assigned to an interaction. This code is user defined.

 4.0.106.453 4.0 Release
Description nvarchar (128) False Depends on customer usage

Account code description.

 4.0.106.453 4.0 Release
I3TimeStampGMT datetime False No

System supplied date/time when row was sent to the IC Logging server for insertion into the table.

 4.0.106.453 4.0 Release
SiteId smallint False No

Site identifier of the source of this interaction row. Used in multi-site rollup to distinguish the origin of data.

 4.0.106.453 4.0 Release
SubSiteId smallint False No

Not used in the current release. The purpose of this field is to divide use within a site, such as for multiple independent companies on one CIC system. Until CIC has such functionality, this field is zero and is reserved for future use.

 4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_AccountCodeMirror Non-clustered SiteId (Ascending)
AccountCode (Ascending)


Index Name Type Column Name (sort order)
I3TimeStampGMT Clustered I3TimeStampGMT (Ascending)
SiteId (Ascending)