Sprints Table Reference

Sprints Table Description

 

The Sprints table is designed to export data related to sprints, including information such as the number of issues, estimations, and more. The specific list of fields that can be exported, along with their descriptions is presented in the table below.

 

Column Name

Column ID

Description

Sprint ID

SPRINT_ID

Sprint unique ID in Jira database

Sprint Name

SPRINT_NAME

Sprint name

Sprint State

SPRINT_STATE

Sprint state (future, active, closed)

Sprint Goal

SPRINT_GOAL

User-specified sprint goal

This field is available for unloading on Jira versions 7.2.0 and higher.

Sprint Activated Date

SPRINT_ACTIVATED_DATE

Actual start time of sprint in UTC

This field is available for unloading on Jira versions 8.7.0 and higher.

Sprint Complete Date

SPRINT_COMPLETE_DATE

Actual time of sprint completion in UTC

Sprint Start Date

SPRINT_START_DATE

Sprint start time specified by user in UTC

Sprint End Date

SPRINT_END_DATE

Sprint completion time specified by user in UTC

Story Points Committed deprecated

Note: The field was deprecated after 10/15/2023.

SPRINT_STORY_POINTS_COMMITTED

Overall assessment of Issues (exclude subtasks) in Story Points that were added to the sprint and were not closed before they were added.

Field value calculation logic.

Story Points Completed deprecated

Note: The field was deprecated after 10/15/2023.

SPRINT_STORY_POINTS_COMPLETED

Overall assessment of Issues (exclude subtasks) in Story Points that were added to the sprint and closed during sprint.

Field value calculation logic.

Story Points Remaining deprecated

Note: The field was deprecated after 10/15/2023.

SPRINT_STORY_POINTS_REMAINING

Difference between Committed and Completed fields values

Issue Sprints Count

ISSUE_SPRINTS_COUNT

Number of Issues (tasks and subtasks) related to sprint

Data Used for Calculation of Sprints Table Fields Values

 

The table indicates the sources of data for calculating Sprints table fields.

 

Boards data and related data are not used in calculating Sprints table field values. Consequently, data displayed on Boards may differ from the results obtained when calculating Story Points Committed and Story Points Completed field values in the Sprints table. 

Column Name

Sources of data

Sprint ID

Sprints table data

Sprint Name

Sprints table data

Sprint State

Sprints table data

Sprint Goal

Sprints table data

Sprint Activated Date

Sprints table data

Sprint Complete Date

Sprints table data

Sprint Start Date

Sprints table data

Sprint End Date

Sprints table data

Story Points Committed

Sprints table data

Issue history changes (sprints, estimation field, resolution changes)

Actual Issues Estimation Values

Actual Issues Sprints Values

Story Points Completed

Sprints table data

Issues history changes (sprints, estimation field, resolution changes)

Actual Issues Estimation Values

Actual Issues Sprints Values

Story Points Remaining

Story Points Committed field value

Story Points Completed field value

Issue Sprints Count

Actual Issues Sprints Values

Issues and issues links data

Calculation of Story Points Committed and Story Points Completed Fields Values

 

The custom numeric field for calculating determined by the corresponding mapping in the admin panel. 

 

The field values are calculated by analyzing the history of changes in the state of each individual Issue relative to the start and completion dates of the corresponding sprint. 

You can track the history of changes for each Issue in the History tab.

 

To calculate the values, all Issues associated with a specific sprint are used.

Issues can be found in various projects and boards.

To see the current list of Issues for a specific sprint, use “Search for Issues” by Sprint value.

The Issue status is determined by the presence of a value in the Resolution field. If the value is not empty, status is defined as closed.

 

 

Calculation of Story Points Committed and Completed Fields Values

The values included or excluded from the resulting Committed and Completed fields values are described in the tables below.

 

The values included or excluded from the resulting Committed field value:

Sprint State

Include estimation field values

Exclude estimation field values

Future

Opened Issues Actual Values

Closed Issues Values

Active

Opened Issues Actual Values, 

Actual Values of Issues that closed in Sprint

Values of Issues that closed outside of sprint

Closed

Opened Issues Values at the completion date of sprint,

Closed Issues Values at the completion date of sprint 

Values of Issues that closed outside of sprint

The values included or excluded from the resulting Completed field value:

Sprint State

Include estimation field values

Exclude estimation field values

Future

 

  • All Issues Values

Active

Actual Values of Issues that closed in Sprint

  • Opened Issues Actual Values

  • Values of Issues that closed outside of sprint

Closed

Closed Issues Values at the completion date of sprint 

  • Opened Issues Values at the completion date of sprint

  • Values of Issues that closed outside of sprint