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.
| 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 |
| 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 | nvarchar2 (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 | nvarchar2 (128) | True | Depends on customer usage | Account code description. |
4.0.106.453 | 4.0 Release | |||
| I3TimeStampGMT | date | 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 | number | 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 | number | 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 |
| Primary Key Name | Type | Column Name (sort order) |
|---|---|---|
| PK_AccountCodeMirror | Non-clustered | SiteId (Ascending) AccountCode (Ascending) |
| Primary Key Name | Column Name (sort order) |
|---|---|
| PK_AccountCodeMirror | SiteId (Ascending) AccountCode (Ascending) |
| Index Name | Type | Column Name (sort order) |
|---|---|---|
| I3TimeStampGMT | Clustered | I3TimeStampGMT (Ascending) SiteId (Ascending) |
| Index Name | Column Name (sort order) |
|---|---|
| I3TimeStampGMT | I3TimeStampGMT (Ascending) SiteId (Ascending) |