Share this page
AGILE_DATA_FEATURES
Note: All the tables prefixed with AGILE_DATA store data of agile projects that are running in the agile tools such as ALM Octane and Atlassian JIRA.
This table stores the information of agile project features.
Foreign Keys
There are no foreign keys for this table.
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
FEATURE_ID |
NOT NULL |
VARCHAR2(100) |
Feature identifier |
|
NAME |
NULLABLE |
VARCHAR2(2000) |
Feature name |
|
STATUS |
NULLABLE |
VARCHAR2(50) |
Feature status |
|
FEATURE_POINTS |
NULLABLE |
NUMBER |
Story points defined in the feature level |
|
AGG_STORY_POINTS |
NULLABLE |
NUMBER |
The sum of the story points of the feature contents |
|
NUM_OF_USER_STORIES |
NULLABLE |
NUMBER |
The number of user stories that belong to the feature |
|
NUM_OF_DEFECTS |
NULLABLE |
NUMBER |
The numbers of defects that belong to the feature |
|
EPIC_ID |
NULLABLE |
VARCHAR2(100) |
Identifier of the epic where the feature belongs |
|
RELEASE_ID |
NULLABLE |
VARCHAR2(100) |
Identifier of the release where the feature belongs |
|
LAST_MODIFIED |
NULLABLE |
VARCHAR2(200) |
Date when the feature is last updated |
|
SOLUTION |
NULLABLE |
VARCHAR2(2000) |
Identifier of the solution. Refer to table PPM_INT_SOLUTIONS |
|
INSTANCE_ID |
NOT NULL |
VARCHAR2(100) |
Identifier of the instance where the feature belongs |
|
PROJECT_ID |
NOT NULL |
VARCHAR2(100) |
Identifier of the project where the feature belongs |
Indexes
There are no indexes for this table.
