Share this page
ALM Project Database Reference
td.QPM_KPI_BREAKDOWN_TYPES Table
Description
KPI Breakdown Types.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | KPIBT_ID | The record ID. | int | 4 | |||
| KPIBT_KPIT_ID | QPM_KPI_TYPES.KPIT_ID | int | 4 | ||||
| KPIBT_NAME | The breakdown type name. | varchar | 255 |  | |||
| KPIBT_FILTER | XML representation of an ALM filter on the KPI population. | varchar | 16 | | |||
| KPIBT_GROUP_BY_SF_COLUMN_NAME | The group-by field. | varchar | 40 | | |||
| KPIBT_FUNCTION_NAME | The aggregation function. For example, "COUNT". | varchar | 60 | | |||
| KPIBT_FUNCTION_FIELD | For future use. | varchar | 60 | | |||
| KPIBT_DEFAULT_GRAPH_LAYOUT | The graph layout. For example, "Pie" . | varchar | 10 | | |||
| KPIBT_ENABLED | Y if this breakdown is in use. | varchar | 1 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| KPIBT_KPIT_ID_IDX | |||
| KPIBT_PRIMARYKEY | | |
See Also
Related Objects
