Share this page

# PPM_INT_QC_KPI

This table stores the KPI values retrieved from Application Lifecycle Management (ALM).

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
KPI_ITEM_ID | NOT NULL | NUMBER | System-generated identifier
PPM_PROJECT_ID | NOT NULL | NUMBER | PPM project ID
PPM_PROJECT_NAME | NOT NULL | VARCHAR2(300) | PPM project name
QC_SERVER_ID | NOT NULL | VARCHAR2(128) | ALM/QC server name on the View Project Quality integration landing page
QC_DOMAIN_ID | NOT NULL | VARCHAR2(200) | ALM/QC domain name on the View Project Quality integration landing page
QC_PROJECT_ID | NOT NULL | VARCHAR2(200) | ALM/QC project name on the View Project Quality integration landing page
QC_RELEASE_ID | NOT NULL | NUMBER | ALM/QC release ID on the View Project Quality integration landing page
TOTAL_TESTS | NULLABLE | NUMBER | Total number of test cases within a specific release. Not used in PPM Center version 9.20.
PASSED_TESTS | NULLABLE | NUMBER | Number of test cases with status of "Passed". Not used in PPM Center version 9.20.
TOTAL_REQUIREMENTS | NULLABLE | NUMBER | Total number of requirements within a specific release
COVERED_REQUIREMENTS | NULLABLE | NUMBER | Number of the requirements within a specific release, excluding status "Not Covered" or "N/A"
REVIEWED_REQUIREMENTS | NULLABLE | NUMBER | Number of requirements with status "Reviewed" within a specific release
PASSED_REQUIREMENTS | NULLABLE | NUMBER | Number of requirements with status of "Passed"
TOTAL_DEFECTS | NULLABLE | NUMBER | Total number of defects of release level
PRIORITY_DEFECTS | NULLABLE | NUMBER | Number of defects with priority level at "4-Very High" or "5-Urgent"
CLOSED_DEFECTS | NULLABLE | NUMBER | Number of defects with status of "Closed"
CREATION_DATE | NOT NULL | DATE |

## Indexes

This table does not use any indexes.

## Sequences

Sequence Name | Sequence Type
--- | ---
PPM_INT_QC_KPI_S | KPI_ITEM_ID

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: