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 fail. Because the poll for the updated QC entities will go on without waiting even if the there is something wrong with some requests while the result of the last poll is processing. So, we need 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