KCRT_FG_QC_DEFECT_INFO_INT
This table stores information for importing requests that have information about a corresponding Quality Center defect into the KCRT_FG_QC_DEFECT_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 |
System-generated identifier |
TRANSACTION_ID |
NULLABLE |
NUMBER |
Provides a unique identifier for each transaction |
PARENT_TRANSACTION_ID |
NULLABLE |
NUMBER |
Provides the transaction ID (from KCRT_REQUESTS_INT) of the parent table being imported |
REQUEST_ID |
NOT NULL |
NUMBER |
Identifies the request. |
REQUEST_TYPE_ID |
NOT NULL |
NUMBER |
Identifies the request type. |
QC_DEFECT_DOMAIN |
NULLABLE |
VARCHAR2(128) |
Quality Center Domain name |
QC_DEFECT_PROJECT |
NULLABLE |
VARCHAR2(64) |
Quality Center Project name |
QC_DEFECT_ASSIGN_TO_USER |
NULLABLE |
VARCHAR2(64) |
Quality Center user name of the assigned to user |
QC_DEFECT_NO |
NULLABLE |
NUMBER |
Quality Center Defect ID |
QC_DEFECT_STATUS |
NULLABLE |
VARCHAR2(500) |
Quality Center Defect status (BUG.BG_STATUS) |
QC_DEFECT_ATTACHMENT_URL |
NULLABLE |
VARCHAR2(200) |
Link to Quality Center defect attachments |
QC_DEFECT_INT_MSG |
NULLABLE |
VARCHAR2(300) |
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_DEFECT_DOMAIN_ID |
NULLABLE |
NUMBER |
Quality Center Domain ID |
QC_DEFECT_PROJECT_ID |
NULLABLE |
NUMBER |
Quality Center Project ID |
QC_DEFECT_ASSIGN_TO_USER_ID |
NULLABLE |
VARCHAR2(64) |
Quality Center assigned to user ID |
QC_DEFECT_INSTANCE |
NULLABLE |
VARCHAR2(200) |
URL of the Quality Center server (instance) |
QC_DEFECT_INSTANCE_ID |
NULLABLE |
NUMBER |
ID of the Quality Center instance |
QC_DEFECT_ATT_URL_ID |
NULLABLE |
VARCHAR2(200) |
ID of the Quality Center attachments URL |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KCRT_FG_QC_DEFECT_INFO_INT_N1 |
NONUNIQUE |
1 |
GROUP_ID |
KCRT_FG_QC_DEFECT_INFO_INT_N1 |
NONUNIQUE |
2 |
TRANSACTION_ID |
Sequences
This table uses no sequences.