Share this page

# PPM_INT_AGILE_TASK_MAPPING

This table stores mapping values between PPM Center tasks and Agile Manager releases.

Note: This table is available after deployment of the Agile Manager Integration Plug-in for PPM.

## 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
--- | --- | --- | ---
MAPPING_ID | NOT NULL | NUMBER(19) | System-generated identifier
PPM_TASK_ID | NOT NULL | NUMBER(19) | PPM task ID
PPM_PROJECT_ID | NOT NULL | NUMBER(19) | PPM project ID
PPM_WORKPLAN_ID | NOT NULL | NUMBER(19) | PPM workplan ID
STATUS_ID | NOT NULL | VARCHAR2(128) | Status information of synchronization service run at this mapping
CONFIGURATION_KEY | NOT NULL | VARCHAR2(128) | Configuration key of Agile server
IS_ACTIVE | NOT NULL | NUMBER(1) | Default to 1, which means active
AUTHENTICATION_JSON | NOT NULL | VARCHAR2(4000) | Authentication information in JSON format
AGILE_PROJECT_JSON | NOT NULL | VARCHAR2(4000) | Agile project information in JSON format
LAST_SUCCESS_TIME | NOT NULL | DATE | Time of the last success run of the synchronization service

## Indexes

This table does not use any indexes.

## Sequences

Sequence Name | Sequence Type
--- | ---
PPM_INT_AGILE_TASK_MAPPING_S | MAPPING_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: