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 OpenText Software Delivery Management 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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: