Share this page

# KCRT_FG_QC_DEFECT_INFO_INT

This table stores information for importing requests that have information about a corresponding Quality Center defect into the KCRT_FG_QC_DEFECT_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 | System-generated identifier
TRANSACTION_ID | NULLABLE | NUMBER | Provides a unique identifier for each transaction
PARENT_TRANSACTION_ID | NULLABLE | NUMBER | Provides the transaction ID (from KCRT_REQUESTS_INT) of the parent table being imported
REQUEST_ID | NOT NULL | NUMBER | Identifies the request.
REQUEST_TYPE_ID | NOT NULL | NUMBER | Identifies the request type.
QC_DEFECT_DOMAIN | NULLABLE | VARCHAR2(128) | Quality Center Domain name
QC_DEFECT_PROJECT | NULLABLE | VARCHAR2(64) | Quality Center Project name
QC_DEFECT_ASSIGN_TO_USER | NULLABLE | VARCHAR2(64) | Quality Center user name of the assigned to user
QC_DEFECT_NO | NULLABLE | NUMBER | Quality Center Defect ID
QC_DEFECT_STATUS | NULLABLE | VARCHAR2(500) | Quality Center Defect status (BUG.BG_STATUS)
QC_DEFECT_ATTACHMENT_URL | NULLABLE | VARCHAR2(200) | Link to Quality Center defect attachments
QC_DEFECT_INT_MSG | NULLABLE | VARCHAR2(300) | 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_DEFECT_DOMAIN_ID | NULLABLE | NUMBER | Quality Center Domain ID
QC_DEFECT_PROJECT_ID | NULLABLE | NUMBER | Quality Center Project ID
QC_DEFECT_ASSIGN_TO_USER_ID | NULLABLE | VARCHAR2(64) | Quality Center assigned to user ID
QC_DEFECT_INSTANCE | NULLABLE | VARCHAR2(200) | URL of the Quality Center server (instance)
QC_DEFECT_INSTANCE_ID | NULLABLE | NUMBER | ID of the Quality Center instance
QC_DEFECT_ATT_URL_ID | NULLABLE | VARCHAR2(200) | ID of the Quality Center attachments URL

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KCRT_FG_QC_DEFECT_INFO_INT_N1 | NONUNIQUE | 1 | GROUP_ID
KCRT_FG_QC_DEFECT_INFO_INT_N1 | NONUNIQUE | 2 | TRANSACTION_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: