Scrum sprints of a project; the state is persisted as canonical text (Planning, Active, Closed)
Data model

Fields
| Field |
Type |
Description |
| end_date* |
DATE |
Sprint end date |
| executed_hours* |
DECIMAL |
Hours Executed of the Sprint |
| is_active* |
BIT |
Logical Deletion: 1 = Active Record, 0 = Retired |
| planned_capacity_hours* |
DECIMAL |
Planned sprint capacity in hours |
| planned_hours* |
DECIMAL |
Planned sprint item times |
| project_id* |
UNIQUEIDENTIFIER |
Project to which the sprint belongs |
| sprint_goal |
NVARCHAR (MAX) |
Sprint Goal |
| sprint_id* |
UNIQUEIDENTIFIER |
Unique sprint identifier |
| sprint_name* |
VARCHAR (150) |
Sprint Name |
| sprint_status_id* |
VARCHAR (20) |
Canonical sprint status: Planning, Active, or Closed |
| start_date* |
DATE |
Sprint Start Date |
| velocity_points* |
INT |
Velocity of the sprint (story points completed; calculates PRC_APMO_SPRINT_CLOSE at closing) |
Primary Key
References
| Column |
Referenced Table |
Referenced column |
Name |
| project_id* |
dbo.APMO_PROJECT |
project_id |
FK01_APMO_SPRINT |