Share this page

# KCRT_FG_QC_INFO_INT

This table stores information for importing requests that are integrated with Quality Center server into the KCRT_FG_QC_INFO table.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KCRT_REQUESTS_INT | TRANSACTION_ID | PARENT_TRANSACTION_ID
KCRT_REQUESTS | REQUEST_ID | REQUEST_ID
KCRT_REQUEST_TYPES_NLS | REQUEST_TYPE_ID | REQUEST_TYPE_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
GROUP_ID | NULLABLE | NUMBER | This value is used to tie records in the interface tables together. Most of the database processing is done based on this value. The value must be the same as the parent's GROUP_ID in the KCRT_REQUESTS_INT table.
TRANSACTION_ID | NULLABLE | NUMBER | System-generated record identifier
PARENT_TRANSACTION_ID | NULLABLE | NUMBER | Links this table to TRANSACTION_ID in KCRT_REQUESTS_INT
REQUEST_ID | NULLABLE | NUMBER | Refers to the REQUEST_ID in KCRT_REQUESTS table
REQUEST_TYPE_ID | NULLABLE | NUMBER | Request type ID used by this request
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

This table uses no indexes.

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