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 |
