Resource Assignment Information Field Mapping

Microsoft Project Field Mappings › Resource Assignment Information Field Mapping

Resource Assignment Information Field Mapping

The following table details the resource assignment information that is mapped from Microsoft Project to fields in CA Clarity PPM.

Any assignment that exists in CA Clarity PPM when a timesheet for that resource is posted gets an Actuals Thru date equal to the end of the timesheet period. Conditions can exist where you inadvertently place remaining work before this date. The following examples illustrate this condition:

A task has actuals that end before the Actuals Thru date and has no remaining work, but require to add work. You enter an updated Remaining Work amount and Microsoft Project places it at the end of the task, which is in the prior week.
A task is scheduled to start next week and has not yet started. You remove a predecessor dependency on the task, which reschedules the task to two weeks ago.

When these situations occur, the work is moved beyond the Actuals Thru date when you save the project to CA Clarity PPM. A message appears warning you of the change.

Microsoft Project	CA Clarity PPM	Notes
Units	Max % Load PRAssignment: PRESTMAX	When opening the project in Microsoft Project, this field is set to the value in CA Clarity PPM multiplied by the resource maximum units (or by 1 if the maximum unit is 0). This value is set only for the not contoured assignment of labor resources to unfixed tasks. When saving the project to CA Clarity PPM, this field is set to the assignment units divided by the resource maximum units. Or if either value is 0, sets the value to 1. This value is set only for assignments of labor resources.
Number1	Task Assignment: Proposed ETC (Not displayed by default) PRAssignment: PRPENDESTSUM	When opening the project in Microsoft Project, this field is set to the value in the field or to -1 when the Pending Estimates in CA Clarity PPM is blank. This field is saved to CA Clarity PPM only if: Either the project or the assigned resource is tracked in CA Clarity PPM (the Track Mode is set to Clarity or Other). Value is -1, which clears the Pending Estimates in CA Clarity PPM.
Number2	Pending Actuals (not displayed by default) PRAssignment: PRPENDACTSUM	This field is not saved back to CA Clarity PPM.
Number2	Task Properties: Status PRAssignment: PRSTATUS	This field is set to the following: Not Started if there are no actuals in Microsoft Project. Started if the remaining work is greater than 0. Complete if there is no remaining work.
Resume	Actuals Thru Date PRAssignment: PRactThru	This field must always be on or after the last day of the actuals on the assignment. If either the project or the assigned resource has Track Mode set to None, the following applies: This field can be implicitly modified to correspond with updates to actuals when saving the project to CA Clarity PPM. If the Resume field is set beyond the first day of the remaining work, the remaining work is modified when saving the project to CA Clarity PPM.
Actual Work	Actuals PRJ_BASELINE_ DETAILS: PREXTENSION	This information is saved to CA Clarity PPM only if the Track Mode is set to None for either the project or the assigned resource.
Work	Assignment Properties: Assignments: ETC PRASSIGNMENT: PREXTENSION	This field is set when saving to CA Clarity PPM only if the assigned resource has Track Mode set to None.
Baseline Start	Assignment Properties: Baseline: Baseline Start Date (not displayed by default) PRJ_BASELINE_ DETAILS: START_DATE
Baseline Finish	Assignment Properties: Baseline: Baseline Finish (not displayed by default) PRJ_BASELINE_ DETAILS: FINISH_DATE
Baseline Cost	Assignment Properties: Baseline: Baseline Cost (not displayed by default) PRJ_BASELINE_ DETAILS: COSTSUM
Baseline Work	Assignment Properties: Baseline: Baseline Usage (not displayed by default) PRJ_BASELINE_ DETAILS: USAGESUM	You must have Modify Baseline rights to save a baseline to CA Clarity PPM.

More information:

Modify Resource Assignments