Project Data Tables Database > td Schema : td.QPM_KPI_CALCULATIONS Table |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
KPIC_ID | The record ID. | int | 4 | ||||
KPIC_KPI_MSI_ID | The QPM_KPI_MILESTONE_SCOPEITEM.KMSI_ID | int | 4 | ||||
KPIC_CALCULATION_TASK_ID | Record ID of the calculation task in the ALM Platform site database. | int | 4 | ||||
KPIC_TIME_FRAME_START_DATE | Scheduled calculation start time. | datetime | 4 | ||||
KPIC_START_DATE | Actual calculation start time. | datetime | 4 | ||||
KPIC_END_DATE | Actual calculation end time. | datetime | 4 | ||||
KPIC_STATUS | One of: | int | 4 | ||||
KPIC_IS_FOR_PURGE | Indicates if purge job can delete this record. | varchar | 1 |
Index | Description | Primary | Unique |
---|---|---|---|
KPIC_IDX1 | |||
KPIC_PRIMARYKEY |