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 |