KCRT_FG_QC_DEFECT_INFO_INT

Table for importing requests that have information about a corresponding Quality Center defect into KCRT_FG_QC_DEFECT_INFO.

Table A-13. KCRT_FG_QC_DEFECT_INFO_INT interface table

Column

Usage

Data Type

Description

GROUP_ID

I/O

NUMBER

System-generated identifier

TRANSACTION_ID

I/O

NUMBER

Provides a unique identifier for each transaction

PARENT_TRANSACTION_ID

I/O

NUMBER

Provides the transaction id (from KCRT_REQUESTS_INT) of the parent table being imported

REQUEST_ID

I

NUMBER

Identifies the request.

REQUEST_TYPE_ID

I

NUMBER

Identifies the request type.

QC_DEFECT_DOMAIN

I/O

VARCHAR2

Identifies the Quality Center Domain name.

QC_DEFECT_PROJECT

I/O

VARCHAR2

Identifies the Quality Center Project name.

QC_DEFECT_ASSIGN_TO_USER

I/O

VARCHAR2

Identifies the Quality Center user name of the assigned to user.

QC_DEFECT_NO

I/O

NUMBER

Identifies the Quality Center Defect ID.

QC_DEFECT_STATUS

I/O

VARCHAR2

Identifies the Quality Center Defect status (BUG.BG_STATUS).

QC_DEFECT_ATTACHMENT_URL

I/O

VARCHAR2

Identifies the link to Quality Center defect attachments.

QC_DEFECT_INT_MSG

I/O

VARCHAR2

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, the request is updated in PPM by Quality Center, or PPM attempts to update Quality Center but encounters an error.

QC_DEFECT_DOMAIN_ID

I/O

NUMBER

Identifies the Quality Center Domain ID.

QC_DEFECT_PROJECT_ID

I/O

NUMBER

Identifies the Quality Center Project ID.

QC_DEFECT_ASSIGN_TO_USER_ID

I/O

VARCHAR2

Identifies the Quality Center assigned to user ID.

QC_DEFECT_INSTANCE

I/O

VARCHAR2

Identifies the URL of the Quality Center server (instance).

QC_DEFECT_INSTANCE_ID

I/O

NUMBER

Identifies the Quality Center instance.

QC_DEFECT_ATT_URL_ID

I/O

VARCHAR2

Identifies the Quality Center attachments URL.