Expand All Collapse All
Stat Profile

StatProfile Table

Stat Profile

As StatDimension table defines the what statistics, StatProfile defines the when. Each DimensionSet identifier combined with the dIntervalStart column in this table make up into another uniquely identifier field called StatisticsSet. This field can thus be used to identify all of the dimensions of any given queue period statistics.

As time always progresses in any of the queue period statistics views, the StatisticsSet is thus continue to be increasing. Because of this, a substantially large value ranges is made available. Over 4 billion records (and twice of that in an Oracle environment) can exist before the identifier wraps around. Even in the most strenuous system combine with the longest retention time for the queue period statistics data, the number of records in any given type of queue period statistics is expected to never reach this maximum count.

  • Table Type - Historical
  • 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
StatisticsSet int False No

A unique identifier referencing this row.

 4.0.106.453 4.0 Release
DimensionSet int False No

The report hierarchies set that the above StatisticsSet represents. This identifier can be translated back to the report hierarchies set using StatDimensions table.

 4.0.106.453 4.0 Release
dIntervalStart datetime False No

Starting date/time of the interval based on the local time that the physical IC server resides that the above StatisticsSet represents. The interval is configured under Report Configuration tab in IA. The default interval is 1800 seconds (30 minutes) and is always relative to the hour. In some cases, the interval start times might not be exactly on the hour. This is usually due to stopping and starting CIC. These odd interval start times may be visible in the reports.

 4.0.106.453 4.0 Release
I3TimeStampGMT datetime False No

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

 4.0.106.453 4.0 Release
SiteId smallint False No

Site identifier of the source for this record. Used in multi-site installations to distinguish the origin of the record. Configured when setting up CIC.

 4.0.106.453 4.0 Release
nDuration int False No

The duration in seconds of the interval. If dIntervalStart is an odd start time, the duration of the interval will have a non-standard length.

 4.0.106.453 4.0 Release
dIntervalStartUTC datetime True No

Holds dIntervalStart time UTC.

 4.0.106.453 4.0 Release
ConfigurationSet int False No

The unique identifier representing the service level configuration settings when this statistics was tabulated.

 4.0.106.453 4.0 Release
SchemaMajorVersion tinyint False No

The major version that this row was written in. This is meant to distinguish migrated and native data.

 4.0.106.453 4.0 Release
SchemaMinorVersion tinyint False No

The minor version that this row was written in. This is meant to distinguish migrated and native data.

 4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_StatProfile Clustered StatisticsSet (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_StatProfile_StatDim DimensionSet StatDimensions DimensionSet Yes
FK_StatProfile_DQConf ConfigurationSet DQConfig ConfigurationSet Yes

Index Name Type Column Name (sort order)
SP_DimSetCovering Unique non-clustered DimensionSet (Ascending)
dIntervalStart (Ascending)
I3TimeStampGMT (Ascending)
SiteId (Ascending)
SP_dIntCovering Non-clustered dIntervalStart (Ascending)
DimensionSet (Ascending)
SiteId (Ascending)
nDuration (Ascending)
SP_I3TimSit Non-clustered I3TimeStampGMT (Ascending)
SiteId (Ascending)