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.