Share this page

# PPM_INT_QC_ENTITY_MAP

This table stores the mapping of PPM Center request and Quality Center entity.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
MAP_ID | NOT NULL | NUMBER | System-generated identifier
CREATION_DATE | NOT NULL | DATE | Date record was created
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
VERSION | NOT NULL | NUMBER | System field for persistent layer, this field has nothing to do with the business
PPM_REQUEST_TYPE_ID | NOT NULL | NUMBER | Request type ID of PPM Center
PPM_REQUEST_ID | NOT NULL | NUMBER | ID of the PPM Center request
PPM_LAST_UPDATE_TIME | NOT NULL | DATE | Last update time of PPM Center request. When the backend service is searching updated requests for a period of time, it will compare this field and the real update time of the request to determine whether this request is a candidate.
PPM_LAST_NOTE_TIME | NULLABLE | DATE | Last note time of PPM request. When the backend service is processing a updated request, it will compare this field and the time of the request's notes to determine which note is going to be synchronized to the Quality Center.
QC_ENTITY_ID | NOT NULL | NUMBER | ID of the Quality Center entity.
QC_LAST_UPDATE_TIME | NOT NULL | DATE | Last time that the backend service successfully uses an updated Quality Center entity to update the corresponding request in PPM Center
RETRY_FLAG | NOT NULL | VARCHAR2(1) | This flag field is set to true while the update to PPM Center request lunched by a QC entity fails. Because the poll for the updated QC entities will go on without waiting even if there is something wrong with some requests while the result of the last poll is processing. Therefore, PPM needs to set the retry flag for these failed entity maps and let the backend service to pick up them and retry the update.
RETRY_ON_ERROR_TIMES | NOT NULL | NUMBER | This field accumulates the times that the backend service fail to process this map. This filed can be reset while the process on this map succeeds.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
PPM_INT_QC_ENTITY_MAP_N1 | NONUNIQUE | 1 | PPM_REQUEST_TYPE_ID
PPM_INT_QC_ENTITY_MAP_N1 | NONUNIQUE | 2 | PPM_REQUEST_ID
SYS_C005201896 | UNIQUE | 1 | MAP_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
PPM_INT_QC_ENTITY_MAP_S | MAP_ID

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: