Share this page
KCRT_FG_AGILE_INFO
This table stores the field group information for the PPM requests that can trigger creation of agile entities and sync changes between the requests and agile entities.
Foreign Keys
This table does not have foreign keys.
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
REQUEST_ID |
NOT NULL |
NUMBER |
ID of the request this field group belongs to |
|
REQUEST_TYPE_ID |
NOT NULL |
NUMBER |
ID of the request type this field group belongs to. |
|
AGILE_INSTANCE_ID |
NULLABLE |
VARCHAR2(300) |
ID of the agile instance |
|
AGILE_INSTANCE_NAME |
NULLABLE |
VARCHAR2(300) |
Agile instance name |
|
AGILE_PROJECT_NAME |
NULLABLE |
VARCHAR2(300) |
Agile project name |
|
AGILE_PROJECT_VALUE |
NULLABLE |
VARCHAR2(300) |
Agile project value e.g.: {"WORKSPACE_ID":7001,"SHARED_SPACE_ID":22001} |
|
AGILE_ENTITY_TYPE_VALUE |
NULLABLE |
VARCHAR2(300) |
Agile entity type e.g.: feature, user story |
|
AGILE_ENTITY_TYPE_NAME |
NULLABLE |
VARCHAR2(300) |
Agile entity name |
|
SYNC_FLAG |
NULLABLE |
VARCHAR2(1) |
Whether or not the request can create/update its mapped agile entity |
|
AGILE_ENTITY_URL |
NULLABLE |
VARCHAR2(300) |
Agile entity full URL |
|
AGILE_ENTITY_ID |
NULLABLE |
VARCHAR2(200) |
Agile entity ID |
Indexes
This table does not have any indexes.
Sequences
This table does not have any sequences.
