HP ALM Database Reference
td.QPM_KPI_CALCULATION_RESULTS Table

Description

Results of KPI calculations.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key KPIR_IDThe record ID.int4  
 KPIR_KPIC_IDQPM_KPI_CALCULATIONS.KPIC_IDint4  
 KPIR_KPI_MSI_IDQPM_KPI_MILESTONE_SCOPEITEM.KMSI_IDint4  
 KPIR_NUMERIC_RESULTResult of numeric KPIs or empty for percentage KPIs.int4 
 KPIR_NUMERATOR_RESULTNumerator for percentage KPIs or empty for numeric KPIs.int4 
 KPIR_DENOMINATOR_RESULTDenominator for percentage KPIs or empty for numeric KPIs.int4 
 KPIR_TIME_FRAME_START_DATEScheduled calculation start time.datetime4  
 KPIR_ACTUAL_RESULT_DATETime the result was generated according to the clock of the ALM Platform site database server.datetime4  
 KPIR_IS_FOR_PURGEIndicates if purge jog can delete this record.varchar1  

See Also