PPM_INT_AGILE_ENTITY_MAP

This table stores the mappings between PPM requests and third-party agile entities.

Foreign Keys

This table does not have foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

MAP_ID

NOT NULL

NUMBER

System-generated identifier

CREATION_ DATE

NOT NULL

DATE

Date when the record was created

CREATED_ BY

NOT NULL

NUMBER

Identifier for the user who created the record

LAST_ UPDATE_ DATE

NOT NULL

DATE

Date when the record was last updated

LAST_ UPDATED_ BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

VERSION

NOT NULL

NUMBER

Record version

PPM_REQUEST_ID

NOT NULL

NUMBER

Request ID

PPM_LAST_UPDATE_TIME

NOT NULL

DATE

Date when the PPM request was last updated

PPM_LAST_NOTE_TIME

NULLABLE

DATE

Currently not in use

AGILE_ENTITY_ID

NULLABLE

VARCHAR2(64)

ID of the agile entity that WAS generated by the PPM request

AGILE_LAST_UPDATE_TIME

NOT NULL

DATE

Date when the agile entity was last updated
RETRY_FLAG NOT NULL VARCHAR2(1) Whether or not to retry sync between PPM request and agile entity
RETRY_ON_ERROR_TIMES NOT NULL NUMBER The number of times the sync between PPM request and agile entity is retried.
CONFIGURATION_ID NOT NULL NUMBER ID of the configuration (agile instance) where the request and agile entity mapping belongs. It is retrieved from the CONFIGURATION_ID column in the table PPM_INT_CONFIGURATION.
MAPPING_KEY NOT NULL VARCHAR2(200) Request type mapping in the agile instance where the request and agile entity mapping belongs. It is retrieved from the FIELDS_MAPPING_CONFIGURATION column in the table PPM_INT_CONFIGURATION.

Indexes

This table does not have any indexes.

Sequences

Sequence Name

Sequence Type

PPM_INT_AGILE_ENTITY_MAP_S

MAP_ID