Description
An association table between QPM_KPIS and QPM_MILESTONE_SCOPEITEM.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | KMSI_ID | The record ID. | int | 4 | |||
| KMSI_MILESTONE_SCOPEITEM_ID | int | 4 | |||||
| KMSI_KPI_ID | QPM_KPIS.KPI_ID | int | 4 | ||||
| KMSI_IS_ACTIVE | Y indicates that the KPI is active for the scope item in the milestone. | varchar | 1 | ||||
| KMSI_IS_THRESHOLD_CUSTOM | Y indicates that the KPI threshold is overridden by the milestone scope item threshold. | varchar | 1 | ||||
| KMSI_VER_STAMP | The version number of this record. | int | 4 | ||||
| KMSI_VTS | The version time stamp. | varchar | 20 |
See Also