Share this page

# 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.

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: