<!-- TITLE: Reporting Schema --> <!-- SUBTITLE: 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.](https://support.office.com/en-us/article/set-the-status-date-for-project-reporting-ef4ad175-b219-456a-8f62-2eef97a3c8ce?ocmsassetID=HA102809632&CorrelationId=815a7cb1-1f23-45cb-a9f2-11051c17e593&ui=en-US&rs=en-US&ad=US)| | 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.](https://support.office.com/en-us/article/duration-task-field-2a65ab25-5a7b-4e3d-a1fa-c7cecbddd2c7?ocmsassetID=HP010374596&CorrelationId=5733b22e-9583-405d-982b-2f4bc5205b46&ui=en-US&rs=en-US&ad=US)| |Fixed Cost|Total nonresource fixed cost of the project. See [Fields Reference.](https://support.office.com/en-us/article/fixed-cost-fields-8872c8fa-40f8-431a-91e1-3dfce897d235?ocmsassetID=HP001024547&CorrelationId=23da479b-935c-49ae-8e5b-03ea6e48cbe0&ui=en-US&rs=en-US&ad=US)| |Cost|Cost of the project. See [Fields Reference.](https://support.office.com/en-us/article/cost-fields-c9ddf12c-8396-49e4-8edd-07aebd862f10?ocmsassetID=HP001023938&CorrelationId=644d3805-ff63-49ef-940a-d1decb810480&ui=en-US&rs=en-US&ad=US)| |Overtime Cost|Total overtime cost already incurred on the project. Overtime Cost = Actual Overtime Cost + Remaining Overtime Cost. See [Fields Reference.](https://support.office.com/en-us/article/overtime-cost-fields-05a98260-e448-4c7f-ab9e-8844c01fde64?ocmsassetID=HP001024581&CorrelationId=d9ee9334-a612-4fa0-8e5b-4c3a39651863&ui=en-US&rs=en-US&ad=US)| |Actual Cost|Actual cost of project (the project summary task) to the status date. See [Fields Reference.](https://support.office.com/en-us/article/actual-cost-fields-b4edba82-9f2c-43a3-8e3a-43076b679fce?ocmsassetID=HP001023246&CorrelationId=972cfe00-3800-4290-b333-fa8695c0db4e&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/actual-overtime-cost-fields-4e22200f-dad3-4c49-855f-5759b875b618?ocmsassetID=HP001023082&CorrelationId=e8076e5c-0e67-49ea-a86d-3b315dc58895&ui=en-US&rs=en-US&ad=US)| |Work|Total time scheduled for all tasks in the project for all assigned resources. See [Fields Reference.](https://support.office.com/en-us/article/work-fields-de691c93-4ddc-4b8e-981e-ebad102f370b?ocmsassetID=HP001025931&CorrelationId=bc3d8ed6-46d2-4faa-b0e0-b416b979c73e&ui=en-US&rs=en-US&ad=US)| |Overtime Work|Total scheduled overtime work on the project. See [Fields Reference.](https://support.office.com/en-us/article/overtime-work-fields-d56e869c-51d1-4705-9226-01e0d3f81f09?ocmsassetID=HP001024582&CorrelationId=307937d8-cad0-45a9-827b-0134f771eebe&ui=en-US&rs=en-US&ad=US)| |Actual Work|Actual work done on the project, to the status date. See [Fields Reference.](https://support.office.com/en-us/article/actual-work-fields-24a92558-1d3f-4013-975e-7b2842fa0d2b?ocmsassetID=HP001023098&CorrelationId=fe93600f-42ce-4293-8964-b70abedbb56d&ui=en-US&rs=en-US&ad=US)| |Actual Overtime Work|Amount of overtime work already performed on the project, to the status date. See [Fields Reference.](https://support.office.com/en-us/article/actual-overtime-work-fields-971f0bc8-11d0-4466-bc98-557ec2d6afc8?ocmsassetID=HP001023096&CorrelationId=a5fa8e39-9c12-4add-afd9-d6b0055bd403&ui=en-US&rs=en-US&ad=US)| |Duration Variance|Difference between the baseline duration of the whole project and the current estimate of project duration. See [Fields Reference.](https://support.office.com/en-us/article/duration-variance-task-field-e647bbeb-0a53-4335-802d-f49e7ba927b0?ocmsassetID=HP045305004&CorrelationId=560d2afb-04d8-48ef-815a-de2e2cf37999&ui=en-US&rs=en-US&ad=US)| |Start Variance|Difference between the baseline project start date and the currently scheduled start date. See [Fields Reference.](https://support.office.com/en-us/article/start-variance-fields-0d8ac113-d0d6-4577-892b-893acb66a028?ocmsassetID=HP001025920&CorrelationId=6a8fe001-c7c0-4de6-9354-e1d0aad091fd&ui=en-US&rs=en-US&ad=US)| |Finish Variance|Variance at the project finish date. See [Fields Reference.](https://support.office.com/en-us/article/finish-variance-fields-2b630199-4211-4b5a-b5f2-d1efc24ec4e7?ocmsassetID=HP001024546&CorrelationId=fb481d19-0587-44ff-8a08-1d321602e207&ui=en-US&rs=en-US&ad=US)| |Duration|Total span of project working time. See [Fields Reference.](https://support.office.com/en-us/article/baseline1-10-duration-task-fields-b6fe94ea-5e6a-4807-8171-6548eb29a777?ocmsassetID=HP043008298&CorrelationId=f6d3832e-f726-4979-b09b-2a760da7e052&ui=en-US&rs=en-US&ad=US)| |Actual Duration|Actual duration of the project (the project summary task) to the status date. See [Fields Reference.](https://support.office.com/en-us/article/actual-duration-task-field-d781ba93-30d3-4a28-aecc-9fa330fa7984?ocmsassetID=HP045304816&CorrelationId=9ecb39e8-b7fe-401c-aa26-8184b193f9c1&ui=en-US&rs=en-US&ad=US)| |Actual Start Date|Date and time that work on the project actually began. See [Fields Reference.](https://support.office.com/en-us/article/actual-start-fields-b1b833a7-07f5-4c4d-858d-f9261d1be7f7?ocmsassetID=HP001023097&CorrelationId=ea8389c8-b93e-45cd-88c9-c807ea623f4b&ui=en-US&rs=en-US&ad=US)| |Actual Finish Date|Date and time the project was completed. See [Fields Reference.](https://support.office.com/en-us/article/actual-finish-fields-3894a632-76ae-4726-9640-575dafad0a7f?ocmsassetID=HP001023095&CorrelationId=83ee716d-8704-4bad-bfc2-55417fa4f47d&ui=en-US&rs=en-US&ad=US)| |Percent Completed|Percent complete for the project. See [Fields Reference.](https://support.office.com/en-us/article/percent-complete-fields-84ec5068-4a34-497c-97eb-e12b6dc47cc5?ocmsassetID=HP001024590&CorrelationId=b2a4e110-749c-4cb0-b3f4-88e474bb9a08&ui=en-US&rs=en-US&ad=US)| |Percent Work Completed|Percent work complete for the project. See [Fields Reference.](https://support.office.com/en-us/article/percent-work-complete-fields-023e4edf-098f-495e-9ec5-3e6a821e383f?ocmsassetID=HP001024591&CorrelationId=6026ad5a-70e1-4aea-a1e4-b9a4687738cc&ui=en-US&rs=en-US&ad=US)| |ACWP|Actual cost of work performed on the project, up to the status date. See [Fields Reference.](https://support.office.com/en-us/article/acwp-fields-710a1c21-b9f1-4516-9c78-986e87345277?ocmsassetID=HP001023099&CorrelationId=f7686358-eb77-4693-8e9b-88b3b5e42f3c&ui=en-US&rs=en-US&ad=US)| |BCWP|Budgeted cost of work scheduled for a project. See [Fields Reference.](https://support.office.com/en-us/article/bcwp-earned-value-or-ev-fields-e0c570ea-9c7b-4864-8a6b-920ed0f7b847?ocmsassetID=HP010173396&CorrelationId=2c37fdc8-4304-4a8b-8ee5-f2c5a1e1c931&ui=en-US&rs=en-US&ad=US)| |SPI|Schedule performance index is BCWP / BCWS. See [Fields Reference.](https://support.office.com/en-us/article/spi-fields-d2f8cf9b-f7e6-4cdd-87d6-e5cbd27e0421?ocmsassetID=HP001025917&CorrelationId=31b92054-ecfb-404c-bcef-979c01b71393&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/tcpi-task-field-c836b125-b7c4-4803-872c-b2cbc8fa8f1e?ocmsassetID=HP043008320&CorrelationId=f3a15380-f3c5-41f0-8a63-fd078baae8df&ui=en-US&rs=en-US&ad=US)| |VAC|Variance at completion. See [Fields Reference.](https://support.office.com/en-us/article/vac-fields-6306c128-1fc7-4a59-8ca4-ad186ed748fa?ocmsassetID=HP001025929&CorrelationId=8696564c-d9f5-43e2-83fe-21b014584559&ui=en-US&rs=en-US&ad=US)| |EAC|Estimate at completion of the expected total cost of a project based on performance up to the status date. See [Fields Reference.](https://support.office.com/en-us/article/eac-task-field-c239ab92-01e6-4186-bc0a-a745eaaf23a7?ocmsassetID=HP043008407&CorrelationId=88ff0834-39c2-4cc7-9573-e2ded7f41e80&ui=en-US&rs=en-US&ad=US)| |Cost Variance|Project earned value cost variance. See [Fields Reference.](https://support.office.com/en-us/article/cost-variance-fields-10739faf-4b5e-4303-bed8-aa5663604526?ocmsassetID=HP001023941&CorrelationId=7fd5c222-ddb3-4c2a-be4e-71a8da30af57&ui=en-US&rs=en-US&ad=US)| |CV|Cost variance percentage for a project. See [Fields Reference.](https://support.office.com/en-us/article/cv-fields-1ad70d06-e8fb-4759-92ef-c1c83cb5e567?ocmsassetID=HP001023946&CorrelationId=68133f5f-c05e-4373-a65b-18be81e260c5&ui=en-US&rs=en-US&ad=US)| |CPI|Cost performance index. See [Fields Reference.](https://support.office.com/en-us/article/cpi-fields-d6d4d113-a5c6-4bb1-a70c-db7afb230aae?ocmsassetID=HP001023942&CorrelationId=06c56436-4c4c-420e-841d-9ea3bc7ff954&ui=en-US&rs=en-US&ad=US)| |SV|Earned value schedule variance is the cost difference between the current progress and the baseline plan of a project. See [Fields Reference.](https://support.office.com/en-us/article/sv-fields-c4417aae-58f6-4a87-9ce8-4ad069012347?ocmsassetID=HP001025921&CorrelationId=847d6d2c-a579-4009-85d8-d1cad312b9a2&ui=en-US&rs=en-US&ad=US)| |Work Variance|Difference between the baseline total work in the project and the currently scheduled work. See [Fields Reference.](https://support.office.com/en-us/article/work-variance-fields-1bb45242-e32e-4c7f-a694-81bc2a9e9a74?ocmsassetID=HP001025933&CorrelationId=e68f33b5-163c-4281-95d8-467a3aa5da7a&ui=en-US&rs=en-US&ad=US)| |Budget Cost|Budget cost for a project. See [Fields Reference.](https://support.office.com/en-us/article/budget-cost-fields-debac6b2-48fb-4314-b1a5-8a5f0979f6cb?ocmsassetID=HA010167372&CorrelationId=66e795ee-f973-4b5c-8a97-b48de8aefaec&ui=en-US&rs=en-US&ad=US)| |Budget Work|Budget work and material resources for a project. See [Fields Reference.](https://support.office.com/en-us/article/budget-work-fields-4ff88854-d1c8-4f98-b7c6-e234fd033084?ocmsassetID=HA010167373&CorrelationId=c26ff288-0680-4591-88de-37766650ec88&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/remaining-cost-fields-a66613ef-b80d-4530-8292-c8a467c5e1a9?ocmsassetID=HP001024596&CorrelationId=9f2acd36-27a4-4147-8243-b91546df2c62&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/remaining-overtime-cost-fields-61c3723c-0a92-4d17-a776-8990244e0fd2?ocmsassetID=HP001024597&CorrelationId=941ee26d-550e-4dad-921d-1d45a593dd39&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/remaining-work-fields-23733389-d8d6-4ef1-9da1-ece1ab408136?ocmsassetID=HP001024599&CorrelationId=cf51277b-c908-4124-8bd3-098791c76a81&ui=en-US&rs=en-US&ad=US)| |Remaining Overtime Work|Total remaining overtime work scheduled for a project. See [Fields Reference.](https://support.office.com/en-us/article/remaining-work-fields-23733389-d8d6-4ef1-9da1-ece1ab408136?ocmsassetID=HP001024599&CorrelationId=cf51277b-c908-4124-8bd3-098791c76a81&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/remaining-duration-task-field-887ee907-fff6-4250-87e7-5bd7c2c5074f?ocmsassetID=HP045305278&CorrelationId=db971790-498c-4e76-99a9-b72b409c08cd&ui=en-US&rs=en-US&ad=US)| |CVP|Earned value cost variance. See [Fields Reference.](https://support.office.com/en-us/article/cv-fields-4899c2c4-152e-4139-b019-741eda040773?ocmsassetID=HP001023947&CorrelationId=51382da0-8528-46a9-a3d2-1235c7d33a93&ui=en-US&rs=en-US&ad=US)| |SVP|Schedule variance percentage for a project (SV / BCWS). See [Fields Reference.](https://support.office.com/en-us/article/sv-percent-fields-48f18cd0-b163-49b3-b7ab-6c328e265a71?ocmsassetID=HP001025922&CorrelationId=bf41fc29-d251-4414-8106-36ae5becef13&ui=en-US&rs=en-US&ad=US)| |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.](http://office.microsoft.com/en-us/project-help/baseline1-10-cost-fields-HP001023262.aspx)| |Baseline Fixed Cost|Total nonresource cost for a project at the baseline (0 - 10). See [Fields Reference.](https://support.office.com/en-us/article/fixed-cost-fields-8872c8fa-40f8-431a-91e1-3dfce897d235?ocmsassetID=HP001024547&CorrelationId=3527e6d9-155a-4d21-a61a-8b5e9242c52f&ui=en-US&rs=en-US&ad=US)| |Baseline Work|Total planned person-hours for a project at the baseline (0 - 10). See [Fields Reference.](https://support.office.com/en-us/article/baseline1-10-work-fields-f79aceff-b206-4c29-8d29-d10464997766?ocmsassetID=HP001023265&CorrelationId=0a25d8b7-f26c-4588-9220-28d82070e135&ui=en-US&rs=en-US&ad=US)| |Baseline Budget Cost|Planned baseline (0 - 10) amount for cost resources identified as budget resources on a project. See [Fields Reference.](https://support.office.com/en-us/article/baseline1-10-budget-cost-fields-7d1ffef6-598a-4499-b346-39e2e422b1d9?ocmsassetID=HA010167489&CorrelationId=3f8e6700-5c74-44ac-95ef-7e95769bd7d2&ui=en-US&rs=en-US&ad=US)| |Baseline Budget Work|Planned baseline (0 - 10) amount for cost resources identified as budget resources on a project. See [Fields Reference.](https://support.office.com/en-us/article/baseline1-10-budget-cost-fields-7d1ffef6-598a-4499-b346-39e2e422b1d9?ocmsassetID=HA010167489&CorrelationId=3f8e6700-5c74-44ac-95ef-7e95769bd7d2&ui=en-US&rs=en-US&ad=US)| |Baseline Start Date|Planned start date for a project at the time of a baseline (0 - 10). See [Fields Reference.](https://support.office.com/en-us/article/baseline1-10-start-fields-6cd8e7c2-6964-4b05-a35c-4abeb2d10f8e?ocmsassetID=HP001023264&CorrelationId=a32fa2a9-4f5a-4b5b-be69-ba0b2fee8f3a&ui=en-US&rs=en-US&ad=US)| |Baseline Finish Date|Planned completion date of a project at the time of a baseline (0 - 10). See [Fields Reference.](https://support.office.com/en-us/article/baseline1-10-finish-fields-814062ad-41b6-4398-a8b0-5f840fc36d41?ocmsassetID=HP001023263&CorrelationId=ed0bee7e-5288-4be6-bd51-934fe4b51f9f&ui=en-US&rs=en-US&ad=US)| |Baseline Duration|Total planned duration for a project baseline (0 - 10). See [Fields Reference.](https://support.office.com/en-us/article/baseline1-10-duration-task-fields-b6fe94ea-5e6a-4807-8171-6548eb29a777?ocmsassetID=HP043008298&CorrelationId=dc6d5243-bff2-430a-9b64-9c39d274e7a6&ui=en-US&rs=en-US&ad=US)| # Task Fields | Field Name | Description | | --- | --- | |Task Name|Name of the task.| |Task Index|Number of the task in the local project. See [Fields Reference.](https://support.office.com/en-us/article/id-fields-8ba2be92-1bae-42c6-8bd3-86eb74afef14?ocmsassetID=HP001024569&CorrelationId=4152df77-e96c-430f-b430-9e9c43b37ca0&ui=en-US&rs=en-US&ad=US)| |Task Is Over allocated|True if task if overallocated. See [Fields Reference.](https://support.office.com/en-us/article/overallocated-fields-3b662a6b-52fc-4fbb-a9f4-7f87d7d98a99?ocmsassetID=HP001024579&CorrelationId=dd74c22a-16d9-45d2-a28c-a5f33dfd0400&ui=en-US&rs=en-US&ad=US)| |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.](http://office.microsoft.com/en-us/project-help/outline-level-fields-HP001024578.aspx)| |Task Outline Number|Position of a task in the outline hierarchy, similar to a WBS number. See [Fields Reference.](https://support.office.com/en-us/article/outline-number-task-field-42d34c61-e970-40b8-bc4a-d5a429f1b56a?ocmsassetID=HP045305195&CorrelationId=086fe82a-5261-40b8-827c-4a9382acd9da&ui=en-US&rs=en-US&ad=US)| |Task Is Milestone|True if task is a milestone. See [Fields Reference.](https://support.office.com/en-us/article/milestone-task-field-b3bf8a34-4453-4cb4-9fc8-0ae5ef0b4c25?ocmsassetID=HP045305150&CorrelationId=5c2c0b3d-8105-4224-8edf-728b7a6986d7&ui=en-US&rs=en-US&ad=US)| |Task Is Critical|True if task is on a critical path. See [Fields Reference.](https://support.office.com/en-us/article/critical-fields-0c2349bb-2001-44e7-ba7c-5d6919ff6e97?ocmsassetID=HP001023943&CorrelationId=cc2d4569-ce28-41ee-bcff-8534443e4dc5&ui=en-US&rs=en-US&ad=US)| |Task Is Summary|True if the task is a summary task. See [Fields Reference.](https://support.office.com/en-us/article/summary-task-field-faaa9c5b-2d78-4ddc-b701-4a2170d2a2a0?ocmsassetID=HP045305359&CorrelationId=06738046-6481-4425-86dc-0e9f84e8470e&ui=en-US&rs=en-US&ad=US)| |Task Fixed Cost|Nonresource task expense (fixed cost). See [Fields Reference.](https://support.office.com/en-us/article/fixed-cost-fields-8872c8fa-40f8-431a-91e1-3dfce897d235?ocmsassetID=HP001024547&CorrelationId=85e0bae4-0197-4472-b516-33425ba51fae&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/fixed-cost-fields-8872c8fa-40f8-431a-91e1-3dfce897d235?ocmsassetID=HP001024547&CorrelationId=85e0bae4-0197-4472-b516-33425ba51fae&ui=en-US&rs=en-US&ad=US)| |Task Cost|Total scheduled or projected cost for a task. See [Fields Reference.](https://support.office.com/en-us/article/cost-fields-c9ddf12c-8396-49e4-8edd-07aebd862f10?ocmsassetID=HP001023938&CorrelationId=b90cf0d9-625d-4a38-b16a-73e9ab7cf54c&ui=en-US&rs=en-US&ad=US)| |Task Overtime Cost|Task overtime cost. Overtime Cost = Actual Overtime Cost + Remaining Overtime Cost. See [Fields Reference.](https://support.office.com/en-us/article/overtime-cost-fields-05a98260-e448-4c7f-ab9e-8844c01fde64?ocmsassetID=HP001024581&CorrelationId=f21d21b5-d2d9-44f5-90db-c28bb00a2716&ui=en-US&rs=en-US&ad=US)| |Task Actual Cost|Actual cost of a task. See [Fields Reference.](https://support.office.com/en-us/article/actual-cost-fields-b4edba82-9f2c-43a3-8e3a-43076b679fce?ocmsassetID=HP001023246&CorrelationId=e3c41298-1083-4d21-94e9-b61a055c5b68&ui=en-US&rs=en-US&ad=US)| |Task Actual Overtime Cost|Cost of overtime work already performed on the task. Actual Overtime Cost = Overtime Cost - Remaining Overtime Cost. See [Fields Reference.](https://support.office.com/en-us/article/actual-overtime-cost-fields-4e22200f-dad3-4c49-855f-5759b875b618?ocmsassetID=HP001023082&CorrelationId=47d6e81f-1552-4242-988e-ea63a5857fdc&ui=en-US&rs=en-US&ad=US)| |Task Work|Total time scheduled on a task for all assigned resources. See [Fields Reference.](https://support.office.com/en-us/article/work-fields-de691c93-4ddc-4b8e-981e-ebad102f370b?ocmsassetID=HP001025931&CorrelationId=96596264-85be-4984-a378-f79d85b3cea8&ui=en-US&rs=en-US&ad=US)| |Task Overtime Work|The amount of overtime work scheduled to be performed by all resources assigned to a task. See [Fields Reference.](https://support.office.com/en-us/article/overtime-work-fields-d56e869c-51d1-4705-9226-01e0d3f81f09?ocmsassetID=HP001024582&CorrelationId=f15db89a-cb7f-4429-a172-936ac2ac3fe5&ui=en-US&rs=en-US&ad=US)| |Task Actual Work|Actual cost of a task. See [Fields Reference.](https://support.office.com/en-us/article/actual-cost-fields-b4edba82-9f2c-43a3-8e3a-43076b679fce?ocmsassetID=HP001023246&CorrelationId=e3c41298-1083-4d21-94e9-b61a055c5b68&ui=en-US&rs=en-US&ad=US)| |Task Actual Overtime Work|Amount of overtime work already performed on the task. See [Fields Reference.](https://support.office.com/en-us/article/actual-overtime-work-fields-971f0bc8-11d0-4466-bc98-557ec2d6afc8?ocmsassetID=HP001023096&CorrelationId=849003cd-9561-4a92-80e3-f0085133b7cd&ui=en-US&rs=en-US&ad=US)| |Task Duration Variance|Difference between the baseline duration and the total duration (current estimate) of a task. See [Fields Reference.](https://support.office.com/en-us/article/duration-variance-task-field-e647bbeb-0a53-4335-802d-f49e7ba927b0?ocmsassetID=HP045305004&CorrelationId=103aa3a8-3b54-4f11-bff9-ec81d5c2f141&ui=en-US&rs=en-US&ad=US)| |Task Start Variance|Task start variance is the difference between a baseline start date and the currently scheduled start date. See [Fields Reference.](https://support.office.com/en-us/article/start-variance-fields-0d8ac113-d0d6-4577-892b-893acb66a028?ocmsassetID=HP001025920&CorrelationId=e39c5890-eba2-426b-8b51-d9ebe687b764&ui=en-US&rs=en-US&ad=US)| |Task Finish Variance|Variance at the task finish date. See [Fields Reference.](https://support.office.com/en-us/article/finish-variance-fields-2b630199-4211-4b5a-b5f2-d1efc24ec4e7?ocmsassetID=HP001024546&CorrelationId=fb481d19-0587-44ff-8a08-1d321602e207&ui=en-US&rs=en-US&ad=US)| |Task Total Slack|Amount of time the task finish date can be delayed without delaying the project finish date. See [Fields Reference.](https://support.office.com/en-us/article/total-slack-task-field-55dacfda-95bc-469c-9cc9-b1454b8df42c?ocmsassetID=HP045305403&CorrelationId=dbc5f537-110b-4481-866c-c2f4996d321a&ui=en-US&rs=en-US&ad=US)| |Task Free Slack|Amount of time a task can be delayed without delaying successor tasks. See [Fields Reference.](https://support.office.com/en-us/article/free-slack-task-field-87145b2b-8d50-45a1-b89b-89aa73015d17?ocmsassetID=HP045305065&CorrelationId=b7bdedfb-4fbb-49f0-9eb4-91d1d42812e6&ui=en-US&rs=en-US&ad=US)| |Task Duration|Total span of active working time for a task. See [Fields Reference.](https://support.office.com/en-us/article/duration-task-field-2a65ab25-5a7b-4e3d-a1fa-c7cecbddd2c7?ocmsassetID=HP010374596&CorrelationId=ff0a98a3-a95b-4532-9690-560e7c5bd6ad&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/actual-duration-task-field-d781ba93-30d3-4a28-aecc-9fa330fa7984?ocmsassetID=HP045304816&CorrelationId=44f92e39-b7e3-4b00-ab36-b29cf7ce4f3b&ui=en-US&rs=en-US&ad=US)| |Task Start Date|Date an assigned resource is scheduled to begin work on a task. See [Fields Reference.](https://support.office.com/en-us/article/start-fields-65b22c0b-8580-4352-994b-b491049cfbd2?ocmsassetID=HP010374583&CorrelationId=3f6edfe1-8a5b-43d0-910d-da56437687b0&ui=en-US&rs=en-US&ad=US)| |Task Finish Date|Date a task is scheduled to be completed. See [Fields Reference.](https://support.office.com/en-us/article/finish-task-field-7800a9ac-b805-44a2-8f08-01feed034a00?ocmsassetID=HP010374589&CorrelationId=30ffec4f-b418-4880-9730-08999a372f00&ui=en-US&rs=en-US&ad=US)| |Task Deliverable Start Date|Published deliverable start date for a task. See [Fields Reference.](https://support.office.com/en-us/article/deliverable-start-task-field-f4f33390-f56f-45dd-8577-ef0c3e2fa412?ocmsassetID=HA010167473&CorrelationId=9d31ee48-8dea-4480-ade4-5943e2d6e234&ui=en-US&rs=en-US&ad=US)| |Task Deliverable Finish Date|Published deliverable finish date for a task. See [Fields Reference.](https://support.office.com/en-us/article/deliverable-finish-task-field-4944c951-b536-43ed-8c78-f2b575053a47?ocmsassetID=HA010167472&CorrelationId=81596bb5-8fbd-40ce-ba28-14d4f684fe83&ui=en-US&rs=en-US&ad=US)| |Task Actual Start Date|Date that work on the task actually began. See [Fields Reference.](https://support.office.com/en-us/article/actual-start-fields-b1b833a7-07f5-4c4d-858d-f9261d1be7f7?ocmsassetID=HP001023097&CorrelationId=cf79ac83-7764-49a9-899a-a80f03b598ae&ui=en-US&rs=en-US&ad=US)| |Task Actual Finish Date|Date the task was completed. See [Fields Reference.](https://support.office.com/en-us/article/actual-finish-fields-3894a632-76ae-4726-9640-575dafad0a7f?ocmsassetID=HP001023095&CorrelationId=95531437-d347-4d73-975a-502ebc00d899&ui=en-US&rs=en-US&ad=US)| |Task Percent Completed|Current task status, as percent completed of task duration. See [Fields Reference.](https://support.office.com/en-us/article/percent-complete-fields-84ec5068-4a34-497c-97eb-e12b6dc47cc5?ocmsassetID=HP001024590&CorrelationId=33ab520f-8960-4973-920f-0693da5e3988&ui=en-US&rs=en-US&ad=US)| |Task Percent Work Completed|Current status of task, expressed as percent of work completed. See [Fields Reference.](https://support.office.com/en-us/article/percent-work-complete-fields-023e4edf-098f-495e-9ec5-3e6a821e383f?ocmsassetID=HP001024591&CorrelationId=42a6670b-2a8b-4385-960c-3abc3ff625ea&ui=en-US&rs=en-US&ad=US)| |Task Physical Percent Completed|Percent complete of a task that is used for calculating earned value (BCWP). See [Fields Reference.](https://support.office.com/en-us/article/physical-percent-complete-task-field-4866cb37-f404-42e2-9241-6b144330c806?ocmsassetID=HP043008313&CorrelationId=21838abc-11de-497d-82a6-c56e7e80e243&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/acwp-fields-710a1c21-b9f1-4516-9c78-986e87345277?ocmsassetID=HP001023099&CorrelationId=2b259ccb-8c72-4637-a30e-8da8b8144931&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/acwp-fields-710a1c21-b9f1-4516-9c78-986e87345277?ocmsassetID=HP001023099&CorrelationId=2b259ccb-8c72-4637-a30e-8da8b8144931&ui=en-US&rs=en-US&ad=US)| |Task BCWS|Budgeted cost of work scheduled up to the current date or status date (planned value). See [Fields Reference.](https://support.office.com/en-us/article/bcws-planned-value-or-pv-fields-d643a208-a32c-4e75-8d0d-024a7babdb33?ocmsassetID=HP010173401&CorrelationId=8df0f94d-1410-44ae-b7ef-e7056792cbd5&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/leveling-delay-fields-b3b137c5-fafc-4122-9c03-52880da4b8b7?ocmsassetID=HP001024571&CorrelationId=c269661f-6f7e-490a-bd24-b15b935083c9&ui=en-US&rs=en-US&ad=US)| |Task Priority|Level of importance of a task, from 0 to 1000. See [Fields Reference.](https://support.office.com/en-us/article/priority-fields-096ac288-1507-431f-bc6f-5b8b3a6f2673?ocmsassetID=HP001025916&CorrelationId=166b149d-fe03-4791-a2d3-038197cdfc04&ui=en-US&rs=en-US&ad=US)| |Task SPI|Schedule performance index is BCWP / BCWS. See [Fields Reference.](https://support.office.com/en-us/article/spi-fields-d2f8cf9b-f7e6-4cdd-87d6-e5cbd27e0421?ocmsassetID=HP001025917&CorrelationId=09d916cd-d3bb-473a-9380-c9c573c6d137&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/tcpi-task-field-c836b125-b7c4-4803-872c-b2cbc8fa8f1e?ocmsassetID=HP043008320&CorrelationId=2c7c4e2e-7b1b-41dd-bbf0-b841eab5d815&ui=en-US&rs=en-US&ad=US)| |Task VAC|Variance at completion. See [Fields Reference.](https://support.office.com/en-us/article/vac-fields-6306c128-1fc7-4a59-8ca4-ad186ed748fa?ocmsassetID=HP001025929&CorrelationId=3ba321e0-b5fa-46da-9d86-e1029523a4a2&ui=en-US&rs=en-US&ad=US)| |Task Deadline|Target date for when task should be completed. See [Fields Reference.](https://support.office.com/en-us/article/deadline-task-field-8c6c4acd-1324-484a-a92b-9bd2eb313dfa?ocmsassetID=HP045326244&CorrelationId=aa1917eb-798f-4246-b223-767827730a6c&ui=en-US&rs=en-US&ad=US)| |Task Duration Is Estimated|True if task duration is estimated. See [Fields Reference.](https://support.office.com/en-us/article/estimated-task-field-d5bd2410-9e1e-428f-bdb3-806cd2d8beff?ocmsassetID=HP045326245&CorrelationId=754bd8eb-5884-499b-a0dc-9f3b241ff453&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/eac-task-field-c239ab92-01e6-4186-bc0a-a745eaaf23a7?ocmsassetID=HP043008407&CorrelationId=29343ca5-e473-4e63-b900-3d480060c33c&ui=en-US&rs=en-US&ad=US)| |Task Is Effort Driven|True if task is effort driven. See [Fields Reference.](https://support.office.com/en-us/article/effort-driven-task-field-2155647a-a232-48a6-a832-ed64fa87dc71?ocmsassetID=HP045305016&CorrelationId=9bac70b0-2328-4ecf-8a93-e59bcc23c0e3&ui=en-US&rs=en-US&ad=US)| |Task Is External|True if task is linked from another project. See [Fields Reference.](https://support.office.com/en-us/article/external-task-task-field-0732831c-6f94-419e-9e47-62712d09942b?ocmsassetID=HP045326246&CorrelationId=17d8ed62-2a28-4a05-9499-7f47cdafc6a3&ui=en-US&rs=en-US&ad=US)| |Task Is Recurring|True if the task is part of a series of recurring tasks. See [Fields Reference.](https://support.office.com/en-us/article/recurring-task-field-301f2833-b84e-4e0e-aca4-581d239e2788?ocmsassetID=HP045305264&CorrelationId=40699bd7-db58-49ba-82cd-fb15645b182f&ui=en-US&rs=en-US&ad=US)| |Task Cost Variance|Difference between the baseline cost and total cost for a task. See [Fields Reference.](https://support.office.com/en-us/article/cost-variance-fields-10739faf-4b5e-4303-bed8-aa5663604526?ocmsassetID=HP001023941&CorrelationId=09fcd33a-49b8-4666-9b97-b5abd2642407&ui=en-US&rs=en-US&ad=US)| |Task CV|Earned value cost variance. See [Fields Reference.](https://support.office.com/en-us/article/cv-fields-1ad70d06-e8fb-4759-92ef-c1c83cb5e567?ocmsassetID=HP001023946&CorrelationId=649c479d-a783-4f6b-841b-69585a68e0cd&ui=en-US&rs=en-US&ad=US)| |Task CPI|Cost performance index. See [Fields Reference.](https://support.office.com/en-us/article/cpi-fields-d6d4d113-a5c6-4bb1-a70c-db7afb230aae?ocmsassetID=HP001023942&CorrelationId=b7f3b9de-4920-4e32-b156-a865417acaa1&ui=en-US&rs=en-US&ad=US)| |Task Early Finish|Earliest date that a task could possibly finish. See [Fields Reference.](https://support.office.com/en-us/article/early-finish-task-field-95f2c025-cd33-4bdb-b4f4-fd274987c4ef?ocmsassetID=HP045305010&CorrelationId=08a7da45-42dc-4510-8039-302c0d181dc3&ui=en-US&rs=en-US&ad=US)| |Task Early Start|Earliest date that a task could begin. See [Fields Reference.](https://support.office.com/en-us/article/early-start-task-field-4d55ec53-073e-460a-9779-c3a8b426b74d?ocmsassetID=HP045305011&CorrelationId=3ad86aad-97b0-4a3f-90da-1446462f4490&ui=en-US&rs=en-US&ad=US)| |Task Late Finish|Latest date a task can finish without delaying the project finish. See [Fields Reference.](https://support.office.com/en-us/article/late-finish-task-field-3e47febb-92b5-4d0b-94c5-b6b1ab70e8c1?ocmsassetID=HP045305123&CorrelationId=6e051d97-2981-4556-95aa-f0bc98153a7d&ui=en-US&rs=en-US&ad=US)| |Task Late Start|Latest date a task can start without delaying the project finish date. See [Fields Reference.](https://support.office.com/en-us/article/late-start-task-field-76c8e294-9feb-4455-bcb3-b447088648f6?ocmsassetID=HP045305124&CorrelationId=7c2b64a2-d612-48c6-aca5-87188aa12327&ui=en-US&rs=en-US&ad=US)| |Task SV|Earned value schedule variance is the cost difference between the current progress and the baseline plan of a task. See [Fields Reference.](https://support.office.com/en-us/article/sv-fields-c4417aae-58f6-4a87-9ce8-4ad069012347?ocmsassetID=HP001025921&CorrelationId=d925e308-858f-4b5e-91a3-01900d180121&ui=en-US&rs=en-US&ad=US)| |Task Work Variance|Difference between baseline work and currently scheduled work. See [Fields Reference.](https://support.office.com/en-us/article/work-variance-fields-1bb45242-e32e-4c7f-a694-81bc2a9e9a74?ocmsassetID=HP001025933&CorrelationId=e68f33b5-163c-4281-95d8-467a3aa5da7a&ui=en-US&rs=en-US&ad=US)| |Task Ignores Resource Calendar|True if task ignores assigned resource calendars. See [Fields Reference.](https://support.office.com/en-us/article/ignore-resource-calendar-task-field-a3d675e0-2a47-4435-a838-a353d5eda56e?ocmsassetID=HP045326274&CorrelationId=0b2ab0ee-b8c5-4a5d-ba66-27669cacbe17&ui=en-US&rs=en-US&ad=US)| |Task Client Unique Id|Unique ID of the task as shown in Project Professional. See [Fields Reference.](https://support.office.com/en-us/article/unique-id-fields-9d8c0bcf-7fd7-40af-8b37-e32f627aa5e7?ocmsassetID=HP001025927&CorrelationId=dca8907a-6a1a-4e18-b5b7-c8ef1cc6648d&ui=en-US&rs=en-US&ad=US)| |Task Is Marked|True if task is marked for identification or further action. See [Fields Reference.](https://support.office.com/en-us/article/marked-task-field-51a8ffe2-ac6d-4b20-a126-a16d241b936f?ocmsassetID=HP045305141&CorrelationId=fed89462-0d52-4905-beba-e7ce1a4ff1d5&ui=en-US&rs=en-US&ad=US)| |Task Is Active|True if the task is active. See [Fields Reference.](https://support.office.com/en-us/article/active-task-field-81769c1e-6b4b-4014-bad4-21471fdaa99e?ocmsassetID=HA010371086&CorrelationId=08a00abb-ca91-4900-b132-b0a081471f58&ui=en-US&rs=en-US&ad=US)| |Task Is Manually Scheduled|True if the task is manually scheduled. See [Fields Reference.](https://support.office.com/en-us/article/task-mode-task-field-3b185518-0e9a-4774-ba51-7b8d191bb84a?ocmsassetID=HA010371088&CorrelationId=3431ed41-062a-4d16-8823-2e7cb111d2d3&ui=en-US&rs=en-US&ad=US)| |Task WBS|Work breakdown structure code, used to represent the task position within the hierarchical structure of a project. See [Fields Reference.](https://support.office.com/en-us/article/wbs-fields-1723c8d6-c103-4390-b250-070c7c927dd2?ocmsassetID=HP001025930&CorrelationId=7b24ee08-502a-4af2-9d4a-3d73d4b8bcfb&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/created-task-field-c11ccaf5-8f5e-47cf-9042-4acaf5e2d829?ocmsassetID=HP010166241&CorrelationId=60bc6b0b-4693-4e4c-b088-8b6d4e9006b1&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/budget-cost-fields-debac6b2-48fb-4314-b1a5-8a5f0979f6cb?ocmsassetID=HA010167372&CorrelationId=8d8f7825-513b-4536-8305-70e6cc104153&ui=en-US&rs=en-US&ad=US)| |Task Budget Work|Used to compare current budgeted work with the planned work. See [Fields Reference.](https://support.office.com/en-us/article/budget-work-fields-4ff88854-d1c8-4f98-b7c6-e234fd033084?ocmsassetID=HA010167373&CorrelationId=b83a053c-a0f1-4721-a698-8788e356e42e&ui=en-US&rs=en-US&ad=US)| |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.](http://office.microsoft.com/en-us/project-help/hyperlink-fields-HP001024550.aspx)| |Task Hyper Link Address|Hyperlink associated with a task. See [Fields Reference.](https://support.office.com/en-us/article/hyperlink-fields-79132b68-99bf-45bd-8a8e-6e17714a57f2?ocmsassetID=HP001024550&CorrelationId=8d6d5fc0-9d65-4b7c-82a3-8edce0e8f3bc&ui=en-US&rs=en-US&ad=US)| |Task Hyper Link Sub Address|Sub-address of a task hyperlink. See [Fields Reference.](https://support.office.com/en-us/article/hyperlink-subaddress-fields-e46d7aa0-a71d-4289-a423-2a3e31c35f50?ocmsassetID=HP001024554&CorrelationId=026ee9c4-bb7d-4063-9802-1eae6c05a53d&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/remaining-cost-fields-a66613ef-b80d-4530-8292-c8a467c5e1a9?ocmsassetID=HP001024596&CorrelationId=37cb1884-d815-4077-95e5-db11b4cab56a&ui=en-US&rs=en-US&ad=US)| |Task Remaining Overtime Cost|Remaining scheduled overtime expense for the task. Remaining Overtime Cost = Overtime Cost - Actual Overtime Cost. See [Fields Reference.](https://support.office.com/en-us/article/remaining-overtime-cost-fields-61c3723c-0a92-4d17-a776-8990244e0fd2?ocmsassetID=HP001024597&CorrelationId=3f43b8b8-e783-4d17-a034-f4ee1fb3190d&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/remaining-work-fields-23733389-d8d6-4ef1-9da1-ece1ab408136?ocmsassetID=HP001024599&CorrelationId=cf51277b-c908-4124-8bd3-098791c76a81&ui=en-US&rs=en-US&ad=US)| |Task Remaining Overtime Work|Remaining scheduled overtime. See [Fields Reference.](https://support.office.com/en-us/article/remaining-overtime-work-fields-5332e105-3cb7-4e68-abeb-153c7aed5bf0?ocmsassetID=HP001024598&CorrelationId=50ed7e8f-35a0-43e4-9873-177be2d3eefa&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/remaining-duration-task-field-887ee907-fff6-4250-87e7-5bd7c2c5074f?ocmsassetID=HP045305278&CorrelationId=dc45bfa0-b193-4cec-9b91-5ad6e192f181&ui=en-US&rs=en-US&ad=US)| |Task CVP|Cost variance percentage of a task (CV / BCWP). See [Fields Reference.](https://support.office.com/en-us/article/cv-fields-4899c2c4-152e-4139-b019-741eda040773?ocmsassetID=HP001023947&CorrelationId=5dceed04-3ed7-4f3a-8e74-16e393806067&ui=en-US&rs=en-US&ad=US)| |Task SVP|Schedule variance percentage for a task (SV / BCWS). See [Fields Reference.](https://support.office.com/en-us/article/sv-percent-fields-48f18cd0-b163-49b3-b7ab-6c328e265a71?ocmsassetID=HP001025922&CorrelationId=5196a895-fc1e-43b2-ba62-dd411d9024cf&ui=en-US&rs=en-US&ad=US)| |Task Baseline Cost|Total planned baseline cost for a task. See [Fields Reference.](https://support.office.com/en-us/article/baseline-cost-fields-5856f63d-4f9b-4c95-b48d-4fca747ca805?ocmsassetID=HP001023266&CorrelationId=29cb1a78-f544-464c-9d72-1c343a278897&ui=en-US&rs=en-US&ad=US)| |Task Baseline Fixed Cost|Baseline (0 - 10) fixed nonresource cost of a task. See [Fields Reference.](https://support.office.com/en-us/article/fixed-cost-fields-8872c8fa-40f8-431a-91e1-3dfce897d235?ocmsassetID=HP001024547&CorrelationId=85e0bae4-0197-4472-b516-33425ba51fae&ui=en-US&rs=en-US&ad=US)| |Task Baseline Work|Total planned person-hours scheduled in saved baseline (0 - 10) for a task. See [Fields Reference.](https://support.office.com/en-us/article/baseline-work-fields-a3142410-6b5c-40b5-8e71-d871fd7df2d1?ocmsassetID=HP001023268&CorrelationId=1a757ec1-01ab-4fd1-83d0-3b6e9de1d826&ui=en-US&rs=en-US&ad=US)| |Task Baseline Budget Cost|Planned baseline (0 - 10) cost for a task, from resources identified as budget resources. See [Fields Reference.](https://support.office.com/en-us/article/baseline-budget-cost-fields-8a74a8b0-1fed-4d85-853a-71b4da5885a8?ocmsassetID=HA010167374&CorrelationId=3b88fd7f-7468-401c-b3a8-589dec412861&ui=en-US&rs=en-US&ad=US)| |Task Baseline Budget Work|Planned baseline (0 - 10) work on a task, using work resources identified as budget resources. See [Fields Reference.](https://support.office.com/en-us/article/baseline-budget-work-fields-3fc3912c-edec-44c2-8222-e76ddf398c54?ocmsassetID=HA010167375&CorrelationId=db39571f-94db-49d4-a4da-b542c903aba3&ui=en-US&rs=en-US&ad=US)| |Task Baseline Start Date|Planned start date for a task, saved in baseline (0 - 10). See [Fields Reference.](https://support.office.com/en-us/article/baseline-start-fields-5661a129-3d08-4567-860b-24ba304f526f?ocmsassetID=HP001024400&CorrelationId=a233d9ea-d023-414b-a3b1-a35c71122089&ui=en-US&rs=en-US&ad=US)| |Task Baseline Finish Date|Planned completion date for a task, saved in baseline (0 - 10). See [Fields Reference.](https://support.office.com/en-us/article/baseline-finish-fields-49bc170f-409d-4663-b8a7-baf6bc965e97?ocmsassetID=HP001023267&CorrelationId=1e8933cf-92b7-4db0-998f-ca9746348014&ui=en-US&rs=en-US&ad=US)| |Task Baseline Deliverable Start Date|Deliverable start date for a task, saved in baseline (0 - 10). See [Fields Reference.](https://support.office.com/en-us/article/baseline-deliverable-start-task-field-99827376-68d5-46f6-a01b-b5e482222b29?ocmsassetID=HA010167485&CorrelationId=8a1a953e-a5c9-4993-8986-785ec5e91a14&ui=en-US&rs=en-US&ad=US)| |Task Baseline Deliverable Finish Date|Deliverable finish date for a task, saved in baseline (0 - 10). See [Fields Reference.](https://support.office.com/en-us/article/baseline-deliverable-finish-task-field-130091ba-c65f-4550-86ac-854eb186d986?ocmsassetID=HA010167486&CorrelationId=20236726-ca8f-41db-be3f-23aedeca558e&ui=en-US&rs=en-US&ad=US)| |Task Baseline Duration|Duration of a task, saved in baseline (0 - 10). See [Fields Reference.](https://support.office.com/en-us/article/baseline-duration-task-field-050ebbd5-dc99-42a5-b8a5-97d8098231bc?ocmsassetID=HP045304874&CorrelationId=c87d90ea-5ba3-4641-97ac-54c875163801&ui=en-US&rs=en-US&ad=US)| # 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.](http://office.microsoft.com/en-us/project-help/type-fields-HP001025926.aspx)| |Resource Booking Type|Proposed or committed booking type. See [Fields Reference.](https://support.office.com/en-us/article/booking-type-fields-38db6ac6-510d-45ac-a0bc-41bfc98afaf9?ocmsassetID=HP001043690&CorrelationId=d9f305e6-eb12-48dd-a5c8-203098b83dc3&ui=en-US&rs=en-US&ad=US)| |Resource ID|unique ID of the resource.| |Resource Name|Name of the resource. See [Fields Reference.](http://office.microsoft.com/en-us/project-help/name-fields-HP001024573.aspx)| |Resource Standard Rate|Standard rate of pay. See [Fields Reference.](https://support.office.com/en-us/article/standard-rate-resource-field-1e99b07c-9b9d-41a2-be31-06f0297840f3?ocmsassetID=HP045305339&CorrelationId=1f534c97-43c6-45b1-9190-4afc281c7fd6&ui=en-US&rs=en-US&ad=US)| |Resource Overtime Rate|Overtime rate of pay. See [Fields Reference.](https://support.office.com/en-us/article/overtime-rate-resource-field-9b8736b3-7534-4c82-bbbc-3aa8549ed3d9?ocmsassetID=HP045305207&CorrelationId=f4e9ef32-95b3-415e-bafb-1f15e5c2fcbb&ui=en-US&rs=en-US&ad=US)| |Resource Code|User-defined code for filtering or sorting of resources. See [Fields Reference.](https://support.office.com/en-us/article/code-resource-field-a3fb7c04-6544-48f8-9dbb-dc802289db32?ocmsassetID=HP045304919&CorrelationId=6f3632c3-c665-4425-81d9-72240f26b460&ui=en-US&rs=en-US&ad=US)| |Resource Cost Per Use|Cost that accrues each time a work resource is used. The field value is 100x the cost. See [Fields Reference.](http://office.microsoft.com/en-us/project-help/cost-per-use-resource-field-HP045304945.aspx)| |Resource Email Address|Resource e-mail address. See [Fields Reference.](https://support.office.com/en-us/article/e-mail-address-resource-field-1179bbc2-bd6c-4f39-9227-b91b7deb1b62?ocmsassetID=HP045305019&CorrelationId=d698f92e-283b-4d91-baaa-ca58ff95ebc3&ui=en-US&rs=en-US&ad=US)| |Resource Initials|Initials of the resource.| |Resource Material Label|Unit of measurement for a material resource. See [Fields Reference.](https://support.office.com/en-us/article/material-label-resource-field-58199492-c314-4ae1-95ca-f20f475dd13a?ocmsassetID=HP045326279&CorrelationId=a15f9420-90ab-4996-a9a3-d8bd351e323f&ui=en-US&rs=en-US&ad=US)| |Resource Group|Group to which a resource belongs. See [Fields Reference.](https://support.office.com/en-us/article/group-resource-field-d4e88ff9-fba9-43a3-be2f-30273e3e0ba3?ocmsassetID=HP045305071&CorrelationId=75d09eb9-57e2-4356-ae20-871978fb8de6&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/max-units-resource-field-e8ad719d-0d04-4369-91e7-9284dd819765?ocmsassetID=HP045305143&CorrelationId=bd21e93a-591a-474f-bc97-81ca265af8fa&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/available-from-resource-field-35b12544-ed98-4e6a-b599-2db976e5a13b?ocmsassetID=HP045304863&CorrelationId=2da11840-bfae-44d4-8397-456344fd0de7&ui=en-US&rs=en-US&ad=US)| |Resource Latest Available To|Last date resource is available. See [Fields Reference.](https://support.office.com/en-us/article/available-to-resource-field-b43ee04a-e32c-48a4-9730-c14604a8e386?ocmsassetID=HP045304864&CorrelationId=c31cddf2-bafc-407e-bb61-e925c9a52256&ui=en-US&rs=en-US&ad=US)| |Resource Can Level|True if resource leveling can be done. See [Fields Reference.](https://support.office.com/en-us/article/can-level-resource-field-6688434d-ba72-4583-abaa-51c2db552fa2?ocmsassetID=HP045304909&CorrelationId=53beb278-540f-4e22-a003-69681c70415a&ui=en-US&rs=en-US&ad=US)| |Resource Hyperlink|URL specified for the resource in the Edit User page of Project Web App. See [Fields Reference.](https://support.office.com/en-us/article/hyperlink-fields-79132b68-99bf-45bd-8a8e-6e17714a57f2?ocmsassetID=HP001024550&CorrelationId=eade981b-e96f-4737-8d9c-392f6b4a5961&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/hyperlink-href-fields-4b07fcdc-6eb1-4a40-b13d-74530b651ee0?ocmsassetID=HP001024552&CorrelationId=c267b46e-46a5-442c-9355-b45686b149c3&ui=en-US&rs=en-US&ad=US)| |Resource NT Account|Windows account name for the resource. See [Fields Reference.](https://support.office.com/en-us/article/windows-user-account-resource-field-9e6a11a0-5512-4835-b3ce-8459a16c0a41?ocmsassetID=HP045326286&CorrelationId=cf6a4d7e-29cf-4226-a152-ce81c0eb6ae2&ui=en-US&rs=en-US&ad=US)| |User Claims Account|New field. The claims account for the resource.| |Resource Is Active|True if the resource is active. See [Fields Reference.](https://support.office.com/en-us/article/inactive-resource-field-7a963cd9-f115-4898-b361-a0dd21ace5af?ocmsassetID=HP043008412&CorrelationId=305f0a6d-1db1-4fc8-9c4b-fa854331e1db&ui=en-US&rs=en-US&ad=US)| |Resource Is Generic|True if the resource is generic. See [Fields Reference.](https://support.office.com/en-us/article/generic-resource-field-06e04040-a8c5-414c-89e3-71b80e5b243d?ocmsassetID=HP043008292&CorrelationId=f5ab48ac-fad4-4d5f-aab2-6d920c685b7e&ui=en-US&rs=en-US&ad=US)| |Resource Is Team|True if the resource is a team resource. See [Fields Reference.](https://support.office.com/en-us/article/team-assignment-pool-resource-field-8717ff45-640d-46c3-b16d-697b48a0757d?ocmsassetID=HA010169491&CorrelationId=841a1543-a5ee-4ac9-9fc8-232b6e1ca8d5&ui=en-US&rs=en-US&ad=US)| |Resource Base Calendar|The base calendar for a resource. See [Fields Reference.](https://support.office.com/en-us/article/base-calendar-resource-field-09e82e06-142d-40d0-a959-abdec6b94b9f?ocmsassetID=HP045304866&CorrelationId=f77edf6e-c273-407f-a253-ce726fbeef45&ui=en-US&rs=en-US&ad=US)| |Resource Client Unique Id|Unique ID of the resource from a local project when opened in Project Professional. See [Fields Reference.](https://support.office.com/en-us/article/unique-id-fields-9d8c0bcf-7fd7-40af-8b37-e32f627aa5e7?ocmsassetID=HP001025927&CorrelationId=18e8d97f-4b64-4ca1-aad8-e055eef5444e&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/cost-type-resource-field-e0d2f155-d329-4e41-849c-af47e1c2ddac?ocmsassetID=HA010371115&CorrelationId=19943650-4341-47bf-bbc3-f1f52526f61e&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/rbs-fields-5d08f8c1-be86-4ea7-b93e-27ba5112427b?ocmsassetID=HP001024593&CorrelationId=442d945d-9f63-42d4-9d62-d64cb9f2ae57&ui=en-US&rs=en-US&ad=US)| |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.](https://support.office.com/en-us/article/max-units-resource-field-e8ad719d-0d04-4369-91e7-9284dd819765?ocmsassetID=HP045305143&CorrelationId=c0701cc4-bde0-4654-b773-e6dea9d2609e&ui=en-US&rs=en-US&ad=US)| |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.](http://office.microsoft.com/en-us/project-help/rbs-fields-HP001024593.aspx)| # 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.]()|