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.