Reporting Schema

A quick summary of Reporting Schema

Project Fields

Field Name Description
Project Name Name of the project, data type of this field is Text
Description Description of the project, data type of this field is Text
Project Start Date Start date of the project, data type of this field is Date
Project Finish Date Finish date of the project , data type of this field is Date
Status Date Status date of the project. See Fields Reference.
Project Type Type of project. Standard project=0, Template=1, Proposal (LightWeightProject)=4. See the Project.ProjectType enumeration in Microsoft.Office.Project.Server.Library or in Microsoft.ProjectServer.Client.
Workspace Internal Url URL of the project site.
ProjectCurrency Currency character code, as in ISO 4217 (USD, JPY, EUR, and so forth).
Created Date Date the project was created.
Modified Date Date the project was last modified.
Calendar Duration Total span of active working time for all tasks in the project, based on the project calendar specified in the Project Information dialog box. See Fields Reference.
Fixed Cost Total nonresource fixed cost of the project. See Fields Reference.
Cost Cost of the project. See Fields Reference.
Overtime Cost Total overtime cost already incurred on the project. Overtime Cost = Actual Overtime Cost + Remaining Overtime Cost. See Fields Reference.
Actual Cost Actual cost of project (the project summary task) to the status date. See Fields Reference.
Actual Overtime Cost Cost for overtime work already performed on the project to the status date. Actual Overtime Cost = Overtime Cost - Remaining Overtime Cost. See Fields Reference.
Work Total time scheduled for all tasks in the project for all assigned resources. See Fields Reference.
Overtime Work Total scheduled overtime work on the project. See Fields Reference.
Actual Work Actual work done on the project, to the status date. See Fields Reference.
Actual Overtime Work Amount of overtime work already performed on the project, to the status date. See Fields Reference.
Duration Variance Difference between the baseline duration of the whole project and the current estimate of project duration. See Fields Reference.
Start Variance Difference between the baseline project start date and the currently scheduled start date. See Fields Reference.
Finish Variance Variance at the project finish date. See Fields Reference.
Duration Total span of project working time. See Fields Reference.
Actual Duration Actual duration of the project (the project summary task) to the status date. See Fields Reference.
Actual Start Date Date and time that work on the project actually began. See Fields Reference.
Actual Finish Date Date and time the project was completed. See Fields Reference.
Percent Completed Percent complete for the project. See Fields Reference.
Percent Work Completed Percent work complete for the project. See Fields Reference.
ACWP Actual cost of work performed on the project, up to the status date. See Fields Reference.
BCWP Budgeted cost of work scheduled for a project. See Fields Reference.
SPI Schedule performance index is BCWP / BCWS. See Fields Reference.
TCPI Ratio of the work remaining to be done to funds remaining to be spent, as of the project status date (to complete performance index). See Fields Reference.
VAC Variance at completion. See Fields Reference.
EAC Estimate at completion of the expected total cost of a project based on performance up to the status date. See Fields Reference.
Cost Variance Project earned value cost variance. See Fields Reference.
CV Cost variance percentage for a project. See Fields Reference.
CPI Cost performance index. See Fields Reference.
SV Earned value schedule variance is the cost difference between the current progress and the baseline plan of a project. See Fields Reference.
Work Variance Difference between the baseline total work in the project and the currently scheduled work. See Fields Reference.
Budget Cost Budget cost for a project. See Fields Reference.
Budget Work Budget work and material resources for a project. See Fields Reference.
Resource Plan Work The amount of tome on a project scheduled by the resource plan.
Regular Cost Total non-overtime cost scheduled or projected for the project.
Remaining Cost Total remaining expense to complete the scheduled work on the project. See Fields Reference.
Remaining Cost Total remaining cost to complete the scheduled overtime work on the project. Remaining Overtime Cost = Overtime Cost - Actual Overtime Cost. See Fields Reference.
Actual Regular Cost Actual non-overtime cost of the project, to the status date.
Remaining Regular Cost Total remaining non-overtime cost to complete all scheduled work for a project.
Regular Work Total non-overtime time scheduled for a project.
Remaining Work Total remaining work scheduled for a project. See Fields Reference.
Remaining Overtime Work Total remaining overtime work scheduled for a project. See Fields Reference.
Actual Regular Work Actual non-overtime work already performed on the project, to the status date.
Remaining Regular Work Total remaining non-overtime work scheduled for a project.
Remaining Duration Time remaining to complete all scheduled tasks in the project. See Fields Reference.
CVP Earned value cost variance. See Fields Reference.
SVP Schedule variance percentage for a project (SV / BCWS). See Fields Reference.
Owner Name Name of the project owner, who is the project manager. The project manager can be different from project status managers, who manage task updates and assignments.
Baseline Cost Total planned cost for a project baseline (0 - 10). See Fields Reference.
Baseline Fixed Cost Total nonresource cost for a project at the baseline (0 - 10). See Fields Reference.
Baseline Work Total planned person-hours for a project at the baseline (0 - 10). See Fields Reference.
Baseline Budget Cost Planned baseline (0 - 10) amount for cost resources identified as budget resources on a project. See Fields Reference.
Baseline Budget Work Planned baseline (0 - 10) amount for cost resources identified as budget resources on a project. See Fields Reference.
Baseline Start Date Planned start date for a project at the time of a baseline (0 - 10). See Fields Reference.
Baseline Finish Date Planned completion date of a project at the time of a baseline (0 - 10). See Fields Reference.
Baseline Duration Total planned duration for a project baseline (0 - 10). See Fields Reference.

Task Fields

Field Name Description
Task Name Name of the task.
Task Index Number of the task in the local project. See Fields Reference.
Task Is Over allocated True if task if overallocated. See Fields Reference.
Task Is Project Summary True if the task is a project summary task (the task index is 0).
Task Outline Level Place of a task in the project outline hierarchy, indicated by a number. See Fields Reference.
Task Outline Number Position of a task in the outline hierarchy, similar to a WBS number. See Fields Reference.
Task Is Milestone True if task is a milestone. See Fields Reference.
Task Is Critical True if task is on a critical path. See Fields Reference.
Task Is Summary True if the task is a summary task. See Fields Reference.
Task Fixed Cost Nonresource task expense (fixed cost). See Fields Reference.
Task Actual Fixed Cost Costs for a task that remain constant regardless of the task duration, the amount of work performed by the resource, and the number of assignment units. See Fields Reference.
Task Cost Total scheduled or projected cost for a task. See Fields Reference.
Task Overtime Cost Task overtime cost. Overtime Cost = Actual Overtime Cost + Remaining Overtime Cost. See Fields Reference.
Task Actual Cost Actual cost of a task. See Fields Reference.
Task Actual Overtime Cost Cost of overtime work already performed on the task. Actual Overtime Cost = Overtime Cost - Remaining Overtime Cost. See Fields Reference.
Task Work Total time scheduled on a task for all assigned resources. See Fields Reference.
Task Overtime Work The amount of overtime work scheduled to be performed by all resources assigned to a task. See Fields Reference.
Task Actual Work Actual cost of a task. See Fields Reference.
Task Actual Overtime Work Amount of overtime work already performed on the task. See Fields Reference.
Task Duration Variance Difference between the baseline duration and the total duration (current estimate) of a task. See Fields Reference.
Task Start Variance Task start variance is the difference between a baseline start date and the currently scheduled start date. See Fields Reference.
Task Finish Variance Variance at the task finish date. See Fields Reference.
Task Total Slack Amount of time the task finish date can be delayed without delaying the project finish date. See Fields Reference.
Task Free Slack Amount of time a task can be delayed without delaying successor tasks. See Fields Reference.
Task Duration Total span of active working time for a task. See Fields Reference.
Task Duration String String value for the task duration, for example, 3d for three days.
Task Actual Duration Actual working time for a task, based on the scheduled duration and remaining work. See Fields Reference.
Task Start Date Date an assigned resource is scheduled to begin work on a task. See Fields Reference.
Task Finish Date Date a task is scheduled to be completed. See Fields Reference.
Task Deliverable Start Date Published deliverable start date for a task. See Fields Reference.
Task Deliverable Finish Date Published deliverable finish date for a task. See Fields Reference.
Task Actual Start Date Date that work on the task actually began. See Fields Reference.
Task Actual Finish Date Date the task was completed. See Fields Reference.
Task Percent Completed Current task status, as percent completed of task duration. See Fields Reference.
Task Percent Work Completed Current status of task, expressed as percent of work completed. See Fields Reference.
Task Physical Percent Completed Percent complete of a task that is used for calculating earned value (BCWP). See Fields Reference.
Task ACWP Actual cost of work performed, for work already done on a task up to the current date or status date. See Fields Reference.
Task BCWP Actual cost of work performed, for work already done on a task up to the current date or status date. See Fields Reference.
Task BCWS Budgeted cost of work scheduled up to the current date or status date (planned value). See Fields Reference.
Task Leveling Delay Amount of time a task is to be delayed from its early start date as a result of resource leveling. See Fields Reference.
Task Priority Level of importance of a task, from 0 to 1000. See Fields Reference.
Task SPI Schedule performance index is BCWP / BCWS. See Fields Reference.
Task TCPI Ratio of the work remaining to be done to funds remaining to be spent, as of the task status date (to complete performance index). See Fields Reference.
Task VAC Variance at completion. See Fields Reference.
Task Deadline Target date for when task should be completed. See Fields Reference.
Task Duration Is Estimated True if task duration is estimated. See Fields Reference.
Task EAC Task estimate at completion is the expected total cost of a task based on performance up to the status date. See Fields Reference.
Task Is Effort Driven True if task is effort driven. See Fields Reference.
Task Is External True if task is linked from another project. See Fields Reference.
Task Is Recurring True if the task is part of a series of recurring tasks. See Fields Reference.
Task Cost Variance Difference between the baseline cost and total cost for a task. See Fields Reference.
Task CV Earned value cost variance. See Fields Reference.
Task CPI Cost performance index. See Fields Reference.
Task Early Finish Earliest date that a task could possibly finish. See Fields Reference.
Task Early Start Earliest date that a task could begin. See Fields Reference.
Task Late Finish Latest date a task can finish without delaying the project finish. See Fields Reference.
Task Late Start Latest date a task can start without delaying the project finish date. See Fields Reference.
Task SV Earned value schedule variance is the cost difference between the current progress and the baseline plan of a task. See Fields Reference.
Task Work Variance Difference between baseline work and currently scheduled work. See Fields Reference.
Task Ignores Resource Calendar True if task ignores assigned resource calendars. See Fields Reference.
Task Client Unique Id Unique ID of the task as shown in Project Professional. See Fields Reference.
Task Is Marked True if task is marked for identification or further action. See Fields Reference.
Task Is Active True if the task is active. See Fields Reference.
Task Is Manually Scheduled True if the task is manually scheduled. See Fields Reference.
Task WBS Work breakdown structure code, used to represent the task position within the hierarchical structure of a project. See Fields Reference.
Task Created Revision Counter Specifies the project version that was active when the task was created. This field is for internal use by the Project cache.
Task Modified Revision Counter Number of times task data was modified.
Task Created Date Date and time the task was added to the project. See Fields Reference.
Task Modified Date Date and time the task data was modified.
Task Budget Cost Used to compare budgeted costs with the planned or actual costs. See Fields Reference.
Task Budget Work Used to compare current budgeted work with the planned work. See Fields Reference.
Task Resource Plan Work Time scheduled on a task for all resouces in the resource plan. This field is used to avoid double-counting if the scheduled work is from a resource plan.
Task Hyper Link Friendly Name Text to display for a task hyperlink. See Fields Reference.
Task Hyper Link Address Hyperlink associated with a task. See Fields Reference.
Task Hyper Link Sub Address Sub-address of a task hyperlink. See Fields Reference.
Task Regular Cost Total scheduled or projected non-overtime cost for a task.
Task Remaining Cost The total remaining scheduled expense for the scheduled work on the task. See Fields Reference.
Task Remaining Overtime Cost Remaining scheduled overtime expense for the task. Remaining Overtime Cost = Overtime Cost - Actual Overtime Cost. See Fields Reference.
Task Actual Regular Cost Cost of non-overtime work already performed on the task.
Task Remaining Regular Cost The remaining scheduled non-overtime expense for the task.
Task Regular Work Total amount of non-overtime work scheduled for a task.
Task Remaining Work Amount of time, such as person-hours or days, remaining to complete a task. See Fields Reference.
Task Remaining Overtime Work Remaining scheduled overtime. See Fields Reference.
Task Actual Regular Work Amount of non-overtime work already performed on the task.
Task Remaining Regular Work Remaining scheduled non-overtime work for a task.
Task Remaining Duration Amount of time required to complete the unfinished part of the task. See Fields Reference.
Task CVP Cost variance percentage of a task (CV / BCWP). See Fields Reference.
Task SVP Schedule variance percentage for a task (SV / BCWS). See Fields Reference.
Task Baseline Cost Total planned baseline cost for a task. See Fields Reference.
Task Baseline Fixed Cost Baseline (0 - 10) fixed nonresource cost of a task. See Fields Reference.
Task Baseline Work Total planned person-hours scheduled in saved baseline (0 - 10) for a task. See Fields Reference.
Task Baseline Budget Cost Planned baseline (0 - 10) cost for a task, from resources identified as budget resources. See Fields Reference.
Task Baseline Budget Work Planned baseline (0 - 10) work on a task, using work resources identified as budget resources. See Fields Reference.
Task Baseline Start Date Planned start date for a task, saved in baseline (0 - 10). See Fields Reference.
Task Baseline Finish Date Planned completion date for a task, saved in baseline (0 - 10). See Fields Reference.
Task Baseline Deliverable Start Date Deliverable start date for a task, saved in baseline (0 - 10). See Fields Reference.
Task Baseline Deliverable Finish Date Deliverable finish date for a task, saved in baseline (0 - 10). See Fields Reference.
Task Baseline Duration Duration of a task, saved in baseline (0 - 10). See Fields Reference.

