Fields Mapped Between Applications
The following fields are mapped between Project Management and Microsoft Project, grouped by information type (planned and actuals information). All fields are task-level fields unless otherwise noted. See Impact of Microsoft Project Rules on Fields, How Information is Synchronized, and Conditional editing allowed in Project Management for additional considerations about mapping fields.
Project Management Field |
Microsoft Project Field |
Additional Information |
---|---|---|
Planned information |
||
Milestone |
Milestone |
Milestones retrieved from Microsoft Project must be manually set to 100% complete in Project Management. Milestones retrieved from Project Management do not require updates. See Planned Information also . |
Predecessor |
Predecessor |
See Planned Information, Planned Information, Planned Information, and Planned Information. |
Priority |
Priority |
See Planned Information. |
Resources |
Resources |
See Planned Information. |
Scheduled Duration |
Duration |
Microsoft Project recalculates duration so that Start, Finish, and Duration are valid. However, if a task is of a fixed duration, only Start and Finish are recalculated. See also Planned Information. |
Scheduled Effort |
Work |
Scheduled Effort (measured in days) is converted to Work (measured in hours) using the calendar option Hours per day in Microsoft Project. |
Scheduled Effort (resource-level) |
Work (resource-level) |
For tasks with more than one assigned resource, the amount of Scheduled Effort/Work assigned to each resource is synchronized. |
Scheduled Start Date |
Start |
See Scheduled Start and Scheduled Finish Dates, Planned Information, Planned Information, and Planned Information. |
Scheduled Finish Date |
Finish |
See Scheduled Start and Scheduled Finish Dates, Planned Information, Planned Information, and Planned Information. |
Scheduling Constraint/Constraint Date |
Constraint Type/Date |
See Planned Information and Planned Information. |
Task Name |
Task Name |
See Planned Information and Planned Information. |
Actuals information |
||
% Complete |
Percent Complete |
See Percent Complete and Percent Work Complete, % Complete When Initializing a Project Management Work Plan from an Existing Microsoft Project Work Plan, and % Complete for Tasks that are Cancelled or On Hold (Bypassed). |
Activity |
Custom |
|
Actual Duration |
Actual Duration |
See Actual Duration for Tasks and Actual Duration for Summary Tasks/Task Groups. |
Actual Effort |
Actual Work |
If any type of effort is tracked in PPM, the link in Microsoft Project between Percent Complete and Percent Work Complete is disabled. See also Actual Effort/Actual Work and Resource Units and Actual Effort and Time Management Integration. |
Actual Start |
Actual Start |
When this date exists, Microsoft Project defaults Start to this date. See also Actual Start and Actual Finish and Actual Start of a Task Group. |
Actual Finish |
Actual Finish |
When this date exists, Microsoft Project defaults Finish to this date. See also Actual Start and Actual Finish. |
Estimated Finish Date |
Finish |
|
Estimated Remaining Effort |
Remaining Work |
|
Task Description and Notes |
Notes (for tasks) |
|
User-defined |
Custom |