Share this page
PPM_INT_AGILE_CONTROL
This table stores the PPM request-agile entity sync information.
Foreign Keys
This table does not have foreign keys.
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
CONTROL_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 |
| PARAM_NAME | NOT NULL | VARCHAR2(200) |
What the background service last synced for PPM and agile system Currently this column only stores LAST_MODIFIED_TIME |
| PARAM_VALUE | NULLABLE | VARCHAR2(200) | Parameter value |
| 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. |
| FIELD_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 |
