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 | |
|---|---|---|---|---|---|---|---|
| SCIMV_SCOPE_ITEM_ID | The td.QPM_SCOPE_ITEM Table | int | 4 | ||||
| SCIMV_COLUMN_NAME | The multi-value column. | varchar | 40 | ||||
| SCIMV_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_SCIMV | | ||
| INX_SCIMV_SCOPE_ITEM_ID |
See Also