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.