KCRT_FG_QC_INFO
This table stores fields for the PPM-Quality Center integration.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KCRT_REQUESTS |
REQUEST_ID |
REQUEST_ID |
KCRT_REQUEST_TYPES_NLS |
REQUEST_TYPE_ID |
REQUEST_TYPE_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
REQUEST_ID |
NOT NULL |
NUMBER |
System-generated identifier |
REQUEST_TYPE_ID |
NOT NULL |
NUMBER |
Request type ID |
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
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KCRT_FG_QC_INFO_U1 |
UNIQUE |
1 |
REQUEST_ID |
Sequences
This table uses no sequences.