Share this page

# 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.

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: