kpi_control

This tables contains data to render Six Sigma control charts. This data is aggregated periodically by a server process, from data in the kpi_process_stats table.

Column Name Column Datatype Column Null Option Column Comment
kpi_id integer not null Foreign key to KPI type
datetime date not null Timestamp for control chart record
dimension_2 varchar(255) not null Metric value 1 for control chart record
dimension_3 varchar(255) not null Metric value 2 for control chart record
sample_size integer not null Size of data sample
sample_average float not null Average of data sample
sample_range integer not null Range of data sample
sample_values varchar(255) not null Sample stats string

Product Name: BPM

Table Type: Table


Copyright © 2006 CA. All rights reserved.