KCRT_FG_QC_INFO

This table stores fields for the PPM-Quality Center integration.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KCRT_REQUESTS

REQUEST_ID

REQUEST_ID

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

REQUEST_TYPE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

REQUEST_ID

NOT NULL

NUMBER

System-generated identifier

REQUEST_TYPE_ID

NOT NULL

NUMBER

Request type ID

QC_DOMAIN

NULLABLE

VARCHAR2(128)

Quality Center Domain name

QC_PROJECT

NULLABLE

VARCHAR2(64)

Quality Center Project name

QC_REQUIREMENTS_COVERAGE

NULLABLE

NUMBER

Percentage of tests planned for this requirement that have been run.

QC_OPEN_DEFECTS

NULLABLE

NUMBER

Number of open defects in the project.

QC_DOMAIN_ID

NULLABLE

NUMBER

ID of Quality Center domain

QC_PROJECT_ID

NULLABLE

NUMBER

ID of the Quality Center project

QC_ASSIGNED_TO_USER

NULLABLE

VARCHAR2(200)

Username of the user to whom the defect has been assigned in Quality Center.

QC_ASSIGNED_TO_USER_ID

NULLABLE

VARCHAR2(64)

ID of the user to whom the defect has been assigned in Quality Center.

QC_REQUIREMENT_NO

NULLABLE

NUMBER

Number of the requirement in Quality Center.

QC_REQUIREMENT_STATUS

NULLABLE

VARCHAR2(100)

Status of the requirement in Quality Center.

QC_REQUIREMENT_INT_MSG

NULLABLE

VARCHAR2(500)

A message informing you whether the Quality Center integration is working properly or whether there are errors. The message changes when one of the following occurs: a new entity (a requirement or defect) is created in Quality Center by PPM Center, the request is updated in PPM Center by Quality Center, or PPM Center attempts to update Quality Center but encounters an error.

QC_REQUIREMENT_ATTACHMENT_URL

NULLABLE

VARCHAR2(200)

Link to the documents attached to the requirement in Quality Center

QC_INSTANCE

NULLABLE

VARCHAR2(200)

URL of the Quality Center server (instance)

QC_INSTANCE_ID

NULLABLE

NUMBER

ID of the Quality Center server (instance)

QC_DASHBOARD_SUBJECT

NULLABLE

VARCHAR2(255)

Name of the Quality Center Dashboard subject mapped to the Quality Center project that contains this defect

QC_REQUIREMENT_ATT_URL_ID

NULLABLE

VARCHAR2(200)

Quality Center requirement attachments URL

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_FG_QC_INFO_U1

UNIQUE

1

REQUEST_ID

Sequences

This table uses no sequences.