Share this page

# PPM_INT_AGILE_PORTFOLIO_MAP

This table stores the PPM portfolios that need to be synchronized to OpenText Software Delivery Management

## Foreign keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
PFM_PORTFOLIOS | PORTFOLIO_ID | PPM_PORTFOLIO_ID

## Column descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
MAP_ID | NOT NULL | NUMBER | System-generated identifier.
AGILE_ENTITY_ID | NOT NULL | NUMBER | The product ID in OpenText Software Delivery Management.
PPM_LAST_UPDATE_TIME | NOT NULL | TIMESTAMP | The time when the portfolio in PPM was last updated.
CONFIGURATION_KEY | NOT NULL | VARCHAR | The configuration key of the integration system in PPM.
IS_NEED_SYNC | NOT NULL | VARCHAR 1 - Y, 2 - N, | Whether this line needs to be synced to OpenText Software Delivery Management.

## Indexes

This table has no indexes.

## Sequences

Sequence Name | Sequence Type
--- | ---
ppm_int_agile_portfolio_map_s | Auto-increment

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: