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