HP ALM Database Reference
td.QPM_KPI_BREAKDOWN_RESULTS Table

Description

KPI breakdown results.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key KPIBR_IDThe record ID.int4  
 KPIBR_KPIBT_IDQPM_KPI_BREAKDOWN_TYPES.KPIBT_IDint4  
 KPIBR_KPIC_IDQPM_KPI_CALCULATIONS.KPIC_IDint4  
 KPIBR_KPI_MSI_IDQPM_KPI_MILESTONE_SCOPEITEM.KMSI_IDint4  
 KPIBR_GROUP_BY_SF_COLUMN_NAMEThe group-by field used for the breakdown result.varchar40 
 KPIBR_LS_DESCRIPTIONThe group-by key. For example, "1-Low" or "Not-Reviewed".varchar255 
 KPIBR_VALUEThe value related to the group-by query aggregated by the KPIBR_LS_DESCRIPTION fieldint4 
 KPIBR_TIME_FRAME_START_DATEScheduled calculation start time.datetime4  
 KPIBR_ACTUAL_RESULT_DATETime the result was generated according to the clock of the ALM Platform site database server.datetime4  
 KPIBR_IS_FOR_PURGEIndicates if purge jog can delete this record.varchar1  

See Also