Work item field and database schema reference

Visual Studio Team Foundation Server 2013

This reference helps you understand how fields are used to track progress and build reports. You can look up a description of each field used to track work items and learn which fields are set to be reportable by default.

Also, you can understand the structure of the relational warehouse and Analysis Services cube for Team Foundation Server.

Lookup a definition or description conceptual ima

Index of work item fields

  • Titles, IDs, descriptions, and history

  • Areas and iterations

  • Assignments and workflow

  • Planning, ranking, and priorities

  • Effort, schedules, and tracking work

  • Build integration

  • Link controls, restrictions, and fields

  • Attachment controls and fields

  • Fields that support integration with test, build, and version control

Reportable field reference

Conceptual image for reports

Required activities to monitor progress and generate useful reports

For a list of out-of-the-box (OOB) reports and activities team members must perform to generate useful reports, see Reports (SQL Server Reporting Services).

OOB reports, customized reports, and dashboards are built from data written to the relational warehouse database and OLAP cube. In addition to work item data, the warehouse contains data about builds, source code, test results and code coverage. All data captured for all team projects is written to the data store for the team project collection. All data for all team project collections is written to the relational warehouse database and OLAP cube.

Reports, metrics, and data stores

For information about customizing reports, see Create, customize, and manage reports for Visual Studio ALM.