KCRT_FG_QC_INFO_INT

Table for importing requests that are integrated with Quality Center server into KCRT_FG_QC_INFO.

Table A-14. KCRT_FG_QC_INFO_INT interface table

Column

Usage

Data Type

Description

GROUP_ID

I

NUMBER

Groups all the records that should be processed at the same time.

Use only one GROUP_ID for each batch of imported users when running the User Open Interface report.

Derived from the KNTA_INTERFACE_GROUPS_S sequence.

This value should be the same as the parent's GROUP_ID in KCRT_REQUEST_INT.

TRANSACTION_ID

I

NUMBER

Uniquely identifies each transaction.

If left blank, the value is generated by the system.

PARENT_TRANSACTION_ID

I

NUMBER

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

REQUEST_ID

I

NUMBER

Identifies the request.

This is normally left blank and is derived from the KCRT_REQUESTS_S sequence.

REQUEST_TYPE_ID

I

NUMBER

Identifies the request type.

This is normally left blank and is derived from REQUEST_TYPE_NAME.

QC_DOMAIN

I

VARCHAR2

Identifies the Quality Center Domain name.

QC_PROJECT

I

VARCHAR2

Identifies the Quality Center Project name.

QC_USER

I

VARCHAR2

Identifies the Quality Center user name.

QC_PASSWORD

I

VARCHAR2

Identifies the Quality Center password associated with the user.

QC_TESTSET_EXEC_ID

I

NUMBER

Uniquely identifies the Quality Center test set execution.

QC_TESTSET_STATUS

I

VARCHAR2

Identifies the status value for the Quality Center test set execution.

QC_REQUIREMENTS_COVERAGE

I

NUMBER

Identifies the percentage of tests planned for this requirement that have been run.

QC_OPEN_DEFECTS

I

NUMBER

Identifies the number of open defects in the project.

QC_DOMAIN_ID

I

NUMBER

Identifies the Quality Center domain.

QC_PROJECT_ID

I

NUMBER

Uniquely identifies the Quality Center project.