Task Information Field Mapping (Microsoft Project)

Use the following fields to map task information:

Tasks Field Mapping (Microsoft Project)

Maps fields from Task Information in Microsoft Project to fields in CA Clarity PPM.

Microsoft Project

CA Clarity PPM

Notes

General tab

Name

Tasks Properties: Name

PRTask: PRNAME

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

This field cannot be blank.

Text1

Tasks Properties: ID

PRTask: PREXTERNALID

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

Start

Task Properties: Start

PRTask: PRSTART

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

Finish

Task Properties: Finish

PRTask: PRFINISH

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

Duration

Project Tasks: Duration (not displayed by default)

PRTask: PRDURATION

In Microsoft Project, the duration unit is set by the Duration Is Entered In field on the Schedule tab in the Tools Options dialog box.

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

Priority

Project Tasks: Priority (not displayed by default)

PRTask: PRPRIORITY

Priorities are translated between Microsoft Project’s range (0-1000) and CA Clarity PPM's range (36-0).

Precision is lost.

Flag1

Task Properties: Key Task

PRTask: PRISKEY

This is the default mapping, which can be changed.

Text5

Task Properties: Charge Code

PRTask: PRCHARGECODEID

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

This is the default mapping, which you can change.

% Complete

Project Tasks: Tasks: % Complete

PRTask: PRSTATUS

and

PRTask: PRPCTCOMPLETE

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

Note: The physical % complete in Microsoft Project 2002 is not mapped.

Advanced tab

Mark Task as Milestone

Task Properties: Milestone

PRTask:

PRISMILESTONE

In Microsoft Project, any task can be flagged a milestone as a means to drive Gantt bar rules (e.g., drawing the diamond) and other features such as filtering. Microsoft Project automatically sets this flag when a task acquires a 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 may degrade noticeably.

Constraints

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

Microsoft Project automatically sets the Start No Earlier Than constraint when it is needed to hold a task start date. If there is a saved Start No Earlier Than constraint and Microsoft Project sets 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, CA Clarity PPM Schedule Connect only processes the first constraint it encounter if there are multiple constraints in CA Clarity PPM for a task.

Constraint Date

No CA Clarity PPM user interface field available

PRConstraint:PRTIME

 

Task Baseline Field Mapping (Microsoft Project)

Maps fields from task baseline information in Microsoft Project to fields in CA Clarity PPM.

Microsoft Project

CA Clarity PPM

Notes

Baseline Start

Task Properties: Baseline: Baseline Start

(Not displayed by default)

PRJ_BASELINE_ DETAILS:

START_DATE

 

Baseline Finish

Task Properties: Baseline: Baseline Finish (Not displayed by default)

PRJ_BASELINE_ DETAILS:

FINISH_DATE

 

 

Task Properties: Baseline: (Not displayed by default)

PRJ_BASELINE_ DETAILS:

PREXTENSION

 

Baseline Cost

Task 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.

Duration

Task Properties: Baseline: Duration (Not displayed by default)

PRJ_BASELINE_ DETAILS:

DURATION

 

No mapping

Created_Date (not displayed by default)

PRJ_BASELINE_ DETAILS:

CREATED_DATE

When saving the project to CA Clarity PPM, this field is set to the current system date if baseline information is present in Microsoft Project. It is not the actual date the baseline was modified in Microsoft Project.

Guidelines Field Mapping (Microsoft Project)

Maps fields from the File Properties in Microsoft Project to fields in CA Clarity PPM.

Microsoft Project

CA Clarity PPM

Notes

Hyperlink base

Task Properties: Guidelines

PRJ_PROJECTS: PRGUIDELINES

 

Text2

No CA Clarity PPM user interface field available

PRTask: PRGUIDELINES

This is only the portion of the guidelines URL that is directly associated with the task.

This is the default mapping, which you can change