Effort, Schedules, and Tracking Hours (Agile)

You use the fields that are grouped under Effort (hours) to track estimated, completed, and remaining work for a Task and to report on the progress toward completing tasks. By tracking hours, you gain more detailed insight into which user stories are almost finished and what the team burn rate is. Several reports and dashboards provide charts that display the data that these fields contain.

You specify the level of effort for the Tasks that you are assigned. For more information about how to track hours, see Task (Agile).

In this topic

  • Fields Used to Track Hours

  • Fields Calculated by Office Project

Fields Used to Track Hours

The following table describes the fields that you can use to track hours. This information is tracked only for task work items in the process template of MSF for Agile Software Development v5.0. For information about data types and default field attributes, see Working with Work Item Fields.

Field name

Description

Reference name

Data type

Default value of the reportable type attribute

Default value of the index attribute

Activity

The type of activity that is required to perform a Task.

Microsoft.VSTS.Common.Activity

String

Dimension

False

Original Estimate

The number of hours that are required to complete a Task.

Microsoft.VSTS.Scheduling.OriginalEstimate

Double

Measure, Sum

False

Remaining

The number of hours that remain to finish a Task.

Microsoft.VSTS.Scheduling.RemainingWork

Double

Measure, Sum

False

Completed

The number of hours that were spent working on a Task.

Microsoft.VSTS.Scheduling.CompletedWork

Double

Measure, Sum

False

Scheduling Fields That Office Project Calculates

The following table lists fields that are calculated if you create a project plan in Office Project and then synchronize that plan with Tasks that are stored in Team Foundation Server. These fields do not appear on the work item form, but they are calculated for both User Stories and Tasks that are linked to User Stories. You can view their read-only values in results from a query or from Office Excel and Office Project. For more information, see Scheduling Tasks and Assigning Resources Using Microsoft Project.

Field name

Description

Reference name

Data type

Default value of the reportable type attribute

Default value of the index attribute

Due Date

The forecasted due date for a Task to be completed.

Microsoft.VSTS.Scheduling.DueDate

DateTime

Dimension

False

Finish Date

The date and time when the schedule indicates that the Task will be completed.

Microsoft.VSTS.Scheduling.FinishDate

DateTime

Dimension

False

Start Date

The date and time when the schedule indicates that the Task will start.

Microsoft.VSTS.Scheduling.StartDate

DateTime

Dimension

False

See Also

Concepts

Task (Agile)

Customizing Microsoft Project Field Mappings

Using System Fields and Fields Defined by the MSF Process Templates

Finding Bugs, Tasks, and Other Work Items

Other Resources

Work Item Fields (Agile)