Previous Topic: Resource Information Field Mapping (Microsoft Project)Next Topic: Resource Assignment Information Field Mapping


Tasks Field Mapping (Microsoft Project)

The following table maps fields from Microsoft Project to fields on the task properties page in CA Clarity PPM:

Microsoft Project

CA Clarity PPM

Notes

General tab

Name

Name

PRTask: PRNAME

When saving the project to CA Clarity PPM, if the Name field is blank in Microsoft Project, it is set to the CA Clarity PPM internal ID.

This field cannot be blank.

Text1

ID

PRTask: PREXTERNALID

Task ID in the same project must be unique in CA Clarity PPM (except blank).

Start

Start

PRTask: PRSTART

The same calendar information is reflected in the Set Working Time in Microsoft Project.

Finish

Finish

PRTask: PRFINISH

The same calendar information reflected in the Set Working Time options in the Change Working Time dialog.

Duration

Duration

This field is not displayed by default.

PRTask: PRDURATION

In Microsoft Project, you can set the duration unit in the Duration is entered in field on the Options dialog (Tools, Options).

Elapsed durations are converted to their equivalent in work time duration, but the model is changed.

Priority

Priority

This field is not displayed by default.

PRTask: PRPRIORITY

Priorities are translated between the range (0-1000) in Microsoft Project and the range (36-0) in CA Clarity PPM.

Precision is lost.

Flag1

Key Task

PRTask: PRISKEY

This is the default mapping, which you can change.

Text5

Charge Code

PRTask: PRCHARGECODEID

The ID (PREXTERNALID) for the charge code is shown in Microsoft Project. To modify the charge code for a task, enter any existing CA Clarity PPM charge code ID.

This mapping is the default mapping, which you can change.

% Complete

% Complete

PRTask: PRSTATUS

and

PRTask: PRPCTCOMPLETE

The task status is set to "Started" when the percent complete is greater than zero, or to "Complete" when it is 100. Otherwise, this field is set to "Not Started".

Advanced tab

Mark Task as Milestone

Milestone

PRTask:

PRISMILESTONE

In Microsoft Project, any task can be flagged a milestone as a means to drive Gantt bar rules. For example, drawing the diamond and other features such as filtering. Microsoft Project automatically sets this flag when a task acquires zero duration.

Calendar

 

You can use them in Microsoft Project, but the list of available calendars comes from CA Clarity PPM.

Task Type

Fixed Duration

PRTask: PRISFIXED

All types in Microsoft Project are supported. In Microsoft Project:

  • Fixed duration task type maps to True
  • Fixed unit and fixed work maps to False.

Effort Driven

No Mapping

Tasks flagged as Effort Driven in Microsoft Project take more processing.

If there are many tasks, system memory requirements and performance can degrade noticeably.

Constraints

The constraints defined in Microsoft Project are stored in CA Clarity PPM, but you cannot edit them from Schedule Connect.

Microsoft Project automatically sets the Start No Earlier Than constraint to hold a task start date. If you add a Start No Earlier Than constraint and Microsoft Project then adds a later Start No Earlier Than constraint to hold a task start date, the saved Start No Earlier Than constraint is not set.

Constraint Type

No CA Clarity PPM user interface field available

PRConstraint: PRTYPE

When opening the project in Microsoft Project, if multiple constraints in CA Clarity PPM exist for a task, the first constraint encountered is processed.

Constraint Date

No CA Clarity PPM user interface field available

PRConstraint: PRTIME