Resource Fields

Field Name Description
Resource Type Types can be work (2), material (21), cost (25); generic work(20), generic material (22), generic cost (26); or budget work (50), budget material (52), or budget cost (51). See the Resource.Type enumeration in Microsoft.Office.Project.Server.Library or Microsoft.ProjectServer.Client. See also See Fields Reference.
Resource Booking Type Proposed or committed booking type. See Fields Reference.
Resource ID unique ID of the resource.
Resource Name Name of the resource. See Fields Reference.
Resource Standard Rate Standard rate of pay. See Fields Reference.
Resource Overtime Rate Overtime rate of pay. See Fields Reference.
Resource Code User-defined code for filtering or sorting of resources. See Fields Reference.
Resource Cost Per Use Cost that accrues each time a work resource is used. The field value is 100x the cost. See Fields Reference.
Resource Email Address Resource e-mail address. See Fields Reference.
Resource Initials Initials of the resource.
Resource Material Label Unit of measurement for a material resource. See Fields Reference.
Resource Group Group to which a resource belongs. See Fields Reference.
Resource Max Units The maximum capacity (percentage or units) that a resource is available to accomplish tasks during the current time period. See Fields Reference.
Resource Timesheet Manager ID GUID of the timesheet manager for the resource.
Resource Earliest Available From Earliest date the resource is available. See Fields Reference.
Resource Latest Available To Last date resource is available. See Fields Reference.
Resource Can Level True if resource leveling can be done. See Fields Reference.
Resource Hyperlink URL specified for the resource in the Edit User page of Project Web App. See Fields Reference.
Resource Hyper link Href Text to display for a resource hyperlink, as specified in the Edit User page of Project Web App. See Fields Reference.
Resource NT Account Windows account name for the resource. See Fields Reference.
User Claims Account New field. The claims account for the resource.
Resource Is Active True if the resource is active. See Fields Reference.
Resource Is Generic True if the resource is generic. See Fields Reference.
Resource Is Team True if the resource is a team resource. See Fields Reference.
Resource Base Calendar The base calendar for a resource. See Fields Reference.
Resource Client Unique Id Unique ID of the resource from a local project when opened in Project Professional. See Fields Reference.
Resource Cost Center User-defined code for resource cost accounting.
Resource Created Revision Counter Specifies the project version that was active when the resource was created. This field is for internal use by the Project cache.
Resource Modified Revision Counter Count of how many times resource was modified.
Resource Created Date Date the resource was created in Project Server.
Resource Modified Date Date the resource information was last modified.
Resource Count ResourceCount is always 1. It is a number necessary for OLAP cubes that include the owner.
Cost Type Text value of the Cost Type custom field for a resource. Cost type is one of the default resource custom fields, but the Cost Type lookup table has no default values. See Fields Reference.
Resource Departments Default enterprise resource text custom field, which uses the Department lookup table. Specifies departments for the resource.
RBS Resource breakdown structure (RBS) is one of the default resource text custom fields, typically to show the organizational structure for resources. The RBS lookup table has no default values. See Fields Reference.
Time By Day Date and time for the data, for example, 2013-03-29 00:00:00.000.
Base Capacity Also known as baseline capacity. Maximum work capacity determined by the resource calendar.
Capacity How much work the resource can do, for example hours per day. See Max Units, See Fields Reference.
Resource Count ResourceCount is always 1. It is a number necessary for OLAP cubes that include the owner.

