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 |