Description
Limits of measured KPI values by date.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | TV_ID | The record ID. | int | 4 | |||
| TV_OWNER_ID | The record ID in the TV_OWNER_TYPE table. | int | 4 | ||||
| TV_OWNER_TYPE | The name of the project database table that contains the entity the threshold value belongs to. Either QPM_KPI_MILESTONE_SCOPEITEM or QPM_KPIS. | varchar | 40 | ||||
| TV_DATE | The date on which the threshold value is defined. | datetime | 4 | ||||
| TV_TARGET_VALUE | The limit in effect on TV_DATE. | int | 4 | ||||
| TV_TOLERANCE | The warning range, relative to TV_TARGET_VALUE. | int | 4 | ||||
| TV_VER_STAMP | The version number of this record. | int | 4 | ||||
| TV_USER_01 | User-defined field. | varchar | 40 |  |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| THRESHOLD_VALUES_IX1 | |||
| THRESHOLD_VALUES_PK | | |
See Also