Description
Values for defect a columns of a record where the column has more than one value.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| KPIMV_KPI_ID | The QPM_KPIS.KPI_ID | int | 4 | ||||
| KPIMV_COLUMN_NAME | The multi-value column. | varchar | 40 | ||||
| KPIMV_VALUE | A single value.
Note: The values are denormalized for performance reasons. Any program that alters the values in this value field must also handle the semicolon-separated value in the main entity table | varchar | 255 |  |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| INX_KPIMV | | ||
| INX_KPIMV_KPI_ID |
See Also