Timesheet Fields

Field Name Description
Timesheet ID GUID of the timesheet.
Owner Resource Name UID GUID of the timesheet owner.
Last Status Change Resource Name UID GUID of the resource who last changed the timesheet status.
Timesheet Status ID Status ID of the timesheet. where NotSpecified=-1, InProgress=0, Submitted=1, Acceptable=2, Approved=3, Rejected=4, and PendingSubmit=5. See the Microsoft.Office.Project.Server.Library.TimesheetEnum.Status enumeration, or the Microsoft.ProjectServer.Client.TimeSheetStatus enumeration.
Created Date Date and time created.
Modified Date Date and time the item was modified.
Timesheet Name Name of the timesheet.
Comment Text comment.

Timesheet Actual Fields

Field Name Description
Timesheet Line ID GUID of the timesheet line.
Time By Day Date and time for the data, for example, 2013-03-29 00:00:00.000.
Adjustment Index The timesheet actual adjustment index.
Last Changed Resource Name ID GUID of the resource who last changed the timesheet actuals.
Time By Day_Day Of Week Day of the week (1 - 7) for time by day calculation.
Time By Day_Day Of Month Day of the month (1 - 31) for time by day calculation.
Adjustment UID GUID of the timesheet adjustment.
Actual Work Billable The actual billable amount of work that has already been performed.
Actual Work Non Billable The actual nonbillable amount of work that has already been performed.
Actual Overtime Work Billable The actual billable overtime work that has already been performed.
Actual Overtime Work Non Billable The actual nonbillable overtime work that has already been performed.
Planned Work The estimated amount of work.
Comment Text comment

