Work item field and database schema reference

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.

	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
	Data warehouse components Table reference for the relational warehouse database for Visual Studio ALM Perspectives and measure groups provided in the Analysis Services cube Shared dimensions Builds Code churn and code coverage Test results Test cases and work item tracking

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.

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