ALM Project Database Reference
td.QPM_KPI_CALCULATIONS Table
Description
Status of KPI calculation jobs.
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key KPIC_IDThe record ID.int4   
 KPIC_KPI_MSI_IDThe QPM_KPI_MILESTONE_SCOPEITEM.KMSI_IDint4   
 KPIC_CALCULATION_TASK_IDRecord ID of the calculation task in the ALM Platform site database.int4   
 KPIC_TIME_FRAME_START_DATEScheduled calculation start time.datetime4   
 KPIC_START_DATEActual calculation start time.datetime4  
 KPIC_END_DATEActual calculation end time.datetime4  
 KPIC_STATUS

One of:
0 - Not started
1 - In progress
2 - Complete

int4   
 KPIC_IS_FOR_PURGEIndicates if purge job can delete this record.varchar1   
Indexes
IndexDescriptionPrimaryUnique
KPIC_IDX1   
KPIC_PRIMARYKEY 
See Also