Share this page
PPM_INT_AGILE_ENTITY_MAP
This table stores the mappings between PPM requests and third-party agile entities.
Foreign Keys
This table does not have foreign keys.
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
MAP_ID |
NOT NULL |
NUMBER |
System-generated identifier |
|
CREATION_ DATE |
NOT NULL |
DATE |
Date when the record was created |
|
CREATED_ BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
|
LAST_ UPDATE_ DATE |
NOT NULL |
DATE |
Date when the record was last updated |
|
LAST_ UPDATED_ BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
|
VERSION |
NOT NULL |
NUMBER |
Record version |
|
PPM_REQUEST_ID |
NOT NULL |
NUMBER |
Request ID |
|
PPM_LAST_UPDATE_TIME |
NOT NULL |
DATE |
Date when the PPM request was last updated |
|
PPM_LAST_NOTE_TIME |
NULLABLE |
DATE |
Currently not in use |
|
AGILE_ENTITY_ID |
NULLABLE |
VARCHAR2(64) |
ID of the agile entity that WAS generated by the PPM request |
|
AGILE_LAST_UPDATE_TIME |
NOT NULL |
DATE |
Date when the agile entity was last updated |
| RETRY_FLAG | NOT NULL | VARCHAR2(1) | Whether or not to retry sync between PPM request and agile entity |
| RETRY_ON_ERROR_TIMES | NOT NULL | NUMBER | The number of times the sync between PPM request and agile entity is retried. |
| CONFIGURATION_ID | NOT NULL | NUMBER | ID of the configuration (agile instance) where the request and agile entity mapping belongs. It is retrieved from the CONFIGURATION_ID column in the table PPM_INT_CONFIGURATION. |
| MAPPING_KEY | NOT NULL | VARCHAR2(200) | Request type mapping in the agile instance where the request and agile entity mapping belongs. It is retrieved from the FIELDS_MAPPING_CONFIGURATION column in the table PPM_INT_CONFIGURATION. |
Indexes
This table does not have any indexes.
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
PPM_INT_AGILE_ENTITY_MAP_S |
MAP_ID |
