Sprints table reference

Sprints table description

Sprints table is designed to unload data about sprints and related data (number of issues, estimations, etc.). A specific list of fields that can be unloaded and their description are presented in the Table:

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	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	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	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 the process of calculating Sprints table field values. Thus, data presented on Boards may not match with the data obtained when calculating Story Points Committed and Story Points Completed field values of 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.

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.

The history of changes for each Issue is tracked in the History tab.

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

NOTE: issues can be found in various projects and boards.

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

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".

Calculating Story Points Committed and Completed fields values

Values that are included or excluded from the resulting Committed and Completed fields values are described in the Tables below

Values that are 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