Start Date

Project Properties: Main: Schedule: Start Date

PRJ_PROJECTS: PRSTART

Finish Date

Project Properties: Main: Schedule: Finish Date

PRJ_PROJECTS: PRFINISH

Schedule From

Project Properties: Schedule: Start Imposed (not displayed by default)

PRJ_PROJECTS: PRSTARTIMPOSED

Project Properties: Schedule: Finish Imposed (not displayed by default)

PRJ_PROJECTS: PRFINISHIMPOSED

If Start Imposed is set to “on” in CA Clarity PPM, the Schedule From field is set to the Project Start Date when opening the project in Microsoft Project. Otherwise, Schedule From is set to the Project Finish Date.

If the Schedule From field is set to the Project Start Date in Microsoft Project, the Start Imposed option is set to On and the Finish is imposed is set to Off when saving the project to CA Clarity PPM. Otherwise, Finish Imposed is set to On and the Start Imposed is set to Off.

Status Date

Project Properties: Schedule: As Of Date

PRJ_PROJECTS: PRASOF

Since Microsoft Project does not allow this field to be programmatically set to NA, the existing value in this field is retained if the AS of Date in CA Clarity PPM is blank.

Calendar

Calendar

PRCalendar: PRVALUE

When opening the project in Microsoft Project, this field is set to CA Clarity PPM’s configured system calendar.

This field is not saved back to CA Clarity PPM.

Priority

Project Properties: Schedule: Priority

PRJ_PROJECTS: PRPRIORITY

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

Baseline Start

Project Properties: Baseline: Baseline Start (Not displayed by default)

PRJ_BASELINE_

DETAILS:

START_DATE

Baseline Finish

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

PRJ_BASELINE_

DETAILS:

FINISH_DATE

Baseline Cost

Project Properties: Baseline: Baseline Cost (Not displayed by default)

PRJ_BASELINE_

DETAILS:

COSTSUM

Baseline Work

Project Properties: Baseline: Baseline Work (Not displayed by default)

PRJ_BASELINE_

DETAILS:

USAGESUM

No mapping

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 available from Microsoft Project. It is not the actual date the baseline was modified in Microsoft Project.

Company

INV_PROJECTS:

PRDEPARTMENT

Manager

Project Properties: Main: General: Manager

When opening the project in Microsoft Project, this field is set to the user name in CA Clarity PPM identified as the project manager. This value is not saved back to CA Clarity PPM.

Title

Title

SRM_PPROJECTS:

NAME

Company

INV_PROJECTS:

PRDEPARTMENT

Text5

Project Properties: Main: Schedule: Charge Code

PRJ_PROJECTS: PRCHARGECODEID

The charge code's ID (PREXTERNALID) is shown in Microsoft Project. To modify the charge code for a project, you must enter a charge code ID that already exists in CA Clarity PPM to save the project back to CA Clarity PPM.

This is the default mapping, which you can change.

For

Calendar Name

PRCalendar: PRNAME

Not used for resource calendars.

Base Calendar

Base Calendar

PRCalendar: PRBASECALENDARID

In Microsoft Project, only resource calendars have base calendars.

Combines system calendars with their base calendars when this information is set in Microsoft Project.

Set Working Time for Selected Dates

PRCalendar: PRVALUE

Calendar information defined in CA Clarity PPM is shown in the Set Working Time options in Microsoft Project.