Share this page

# 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

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: