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