EN
Español
English
Português
    APMO_SPRINT

    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

    PK_APMO_SPRINT
    sprint_id

    References

    Column Referenced Table Referenced column Name
    project_id* dbo.APMO_PROJECT project_id FK01_APMO_SPRINT