Timesheet Line Fields

Field Name Description
Period Name Name of the timesheet period.
Period UID GUID of the timesheet period.
Period Status Status of the timesheet period (open, closed, or all periods). See also, the Microsoft.Office.Project.Server.Library.TimesheetEnum.PeriodState enumeration.
Period Status ID Status ID of the timesheet period (Open=0, Closed=1, or All periods=2).
Timesheet Name Name of the timesheet.
Timesheet UID GUID of the timesheet.
Timesheet Status Status description of the timesheet.
Timesheet Status ID Status ID of the timesheet. where NotSpecified=-1, InProgress=0, Submitted=1, Acceptable=2, Approved=3, Rejected=4, and PendingSubmit=5. See the Microsoft.Office.Project.Server.Library.TimesheetEnum.Status enumeration, or the Microsoft.ProjectServer.Client.TimeSheetStatus enumeration.
Timesheet Line Class Timesheet line class.
Timesheet Line Class UID GUID of the timesheet line class.
Timesheet Line Class Type Status of the timesheet class type. See the Microsoft.Office.Project.Server.Library.TimesheetEnum.LineClassType enumeration or the Microsoft.ProjectServer.Client.TimeSheetLineClass enumeration. Values are StandardLine=0, SickTimeLine=1, VacationLine=2, and AdministrativeLine=3.
Resource Name Name of the resource.
Resource UID GUID of the resource.
Project Name Name of the project.
Project UID GUID of the project.
Task Name Name of the task.
Task UID GUID of the task.
Timesheet Line UID GUID of the timesheet line.
Timesheet Line Status Status of the timesheet line, where Pending=0, Approved=1, Rejected=2, NotApplicable=3, and PendingApproval=4. See the Microsoft.Office.Project.Server.Library.TimesheetEnum.LineStatus enumeration, or the Microsoft.ProjectServer.Client.TimeSheetLineStatus enumeration.
Timesheet Line Status ID GUID of the timesheet line status.
Planned Work The estimated amount of work.
Actual Work Billable The actual billable amount of work that has already been performed.
Actual Work Non Billable The actual nonbillable amount of work that has already been performed.
Actual Overtime Work Billable The actual billable overtime work that has already been performed.
Actual Overtime Work Non Billable The actual nonbillable overtime work that has already been performed.
Created Date Created date of the timesheet line.
Modified Date Date and time the item was modified.
Period Start Date Start date of the timesheet period.
Period End Date End date of the timesheet period.
RBS Resource breakdown structure (RBS) is one of the default resource text custom fields, typically to show the organizational structure for resources. The RBS lookup table has no default values. See Fields Reference.

Assignment Fields

Field Name Description
Project UID GUID of the project.
Resource UID unique ID of the resource.
Task UID GUID of the task.
Timesheet Class UID GUID of the timesheet class.
Resource Owner UID GUID of the resource owner.
Assignment Booking ID Assignment booking GUID.
Assignment Type Type of assignment. NormalAssignment=0, WorkOnlyAssignment=1, FixedCostAssignment=2, FixedCostWorkOnlyAssignment=3, EmptyAssignment=4, FixedCostGeneratedAssignment=100 (generated during RDS transfer), ResourcePlanAssignment=101.
Assignment Resource Type Type of resource (work, material, or cost). See Fields Reference.