AGILE_DATA_EPICS

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 epics information of agile projects.

Foreign Keys

There are no foreign keys for this table.

Column Descriptions

Column Name

Null?

Data Type

Description

EPIC_ID

NOT NULL

VARCHAR2 (100)

identifier of the epic

NAME

NULLABLE

VARCHAR2(2000)

Epic name

AGG_FEATURE_STORY_POINTS

NULLABLE

NUMBER

Sum of story points defined in the epic's feature level

PLANNED_STORY_POINTS

NULLABLE

NUMBER

Story points defined in the epic level

TOTAL_STORY_POINTS

NULLABLE

NUMBER

Sum of actual story points of all features of the epic

AUTHOR

NULLABLE

VARCHAR2(200)

Email address of the author of the epic

INSTANCE_ID

NULLABLE

VARCHAR2 (100)

Identifier of the instance where the epic exists

PROJECT_ID

NULLABLE

VARCHAR2 (100)

Identifier of the project where the epic belongs

Indexes

There are no indexes for this table.