Limits of measured KPI values by date.
Column Name | Description | Datatype | Length | Allow Nulls | Default | |
---|---|---|---|---|---|---|
![]() | 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 | ![]() |