Setting Agile Quality KPIs: Metrics, Direction, and Traffic Light Thresholds
Data model

Fields
| Field |
Type |
Description |
| direction* |
VARCHAR (20) |
Metric Direction: HigherIsBetter or LowerIsBetter |
| display_name* |
VARCHAR (150) |
Display name of the KPI |
| green_threshold* |
DECIMAL |
Green traffic light threshold |
| is_active* |
BIT |
Logical Deletion: 1 = Active Record, 0 = Retired |
| is_enabled* |
BIT |
Indicates whether the metric is evaluated as a KPI |
| kpi_id* |
UNIQUEIDENTIFIER |
Unique KPI identifier |
| metric_code* |
VARCHAR (80) |
Code of the metric evaluated as KPI (unique) |
| yellow_threshold* |
DECIMAL |
Yellow traffic light threshold |
Primary Key