Share this page
AGILE_DATA_BACKLOG_ITEMS
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 backlog items information of agile projects.
Foreign Keys
There are no foreign keys for this table.
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
BACKLOG_ITEM_ID |
NOT NULL |
VARCHAR2 (100) |
Backlog item identifier |
|
BACKLOG_TYPE |
NULLABLE |
VARCHAR2 (50) |
Backlog item type |
|
RANK |
NULLABLE |
NUMBER |
Rank of the backlog item |
|
NAME |
NULLABLE |
VARCHAR2 (2000) |
Backlog item name |
|
ASSIGN_TO |
NULLABLE |
VARCHAR2 (200) |
Email address of the user that is assigned to the backlog item |
|
STORY_POINTS |
NULLABLE |
NUMBER |
Story points of the backlog item |
|
STATUS |
NULLABLE |
VARCHAR2 (50) |
Backlog item status |
|
RELEASE_ID |
NULLABLE |
VARCHAR2 (100) |
Identifier of the release where the backlog item belongs |
|
TEAM_ID |
NULLABLE |
VARCHAR2 (100) |
Identifier of the team to which the backlog item is assigned |
|
EPIC_ID |
NULLABLE |
VARCHAR2 (100) |
Identifier of the epic where the backlog item belongs |
|
FEATURE_ID |
NULLABLE |
VARCHAR2 (100) |
Identifier of the feature where the backlog item belongs |
|
SPRINT_ID |
NULLABLE |
VARCHAR2 (100) |
Identifier of the sprint where the backlog item belongs |
|
AUTHOR |
NULLABLE |
VARCHAR2 (200) |
Email address of the author of the backlog item |
|
PRIORITY |
NULLABLE |
VARCHAR2 (50) |
Priority of the backlog item |
|
LAST_MODIFIED |
NULLABLE |
VARCHAR2 (200) |
Date and time when the backlog was last modified |
|
NUMBER_OF_TASKS |
NULLABLE |
NUMBER |
Number of tasks the backlog item includes |
|
DEFECT_STATUS |
NULLABLE |
VARCHAR2 (50) |
|
|
INSTANCE_ID |
NULLABLE |
VARCHAR2 (100) |
Identifier of instance where the backlog item exists |
|
PROJECT_ID |
NULLABLE |
VARCHAR2 (100) |
Identifier of the project where the backlog item belongs |
|
SEVERITY |
NULLABLE |
VARCHAR2(50) |
Severity of the backlog item |
|
DETECTED_IN_RELEASE |
NULLABLE |
VARCHAR2(50) |
Release where the backlog item belongs |
Indexes
There are no indexes for this table.
