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