Share this page
ALM Project Database Reference
td.QPM_KPI_CALCULATION_RESULTS Table
Description
Results of KPI calculations.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | KPIR_ID | The record ID. | int | 4 | |||
| KPIR_KPIC_ID | QPM_KPI_CALCULATIONS.KPIC_ID | int | 4 | ||||
| KPIR_KPI_MSI_ID | QPM_KPI_MILESTONE_SCOPEITEM.KMSI_ID | int | 4 | ||||
| KPIR_NUMERIC_RESULT | Result of numeric KPIs or empty for percentage KPIs. | int | 4 |  | |||
| KPIR_NUMERATOR_RESULT | Numerator for percentage KPIs or empty for numeric KPIs. | int | 4 | | |||
| KPIR_DENOMINATOR_RESULT | Denominator for percentage KPIs or empty for numeric KPIs. | int | 4 | | |||
| KPIR_TIME_FRAME_START_DATE | Scheduled calculation start time. | datetime | 4 | ||||
| KPIR_ACTUAL_RESULT_DATE | Time the result was generated according to the clock of the ALM Platform site database server. | datetime | 4 | ||||
| KPIR_IS_FOR_PURGE | Indicates if purge job can delete this record. | varchar | 1 |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| KPIR_IDX1 | |||
| KPIR_IDX2 | |||
| KPIR_PRIMARYKEY | | |
See Also
Related Objects
